DBD Summary report using the DBDINFO command


When you use the DBDINFO command (F9 in the NEWPFK set on the Segment and Block panels), the Database Zap utility displays the DBD Summary report in place of the pointer and data information or block information on the panel.

Use the RESET command (F5) to redisplay the pointer and data information or block information. The header information and function key definitions do not change.

                              Browse a Segment
Command ===> ________________________________________________ Scroll ===> PAGE

DBDNAME: DBIHD01  DSG: 01  SEGMENT: DB#AASEG BYTES: 100
DATALEN: 100   KEYLEN: 8   COMPRTN: N/A                  EXPAND: N/A SPLIT: N/A
-------------------------------------------------------------------------------

DBD SUMMARY

 DATABASE=DBIHD01     DS GROUPS=1   ORGANIZATION=HDAM    ACCESS METHOD=ESDS
 RANDOMIZER=DFSHDC40  NUMBER RAPS=7     MAX RBN=21         MAX INSERT=

          SEG                     PFX   DATA      PTR     TARGET   TARGET
 SEGMENT  CODE LVL DSG PARENT     LEN   LEN  FLAG TYPE    SEGMENT  DBDNAME
 -------- ---- --- --- --------   ---   ---- ---- ---     -------- --------
 DB#AASEG '01'  1   1              14    100      PTF --> DB#AASEG
                                                  PCF --> DB#BASEG
                                                  PCF --> DB#BBSEG
 DB#BASEG '02'  2   1  DB#AASEG    14    100      PTF --> DB#BASEG
                                                  PP  --> DB#AASEG
                                                  PCF --> DB#CASEG
 DB#CASEG '03'  3   1  DB#BASEG     6    100      PTF --> DB#CASEG
 DB#BBSEG '04'  2   1  DB#AASEG     6    100      PTF --> DB#BBSEG

 PF: 1=HELP       2=GETNEXT    3=END        4=SETPOS     5=RESET    6=RESTPOS
     7=UP         8=DOWN       9=DBDINFO   10=SEGINFO   11=OLDPFK  12=DSINFO

The Database Zap utility obtains the values for the following fields from information in the DBD control block.

DATABASE

The DBD name of the database.

DS GROUPS

The number of data set groups in this DBD.

ORGANIZATION

The database organization of this database (HDAM, HIDAM, etc.).

ACCESS METHOD

The access method for this database (OSAM or ESDS).

RANDOMIZER

The name of the HDAM randomizing routine as specified in the DBD (for HDAM databases only).

NUMBER RAPS

The number of root anchor points per block or CI as specified in the DBD (for HDAM databases only).

MAX RBN

The maximum relative block number for this database as specified in the DBD (for HDAM databases only).

MAX INSERT

The maximum number of bytes that may be inserted into the root addressable area with one series of calls to a database record as specified in the DBD (for HDAM databases only).

PRIMARY INDEX DBD

The DBD name for the primary index (for HIDAM databases only).

PRIMARY INDEX ACCESS METHOD

The access method for the primary index (for HIDAM databases only).

SEGMENT

The segment name.

SEG CODE

The 1-byte hexadecimal code that identifies the segment in the database.

LVL

The segment hierarchical level.

DSG

The segment data set group.

PARENT

The name of this segment’s parent.

PFX LEN

The segment prefix length (in bytes).

DATA LEN

The segment data length (maximum length if the segment is variable length).

FLAG

A flag to indicate the status of the segment. The following values are possible:

  • P

    The segment is padded with one byte to make it an even length in the database. (IMS does not write odd-length segments in HD-type databases.) You could increase the segment length in the DBD by one byte and not use any more disk space.

  • V

    The segment is defined as variable length.

  • C

    The segment has an edit/compression routine. The segment will be stored in the database as a variable length (VL) segment.

PTR TYPE

The types of pointers contained in the segment’s prefix, listed in the same order as they appear in the segment prefix.

TARGET SEGMENT

The name of the segment to which the segment prefix pointer is pointing. For hierarchical pointers, the target segment type may vary.

TARGET DBDNAME

The name of the database that contains the target segment. A DBD name will be shown only if the target segment is in a different database from the source segment.



 

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

BMC AMI Pointer Checker for IMS 5.1