FABBME3 JCL
FABBME3 runs as a standard z/OS® batch job step. An EXEC statement and DD statements that define inputs and outputs are required.
EXEC statement
The EXEC statement must be in the form:
// EXEC FABBME3,REGION=768K,PARM='x'Region-size requirements vary depending on the number of DOVF CIs in a UOW, and the number of IOVF CIs in the area. REGION=768K should suffice for most databases.
FABBME3 requires a PARM= specification on the EXEC statement to specify the emulation mode desired: either "load" or "reorganization." Valid values for PARM= are L and R. If PARM= is not coded, or is specified as any other value, a default specification of L is assumed.
- A value of L requests generation of a model of the database that would be produced by loading its area, or areas, with the data in physical hierarchical sequence.
- A value of R simulates the effect of running the High- Speed Direct Reorganization Utility (DBFUMDR0) against the database.
DD statements
The following table summarizes the DD statements.
| DDNAME | Use | Format | Required or optional |
|---|---|---|---|
| MEDARI | Input | Required | |
| SYSPRINT | Output | LRECL=133 | Required |
| MEDAR12O | Output | Required | |
| MEDAR3O | Output | Required | |
| SORT12 | Output | LRECL=80 | Required |
| SORT3 | Output | LRECL=80 | Required |
The following table shows space requirements for this JCL stream.
| DDNAME | Space requirements |
|---|---|
| MEDAR12O | # CI/area X 1.5 X 20 bytes |
| MEDAR3O | # segments X (30 + 4 X # levels) |
| SORT12 | < 1 track |
| SORT3 | < 1 track |
- MEDARI DD
- This statement defines the input data set that contains the sorted area and segment information records from SORT13 step.
- SYSPRINT DD
- This statement defines the output message and statistics data set. The data set can reside on a
direct-access device or printer, or be routed through the output stream. You can code
RECFM=FBA,LRECL=133 on your DD statement, but it is better to use:
//SYSPRINT DD SYSOUT=A - MEDAR12O DD
- This statement defines the output data set for the area and free space information records. The
data set can reside on either a direct-access device or tape. Standard labels must be used for this
data set.
DCB attributes are calculated by FABBME3. RECFM is VB. For 3380, the default block size is 23476 bytes. For 3390, the default block size is 27998 bytes. For 9345, the default block size is 22928 bytes. If LRECL is larger than the above block size, then this LRECL is used. For other output devices, the default block size is the maximum block size of the output device. A block size can be specified on the DD statement. Do not code any other DCB parameters in your JCL.
Space requirements vary depending on the number of CIs in the tuned area(s), and the number of intersection references. Approximation: number of CIs X 1.5 X 20 bytes. Do not specify DISP=MOD for this DD statement.
Note: The number of CIs includes RAA BASE, DOVF, and IOVF only. - MEDAR3O DD
- This statement defines the output data set for the segment information records. The data set can
reside on either a direct-access device or tape. Standard labels must be used for this data set.
DCB attributes are calculated by FABBME3. RECFM is VB. For 3380, the default block size is 23476 bytes. For 3390, the default block size is 27998 bytes. For 9345, the default block size is 22928 bytes. If LRECL is larger than the above block size, then this LRECL is used. For other output devices, the default block size is the maximum block size of the output device. A block size can be specified on the DD statement. Do not code any other DCB parameters in your JCL.
Space requirements vary depending on the hierarchical structure of the database, and the number of segments in the tuned area(s). Approximation: no. segments X (30 + 4 X no. hierarchical levels in DMB). Do not specify DISP=MOD for this DD statement.
- SORT12
- This statement defines the output data set that contains the SORT control statements required
for step SORT12. This data set must reside on a direct-access device.
Space requirements are very small (1 track suffices). Do not specify DISP=MOD for this DD statement.
DCB information is hard-coded in FABBME3. Do not code DCB information in your JCL.
- SORT3
- This statement defines the output data set that contains the SORT control statements required
for step SORT3. This data set must reside on a direct-access device.
Space requirements are very small (1 track suffices). Do not specify DISP=MOD for this DD statement.
DCB information is hard-coded in FABBME3. Do not code DCB information in your JCL.