IDMSDBAN

The IDMSDBAN database analysis utility analyzes the characteristics and structure of a CA IDMS/DB database (both non-SQL and SQL-defined). The utility provides information useful for system tuning, database structuring, and capacity planning.

IDMSDBAN also verifies the integrity of:

Page structures
Line indexes
Record lengths
Record locations
Set connections for:
- Chained sets
- Constraints
- Indexed sets
- The CALC set
- Variable-length-record fragment chains

Authorization

To	You Need This Privilege	On
Analyze an area	DBAREAD	The area
Analyze a set, constraint, or table	DBAREAD	The area where the set, constraint, or table resides