Try OpenEdge Now

Database Administration

Reference : PROUTIL Utility : PROUTIL DESCRIBE qualifier

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 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.

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

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
ID	Feature
1	OpenEdge Replication
3	DataXtend Remote Edition
5	Large File support
6	Database Auditing
7	JTA
8	AI Management
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
15	Concurrent JTA and Replication
17	MT Index Rebuild
20	TP Index Rebuild
21	Table Partitioning
22	Read-only Partitions
23	New VST Tables
–	Failover Clusters
–	Save Key Events

Notes

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