•  Preface
  • Purpose
  • Audience
  • Organization
  •  Using this manual
    • References to ABL compiler and run-time features
    • References to ABL data types
  • Typographical conventions
  •  Examples of syntax descriptions
    • Long syntax descriptions split across lines
    • Complex syntax descriptions with both required and optional elements
  •  OpenEdge messages
    • Obtaining more information about OpenEdge messages
•  Database Basics
  •  Creating and Deleting Databases
    • Ways to create an OpenEdge database
    •  Creating a database with PROSTRCT CREATE
      •  Creating a structure description file
        • Extent pathnames and naming conventions
        • Rules for creating storage areas and extents
        • Extent length
        • Example structure description file
        • Example structure description file for large files
      •  Create a database structure extent
        • Adding schema to a void database
    • Creating a database with the PRODB utility
    • PRODB maintains pathname convention
    • Creating a database with a Data tool
    • Converting an OpenEdge Release 10 database to OpenEdge Release 11
    • Using the Schema Mover
    • Database conversion utilities
    •  Copying a database
      •  Copying a database using PROCOPY
        • PROCOPY uses absolute pathnames
    • Deleting a database
  •  OpenEdge RDBMS Limits
    • Database block sizes
    • Maximum number of records per block
    •  Number and size of storage areas
      • Recovery sizes
    • Table and index limits
    • Number and size of sequences
    • Maximum size of the primary recovery (BI) area
    • Maximum database size
    • Number of connections per database
    • Number of simultaneous transactions per database
    • OpenEdge database name limits
    • File Handles
    •  Shared memory
      • Shared memory interactions
    • Data types and values
  •  Starting Up and Shutting Down
    •  Unified Broker Framework
      • OpenEdge Management
      • OpenEdge Explorer
      • Managing database configurations
      • Using the DBMAN command-line utility
    •  Starting a server or broker
      •  Specifying international character sets
        • Specifying the operating character set
        • Specifying the character set name of the database log file
      • Network addressing using -S and -H
      • Starting multiple brokers using the same protocol
      • Accessing a server behind a firewall
      • Starting database brokers for SSL connections
    •  Starting and stopping background writers
      • Starting and stopping an APW
      • Starting and stopping a BIW
      • Starting and stopping an AIW
    •  Stopping a server or broker
      • PROSHUT command
      • PROMON shut down database option
