Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL DESCRIBE qualifier


Displays descriptive information about the database and enabled features.


proutil dbname -C describe


Specifies the database to describe.
PROUTIL DESCRIBE provides a basic description of the database and details which features are enabled for the database.
The following figure provides a sample of the PROUTIL DESCRIBE output.
Figure 55. PROUTIL DESCRIBE sample output
OpenEdge Database Description

Database Name : /usr1/dbs/sample_db
Version : 173.0
Block Size : 8192
Largest Cluster : 64
Create Date : Mon Dec 10 13:04:58 2012
Last Open Date : Mon Dec 10 13:25:24 2012
Prior Open Date : Mon Dec 10 13:25:24 2012
Schema Change Date : Mon Dec 10 13:05:09 2012

Before Imaging information
Block Size : 8192
Cluster Size (16K Units) : 32
Last Open Date : Mon Dec 10 13:05:25 2012
Bi Encryption : Enabled

After Imaging Information
Block Size : 8192
Begin Date : Mon Dec 10 13:05:25 2012
Last AIMAGE NEW : Mon Dec 10 13:05:26 2012
Currently Busy Area : 13
Current File Number : 2
Ai Encryption : Enabled

Backup Information
Last Full Backup Date : Mon Dec 10 13:05:17 2012
Last Incremental Backup : *** Not yet performed ***

Database Features

ID Feature Active Details
---- --------------------------------- ------ -------
     1 OpenEdge Replication               Yes     Source database
     7  JTA                                Yes
     9 64 Bit DBKEYS                      Yes
    10 Large Keys                         Yes
    11 64 Bit Sequences                   Yes
    13 Encryption                         Yes
    14  Multi-tenancy                      Yes
    15  Concurrent JTA and Replication     Yes
The PROUTIL DESCRIBE output contains the following fields:
Database Name
The fully qualified name of the database.
The internal database version number.
Block Size
The block size of the database, measured in bytes.
Largest Cluster
The largest cluster size, in blocks, for all of the database data areas.
Create Date
The date and time the database was created.
Last Open Date
The date and time the database was last opened.
Prior Open Date
The date and time of the penultimate database open.
Schema Change Date
The date and time of the last schema change.
Before Imaging Information
The details of the database Before-Image areas, including:
*Block Size — The size (in bytes) of the before-image blocks
*Cluster Size (16K Units) — The size of the before-image cluster, measured in units of 16K
*Last OpenDate — The date and time the before-image log was last opened
*Bi Encryption — Indicates if BI encryption is enabled or disabled
After Imaging Information
The details of After-Imaging areas, if after-imaging is enabled, including:
*Block Size — The size (in bytes) of the after-image blocks
*Begin Date — The date and time after-imaging was started
*Last AIMAGE NEW — The date and time the last RFUTIL AIMAGE NEW command was executed, forcing an extent switch
*Currently Busy Area — The area number of the currently busy after-image area
*Current File Number — The current after-image file number
*Ai Encryption — Indicates if AI encryption is enabled or disabled
Two-Phase Commit Information
The details of two-phase commit, if enabled, including:
*Nickname — The 2PC database nickname
*Coordinator Priority — The 2PC coordinator priority for the database
Backup Information
The details of recent database backup activity, including:
*Last Full Backup Date — The date and time of the last full backup
*Last Incremental Backup — The date and time of the last incremental backup
Database Features
The details of the enabled features of the database, including:
*ID — The ID number of the feature.
*Feature — The name of the feature.
*Active — Is the feature active? Yes/No. Features, such as Auditing, can be enabled, but not active.
*Details — Provides special information pertinent to the feature. For example, for OpenEdge Replication, the database type is listed.
The table below lists the possible ID and Feature names.
Table 96. Database features
OpenEdge Replication
DataXtend Remote Edition
Large File support
Database Auditing
AI Management
64-bit DB Keys
Large Keys (for indexes)
64-bit Sequences
DataXtend Integration Edition
Transparent Data Encryption
Concurrent JTA and Replication
MT Index Rebuild
TP Index Rebuild
Table Partitioning
Read-only Partitions
New VST Tables
Failover Clusters
Save Key Events


DESCRIBE can be run against a database that is online or offline.