Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Manage the OpenEdge Database

SQL Utilities

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Database Basics
    • Creating and Deleting Databases
      • Ways to create an OpenEdge database
      • Database creation and large file support
      • Create 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
      • Create a database with the PRODB utility
      • PRODB maintains pathname convention
      • Create a database with a Data tool
      • Convert an OpenEdge Release 11 Database to OpenEdge Release 12
      • Using the Schema Mover
      • Converting an OpenEdge Release 10 database to OpenEdge Release 12
      • Database conversion utilities
      • Copy a database
        • Copy a database using PROCOPY
          • PROCOPY uses absolute pathnames
      • Delete 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
      • 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 TLS connections
      • Threaded Database Server Functionality Delivered on Windows NT64, AIX64, and Linux64 Platforms
        • Initiate a Threaded Server Process
        • Monitor Threaded Servers and Remote 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
          • Backup Counter Increment limits using the PROBKUP Utility with Type I storage areas
        • 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 encoded 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
        • Asynchronous replication
      • Database ownership models
        • Distribution model
        • Consolidation model
          • Peer-to-peer model
      • Implementing log-based site replication
        • Log-based replication procedure
    • Failover Clusters
    • 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
        • Resolve 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
        • Resolve 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
        • Shared memory and kernel configuration
        • 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
        • Activate a single index
        • Database Client Notification
      • Changing Database Client Notification poll time
      • Change database parameters while the database is running
      • 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
        • Add extents to existing storage areas
      • OpenEdge Structure Add Online utility
      • Extend variable-length database extents
      • 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
        • Change non-structural fields of _File and _Field online
        • Change Int to Int64 online
        • 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
      • Enable multi-tenancy
      • Creating multi-tenant elements
        • Database administration tools
          • Database Administration Console
          • 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
        • Showing syntax help for database utilities
    • 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
    • Diagnostic Data Collection
      • Events
        • Specifying an event
        • Event Levels
      • Data Files
      • Protrace data
      • C stack print option (-cstackPrintopt)
      • DiagProc file
      • Diagnostic data startup parameters
      • Diagnostic data collection in PROMON
        • Diagnostic Data Collection menu
      • Diagnostic data output file formats
        • Diagnostic tracking file
        • Diagnostic BI threshold files
        • Lock table overflow files
        • Syserror event files
    • 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
      • Dump Change Data Capture policies
      • Load 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
        • Modify a Bulk Loader description file
        • Load table contents with the Bulk Loader qualifier
      • Reconstruct 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
    • Logged Data
      • OpenEdge database log file
      • Database log file customization
      • Managing log file size
      • Log file archive and truncate
        • Log file truncate and archive startup parameters
        • PROMON Database Log file management
        • _DbParams VST
        • Archiving
        • Truncated and archived files
      • 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
        • Manage OpenEdge RDBMS events in Windows
        • Understand the event log components
        • The Event Log and the registry
      • Client database-request statement caching
      • Find connected brokers and servers
  • 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 TLS 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 LOB (-baselob)
        • Base Table (-basetable)
        • Base user index (-baseuserindex)
        • Base user LOB (-baseuserlob)
        • Base user table (-baseusertable)
        • Before-image Buffers (-bibufs)
        • Threshold Stall (-bistall)
        • Recovery Log Threshold (-bithold)
        • Maximum Private Buffers per Connection (-Bpmax)
        • 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)
          • Conversion Map (-convmap)
        • 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)
        • C stack print option (-cstackPrintopt)
        • Database consistency check (-DbCheck)
        • Database Notification Operations (-dbnotifyops)
        • Database Notification Time (-dbnotifytime)
        • Delayed BI File Write (-Mf)
        • Diagnostic directory (-diagDir)
        • Diagnostic events value (-diagEvent)
        • Diagnostic event level (-diagEvtLevel)
        • Diagnostic data format (-diagFormat)
        • Diagnostic field separator (-diagFS)
        • Diagnostic pause length (-diagPause)
        • Diagnostic prefix value (-diagPrefix)
        • Diagnostic process (-diagProc)
        • 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 Table Entries (-L)
        • Lock Governor (-LGovernor)
        • Log file archive enable (-lgArchiveEnable)
        • Log file archive directory (-lgArchiveDir)
        • Log file truncate frequency (-lgTruncateFrequency)
        • Log file truncate size (-lgTruncateSize)
        • Log file truncate time (-lgTruncateTime)
        • Limit log file payload (-limitLgPayload)
        • Lock Table Hash Size (-lkhash)
        • Lock release (-lkrela)
        • LOB range (-lobrangesize)
        • LRU force skips (-lruskips)
        • LRU alternate buffer pool force skips (-lru2skips)
        • Auto Server (-m1)
        • Secondary Login Broker (-m3)
        • Maximum area number (-maxAreas)
        • Maximum Clients per Server (-Ma)
        • Maximum Dynamic Server (-maxport)
        • Maximum JTA Transactions (-maxxids)
        • Memory consistency check (-MemCheck)
        • 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)
        • Multi-tenancy Partition Cache Size (-mtpmsize)
        • User MUX Latches (-mux)
        • Shared-memory Overflow Size (-Mxs)
        • Network Type (-N)
        • Number of Users (-n)
        • Nap Time (-nap)
        • Nap Maximum (-napmax)
        • Nap Time Steps (-napstep)
        • Login Governor (-nGovernor)
        • Message Wait (-Nmsgwait)
        • TLS No Host Verify (-nohostverify)
        • No Session Cache (-nosessioncache)
        • No Session Reuse (-nosessionreuse)
        • Number of checkpoint statistics (-numCheckpointStats)
        • Omit Log Messages (-omitLgMsgs)
        • Storage Object Cache Size (-omsize)
        • Prompt for Passphrase (-Passphrase)
        • Pending Connection Time (-PendConnTime)
        • Parameter File (-pf)
        • Database Service Communication Area Size (-pica)
        • Database PICA Queue Nap Time (-picanap)
        • 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)
        • Type of Server to Start (-ServerType)
        • Session Timeout (-sessiontimeout)
        • Shared memory segment size (-shmsegsize)
        • Spin Lock Retries (-spin)
        • Autonomous Update Statistics (-SQLAutoStats)
        • SQL Open Cursors (-SQLCursors)
        • Lock Wait Timeout (-SQLLockWaitTimeout)
        • SQL rowid identifier(-SQLQuotedRowid)
        • SQL Stack Size (-SQLStack)
        • SQL Statement Cache Size (-SQLStmtCache)
        • SQL Sorting Memory (-SQLTempBuff)
        • SQL Sorting on Disk (-SQLTempDisk)
        • SQL Temp Table Data Page (-SQLTempPageSize)
        • Authorized Data Truncation(-SQLTruncateTooLarge)
        • Autonomous Schema Update (-SQLWidthUpdate)
        • Server-side join (-ssj)
        • TLS Encryption for TCP/IP Connections (-ssl)
        • STS logging level (-stslogginglevel)
        • Temporary Directory (-T)
        • Table consistency check (-TableCheck)
        • Table Range Size (-tablerangesize)
        • Threaded Server (-threadedServer)
        • Threaded Server Stack (-threadedServerStack)
        • Transaction End (TXE) Lock Retry Limit (-TXERetryLimit)
        • Transaction End (TXE) Lock Skip Limit (-TXESkipLimit)
        • User index range (-userindexrangesize)
        • User LOB range (-userlobrangesize)
        • 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
        • LOB I/O operations in PROMON
        • 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
        • Diagnostic Data Collection
        • Modify database startup parameters online using PROMON
      • R&D Adjust Monitor Options
      • Advanced R&D
      • 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 CONV1112 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 DISABLEMULTITENANCY qualifier
      • PROUTIL DISABLEREADONLYPARTITIONS qualifier
      • PROUTIL DISABLETABLEPARTITIONING 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 ENABLELARGEKEYS qualifier
      • PROUTIL ENABLEMULTITENANCY qualifier
      • PROUTIL ENABLEREADONLYPARTITIONS qualifier
      • PROUTIL ENABLESTOREDPROC qualifier
      • PROUTIL ENABLETABLEPARTITIONING qualifier
      • PROUTIL EPOLICY INFO qualifier
      • PROUTIL EPOLICY MANAGE qualifier
      • PROUTIL EPOLICY SCAN qualifier
      • PROUTIL EPOLICY VIEW qualifier
      • PROUTIL HOLDER qualifier
      • PROUTIL IDXACTIVATE qualifier
      • PROUTIL IDXBLOCKREPORT 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 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 AIARCHIVE NEXTEXTENT 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
      • DBPOLICYUTIL utility
      • DBTOOL utility
        • Running DBTOOL
      • DSRUTIL utility
      • PROADSV utility
      • PROBKUP 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
      • Modifiable VSTs on Replication Targets
      • VSTs for LOB Activity
      • 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)
        • LOB activity (_LOBStat)
        • Lock table status (_Lock)
        • Lock request (_LockReq)
        • Logging (_Logging)
        • Master block (_MstrBlk)
          • Master block flags for troubleshooting damaged databases
        • User connection (_MyConnection)
        • Resource queue statistics (_Resrc)
        • Segments (_Segments)
        • Servers (_Servers)
        • SQL query plan (_SQL_Qplan)
        • Table statistics (_TableStat)
        • Transaction (_Trans)
        • Transaction end lock statistics (_TxeLock)
        • User index activity (_UserIndexStat)
        • Database input/output (_UserIO)
        • User LOB activity (_UserLOBStat)
        • Record locking table (_UserLock)
        • User status (_UserStatus)
        • User table activity (_UserTableStat)
Table of Contents

SQL Utilities

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: February 13, 2026
  • 1 minute read
    • OpenEdge
    • Version 12.2
    • Documentation

This chapter describes the OpenEdge database administration utilities for SQL.

Contents
  1. SQLDUMP utility
  2. SQLLOAD utility
  3. SQLSCHEMA utility
TitleResults for “How to create a CRG?”Also Available inAlert