SORTDFLT=YES Report Section for LOAD

LOAD (Build CXX or Data Area) › LOAD (Build a Data Area) › SORTDFLT=YES Report Section for LOAD

SORTDFLT=YES Report Section for LOAD

If SORDTDFLT= YES, an additional section to the LOAD report is added after the optional BACKUP INFORMATION section, if present, and before the INPUT FILE INFORMATION section. The heading of the new section is SORTDFLT INFORMATION. After the heading, one line is printed for each table to be loaded.

The line after the SORTDFLT INFORMATION heading contains the following:

Table name and ID
Record count from the BACKUP control record for the table - The number is set as 0 if there is no input, extract input, or backup taken prior to Version 12.0. For a Version 12.0 backup, it is the count in the CXX at the time of the backup and might or might not be accurate.
Note: This report section occurs at the time the first data row is read from the input. Only the control information available at this time is reported. The use of concatenated input with additional control information is subject to the INPUT FILE INFORMATION section but not the SORTDFLT INFORMATION section.
Record count from the current CXX
Count of key definitions for the table
Estimated count of keys to sort using the backup count if the count is not zero, else the Directory count.

The next line starting with *DSOP is the count of index entries possible based on the data space options for the areas being loaded. If the estimated count of keys from the record input is all zeros then the *DSOP value is not added into the total and the override does not occur.

Following the *DSOP line is TOTAL and provides the sum of the key estimates from the SORTDFLT INFORMATION. It also provides information about what is overriding the SORT= keyword.

If the keyword FORMAT= is set to NONE, the sort value is set to one. If the keyword FORMAT= is not set to NONE, in the case where the record counts are all zero, CA Datacom/DB has no information to use for estimating the value of keys to be sorted. In this case, the SORT= value is not overridden. Estimate the values of the keyword SORT= with as much accuracy as possible.

The values are necessary for the sort to estimate the workspace needed and the technique to be used.

If the record counts are significantly incorrect but not zero, the sort uses the estimates as they exist. If the LOAD fails because of low sort count issues, change the JCL to provide a more accurate SORT= value then rerun the LOAD without using the SORTDFLT= keyword.

Example

For this example, database 2 was used. The first statement is a RETIX with KEYNAME=*SETR which recounts the records in the area; it was used only to ensure the counts were accurate in the example and is not intended for normal use.

RETIX  AREA=DD1,DBID=2,KEYNAME=*SETR                         
COMM  OPTION=CLOSE,DBID=2                                    
REPORT AREA=CXX,DBID=2,TYPE=A                                
BACKUP DBID=2,SEQ=NAT,DDNAME=Y                               
INIT   DBID=2,AREA=IXX                                       
LOAD DBID=2,FORMAT=BACKUP,DDNAME=Y,SORT=99999,SORTDFLT=YES,  
OPTION1='(I)'

The resulting output is as follows:

BACKUP FILE INFORMATION JOBNAME RUN UNIT DATE TIME CXXNAME DBID SEQ RECID AREA DBDVL 2,812 8/30/2009 09.52.00 DBDVM0 2 NAT NO SORTDFLT INFORMATION TABLE ID BACKUP DIRECTORY KEYS ESTIMATE AGR 17 333 333 8 2,664 ALS 9 1,857 1,857 3 5,571 ARA 2 48 48 3 144 ATZ 24 7 7 2 14 BAS 1 23 23 5 115 DVW 40 70 70 2 140 ELM 7 580 580 5 2,900 FCN 29 0 0 3 0 FIL 3 86 86 2 172 FLD 5 14,557 14,557 10 145,570 HSD 123 196 196 1 196 JOB 27 0 0 2 0 KEY 6 702 702 12 8,424 KWC 8 30 30 9 270 LIB 56 0 0 2 0 MEM 12 0 0 2 0 MOD 23 0 0 2 0 NOD 13 0 0 3 0 PCV 20 0 0 2 0 PER 25 2 2 2 4 PGM 22 0 0 2 0 PLN 15 0 0 3 0 PNL 14 0 0 2 0 PRC 4 0 0 3 0 PRT 18 0 0 2 0 REL 11 2,634 2,634 7 18,438 RPT 26 0 0 2 0 STM 16 0 0 3 0 STP 28 0 0 2 0 SYS 21 12 12 2 24 TRG 19 0 0 3 0 TXT 10 100 100 2 200 *DSOP 38 TOTAL (SORT ESTIMATE OVERRIDE) 184,884 SORT=00000184884

INPUT FILE INFORMATION AREA TABLE ID DD1 AGR 17 DD1 ALS DD1 ARA 2 DD1 ATZ 24 DD1 BAS 1 DD1 DVW 40 DD1 ELM 7 DD1 FCN 29 DD1 FIL 3 DD1 FLD DD1 HSD 123 DD1 JOB 27 DD1 KEY 6 DD1 KWC 8 DD1 LIB 56 DD1 MEM 12 DD1 MOD 23 DD1 NOD 13 DD1 PCV 20 DD1 PER 25 DD1 PGM 22 DD1 PLN 15 DD1 PNL 14 DD1 PRC 4 DD1 PRT 18 DD1 REL 11 DD1 RPT 26 DD1 STM 16 DD1 STP 28 DD1 SYS 21 DD1 TRG 19 DD1 TXT 10 OUTPUT AREA INFORMATION TOTAL AREA TRACKS DD1 180 OUTPUT TABLE INFORMATION RECORDS AREA TABLE ID RECORDS NOTES 333 DD1 AGR 17 333 9 1,857 DD1 ALS 9 1,857 48 DD1 ARA 2 48 7 DD1 ATZ 24 7 23 DD1 BAS 1 23 70 DD1 DVW 40 70 580 DD1 ELM 7 580 0 DD1 FCN 29 0 86 DD1 FIL 3 86 5 14,557 DD1 FLD 5 14,557 196 DD1 HSD 123 196 0 DD1 JOB 27 0 702 DD1 KEY 6 702 30 DD1 KWC 8 30 0 DD1 LIB 56 0 0 DD1 MEM 12 0 0 DD1 MOD 23 0 0 DD1 NOD 13 0 0 DD1 PCV 20 0 2 DD1 PER 25 2 0 DD1 PGM 22 0 0 DD1 PLN 15 0 0 DD1 PNL 14 0 0 DD1 PRC 4 0 0 DD1 PRT 18 0 2,634 DD1 REL 11 2,634 0 DD1 RPT 26 0 0 DD1 STM 16 0 0 DD1 STP 28 0 12 DD1 SYS 21 12 0 DD1 TRG 19 0 100 DD1 TXT 10 100 USED TOTAL USED PCNT AVG BLOCKS BLOCKS TOTAL TRACKS BLOCKS BLOCKS FULL SLACK EXPANDED COMPRESSED RECORDS 103 2,160 1,228 56 127 N/A N/A 21,237

Information from SORT:

CASO000I  SORT    FILSZ=E00184884,FIELDS=(1,186,BI,A),DYNALLOC=(SYSDA,03)
CASO061I RCD IN 00182359,OUT 00000000

In this example, the count of keys sorted is less than the estimate because CA Datacom Datadictionary uses the rarely used NIL key feature to not be part of the index. NIL keys are defined to have a value of either all blanks (x'40') or all binary zeros (x'00').