Database Administration › Database Allocation Management › Directory CXX Report Sample

Directory CXX Report Sample

CONTROL CARD(S)
                     .........1.........2.........3.........4.........5.........6.........7.........8
                       REPORT AREA=CXX,DBID=4000,TYPE=A

                     FUNCTION=REPORT
                        AREA=CXX
                        DBID=04000
                        TYPE=A

The report shows the following:

• The command exactly as entered.
• An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
• Any messages related to syntax processing.

 DATACOM/AD                   DATA AREA SPACE UTILIZATION REPORT
-AREA DATA       TOTAL         TOTAL       TOTAL        USED    PERCENT    PARTIALLY  AREA REUSE
 NAME BASE      TRACKS       RECORDS      BLOCKS      BLOCKS  FULL   MAX  EMPTY BLKS    OPTION

 CXX               525           N/A       6,300         342     5     5         N/A  N/A
 IXX  4000         900           N/A      10,800       5,445    50    50         N/A  N/A
  AUD 4000       5,010       254,258      10,020       4,398    43    43           1  RANDOM
  INV 4000       3,000       148,724      18,000      14,538    80    80           0  RANDOM
  JNL 4000       1,125        91,359       6,750       5,182    76    76           0  RANDOM
  PCY 4000         510        34,573       6,120       2,449    40    40           1  RANDOM
  SCS 4000       2,010        59,111      12,060       1,136     9     9           1  RANDOM
  SDS 4000         750        16,809       4,500       3,145    69    69           1  RANDOM
  SRG 4000       1,005         1,616       6,030         142     2     2           1  RANDOM
  XML 4000      33,000        61,858      66,000      61,860    93    93           0  RANDOM

The report provides the following information:

AREA NAME and DATA BASE

DATACOM-ID of the database containing the area. Summary statistics for the Directory (CXX) are always displayed on the first line.

TOTAL TRACKS

The number of tracks allocated and accepted by CA Datacom/MSM for use in the area. If the actual number of tracks (blocks) allocated is larger, execute an EXTEND function to make the space available to CA Datacom/MSM.

TOTAL RECORDS

For data areas, the number of records in the area. If a system failure has occurred during maintenance processing, this number can be inaccurate.

TOTAL BLOCKS

Number of blocks in the area.

USED BLOCKS

Number of blocks that contain data. If a system failure has occurred during maintenance processing, this number can be inaccurate.

PERCENT FULL and MAX

Percentage full is calculated by dividing used blocks by total blocks. The value reported is an even percent. Decimals are truncated.

Maximum percentage, sometimes referred to as high-water mark, is calculated by dividing maximum used blocks by total blocks. The value for maximum used blocks is computed internally. This percentage is higher than FULL percentage in the following situations:

• When all records are deleted in a data block with space management option 1 or 3 (random or cluster)

  Note: For information about the data area space management options, see the CA Datacom/DB Database and System Administration Guide.

• When all Index entries are deleted in an Index block

PARTIALLY EMPTY BLKS

Blocks that contain sufficient space to hold the largest record in the area are considered to be partially empty. If partially empty blocks exist and a space reclamation option has been selected, even when all blocks contain data (100 percent full), records can still be added.

AREA REUSE OPTION

The data area space management option used for the data area.

Note: CA Support uses this information.