Database reorganization sample problem

The following shows an example of how a large fixed record type (0000) is captured from one z/TPF system and reloaded to a different z/TPF system. It explains the general flow of the DBR utility and the sequence to follow while using the utility.

Before you begin: Start DBR output in 1052 state and IPL the prime module to 1052 state.

Note: If the system is in a state other than 1052 state, capture and restore logging must be active before you start DBR.

Enter ZDBRO INIT to initialize the DBR record:
```
User:   ZDBRO INIT

System: DBRO0000I 13.42.33 REQUEST COMPLETE
```
Note: DBR initialization must be the first step of the DBR process.

Enter ZDBRO DISPLAY ALL to display the hexadecimal record types to be captured:

User:   ZDBRO DISPLAY ALL

System: DBRO0067I 10.22.21 RECORD TYPES TO BE CAPTURED
        0000 0001 0002 0003 0004 0005 0006 0007
        0008 0009 000A 000B 000C 000D 000E 000F
        0010 0011 0012 0013 0014 0015 0016 0017
        0018 0019 001A 001B 001C 001D 001E 001F
        0020 0021 0022 0023 0024 0025 0026 0027
        0028 0029 002A 002B 002C 002D 002E 002F
        MORE

Note: The first 48 in-use hexadecimal record types are displayed. MORE, which is on the last line of the display, shows that there are more in-use record types.

Enter ZDBRO BYPASS as follows to bypass ordinal numbers 110–119, 280–287, and 17–28:

User:   ZDBRO BYPASS REC-0000 RAN-6E.77

System: DBRO0000I 12.54.00 REQUEST COMPLETE

User:   ZDBRO BYPASS REC-0000 RAN-118.11F

System: DBRO0000I 12.55.00 REQUEST COMPLETE

User:   ZDBRO BYPASS REC-0000 RAN-11.1C

System: DBRO0000I 12.56.00 REQUEST COMPLETE

Note: The previous ordinal numbers are not needed and will be bypassed in this example.

Enter ZDBRO RESET REC-0000 RANGE-11.1C to reset ordinal numbers 17–28:
```
User:   ZDBRO RESET REC-0000 RAN-11.1C

System: DBRO0000I 12.58.00 REQUEST COMPLETE
```
Note: The previous ordinal numbers should be captured; they are reset.

Enter ZDBRO DISPLAY REC-0000 to display hexadecimal record type 0000:

User:   ZDBRO DISPLAY REC-0000

System: DBRO0077I 13.45.28 EXCEPTIONS FOR RECORD TYPE 0000
         START                   END
        000000000000006E       0000000000000077
        0000000000000082       0000000000000083

Note: This display shows verification of the exception entries for the record type.

Enter ZDBRO START 0000 END to start the DBR output phase:

User:   ZDBRO START 0000 END

System: DBRO0010I 13.55.01 DBR OUTPUT PHASE STARTED
        COSK0079A 13.55.01 *CP* HPN    MOUNT DBF TAPE FOR OUTPUT

User:   ZTMNT DBF 281 AO BP

System: COTM0310I 13.55.01 TMNT HPN    TAPE DBF MOUNTED ON DEVICE 0281
                 VSN A00245 G0005 S0001 F38K    SL NOBLK            0 NOCOMP NOENC

Note: Only hexadecimal record type 0000 is needed. END was entered so that the DBR process starts to capture the record type. The DBF (fixed) tape is requested and a mount is issued.

Enter ZDBRO OECB 20 to change the default available ECB count:
```
User:   ZDBRO OECB 20

System: DBRO0000I 14.33.21 REQUEST COMPLETE
```
Note: The default value is 4. Be careful when raising the available ECB count because each ECB causes as many as 20 frames to be used. Consider gradually increasing the ECB count and monitoring system performance.

Enter ZDBRO STATUS to request DBR status:

User:   ZDBRO STATUS

System: DBRO0062I 22.12.33 DBR IS PRESENTLY PROCESSING
        RECORD TYPE 0000,ORDINAL NUMBER 000000000000013D,ECB= 00000020

The end of the record type is displayed in the following example:

System: DBRO0015I 22.45.33 DBR HAS FINISHED PROCESSING RECORD TYPE 0000

The end of output phase is displayed in the following example:

System: DBRO0016I 22.46.33 DBRO FIXED OUTPUT PHASE COMPLETE
        DBRO0011I 22.46.33 DBR OUTPUT PHASE COMPLETE
        COTC0300A 22.46.33 TCLS HPN    REMOVE DBF FROM DEVICE 0281
                 VSN A00245 G0005 S0001 F38K    SL NOBLK            0 NOCOMP NOENC

Note: If pool records were to be captured, the pool controller would receive control at this point and request the DBP (pool) tape.

Enter the following to IPL the general file:
```
User:   I 3E7
```
Note: The fixed file input phase must be run from the general file in 1052 state. The IPL address (3E7) may differ.

Enter ZDBRI START FIXED to start the input phase:

User:   ZDBRI START FIXED

System: DBRI0020I 09.30.16 DBR INPUT PHASE STARTED
        COSK0079A 09.30.16 *CP* HPN    MOUNT DBF TAPE FOR INPUT

User:   ZTMNT DBF 281 AI BP

System: COTM0310I 09.30.16 TMNT HPN    TAPE DBF MOUNTED ON DEVICE 0281
                 VSN A00245 G0005 S0001 F38K    SL NOBLK            0 NOCOMP NOENC

Note: DBR requests the DBF tape that was created in previous steps as input and a mount is issued.

Enter ZDBRO IECB to change the default available ECB count:

User:   ZDBRO IECB 20

System: DBRO0000I 09.31.43 REQUEST COMPLETE

Fixed hexadecimal record type 0000 is reloaded and the DBR process ends in the following example:

System: DBRI0015I 09.33.17 DBR HAS FINISHED PROCESSING RECORD TYPE 0000
        DBRI0000I 09.33.17 REQUEST COMPLETE
        COTC0087A 09.33.17 TCLS HPN    REMOVE DBF FROM DEVICE 0281
                           VSN A00245 NOBLK            0 NOCOMP NOENC

See z/TPF Operations for more information about the ZDBRO commands.