PROUTIL DESCRIBE qualifier

Displays descriptive information about the database and enabled features.

Syntax

proutil dbname -C describe

Parameters

db-name
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 1. 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 ***

Collation and Character Set Information
   Database code page      : utf-8
   Database collation      : ICU-UCA   
   Word-rule file number   : 254
   Word-rule file CRC	   : 53664  

 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.
Version
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
Collation and Character Set Information

The details of recent database backup activity, including:

  • Database code page — The name of the code page table that associates a numeric value with the corresponding character.
  • Database collation — The set of rules that determine the order for sorting and comparing.character data.
  • Word-rule file number — An integer between 1 and 255 that uniquely identifies the compiled word-break table.
  • Word-rule file CRC — A cyclic reduncancy check code that ensures that the word-break rule file does not change between sessions.

For more information, see About Code Pages and Character Processing Tables.

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 1. Database features
ID Feature
1 OpenEdge Replication
3 DataXtend Remote Edition
5 Large Files
6 Database Auditing
7 JTA
8 After Image Management/Archiver
9 64-bit DB Keys
10 Large Keys (for indexes)
11 64-bit Sequences
12 DataXtend Integration Edition
13 Transparent Data Encryption
14 Multi-tenancy
19 Roll Forward Restricted Mode
21 Table Partitioning
26 Authentication Gateway
27 Change Data Capture
33 Dynamic Data Masking

Notes

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