Sample Report: LOAD Data Area

LOAD (Build CXX or Data Area) › LOAD (Build a Data Area) › Sample Report: LOAD Data Area

Sample Report: LOAD Data Area

Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ LOAD AREA=DEM,DBID=1,FORMAT=BACKUP,CLUSTER=DENSE, DEVICE=TAPE,DTFNAME=BACKDEM,LOADDUPS=NO,OPTIMIZE=YES,SORT=500 FUNCTION=LOAD AREA=DEM CLUSTER=DENSE DBID=1 DEVICE=TAPE DTFNAME=BACKDEM FORMAT=BACKUP LOADDUPS=NO OPTIMIZE=YES SORT=00000500 Ž

Œ: 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.

Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 1 ******************************************************************************** Directory: PRODCXX BACKUP FILE INFORMATION JOBNAME RUN UNIT DATE TIME CXXNAME DBID SEQ RECID AREA DBDVL 56,377 5/25/2003 16.26.35 PRODCXX 1 PHY NO DEM INPUT FILE INFORMATION OUTPUT TABLE INFORMATION AREA TABLE ID RECORDS AREA TABLE ID RECORDS NOTES DEM PNC 6 5 DEM PNC 6 5 DEM PNM 5 3 DEM PNM 5 3 DEM POH 3 5 DEM POH 3 5 DEM POL 4 4 DEM POL 4 4 OUTPUT AREA INFORMATION TOTAL USED TOTAL USED PCNT AVG BLOCKS BLOCKS TOTAL AREA TRACKS TRACKS BLOCKS BLOCKS FULL SLACK EXPANDED COMPRESSED RECORDS DEM 2 1 62 2 3 503 N/A N/A 17

The BACKUP FILE INFORMATION consists of the following:

Job name used to produce the backup
The backup job's run unit number
The date and time the backup job was executed
The CXX name
The database ID
The sequence option
The record ID option of the backed up information
The area name provided to the backup. If the input to the LOAD function was a backup produced by CA Datacom/DB Version 8.0, the literal "8.0" is printed instead of an area name.

The BACKUP FILE INFORMATION is optional and variable. It is optional in that it is produced only if FORMAT=BACKUP is specified in the LOAD function statement and the input was produced by the CA Datacom/DB Utility (DBUTLTY) BACKUP function. It is variable in that if more than one BACKUP output is provided to the LOAD, each has its control information reported.

Normally one backup is input to the LOAD utility, however this is not always true. Users in all systems sometimes SORT or MERGE backup files to a single file. These functions are normally done when moving tables among different areas for performance or clustering reasons.

If this section is present, it might present one of the following messages:

DB13012E INSUFFICIENT SPACE IN aaa AREA

DB13014 DATA RECORD(S) LOADED WITH DUPLICATE MASTER KEY.

Note: The messages DB13015W DATA LOADED WITHOUT REORGANIZATION and DB13024I DATA LOADED WITH REORGANIZATION that were printed in prior versions are no longer printed. A backup input with sequence of PHYSICAL and record ID of YES are non-reorganizing. All others reorganize.

Date: mm/dd/ccyy ******************************************************************************** Page: 3 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn Base: 1 ******************************************************************************** Directory: PRODCXX BACKUP FILE INFORMATION JOBNAME RUN UNIT DATE TIME CXXNAME DBID SEQ RECID AREA DBDVL 56,377 5/25/2003 16.26.35 PRODCXX 1 PHY NO DEM ‘ INPUT FILE INFORMATION OUTPUT TABLE INFORMATION AREA TABLE ID RECORDS AREA TABLE ID RECORDS NOTES DEM PNC 6 5 DEM PNC 6 5 DEM PNM 5 3 DEM PNM 5 3 DEM POH 3 5 DEM POH 3 5 DEM POL 4 4 DEM POL 4 4 ’ OUTPUT AREA INFORMATION TOTAL USED TOTAL USED PCNT AVG BLOCKS BLOCKS TOTAL AREA TRACKS TRACKS BLOCKS BLOCKS FULL SLACK EXPANDED COMPRESSED RECORDS DEM 2 1 62 2 3 503 N/A N/A 17

The INPUT FILE INFORMATION has a line for each unique table ID of input records. This part prints the area name, table name, table ID, and number of records.

For partitioned tables, provides the partitioned table name and the Full Parent table name.

For a given table loaded, if input records existed, they are reflected on the same line as the output table. If input records were found for a table not being loaded, then they are printed on separate lines with a note of TABLE ID NOT LOADED. These records were read by the LOAD utility but are ignored.

This section for input records only has information printed if the input was from execution of the BACKUP utility function. Extract data or DBFLSUB exit data does not have this information. Records for a single table ID could be input from multiple original backups. All of these records are loaded, however, if the table name or area name from the input stream is different, the name printed on the report for these records is three question marks (???). This does not mean that an error exists, but that the records came from different sources with different area or table names.

If a table is loaded with zero records, and if the input also reflects the table and zero records, a note of TABLE EXCL OR NOT INCL prints, if the table was excluded, or if an include was done but not for this table. If the note is blank, the table had no records at the time of the backup.

‘

The OUTPUT TABLE INFORMATION has a line per table loaded with the area name, the table name, the table ID, and the number of records.

For partitioned tables, provides the partitioned table name and the Full Parent table name.

The following information is provided under NOTES on the load report when tables are partitioned:

SKIPPED: Indicates record(s) from this table are to be skipped (not loaded) because they do not meet any of the range criteria for any tables in this partition.
TABLE NOT LOADED: Indicates the table was not loaded.

’

The OUTPUT AREA INFORMATION prints the area name, total tracks, used tracks, total blocks, used blocks, percent full, average slack, blocks expanded, blocks compressed, and total records for the area loaded.

The used tracks, used blocks, and percent full reflect high-water marks. If slack space allows for records to be added, or if the backup was physical with record IDs then additional space may exist in this area for record additions. CXX reporting reflects embedded free space. The blocks expanded and blocks compressed require additional CPU time to build and maintain and are requested using the STATS parameter for the load. If STATS are not requested, N/A is printed in these columns.