Preface
Purpose
Audience
Organization
Using ABL documentation
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
Database Client Notification
Changing Database Client Notification poll time
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
Change Data Capture
Change Data Capture highlights
CDC and other RDBMS features
Enabling CDC
Using the CDC cache
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 Change Data Capture policies
Loading Change Data Capture policies
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)
Base user index (-baseuserindex)
Base user table (-baseusertable)
Before-image Buffers (-bibufs)
Threshold Stall (-bistall)
Recovery Log Threshold (-bithold)
Schema Cache File (-cache)
CDC cache size (-cdcsize)
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)
Number of checkpoint statistics (-numcheckpointstats)
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)
Record free chain search depth factor (-recspacesearchdepth)
Service Name (-S)
Schema Lock Wait Queue(-schlockwq)
Security cache size (-secsize)
Semaphore Sets (-semsets)
Server Group (-servergroup)
Session Timeout (-sessiontimeout)
Shared memory segment size (-shmsegsize)
Spin Lock Retries (-spin)
Lock Wait Timeout (-SQLLockwaitTimeout)
SQL rowid identifier(-SQLQuotedRowid)
Authorized Data Truncation(-SQLTruncateToolarge)
Autonomous Schema Update (-SQLWidthUpdate)
SSL (-ssl)
STS logging level (-stslogginglevel)
Temporary Directory (-T)
Table consistency check (-TableCheck)
Table Range Size (-tablerangesize)
Transaction End (TXE) Lock Retry Limit (-TXERetryLimit)
User index range (-userindexrangesize)
User table range (-usertablerangesize)
Database Client Notification (-usernotifytime)
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
Caches
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 DISABLEAUTHGATEWAY qualifier
PROUTIL DISABLEB2 qualifier
PROUTIL DISABLECDC 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 ENABLEAUTHGATEWAY qualifier
PROUTIL ENABLEB2 qualifier
PROUTIL ENABLECDC 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
PROUTIL ZEROSTATS 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)
Cache (_Cache)
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)
Preface
User table activity (_UserTableStat)