•  Protecting Your Data
  •  Backup Strategies
    • Identifying files for backup
    •  Determining the type of backup
      • Full backups
      • Incremental backups
      • Online backups
      • Offline backups
    • Choosing backup media
    •  Creating a backup schedule
      • Database integrity
      • Database size
      • Time
      • Unscheduled backups
  •  Backing Up a Database
    •  Using PROBKUP
      •  Performing an online full backup with PROBKUP
        • UNIX full backup example
      • Testing backups
      • Archiving backups
    • Performing an offline backup
    •  Performing an online backup
      • Improving performance of an online backup
    • Using database quiet points
    • Performing an operating system backup
    •  Database backup examples
      • Incremental backup example
      • Full backup example
    • Verifying a backup
    •  CRC codes and redundancy in backup recovery
      • CRC codes
      • Error-correction blocks
    •  Restoring a database
      • Using the PROREST utility to restore a database
      • Important rules for restoring backups
      • Obtaining storage area descriptions using PROREST
      •  Database restore examples
        • Full backup restore example
        • Incremental backup restore example
  •  Recovering a Database
    •  Introduction to recovery mechanisms
      • Crash recovery
      • Roll-forward recovery
      • Two-phase commit
    • File locations that ensure safe recovery
    •  Developing a recovery plan
      • Time needed for recovery
      • Recovery guidelines
    •  Sample recovery plans
      • Example 1: Low availability requirements
      • Example 2: Moderate availability requirements
      • Example 3: Moderate-to-high availability requirements
      • Example 4: high availability requirements
      • Sample recovery scenarios
    • After-imaging and roll-forward recovery commands
    •  Recovering from system failures
      • System crash while running RFUTIL ROLL FORWARD
      • System crash while running other utilities
      • System crash while backing up the database
      • System crash while database is up
    •  Recovering from media failures
      • Loss of the DB files, BI files, or both
      • Loss of the AI file
      • Loss of database backup
      • Loss of transaction log file
    •  Recovering from a full disk
      • After-image area disk
      •  Control or primary recovery area disk
        • BI file not on full disk
        • BI file on the full disk
      • Transaction log file disk
    • Truncating the BI file
    • Releasing shared memory
    • Recovering from a lost or damaged control area
    • Unlocking damaged databases
    • Dumping tables from a damaged database
    • Forcing access to a damaged database
  •  After-imaging
    •  After-image areas and extents
      • Fixed-length extents
      • Variable-length extents
    • Estimating after-imaging disk space requirements
    •  Creating after-image areas
      • Adding AI areas to an existing database
    •  Enabling after-imaging offline
      • Enabling encrypted after-imaging offline for an encryption-enabled database
      • Enabling unencrypted after-imaging offline for an encryption-enabled database
    •  Enabling after-imaging online
      • Enabling encrypted after-imaging online for an encryption-enabled database
      • Enabling unencrypted after-imaging online for an encryption-enabled database
    •  Managing after-imaging files
      • Monitoring AI file status
      •  Switching to a new AI file
        • Switch to the next extent in the sequence
      •  Archiving an AI file
        • Scheduling backups
        • Performing the backup
        • Protecting the backup
        • Extracting AI blocks
      • Making an AI file available for reuse
    •  AI File Management utility
      •  Automatic extent archiving
        • Timed mode archiving process without OpenEdge Replication
        • Timed mode archiving process with OpenEdge Replication
        • On-demand archiving process without OpenEdge Replication
        • On-demand archiving process with OpenEdge Replication
      •  Enabling your database for automated AI file management
        • Enabling an offline database for automated AI file management
        • Enabling an online database for automated AI file management
        • Additional info for enabling automated AI file management
      • Monitoring and adjusting automated AI File Management
      • Restarting the AI file management utility daemon
      • Archived extents
      •  Archive log file
        • Version indicator record
        • Archive record
        • Backup record
      • Database recovery with an archival log
    • Add and reorder AI extents
    •  Performing roll-forward recovery
      •  Roll forward with the OPLOCK qualifier
        • Treatment of operations while under protection
      •  Rolling forward multiple files
        • Applying after-images files from a list
    •  After-image sequences
      • Sequence not required
      • Sequence required
    •  Disabling after-imaging
      • Disabling encryption of AI files when disabling after-imaging
  •  Maintaining Security
    •  Establishing an OpenEdge user ID and password
      • OpenEdge user IDs
      • OpenEdge passwords
      • Validating an OpenEdge user ID and password
    •  Establishing authentication for your OpenEdge database
      • Tables used from ABL only
      • Tables used from SQL only
      • Tables used from both ABL and SQL
    •  Connection security
      • Designating valid users in the _User table accounts
      •  Designating a security administrator
        • Entering user IDs for security administrators
      • Deleting a user from the _User table accounts
      • Changing a password for database users
    • Running a user report
    •  Schema security
      • Freezing and unfreezing schema
    • Operating systems and database security
  •  Auditing
    •  Auditable events
      • Audit events
      • Security events
      • Schema events
      • Data events
      • Administration events
      • Utility events
      • User events
      • Application events
    • Auditing states
    •  Enabling and disabling auditing
      • Enabling auditing
      • Re-enabling auditing from a deactivated state
      • Disabling auditing
    •  Auditing tables
      • Indexes on auditing tables
    •  Archiving audit data
      •  Audit archive process
        • Basic archive process
        • Archive process with seal verification
    •  Reconfiguring audit areas
      • Split one audit area into separate data and index areas
      • Combine audit data and index areas into one area
      • Move existing audit data and indexes to new areas
      • Purge data in existing audit data areas
    • Auditing impact on database resources
    •  Auditing impact on database utilities
      •  Identifying the privileged user
        • _User table
        • Local operating system login
        • Specifying encrypted passwords
    •  Utility modifications
      • Protected tables
      • Protected areas
      • Enhanced utilities
      • Expanded PROUTIL syntax
  •  Transparent Data Encryption
    •  Overview
      • Before you start
      • What is encryptable
      • Data considerations
      •  Database key store
        • Configuring key store access
      • OpenEdge supported ciphers
    •  Enabling Encryption
      • Adding an encryption policy area
      • Running ENABLEENCRYPTION
      • Enabling BI file encryption after enabling encryption
      • Enabling AI file encryption after enabling encryption
      • Verifying enablements
    •  Creating encryption policies
      • Creating encryption policies with PROUTIL EPOLICY
      • Creating encryption policies with Data Admin
    •  Encrypting your existing data
      • EPOLICY MANAGE UPDATE EXAMPLE
      • All new data is encrypted
    •  Running with Transparent Data Encryption enabled
      • Manual start
      •  Autostart
        • Change autostart configuration
        • Disabling autostart
        • Temporary files
      • Restricted utility access
      • Database backups
      • Moving tables and indexes
      • Binary dump and load of data
      • Auditing Transparent Data Encryption
      • Replication support
    •  Maintaining Transparent Data Encryption
      • Rekey encryption policies with Data Admin
      •  Rekey encryption policies with PROUTIL EPOLICY
        • Change the cipher of an encryption policy
      • Viewing encryption policy history in Data Admin
    • Disabling encryption
    • OpenEdge SQL support for Transparent Data Encryption
  •  Replicating Data
    •  Replication schemes
      • Trigger-based replication
      • Log-based site replication
      • Replication models
    •  Database ownership models
      • Distribution model
      •  Consolidation model
        • Peer-to-peer model
    •  Implementing log-based site replication
      • Log-based replication procedure
  •  Failover Clusters
    •  Overview
      •  Related software and hardware
        • AIX (64-bit)
        • HPUX (64-bit PA-RISC and Itanium)
        • SUN Solaris Sparc (64-bit)
        • Windows
      • Installation
      •  Configuration
        • AIX
        •  HPUX
          • Modifying the java_env script
        • SUN Solaris Sparc
        • Windows
    • Security
    • Performance
    • Logging
    • Required cluster components
    • Network considerations
    •  Terms and concepts
      • Resources and dependencies
      • Failure and recovery action
      • Fail over policies
    •  Using the PROCLUSTER command-line interface
      • Cluster-enabling a database
      • Disabling a cluster-enabled database
      • Starting a cluster-enabled database
      • Stopping a cluster-enabled database
      • Terminating a cluster-enabled database
      • Isalive and looksalive
    •  Results of enabling an OpenEdge database for fail over
      • Database UUID file (HPUX 64 bit only)
      • Changing the structure of the database
      • Adding extents on a volume group or file system different from the database (AIX only)
    •  Platform-specific considerations
      • Adding nodes where the database can be run for AIX
      • Upper limit on the number of packages for HPUX
      • Directory of registered packages for HPUX
      • Restarting on the same node for HPUX
      • Sun Cluster uses global devices
      • Windows Server 2008 R2 Cluster support with OpenEdge Windows 64-bit
    • Using a cluster-enabled database with the AdminServer
    • Using a cluster-enabled database with standard commands
    •  Using the Windows Cluster Administrator
      • Starting a database resource with the Cluster Administrator
      • Shutting down a database resource with the Cluster Administrator
      • Adding a secondary broker
    • Emergency disabling of a cluster-enabled database
    • UNIX cluster management commands
  •  Distributed Transaction Processing
    • Distributed transactions
    •  Two-phase commit with ABL clients
      • How the database engine implements two-phase commit
      • Two-phase commit and roll-forward recovery
      • Enabling two-phase commit
      • Modifying the database nickname and priority
      • Transaction log area
      • Deactivating two-phase commit
      • Limbo transactions with two-phase commit
      • Resolving limbo transactions
      • Resolving limbo transactions with PROUTIL
      •  Resolving limbo transaction scenarios
        • Scenario 1: You are on a client machine and the server fails
        • Scenario 2: You are starting up PROUTIL and have a power failure
        • Scenario 3: You are on a client machine and it fails
      • Two-phase commit case study
    •  Java Transaction API (JTA) support
      • JTA resource impact
      • JTA processing impact
      • Enabling JTA support
      • Disabling JTA support
      • JTA transactions and OpenEdge Replication
      • Monitoring JTA transactions
      • Resolving JTA transactions
