Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Appendix B S6BBRTBL/S6BBRSIX Tuning : Sample Job Preparation

Sample Job Preparation
The following is a step by step example of preparing for a large load that includes secondaries. The procedure for S6BBRSIX is almost identical, except that the input data comes from a table rather than a file, and therefore the amount of work file space required is slightly less than would be required for a load.
Procedure
1.
A variable block data set containing approximately 150 million records is loaded to the table ATABLE, located on segment 1. This table:

 
S 99 99 99 99 000000150000000 050 WORKV 4096
I 001 R V
I 002 F PRIMARY_KEY B 004 PRIMARY_KEY
I 003 F FLD01 C 006 FLD01
I 004 F FLD02 C 006 FLD02
I 005 F FLD03 C 029 FLD03
I 006 F FLD04 C 002 FLD04
I 007 F FLD05 C 007 FLD05
I 008 F FLD06 P 005 FLD06
I 009 F FLD07 C 005 FLD07
I 010 F FLD08 C 065 FLD08
I 011 F FLD09 C 010 FLD09
I 012 F FLD10 C 005 FLD10
I 013 F FLD11 C1500
H 001 R ENGL ATABLE
H 002 F PRIMARY_KEY I B 004 P
H 003 F FLD01 I C 006 S
H 004 F FLD02 I C 006 S
H 005 F FLD03 S C 029 S
H 006 F FLD04 I C 002 S
H 007 F FLD05 I C 007 S
H 008 F FLD06 C P 005 S
H 009 F FLD07 I C 005 S
H 010 F FLD08 S C 065
H 011 F FLD09 I C 010 S
H 012 F FLD10 I C 005

 
2.
Sample JCL follows:

 
//LOAD EXEC PGM=S6BBRTBL,REGION=4M,
// PARM=’BROWSE=N,SEGMENT=01’
//STEBLIB DD DSN=S6B.S50.AUTH,
// DISP=SHR
//DBDLIB DD DSN=S6B.050.DBDLIB
// DISP=SHR
//CNTRL DD DSN=S6B.050.S6BBRTBL.CARDS,
// DISP=SHR
//INPUT DD DSN=S6B.050.S6BBRTBL.DATA,
// DISP=SHR
//AUDIT DD SYSOUT=*

 
3.
PARM=’BROWSE=Y,SEGMENT=01’
4.
Sample output follows:

 
CARDS READ INPUT 24 HURON 24 SPEC 1 VALUE 0 TOTAL 49
SPACE UTILIZATION (BYTES) DATA 4010 INDEX 4010 SEC.IX 4010 GROUP.IX 4010
MAX FLDS 50 MAX RCDS 150,000,000 DYNALLOC UNIT WORKV ,01 DYNALLOC BLKSZ 4096
FILE: IXWORK LRECL=00083 BLKSIZE=04067 IXWORK
                                                  #BLOCKS=(0003061234,0001530610)
S6BBL173I BROWSE MODE - REQUEST VALIDATION COMPLETED

 
5.
With the default work data set block size at 4096 (actually 4067) space is required for over three million blocks of primary space on one disk volume, “UNIT WORKV, 01”.
By obtaining the optimum block size or just under a half track for a fixed block data set with a record length of 83, the space required is minimized and sorting is optimized.
Using either menu option 3.2 of ISPF or program IEFBR14, allocate a dummy data set with the characteristics of the work data set: FB UNIT=WORKV LRECL=83, specifying a block size of zero. The system calculates the optimum block size for that data set on that UNIT (WORKV).
Replace 4096 in the S control record with the optimum block size. For example:
S 99 99 99 99 000000150000000 050 WORKV 27971
6.
New sample load output follows:

 
CARDS READ INPUT 24 HURON 24 SPEC 1 VALUE 0 TOTAL 49
SPACE UTILIZATION (BYTES) DATA 4010 INDEX 4010 SEC.IX 4010 GROUP.IX 4010
MAX FLDS 50 MAX RCDS 150,000,000 DYNALLOC UNIT WORKV ,01 DYNALLOC BLKSZ 27971
FILE: IXWORK LRECL=00083 BLKSIZE=27971 IXWORK
                                                  #BLOCKS=(0000445113,0000222557)
S6BBL173I BROWSE MODE - REQUEST VALIDATION COMPLETED

 
7.
The load requires 445113 blocks (222557 tracks) of space for the work data set. One volume of this example’s UNIT “WORKV” contains 50000 tracks, so the load requires four and a half volumes of disk space for the work file.
The load always requests the total space required as the primary allocation. Therefore, it is necessary to modify the S control record so that the calculation results in a primary (and secondaries = 75% of primary) allocation suited to the space available.
There are 7 volumes in the WORKV UNIT group; one volume is completely empty and is used for the primary allocation (approximately 100000 blocks). The remaining six volumes contain sufficient contiguous space to satisfy the secondary allocations (approximately 7 x 50000 blocks).
Modify the control file type S record as follows:
S 99 99 99 99 000000033000000 050 WORKV 27971 07
8.
Sample output follows:

 
CARDS READ INPUT 24 HURON 24 SPEC 1 VALUE 0 TOTAL 49
SPACE UTILIZATION (BYTES) DATA 4010 INDEX 4010 SEC.IX 4010 GROUP.IX 4010
MAX FLDS 50 MAX RCDS 150,000,000 DYNALLOC UNIT WORKV ,07 DYNALLOC BLKSZ 27971
FILE: IXWORK LRECL=00083 BLKSIZE=27971 IXWORK
                                                  #BLOCKS=(0000097932,0000048967)
S6BBL173I BROWSE MODE - REQUEST VALIDATION COMPLETED

 
9.
PARM=’BROWSE=N,SEGMENT=01’
10.
Before submitting the load, check that the work file space is available when required. Since the primary allocation is not sufficient to finish the load, the job could abort due to lack of space after wasting a considerable amount of resources as well as elapsed time.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved