Previous Topic: DB01319INext Topic: DB01321I


DB01320I

f BASE nnnn AREA aaa ON BLOCK bbbbb OF bbbbb RECORD rrr (KEYS) kkkkkk

Reason:

This message is related to the LOAD, RETIX, BACKUP, EXTRACT, and REORG functions of DBUTLTY. This message, for the functions BACKUP and EXTRACT, when using physical sequence (SEQ=PHY), or when using the RETIX function, can occur during the time the area's blocks are being read and processed. This message, for the LOAD and REORG functions, can occur during the time the data area's blocks are being written and is issued as a result of the STATUS console command for DBUTLTY executions. The variables in the message text are as follows:

f

Function: LOAD, RETIX, BACKUP, or EXTRACT.

nnnn

DBID being processed.

aaa

*** (three asterisks) if no area specified to request all areas, or area name of area specified.

bbbbb

Current block being processed for this area.

bbbbb

Total number of blocks to be processed for this area.

rrr

Number of current record being processed for this DBUTLTY function.

(KEYS)

If this is a LOAD/RETIX with sort, or not present if this is not a LOAD/RETIX with sort.

kkkkkk

If this is a LOAD/RETIX with sort, number of keys handed to sort, else blanks.

During a full base RETIX, BACKUP, or EXTRACT, the areas are read one at a time starting with the area containing the lowest alphabetical table name and then the next lowest area until all are complete. Having selected each area, all blocks are read in physical order selecting all selected table records for RETIX or sequence=physical BACKUP/EXTRACT. For sequence=native BACKUP/EXTRACT, the lowest native sequence key for any table in the area is selected, and the index is read with selection of every selected table with this native sequence key. If all tables have not been processed, the next lowest native sequence key is selected, and the process repeats until all tables in the area have been processed.

During a full base LOAD, every area is prepared for loading before the input is read. The input is usually an area at a time (from a full base backup), but it is not required to be (such as moving a table between areas). As the next input record is read, the area name, current block, and total blocks fields for the message are swapped as required. The record number is purely ascending by one regardless of area. After all input records are processed, the utility selects the area with the lowest alphabetical table name for completion (writing low value blocks to the full extent), followed by the next lowest area through all areas. Between each area swap, the DB01320I message is not available.

Action:

None. This message is for information only.