

REPORT (Generate Reports) › Index Area (IXX) Reports
Index Area (IXX) Reports
The Index Area (IXX) Report provides information about keys. Specifically, it provides:
- The number of keys indexed for each table for the selected Index Area (IXX or Inn). You can request this report in either table name (TYPE=A) or key ID (TYPE=B) sequence. The statistics from which these reports derive the data are stored in the Directory (CXX). Therefore, if you move or copy the Index for a database using non-CA Datacom utilities (that is, DFDSS), and if you do not use the DBUTLTY function CXXCLONE (or DBUTLTY function LOAD AREA=CXX) to restore the CXX definitions and statistics into the target CXX, these statistics are not be accurate. The counts are likely to be inaccurate after a MUF outage other than an EOJ.
Take a backup of the source CXX first. Following is an example of the CXXCLONE statement:
CXXCLONE DBID=1022,STATUS=NO_CHANGE,DDNAME=BKPCXX,OPTION=DELETE
- A dump of the Index Area associated with a specific key (TYPE=D) or a dump of the high-level portion of the Index Area associated with a specific key (TYPE=E). Use only if requested by CA Support.
- The number of records that have unique values for key fields (TYPE=G).
Note: TYPE=A,B,D,E, and G run only in MUF, providing current data, including the ability to inspect virtual database data.
Copyright © 2015 CA Technologies.
All rights reserved.
 
|
|