OpenEdge 10.1B introduced the
PROUTIL -C describe function which can be run online or offline. The output provides:
- A basic description of the database
- Details which features are enabled for the database.
Sample output from:
proutil dbname -C describe OpenEdge Database Description
Database Name : <path>\<dbname>
Version : 150.0
Block Size : 8192
Largest Cluster : 64
Create Date : Fri Mar 12 18:00:26 2010
Last Open Date : Mon Mar 15 15:42:40 2010
Prior Open Date : Mon Mar 15 15:42:40 2010
Schema Change Date : Sat Feb 09 20:18:56 2008
Before Imaging information
Block Size : 16384
Cluster Size (16K Units) : 1024
Last Open Date : Fri Mar 12 18:00:28 2010
After Imaging Information
Block Size : 16384
Begin Date : Fri Mar 12 18:00:26 2010
Last AIMAGE NEW : Fri Mar 12 18:17:03 2010
Currently Busy Area : 17
Current File Number : 9
Backup Information
Last Full Backup Date : Fri Mar 12 18:00:28 2010
Last Incremental Backup : *** Not yet performed ***
Database Features
ID Feature Active Details
---- --------------------------------- ------ -------
1 OpenEdge Replication Yes Source database
6 Database Auditing Yes
8 After Image Management/Archiver Yes
9 64 Bit DBKEYS Yes
10 Large Keys Yes
11 64 Bit Sequences Yes Feature IDs and their associated
Feature Name in the latest OpenEdge 11.7 version.
1 OpenEdge Replication
2 Failover Clusters
5 Large Files
6 Database Auditing
7 JTA
8 After Image Mangement/Archiver
9 64 Bit DBKEYS
10 Large Keys
11 64 Bit Sequences
13 Encryption
14 Multi-tenancy
15 Concurrent JTA and Replication
17 MT Index Rebuild
18 MT Data Move
19 Roll Forward Restricted Mode
20 TP Index Rebuild
21 Table Partitioning
22 Read-only Partitions
23 New VST Tables
24 Partition Move
25 Partition Copy
26 Authentication Gateway
27 Change Data Capture
28 Backup Counter Extension (11.7.5)
- Failover Clusters
- Save Key Events
The above features can be queried through the _Database-Feature VST:
FOR EACH _Database-Feature:
DISPLAY
_DBFeature-ID FORMAT ">9" LABEL "ID"
_DBFeature_Name FORMAT "X(20)" LABEL "NAME"
_DBFeature_Active FORMAT "9" LABEL "ACTIVE"
_DBFeature_Enabled FORMAT "9" LABEL "ENABLED"
WITH FRAME ft DOWN.
END.
For further information please refer to the OpenEdge 10.1B+ Database Documentation:
OpenEdge Database Administration, Reference, PROUTIL DESCRIBE qualifier
