gtpd1m1jDatabase Reference

Database Reorganization Sample Problem

The following shows an example of how a large fixed record type (0000) is captured from one TPF system and reloaded to a different 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.
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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* - MOUNT DBF TAPE FOR OUTPUT                     |
    |                                                                                |
    |User:   ZTMNT DBF 281 AO BP                                                     |
    |                                                                                |
    |System: COTN0046I 13.55.01 TMNT - TAPE DBF MOUNTED ON DEVICE 281                |
    +--------------------------------------------------------------------------------+
    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.
  7. 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.
  8. 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                            |
    |        COTC0080A 22.46.33 TCLS - REMOVE DBF FROM DEVICE 281                    |
    +--------------------------------------------------------------------------------+
    Note:
    If pool records were to be captured, the pool controller would receive control at this point and request the DBP (pool) tape.
  9. 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.
  10. 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* - MOUNT DBF TAPE FOR INPUT                      |
    |                                                                                |
    |User:   ZTMNT DBF 281 AI BP                                                     |
    |System: COTN0046I 09.30.16 TMNT - TAPE DBF MOUNTED ON DEVICE 281                |
    +--------------------------------------------------------------------------------+
    Note:
    DBR requests the DBF tape that was created in previous steps as input and a mount is issued.
  11. 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 - REMOVE DBF FROM DEVICE 281 VSN 111111         |
    +--------------------------------------------------------------------------------+

See TPF Operations for more information about the ZDBRO commands.