Largest Database Records report


The Largest Database Records report lists the nnn largest database records and the root’s RBA and key.

A database record is a root segment plus its dependents. The records are listed in descending sequence, with the largest record first. The Unload function and the Reload function generate this report automatically. For more information, see REORGMSG.

When the database uses the IMS/ESA Partition Support Product, one report is generated for each partition. The Largest Database Records report provides the following information:

Field

Description

RECORD SIZE (BYTES)

The size of the database record in bytes. A database record is a root segment and its dependents. This size includes all segment prefixes.

NBR SEGS IN RECORD

The number of segments in the database record.

ROOT’S RBA

The relative byte address of the root segment. For HISAM databases, this field is blank because HISAM databases do not use RBAs.

ROOT’S KEY

The first 22 bytes of the key of the root segment. If the root’s key contains any unprintable character (any character less than X'40'), the entire key is printed in hexadecimal (two lines per record).


Related topic


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Online Reorg for IMS 5.1