gtpo1m3fOperations

ZDBSO BYPASS-Bypass Database Reorganization Record Types

Use this command to bypass a certain record type or to specify that specific ordinal number ranges in a record type are to be bypassed during database reorganization (DBR).

Requirements and Restrictions

Format




RECtype-recvalue
specifies the record type, where recvalue must be a 4-digit hexadecimal number for fixed file records or one of the following for pool records:

SLT
Small, long-term

SST
Small, short-term

SDP
Small, long-term duplicate

LLT
Large, long-term

LST
Large, short-term

LDP
Large, long-term duplicate

4LT
4-KB, long-term

4ST
4-KB, short-term

4DP
4-KB, long-term duplicate

4D6
4-KB, long-term FARF6 duplicate.

RANge-startord.endord
bypasses an ordinal number range in the specified record type, where startord and endord are 1- to 16-digit hexadecimal numbers.

DIR
bypasses the pool records that are not in use.

Additional Information

If you specify the RECTYPE parameter without the RANGE parameter, all ordinal numbers in the specified record type are bypassed.

Examples

Ordinal numbers 120-123 in record type 0005 are bypassed in the following example.

+--------------------------------------------------------------------------------+
|User:   ZDBSO BYPASS REC-0005 RANGE-78.7B                                       |
|                                                                                |
|System: DBRO0000I 19.45.28 REQUEST COMPLETE                                     |
|        DBSO0001I 19.45.28 MULTIPLE SSU REQUEST COMPLETED                       |
+--------------------------------------------------------------------------------+

All 4-KB short-term records are bypassed in the following example.

+--------------------------------------------------------------------------------+
|User:   ZDBSO BYPASS REC-4ST                                                    |
|                                                                                |
|System: DBRO0000I 19.45.28 REQUEST COMPLETE                                     |
|        DBSO0001I 19.45.28 MULTIPLE SSU REQUEST COMPLETED                       |
+--------------------------------------------------------------------------------+

Ordinal numbers 2-5 in record type 0027 in a subsystem with multiple subsystem users are bypassed in the following example.

+--------------------------------------------------------------------------------+
|User:   WP/ZDBSO BYPASS REC-0027 RANGE-2.5                                      |
|                                                                                |
|System: CSMP0097I 21.45.28 CPU-B SS-WP   SSU-WP1  IS-01                         |
|        DBRO0000I 21.45.28 REQUEST COMPLETE                                     |
|        CSMP0097I 21.45.28 CPU-B SS-WP   SSU-WP2  IS-01                         |
|        DBRO0000I 21.45.28 REQUEST COMPLETE                                     |
|        CSMP0097I 21.45.28 CPU-B SS-WP   SSU-WP3  IS-01                         |
|        DBRO0000I 21.45.28 REQUEST COMPLETE                                     |
|        CSMP0097I 21.45.28 CPU-B SS-WP   SSU-WP1  IS-01                         |
|        DBSO0001I 21.45.28 MULTIPLE SSU REQUEST COMPLETED                       |
+--------------------------------------------------------------------------------+

Related Information

See TPF Database Reference for more information about DBR and for a sample problem that shows the sequence of the commands.