•  Maintaining and Monitoring Your Database
  •  Managing Performance
    • Introduction to performance management
    •  Tools for monitoring performance
      • PROMON utility
      • Virtual system tables
    •  Server performance factors
      • CPU usage
      • Disk I/O
      •  Database I/O
        • Storage areas
        • Database buffers
        • How the database engine writes modified buffers
        • Monitoring database buffer activity
        • Tuning database buffers
        • Using private read-only buffers
        • Using APWs to improve performance
        • Monitoring APWs
        • Monitoring user I/O
        • LRU Concurrency
      •  Before-image I/O
        • Monitoring BI activity
        • Moving the BI file
        • Using a before-image writer
        • Providing more BI buffers
        • Increasing the BI cluster size
        • Increasing the number of BI clusters
        • Increasing the BI block size
        • Delaying BI writes
        • Setting a BI threshold
        • Enabling threshold stall
        • Using PROQUIET to adjust the BI threshold
      •  After-image I/O
        • Monitoring AI activity
        • Using an after-image writer
        • Increasing the AI block size
      • Direct I/O
    •  Memory usage
      • Process address space overview
      • Controlling memory use
      • Shared memory allocation
      • Monitoring memory use
      • Shared memory summary
    •  Alternate Buffer Pool
      • Overview
      •  Designating objects to the Alternate Buffer Pool
        • Specifying areas for the Alternate Buffer Pool
        • Specifying objects for the Alternate Buffer Pool
        • Data definition files
      •  Viewing Alternate Buffer Pool selections
        • Viewing Alternate Buffer Pool settings with the Data Dictionary
        • Viewing Alternate Buffer Pool settings with PROUTIL
      • Allocating Alternate Buffer Pool
    •  Operating system resources
      • Processes
      •  Semaphores
        • Allocating semaphores
      • Spin locks
      • File descriptors
    •  Network Communication
      •  Prefetch tuning
        • Enabling prefetch delay
        • Specifying number of records prefetched
        • Specifying the percent of a network buffer used for prefetch records
        • Calculating prefetch buffer utilization
        • Prefetch priority
      • Message wait
    •  Database fragmentation
      • Analyzing database fragmentation
      • Eliminating database fragmentation
      • Managing fragmentation
    •  Index use
      • Analyzing index use
      • Compacting indexes
      • Index utilities
      •  Rebuilding indexes
        • Overcoming SRT size limitations
        • Maximizing index rebuild performance
        • Reactivating unique indexes
      • Activating a single index
    • Virtual system tables
  •  Maintaining Database Structure
    • OpenEdge Structure utility
    • OpenEdge Structure Statistics utility
    • OpenEdge Structure List utility
    •  Using the OpenEdge Structure Add utility
      • PROSTRCT ADD and pathnames
      • Adding extents to existing storage areas
    • OpenEdge Structure Add Online utility
    •  Area numbers
      • Area number assignment
      • Trimming unused area memory
      •  Error checking
        • Server startup
        • Adding areas online
    • Validating structure description files
    • Using the OpenEdge Structure Remove utility
    •  Maintaining indexes and tables
      • Moving tables
      • Moving indexes
      • Compacting indexes
    •  Performing chain analysis online
      • Important considerations when performing chain analysis online
    • Using virtual system tables
  •  Multi-tenant database
    • Multi-tenant database introduction
    •  Multi-tenant database architecture
      • Simple tenancy
      • Multi-tenant groups
      • Multi-tenant features
    • Enabling multi-tenancy
    •  Creating multi-tenant elements
      •  Database administration tools
        •  Database Administration Console
          • Data Administration
          • ABL
        • Data Dictionary
        • Data Administration
      • ABL
      • OpenEdge SQL
    •  Tenant Data Recovery
      • Restrictions
      • Step 1: Restoring your database backup
      • Step 1A: restricting access to your temporary database
      • Step 2: Rolling forward after-image files
      •  Step 3: Moving data with PROUTIL DATAMOVE
        • Move one table with the DATAMOVE command line
        • Move one sequence with the DATAMOVE command line
      •  Move multiple tables and sequences with the DATAMOVE user interface
        • Move table data by tenant
        • Move Sequence values by tenant
        • Move table data by group
        • Set records per transaction
      •  Step 4: Tenant data recovery clean up
        • Remove access restriction from your source database
        • Delete source database
    •  Database utilities
      • Unchanged utilities
      • Indirectly changed utilities
      • Multi-tenant aware utilities
      • Multi-tenant index rebuild
      • Controlling the usage of multi-tenant database resources using multi-tenant governors
  •  Table-partitioned database
    • Table partitioning details
    • Table partition types
    • Table partitioning restrictions
    • Indexes for table partitions
    • Partitioning your database
    •  Managing partitions
      • Splitting partitions
      • Merging partitions
      • Truncating partitions
      • Renaming partitions
      • Altering partition state
      • Viewing partitions
      •  Copying partition data
        • Restrictions on copying a partition
        • Step 1: Restoring your database backup
        • Step 1A: restricting access to your temporary database
        • Step 2: Rolling forward after-image files
        •  Step 3: Moving data with PROUTIL PARTITIONMANAGE COPY
          • Copy one partition with the PARTITIONMANAGE COPY command line
          • Copy multiple partitions with the PARTITIONMANAGE COPY user interface
        •  Step 4: Partition copy clean up
          • Remove access restriction from your source database
          • Clear partition copy pending state
    •  Partition-level database administration
      • Partition-scoped utilities
      • Table-partitioned index rebuild
  •  Dumping and Loading
    •  Overview of dumping and loading
      • Dump and load limitations
    •  Dumping ABL database definitions
      • Dumping ABL database or table definitions
      • Definition file format
      • Multi-tenant keywords
      • Creating an incremental ABL data definitions file
      • Dumping sequence definitions
      • Dumping auto-connect records
    •  Dumping database contents
      •  Dumping table contents with PROUTIL
        • Results of a binary dump with PROUTIL
        • Format of a binary dump file
      • Dumping selective contents with PROUTIL
      • Dumping table contents with a Data tool
      • Contents file format
      • Dumping sequence values with a Data tool
      • Dumping user table contents with a Data tool
      • Dumping an SQL view file's contents with a Data tool
    •  Loading database definitions
      • Loading updated ABL data definitions
    •  Loading database contents
      •  Loading table contents in binary format with PROUTIL
        • Recovering from an aborted binary load
      • Loading table contents with a Data tool
      • Loading user table contents with a Data tool
      • Loading an SQL view file contents
      • Loading sequence values using a Data tool
    •  Bulk loading
      • Creating a Bulk Loader description file
      • Modifying a Bulk Loader description file
      • Loading table contents with the Bulk Loader qualifier
    • Reconstructing bad load records
    •  Specialized dump and load techniques
      • Creating a starting version of a database
      • Using a constant table in multiple databases
      • Economizing disk space
      • Optimizing data for sequential access
      • Optimizing data for random access
      • Using no-integrity mode bulk data loading
      •  Saving disk space by deactivating indexes
        • Deactivating indexes from Data Administration
        • Deactivating indexes from the Data Dictionary
        • Deactivating indexes from an ABL procedure
  •  Logged Data
    • OpenEdge database log file
    • Managing log file size
    •  Saving key database events
      • Defining key events
      • Saving key events
      • Enabling save key events
      • Disabling save key events
      • Stored key events
      •  _KeyEvt table
        • _KeyEvt table creation
        • _KeyEvt schema
        • _KeyEvt table maintenance
    •  Event logging in Windows
      • Managing OpenEdge RDBMS events in Windows
      • Understanding the event log components
      • The Event Log and the registry
    • Client database-request statement caching
