Kbase P119416: How to identify what database features have been enabled for a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/15/2010 |
|
Status: Verified
GOAL:
How to identify what database features have been enabled for a database?
GOAL:
What is the current state of the database?
GOAL:
What is proutil -C describe
GOAL:
How to report on current database details?
GOAL:
When was the database last backed up?
GOAL:
How to find if Auditing is enabled ?
GOAL:
How to find if this is the source or target replication enabled database?
GOAL:
Is Large File Support enabled on this database?
GOAL:
Does this database participate in JTA transactions?
GOAL:
Are key events being recorded?
GOAL:
Is AI Management running on this database?
GOAL:
Are 64-bit keys enabled?
GOAL:
Are large keys for indexes enabled?
GOAL:
Is my database cluster-enabled
GOAL:
How to determine if 64-bit sequences are enabled for a database?
GOAL:
How does the ID relate to the database feature ?
FACT(s) (Environment):
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2x
All Supported Operating Systems
FIX:
In OpenEdge 10.1B, the introduction of PROUTIL -C DESCRIBE provides a basic description of the database and details which features are enabled for the database. It can be run online or offline.
Sample output from: "proutil dbname -C describe" command:
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:0