•  Reference
  •  Startup and Shutdown Commands
    • Startup command syntax
    • Database startup and shutdown commands
    • PROAIW command
    • PROAPW command
    • PROBIW command
    • PROQUIET command
    • PROSERVE command
    • PROSHUT command
    • PROWDOG command
  •  Database Startup Parameters
    • Issuing startup parameters
    • Database server performance parameters
    • Database server-type parameters
    • Database server internationalization parameters
    • Database server statistics parameters
    • Database server consistency check parameters
    • Database server SSL connection parameters
    • Database server network parameters
    • Startup parameter usage categories
    •  Alphabetical listing of database startup parameters
      • AdminServer Port (-adminport)
      • After-image File Management Archive Directory List (-aiarcdir)
      • After-image File Management Archive Directory Create (-aiarcdircreate)
      • After-image File Management Archive Interval (-aiarcinterval)
      • After-image Buffers (-aibufs)
      • After-image Stall (-aistall)
      • Area consistency check (-AreaCheck)
      • Blocks in Database Buffers (-B)
      • Blocks in Alternate Buffer Pool (-B2)
      • Base Index (-baseindex)
      • Base Table (-basetable)
      • Before-image Buffers (-bibufs)
      • Threshold Stall (-bistall)
      • Recovery Log Threshold (-bithold)
      • Schema Cache File (-cache)
      • SQL Server Java Classpath (-classpath)
      • Cluster Mode (-cluster)
      • Conversion Map (-convmap)
      • Case Table (-cpcase)
      • Collation Table (-cpcoll)
      • Internal Code Page (-cpinternal)
      • Log File Code Page (-cplog)
      • Print Code Page (-cpprint)
      • R-code in Code Page (-cprcodein)
      • Stream Code Page (-cpstream)
      • Terminal Code Page (-cpterm)
      • Crash Recovery Status (-crStatus)
      • Crash Recovery Transaction Display (-crTXDisplay)
      • Database consistency check (-DbCheck)
      • Direct I/O (-directio)
      • Encryption cache size (-ecsize)
      • Enforce Mm (-enforceMm)
      • Event Level (-evtlevel)
      • Before-image Truncate Interval (-G)
      • Group Delay (-groupdelay)
      • Host Name (-H)
      • Hash Table Entries (-hash)
      • No Crash Protection (-i)
      • Index consistency check (-IndexCheck)
      • Index Range Size (-indexrangesize)
      • Internet Protocol (-ipver)
      • Key Alias (-keyalias)
      • Key Alias Password (-keyaliaspasswd)
      • Lock Governor (-LGovernor)
      • Lock Table Entries (-L)
      • Lock Table Hash Size (-lkhash)
      • Lock release (-lkrela)
      • LRU force skips (-lruskips)
      • LRU alternate buffer pool force skips (-lru2skips)
      • Auto Server (-m1)
      • Manual Server (-m2)
      • Secondary Login Broker (-m3)
      • Maximum Clients per Server (-Ma)
      • Maximum area number (-maxAreas)
      • Maximum Dynamic Server (-maxport)
      • Maximum JTA Transactions (-maxxids)
      • Memory consistency check (-MemCheck)
      • Delayed BI File Write (-Mf)
      • Minimum Clients per Server (-Mi)
      • Minimum Dynamic Server (-minport)
      • Message Buffer Size (-Mm)
      • Maximum Servers (-Mn)
      • Servers per Protocol (-Mp)
      • Maximum Servers per Broker (-Mpb)
      • User MUX Latches (-mux)
      • Shared-memory Overflow Size (-Mxs)
      • Network Type (-N)
      • Number of Users (-n)
      • Nap Time Increment (-napinc)
      • Nap Maximum (-napmax)
      • Nap Time Steps (-napstep)
      • Login Governor (-nGovernor)
      • Message Wait (-Nmsgwait)
      • No Session Cache (-nosessioncache)
      • Storage Object Cache Size (-omsize)
      • Prompt for Passphrase (-Passphrase)
      • Pending Connection Time (-PendConnTime)
      • Parameter File (-pf)
      • Database Service Communication Area Size (-pica)
      • Pin Shared Memory (-pinshm)
      • Prefetch delay (-prefetchDelay)
      • Prefetch factor (-prefetchFactor)
      • Prefetch Num Recs (-prefetchNumRecs)
      • Prefetch Priority (-prefetchPriority)
      • Configuration Properties File (-properties)
      • Buffered I/O (-r)
      • Service Name (-S)
      • Schema Lock Wait Queue(-schlockwq)
      • Semaphore Sets (-semsets)
      • Server Group (-servergroup)
      • Session Timeout (-sessiontimeout)
      • Shared memory segment size (-shmsegsize)
      • Spin Lock Retries (-spin)
      • SQL rowid identifier(-SQLQuotedRowid)
      • SSL (-ssl)
      • Temporary Directory (-T)
      • Table consistency check (-TableCheck)
      • Table Range Size (-tablerangesize)
      • Transaction End (TXE) Lock Retry Limit (-TXERetryLimit)
      • Century Year Offset (-yy)
  •  PROMON Utility
    • PROMON utility
    • PROMON User Control option
    • PROMON Locking and Waiting statistics option
    • PROMON Block Access option
    • PROMON Record Locking Table option
    • PROMON Activity option
    • PROMON Shared Resources option
    • PROMON Database Status option
    • PROMON Shut Down Database option
    • PROMON Currently Connected Tenants option
    • PROMON R&D Advanced Options
    •  R&D Status Displays
      • Database
      • Backup
      • Servers
      • Processes/Clients
      • Files
      • Lock Table
      • Buffer Cache
      • Logging Summary
      • BI Log
      • AI Log
      • Two-phase Commit
      • Startup Parameters
      • Shared Resources
      • Shared Memory Segments
      • AI Extents
      • Database Service Manager
      • Servers by broker
      •  Client Database-Request Statement Cache
        • Activating database-request statement caching for selected users
        • Activating database-request statement caching for all users
        • Activating database-request statement caching for all future users
        • Deactivating database-request statement caching for selected users
        • Viewing database-request statement caching
        • Specifying a directory for database-request statement caching files
      • Schema Locks & Wait Queue
      • Broker Startup Parameters
    •  R&D Activity Displays
      • Summary
      • Servers
      • Buffer Cache
      • Page Writers
      • BI Log
      • AI Log
      • Lock Table
      • I/O Operations By Type
      • I/O Operations by File
      • Space Allocation
      • Index
      • Record
      • Other
    •  R&D Other Displays
      • Performance Indicators
      • I/O Operations by Process
      • Lock Requests by User
      • Checkpoints
      • I/O Operations by User by Table
      • I/O Operations by User by Index
      • Total Locks per User
    •  R&D Administrative Functions
      • Check Active Transaction Status
      • Check Two-Phase Transactions
      • Resolve Limbo Transactions
      • Adjust Latch Options
      • Adjust Page Writer Options
      • Restricted Options
      • Server Options
      • Enable/disable block level consistency check
      • Shutdown Database
      • Disconnect a tenant's users
      • Adjust Governor options
    • R&D Adjust Monitor Options
    • PROMON 2PC Transactions Control option
    • PROMON Resolve 2PC Limbo Transactions option
    • PROMON 2PC Coordinator Information option
    • PROMON Resolve JTA Transactions option
    • PROMON Modify Defaults option
  •  PROUTIL Utility
    • PROUTIL utility syntax
    • PROUTIL 2PHASE BEGIN qualifier
    • PROUTIL 2PHASE COMMIT qualifier
    • PROUTIL 2PHASE END qualifier
    • PROUTIL 2PHASE MODIFY qualifier
    • PROUTIL 2PHASE RECOVER qualifier
    • PROUTIL AUDITARCHIVE qualifier
    • PROUTIL AUDITLOAD qualifier
    • PROUTIL AUDITRECONFIG qualifier
    • PROUTIL BIGROW qualifier
    • PROUTIL BULKLOAD qualifier
    • PROUTIL BUSY qualifier
    • PROUTIL CHANALYS qualifier
    • PROUTIL CODEPAGE-COMPILER qualifier
    • PROUTIL CONV1011 qualifier
    • PROUTIL CONVCHAR qualifier
    • PROUTIL CONVFILE qualifier
    • PROUTIL DATAMOVE qualifier
    •  PROUTIL DBANALYS qualifier
      •  Database analysis output
        • Output file format
    • PROUTIL DBAUTHKEY qualifier
    • PROUTIL DBIPCS qualifier
    • PROUTIL DBRESTRICT qualifier
    • PROUTIL DEALLOCATE qualifier
    • PROUTIL DESCRIBE qualifier
    • PROUTIL DISABLEAUDITING qualifier
    •  PROUTIL DISABLEB2 qualifier
      • PROUTIL DEALLOCATE qualifier
    • PROUTIL DISABLEENCRYPTION qualifier
    • PROUTIL DISABLEJTA qualifier
    • PROUTIL DISABLEKEYEVENTS qualifier
    • PROUTIL DISABLEMTIDXBLD qualifier
    • PROUTIL DISABLEMULTITENANCY qualifier
    • PROUTIL DISABLENEWVSTTABLES qualifier
    • PROUTIL DISABLEREADONLYPARTITIONS qualifier
    • PROUTIL DISABLETABLEPARTITIONING qualifier
    • PROUTIL DISABLETPIDXBLD qualifier
    • PROUTIL DISPTOSSCREATELIMITS qualifier
    • PROUTIL DUMP qualifier
    • PROUTIL DUMPSPECIFIED qualifier
    • PROUTIL ENABLEAUDITING qualifier
    • PROUTIL ENABLEB2 qualifier
    • PROUTIL ENABLEENCRYPTION qualifier
    • PROUTIL ENABLEJTA qualifier
    • PROUTIL ENABLEKEYEVENTS qualifier
    • PROUTIL ENABLELARGEFILES qualifier
    • PROUTIL ENABLELARGEKEYS qualifier
    • PROUTIL ENABLEMTIDXBLD qualifier
    • PROUTIL ENABLEMULTITENANCY qualifier
    • PROUTIL ENABLENEWVSTTABLES qualifier
    • PROUTIL ENABLEREADONLYPARTITIONS qualifier
    • PROUTIL ENABLESEQ64 qualifier
    • PROUTIL ENABLESTOREDPROC qualifier
    • PROUTIL ENABLETABLEPARTITIONING qualifier
    • PROUTIL ENABLETPIDXBLD qualifier
    • PROUTIL EPOLICY INFO qualifier
    • PROUTIL EPOLICY MANAGE qualifier
    • PROUTIL EPOLICY SCAN qualifier
    • PROUTIL EPOLICY VIEW qualifier
    • PROUTIL HOLDER qualifier
    • PROUTIL IDXACTIVATE qualifier
    • PROUTIL IDXANALYS qualifier
    • PROUTIL IDXBUILD qualifier
    • PROUTIL IDXCHECK qualifier
    • PROUTIL IDXCOMPACT qualifier
    • PROUTIL IDXDEACTIVATE
    • PROUTIL IDXFIX qualifier
    • PROUTIL IDXMOVE qualifier
    • PROUTIL INCREASETO qualifier
    • PROUTIL IOSTATS qualifier
    • PROUTIL LOAD qualifier
    • PROUTIL MTIDXBUILD qualifier
    • PROUTIL MVSCH qualifier
    • PROUTIL PARTITIONMANAGE ALTER qualifier
    • PROUTIL PARTITIONMANAGE COPY qualifier
    • PROUTIL PARTITIONMANAGE MERGE qualifier
    • PROUTIL PARTITIONMANAGE RENAME qualifier
    • PROUTIL PARTITIONMANAGE SPLIT qualifier
    • PROUTIL PARTITIONMANAGE TRUNCATE qualifier
    • PROUTIL PARTITIONMANAGE VIEW qualifier
    • PROUTIL RCODEKEY qualifier
    • PROUTIL SETAREACREATELIMIT qualifier
    • PROUTIL SETAREATOSSLIMIT qualifier
    • PROUTIL SETLOBCREATELIMIT qualifier
    • PROUTIL SETLOBTOSSLIMIT qualifier
    • PROUTIL SETTABLECREATELIMIT qualifier
    • PROUTIL SETTABLETOSSLIMIT qualifier
    • PROUTIL TABANALYS qualifier
    • PROUTIL TABLEMOVE qualifier
    • PROUTIL TPIDXBUILD qualifier
    • PROUTIL TRUNCATE AREA qualifier
    • PROUTIL TRUNCATE BI qualifier
    • PROUTIL UPDATESCHEMA qualifier
    • PROUTIL UPDATEVST qualifier
    • PROUTIL VIEWB2 qualifier
    • PROUTIL WBREAK-COMPILER qualifier
    • PROUTIL WORD-RULES qualifier
  •  PROSTRCT Utility
    • PROSTRCT utility
    • PROSTRCT ADD qualifier
    • PROSTRCT ADDONLINE qualifier
    • PROSTRCT BUILDDB qualifier
    • PROSTRCT CLUSTER CLEAR qualifier
    • PROSTRCT CREATE qualifier
    • PROSTRCT LIST qualifier
    • PROSTRCT REMOVE qualifier
    • PROSTRCT REORDER AI qualifier
    • PROSTRCT REPAIR qualifier
    • PROSTRCT STATISTICS qualifier
    • PROSTRCT UNLOCK qualifier
  •  RFUTIL Utility
    • RFUTIL utility syntax
    • RFUTIL AIARCHIVER DISABLE qualifier
    • RFUTIL AIARCHIVER ENABLE qualifier
    • RFUTIL AIARCHIVER END qualifier
    • RFUTIL AIARCHIVER SETDIR qualifier
    • RFUTIL AIARCHIVER SETINTERVAL qualifier
    • RFUTIL AIARCHIVE EXTENT qualifier
    • RFUTIL AIMAGE AIOFF qualifier
    • RFUTIL AIMAGE BEGIN qualifier
    • RFUTIL AIMAGE END qualifier
    • RFUTIL AIMAGE EXTENT EMPTY qualifier
    • RFUTIL AIMAGE EXTENT FULL qualifier
    • RFUTIL AIMAGE EXTENT LIST qualifier
    • RFUTIL AIMAGE EXTRACT qualifier
    • RFUTIL AIMAGE NEW qualifier
    • RFUTIL AIMAGE QUERY qualifier
    • RFUTIL AIMAGE SCAN qualifier
    • RFUTIL AIMAGE TRUNCATE qualifier
    • RFUTIL AIVERIFY PARTIAL qualifier
    • RFUTIL AIVERIFY FULL qualifier
    • RFUTIL MARK BACKEDUP qualifier
    • RFUTIL ROLL FORWARD qualifier
    • RFUTIL ROLL FORWARD OPLOCK qualifier
    • RFUTIL ROLL FORWARD RETRY qualifier
    • RFUTIL ROLL OPUNLOCK qualifier
    • RFUTIL SEQUENCE qualifier
  •  Other Database Administration Utilities
    • Parameters for authentication
    • DBMAN utility
    •  DBTOOL utility
      • Running DBTOOL
    • DSRUTIL utility
    • PROADSV utility
    • PROBKUP utility
    • PROCLUSTER utility
    • PROCOPY utility
    • PRODB utility
    • PRODEL utility
    • PROLOG utility
    • PROREST utility
  •  SQL Utilities
    • SQLDUMP utility
    • SQLLOAD utility
    • SQLSCHEMA utility
  •  Virtual System Tables
    • Update access to virtual system tables
    • Accessing VSTs with ABL or SQL
    •  Virtual system table summaries
      • After-image log activity (_ActAILog)
      • Before-image log activity (_ActBILog)
      • Buffer activity (_ActBuffer)
      • Index activity (_ActIndex)
      • Input/output activity (_ActIOFile)
      • Input/output type activity (_ActIOType)
      • Lock table activity (_ActLock)
      • Other activity (_ActOther)
      • Page writer activity (_ActPWs)
      • Record activity (_ActRecord)
      • Server activity (_ActServer)
      • Space allocation activity (_ActSpace)
      • Summary activity (_ActSummary)
      • Area status (_AreaStatus)
      • Area threshold (_AreaThreshold)
      • Block (_Block)
      • Buffer status (_BuffStatus)
      • Checkpoint (_Checkpoint)
      • Code Features (_Code-Feature)
      • Database connection (_Connect)
      • Database features (_Database-Feature)
      • Database startup parameters file status (_DbParams)
      • Database status (_DbStatus)
      • Database file status (_Filelist)
      • Index statistics (_IndexStat)
      • Latch statistics (_Latch)
      • License management (_License)
      • Lock table status (_Lock)
      • Lock request (_LockReq)
      • Logging (_Logging)
      • Master block (_MstrBlk)
      • User connection (_MyConnection)
      • Resource queue statistics (_Resrc)
      • Segments (_Segments)
      • Servers (_Servers)
      • SQL query plan (_SQL_Qplan)
      • Startup (_Startup)
      • Index and table statistics range (_StatBase)
      • Table statistics (_TableStat)
      • Transaction (_Trans)
      • Transaction end lock statistics (_TxeLock)
      • User index activity (_UserIndexStat)
      • Database input/output (_UserIO)
      • Record locking table (_UserLock)
      • User status (_UserStatus)
      • User table activity (_UserTableStat)