bdfu1m1gUtilities

ZUDFM OAI/DBTAB-Display DBDEF Table Items

Use this command to maintain and display information from various TPFDF tables.

The DBTAB parameters have three main purposes:

Requirements and Restrictions

None.

Format




Note:
You can use either the ZUDFM OAI/DBTAB or the ZUDFM DEF command.

INIT
rebuilds the DBDEF table. Do this after loading a new DBDEF, or if a DBDEF becomes corrupted.
Note:
The INIT parameter cannot be restricted. See ZUDFM OAE-Restrict Table Handling for more information about the restriction of commands and parameters.

filespec
is the file specification, which can be a 2-character or 4-hexadecimal file ID, or the DSECT name (up to 6 characters).

OPT
displays the option bits in the DBDEF. The display indicates which, if any, of the bits are set.

REF
displays the file IDs that are forward referenced from a file used in an index structure. The REF parameter displays as many as 6 levels of indexing.

BRF
displays the file IDs that are backward referenced from a file used in an index structure. The BRF parameter displays as many as 6 levels of indexing and will only display path 0 references. For backward references other than path 0, you should use the ZUDFM OAI/DBTAB/REL command.

REL
specifies all ID relationship files defined in the DBDEF table.

This includes multiple path backward references, recoup references, and capture/restore utility, information and statistics environment (CRUISE) references, as specified in the ID2= or ID3= parameters in the DBDEF. Any referenced ID that can only be found in the logical record (LREC) itself will also be displayed.

Note:
You must first initialize the ID relationship files before using the ZUDFM OAI/DBTAB/fileid/REL command for the first time. See the REL/CREATE parameter for more information about initializing ID relationship files.

COM
displays common DBDEF subtable information on every file.

DBG
displays the DBDEF for each TPFDF file on the system and information for multiple file versions of the same file.

DBK
displays the default key information for all files that use default keys.

IDX
displays index information defined in the DBDEF.

PGN
displays the program that contains the DBDEF for the file.

REC
displays recoup information defined in the DBDEF.

CNT
displays the number of each type of subtable.

LINK
displays the program fast-link area.

REL/CREATE
initializes the ID relationship files using the DBDEF definitions.

fileid
is a 2-character alphanumeric or 4-character hexadecimal file ID.

WID
specifies ID restriction table maintenance.

ADD
specifies IDs to be added to an application.

applic
specifies a single alphabetic character defining an application type.

filecat
specifies the category of a file:

R
Real-time file.

W
Work file.

priority
specifies the order in which the ID ranges will be used. IDs assigned a priority of 1 are used first, followed by the IDs with a priority of 2, and so on.

C
specifies that the IDs are in character format (2 characters).

X
specifies that the IDs are in hexadecimal format (4 characters).

DEL
specifies IDs to be removed from an application.

NEW
specifies one or more IDs to be reserved (and locked) for an application. The IDs are released after 11 months if they are not used.

totalids
is the total number of IDs to reserve. If no number is specified, a single ID is reserved.

APL
specifies the application type.

DID
displays IDs that have been reserved with the NEW parameter.

DIS
displays IDs being used by each application.

Additional Information

Examples

The following example displays DBDEF parameter settings for all files.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB                                                         |
|                                                                                |
|System: UDFM0302I 17:23:32 CENTRAL DATA - FILE DEFINITIONS                      |
|                                                                                |
|                          F  D R D I   D W  A                                   |
|                          V  B E B D   D R  P                                   |
|            COREADR  RCID N  G C K X   A S  L FILE    RCT BEGORD   ENDORD       |
|            --------------------------------------------------------------      |
|            001CA5C0  B K 00 . . . . . . L4 G BK0RP  0026 00000003 00000003     |
|            001CA5FE  B K 01 . . . . . . L4 G BK0RP  0026 00000004 00000004     |
|            001C9D82  S W 00 . . . . . . L2 G SW00SR                            |
|            001C9C70 FD00 00 Y Y . Y . . L4 G GR26SR                            |
|            001C99DE FD01 00 Y Y . Y . . L4 G GR29SR                            |
|            001CAB00 FD02 00 Y Y . . . . L4 G GR30SR                            |
|            001C9F5E FD03 00 Y Y . Y . . L4 G GR3NSR                            |
|            001CBC00 FD04 00 Y Y . Y . . L1 G GR94SR                            |
|            001CBD6C FD05 00 Y Y . Y . . L1 G GR95SR                            |
|            001CB686 FD06 00 Y . . . . . L4 G IW01DF                            |
|            001CA0D2 FD0A 00 Y Y . Y . . L4 I IRDCDF                            |
|            001C95C0 FD0B 00 Y Y . . . . L2 G ZZZZZZ                            |
|            001C964C FD0C 00 Y Y . . . . L2 G IIIIII                            |
|            001C9DC0 FD0D 00 Y . . . . . L4 G GW01SR                            |
|            001C9764 FD0E 00 Y . . . . . L4 G SW05SR                            |
|            001C96D8 FD0F 00 Y Y . . . . L4 G SR05SR                            |
|            001CA22E FDC0 00 Y . . . . . L4 I IWDWDF                            |
|            001CAAC2 FDE2 00 . . . . . . L4 G BF0WK  0028 00000004 00000004     |
|            001CA1A2 FDE4 00 Y Y . . . . L1 I IRDKDF 0042 00000002 00000002     |
|            001CA02E FDE5 00 Y Y . . . . L4 I IRDIDF 0193 00000000 00000498     |
|            001CC9E0 FDE9 00 Y Y . . . . L4 I IR20DF 0193 00000000 00000498     |
|            001CB5C0 FDEA 00 Y Y . . . Y L4 G IRQ1DF 0028 00000002 00000002     |
|            001CB6EE FDEB 00 Y Y . . . . L4 G IRD1DF 0028 00000003 00000003     |
|            001CBB56 FDEC 00 Y Y . . . . L1 G GR93SR 0186 00000002 00000002     |
|            001CBAAC FDED 00 Y Y . . . . L1 G GR92SR 0187 00000000 00000025     |
|            001CB9E0 FDEE 00 Y Y Y . . . L1 G GR91SR 0186 00000001 00000001     |
|        END OF DISPLAY                                                          |
+--------------------------------------------------------------------------------+

The previous example contains information about every file defined to the TPFDF product. Use the information to ensure that you do not duplicate file IDs when creating new files. The categories are as follows:

 COREADR 
The DBDEF core address of the file.

 RCID 
The ID of the file (character or hexadecimal).

 FVN 
The file version number.

 DBG 
Indicates if the file is a TPFDF file with a Y. A period (.) indicates it is not a TPFDF file.

 REC 
Indicates if there is recoup definition for this file with a Y. A period (.) indicates that there is no recoup definition.

 DBK 
Indicates if there are default keys defined for this file with a Y. A period (.) indicates that there are no default keys defined.

 IDX 
Indicates if the file is an indexed file with a Y. A period (.) indicates that it is not an indexed file.

 DDA 
Indicates if distributed data access (DDA) is defined for this file with a Y. A period (.) indicates that DDA is not defined.

 WRS 
The primary block size used in file.

 APL 
A single alphabetic character that identifies the application type associated with this file.

 FILE 
The DSECT name of the file.

 RCT 
The record type, according to the FACE equate.

 BEGORD 
The FACE begin ordinal.

 ENDORD 
The FACE end ordinal.

The following example displays a single entry from the DBDEF index table corresponding to file FDEA.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/FDEA                                                    |
|                                                                                |
|System: UDFM0302I 17:23:32 CENTRAL DATA - FILE DEFINITIONS                      |
|                      F  D R D I   D W  A                                       |
|                      V  B E B D   D R  P                                       |
|        COREADR  RCID N  G C K X   A S  L FILE    RCT BEGORD   ENDORD           |
|        --------------------------------------------------------------          |
|        001A75F0 FDEA 00 Y Y . . . Y L4 G IRQ1DF 0170 00000002 00000002         |
+--------------------------------------------------------------------------------+

The following example initializes the DBDEF table.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/INIT                                                    |
|                                                                                |
|System: UDFM0303I 14.41.09 UFB-CENTRAL DESCRIPTOR INITIALIZED                   |
+--------------------------------------------------------------------------------+

The following example displays the number of each type of subtable defined.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/CNT                                                     |
|                                                                                |
|System: TOTAL COUNTS OF SUBTABLES                                               |
|                                                                                |
|         UDFM0312I 17:23:32 DBDEF SUBTABLE COUNT DISPLAY                        |
|         COM:   47  FIN:   47  DBG:   42  REC:   35                             |
|         DBK:    1  IDX:    7  GDS:    0  DDA:    2                             |
|         FILE VERSION 0: TOTAL:   45  TPFDF:   41                               |
|         TPFDF FILES: 91,1  PCT                                                 |
|        END OF DISPLAY                                                          |
+--------------------------------------------------------------------------------+

The values in the previous example represent the number of each type of table. The headings correspond to the following:

 COM 
The DBDEF common subtable. Because every DBDEF has a common subtable, this displays the total number of files in the system.

 FIN 
The file information subtable. Because every DBDEF has a common subtable this displays the total number of files in the system.

 DBG 
The TPFDF subtable.

 REC 
The recoup subtable.

 DBK 
The default key subtable.

 IDX 
The TPFDF index subtable.

 GDS 
The general data set subtable.

 DDA 
The distributed data access subtable.

 TOTAL 
The total number of data definitions with file version 0.

 TPFDF 
The total number of TPFDF data definitions with file version 0.

 TPFDF FILES 
The percentage of the total file version 0 definitions that are TPFDF definitions.

The following example displays detailed information for the specified file ID.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/SW/COM                                                  |
|                                                                                |
|System: UDFM0304I          COMMON DESCRIPTION                                   |
|                                                                                |
|        WID  FILE ID               S W  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          SW00SR  APL  APPLICATION INDICATOR    G         |
|        PGN  TABLE PGM NAME       UF1A  SIZ  TABLE SIZE            003E         |
|                                                                                |
|        RCT  FCTB FILE TYPE       0000  BOR  BEGIN ORDINAL     00000000         |
|        PLT  PF0 ST / PF1 ST / PF2 LT   EOR  FACE END ORDINAL  00000000         |
|        WRS  BLOCK SIZE             L2  GCI  CPU ID                   B         |
|        ARS  ALTERNATE BLOCK SIZE   --  AUT  AUTHORIZATION MASK      00         |
|                                                                                |
|        MTY  MDBF TYPE               C                                          |
+--------------------------------------------------------------------------------+
Note:
In the previous display, the multiply database function (MDBF) type indicates the following:
Type
Description
 U 
The subsystem user unique files
 C 
The subsystem user common files
 N 
No MDBF information.

The following example displays recoup information for the specified file ID. This display will vary depending on the file ID in the DBDEF.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/FD04/REC                                                |
|                                                                                |
|System: UDFM0309I          RECOUP TABLE                                         |
|                                                                                |
|        WID  FILE ID              FD04  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          GR94SR  RCT  FCTB FILE TYPE        0000         |
|        BOR  BEGIN ORDINAL    00000000  EOR  FACE END ORDINAL  00000000         |
|                                                                                |
|        ID1  80   BIT 0 - 1  NAB TYPE                                           |
|        ID4  10   BIT 3 - 1  NEW STYLE DBDEF                                    |
|                                                                                |
|        STP  MONITOR BRANCH VECTOR  00  LEV  STRUCTURE LEVEL CTRL    00         |
|        PFC  POS. OF FCH ADDRESS  0008  NAB  INITIAL NAB VALUE     001A         |
|        CBV  TPFDF FIX OR VAR ITEM  05  ITS  ITEM SIZE             0001         |
|        PNB  POS. OF DISP POINTER 0010  RDE  DEL. POINTER IN FILE  0000         |
|        FSZ  SIZE OF NAB/COUNT FLD  03  ISZ  LENGTH OF SIZE FLD      03         |
|        DIS  POS. OF DISP POINTER 0000  TIM  TIMEOUT VALUE FLD     0384         |
|        MPR  DEPENDENT RECORD ID  0000  MPP  DEPENDENT CPU ID      NONE         |
|        RCI  RCI DEPENDENT ITEM   FD05  NXT  NEXT ID TO CHASE      0000         |
|                                                                                |
|        VSZ  SIZE OF TOT ID2 DESCRIPTIONS         0017                          |
|                                                                                |
|        NIT  NO. OF DIFFERENT ITK 0001  DIT  TPFDC DATA IDENTIFIER 0000         |
|        ITK  ITEM KEY               80  .RF  NO. OF REFERENCES       01         |
|                                                                                |
|        ID2  80   BIT 0 - 1  RCI ITEM                              FD04         |
|        FNR  FILE DEFINITION NO.    00  RID  REFERENCED ID         FD05         |
|        ADR  POS. OF REC ADDRESS  0003  RCP  POS. OF REC CODE CHCK 0007         |
|        FAL  LENGTH OF FILE POINTER 0F  PI2  POS. OF SUBITEM START   00         |
|        CP2  POS. OF CNT FLD SUBITM 00  IT2  ITEM SIZE OF SUBITEM    00         |
|        SSZ  SUBITEM COUNT FLD SIZE 03                                          |
|                                                                                |
+--------------------------------------------------------------------------------+

The following example displays which DBDEF program belongs to a particular file.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/PGN                                                     |
|                                                                                |
|System: UDFM0308I          PROGRAM REFERENCE                                    |
|        WID  B K   FVN 00   FIL BK0RP   PGN UF1B  APL G                         |
|        WID  B K   FVN 01   FIL BK0RP   PGN UF1B  APL G                         |
|        WID  S W   FVN 00   FIL SW00SR  PGN UF1A  APL G                         |
|        WID FD00   FVN 00   FIL GR26SR  PGN UF1A  APL G                         |
|        WID FD01   FVN 00   FIL GR29SR  PGN UF1A  APL G                         |
|        WID FD02   FVN 00   FIL GR30SR  PGN UF1B  APL G                         |
|        WID FD03   FVN 00   FIL GR3NSR  PGN UF1A  APL G                         |
|        WID FD04   FVN 00   FIL GR94SR  PGN UF97  APL G                         |
|        WID FD05   FVN 00   FIL GR95SR  PGN UF97  APL G                         |
|        WID FD06   FVN 00   FIL IW01DF  PGN UF1D  APL G                         |
|        WID FD07   FVN 00   FIL IR24DF  PGN UF98  APL I                         |
|        WID FD0A   FVN 00   FIL IRDCDF  PGN UF1A  APL I                         |
|        WID FD0B   FVN 00   FIL ZZZZZZ  PGN UF1A  APL G                         |
|        WID FD0C   FVN 00   FIL IIIIII  PGN UF1A  APL G                         |
|        WID FD0D   FVN 00   FIL GW01SR  PGN UF1A  APL G                         |
|        WID FD0E   FVN 00   FIL SW05SR  PGN UF1A  APL G                         |
|        WID FD0F   FVN 00   FIL SR05SR  PGN UF1A  APL G                         |
|        WID FD11   FVN 00   FIL IR60DF  PGN UF99  APL I                         |
+--------------------------------------------------------------------------------+

The previous example provides the following information:

 WID 
The ID of the file

 FVN 
The file version number

 FIL 
The name of the file DSECT

 PGN 
The DBDEF program name

 APL 
The application type.

The following example displays a single DBDEF subtable for the specified file ID.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/IRA5DF/DBG                                              |
|                                                                                |
|System: UDFM0305I          TPFDF TABLE                                          |
|                                                                                |
|        WID  FILE ID              FDA5  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          IRA5DF  RCT  FCTB FILE TYPE        0170         |
|        BOR  BEGIN ORDINAL    00000005  EOR  FACE END ORDINAL  00000005         |
|                                                                                |
|        INB  INITIAL NAB VALUE    001A  MNB  MAX NAB VALUE         0FDB         |
|        ILT  LREC SIZE            0001  MIS  MAX LREC SIZE         0FC1         |
|        EOR  END ORD TPFDF    00000005  NOC  NUMBER OF CHAINS        00         |
|        ILV  TOT INTERLEAVES DEF  0000  PTN  NO. OF PARTITIONS     0000         |
|        TYP  FILE TYPE               R  NLR  TPFDB0D LRECS P. BLK  0000         |
|        GF0  OS DATA SET INDICATOR  00  TQK  HIGHEST TECHNICAL KEY   0F         |
|        TRS  TRAILER SIZE         0024  LR   NO. LOG REC IDX REFS  0000         |
|        SKE  EXTRACT SIZE BLK IDX 0000  RBV  ALG NO. FIXED FILE    0004         |
|        PLI  PACKING LIMIT         100  PIN  PACKING VALUE           75         |
|        HLD  GDS GR0HSR HOLD ORD   000                                          |
+--------------------------------------------------------------------------------+

The following example displays default keys for a specific file.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/B071/DBK                                                |
|                                                                                |
|System: UDFM0306I          KEY TABLE                                            |
|                                                                                |
|        WID  FILE ID              B071  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          IR71DF  RCT  FCTB FILE TYPE        0000         |
|        BOR  BEGIN ORDINAL    00000000  EOR  FACE END ORDINAL  00000025         |
|                                                                                |
|        PKY 80 TDI 0000 DUI 40 KCD                                              |
|                                   INS  REG   PKY    L1/L2  COMPARAND           |
|                    95804002       CLI        X-80-         NO INFO             |
|                    474E0004       BC   STEP TO NEXT ITEM IN UP ORG             |
|                    477E0018       BC   NOT FOUND - END PROCESSING              |
|                    586030DC       L    R6                  SW00SK1             |
|                    D51840036003   CLC                L-25  NO INFO             |
|                    474E0004       BC   STEP TO NEXT ITEM IN UP ORG             |
|                    477E0018       BC   NOT FOUND - END PROCESSING              |
|                    47FE0030       BC   TOTAL MATCH FOUND                       |
+--------------------------------------------------------------------------------+

The following example displays the DBDEF index table for the specified file ID.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/FD00/IDX                                                |
|                                                                                |
|System: UDFM0307I          DBDEF INDEX SUBTABLE                                 |
|                                                                                |
|        WID  FILE ID              FD00  FVN  FILE DEF VERSION NO.    00         |
|        TSZ  TOT INDEX TABLE SIZE 0080                                          |
|                                                                                |
|        PDL  PATH DESCR. LENGTH   0042  PTH  RETRIEVAL PATH NO.    0000         |
|        IMI  IDX METHOD INDICATORS  00  IFB  PKY OF LREC CAUS. IDX   C0         |
|        IDD  DATA IDTFR CAUS. IDX 0000  IID  ID OF INDEX FILE      FDF6         |
|        IKY  PKY OF INDEX LREC      80  ALG  LENGTH OF ALG DEF       06         |
|        IPA  OFFSET OF ALG PART     00  ILA  LENGTH OF ALG PART      00         |
|        IPK  OFFSET OF KEY PART     00  ILK  LENGTH OF KEY PART      06         |
|        IFR  FILE REF NO.IN IDX ITM 00  IKA  START OF KEY AREA       08         |
|        IRL  TOT LGTH OF IDX LREC 000E  DID  TPFDC DATA IDENTIFIER 0000         |
|        LDI  DISP FOR AREA- EXTRACT 00  LLE  LGTH FOR AREA EXTRACT   0A         |
|        ADI  DISP IN AREA- FOR AREA 02  IPE  END ALG OFFSET          00         |
|        SP0  SPARE                  00  IWI  BIT1 - 1  UP ORGANIZ.   40         |
|        IKI  POINTER TO KEY FINAL INITIAL ROUTINE                  0024         |
|        KEY1-95804002474E0004477E0018586030DC                                   |
|        KEY2-D50540086000474E0004477E001847FE003007F1                           |
+--------------------------------------------------------------------------------+

The following example displays the file IDs that are forward referenced from the specified ID in an index structure.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/FD04/REF                                                |
|                                                                                |
|System: UDFM0310I          FORWARD REFERENCE OF INDEXED FILE                    |
|        FIXED ID  1. LEV   2. LEV   3. LEV   4. LEV   5. LEV   6. LEV           |
|                                                                                |
|        FD04 00  FD05 00                                                        |
|                                                                                |
|                                                                                |
|        WID  FILE ID              FD04  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          GR94SR  RCT  FCTB FILE TYPE        0000         |
|        BOR  BEGIN ORDINAL    00000000  EOR  FACE END ORDINAL  00000000         |
|                                                                                |
|        ID1  80   BIT 0 - 1  NAB TYPE                                           |
|        ID4  10   BIT 3 - 1  NEW STYLE DBDEF                                    |
|                                                                                |
|        STP  MONITOR BRANCH VECTOR  00  LEV  STRUCTURE LEVEL CTRL    00         |
|        PFC  POS. OF FCH ADDRESS  0008  NAB  INITIAL NAB VALUE     001A         |
|        CBV  TPFDF FIX OR VAR ITEM  05  ITS  ITEM SIZE             0001         |
|        PNB  POS. OF DISP POINTER 0010  RDE  DEL. POINTER IN FILE  0000         |
|        FSZ  SIZE OF NAB/COUNT FLD  03  ISZ  LENGTH OF SIZE FLD      03         |
|        DIS  POS. OF DISP POINTER 0000  TIM  TIMEOUT VALUE FLD     0384         |
|        MPR  DEPENDENT RECORD ID  0000  MPP  DEPENDENT CPU ID      NONE         |
|        RCI  RCI DEPENDENT ITEM   FD05  NXT  NEXT ID TO CHASE      0000         |
|                                                                                |
|        VSZ  SIZE OF TOT ID2 DESCRIPTIONS         0017                          |
|                                                                                |
|        NIT  NO. OF DIFFERENT ITK 0001  DIT  TPFDC DATA IDENTIFIER 0000         |
|        ITK  ITEM KEY               80  .RF  NO. OF REFERENCES       01         |
|                                                                                |
|        ID2  80   BIT 0 - 1  RCI ITEM                              FD04         |
|        FNR  FILE DEFINITION NO.    00  RID  REFERENCED ID         FD05         |
|        ADR  POS. OF REC ADDRESS  0003  RCP  POS. OF REC CODE CHCK 0007         |
|        FAL  LENGTH OF FILE POINTER 0F  PI2  POS. OF SUBITEM START   00         |
|        CP2  POS. OF CNT FLD SUBITM 00  IT2  ITEM SIZE OF SUBITEM    00         |
|        SSZ  SUBITEM COUNT FLD SIZE 03                                          |
|                                                                                |
|                                                                                |
|        WID  FILE ID              FD05  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          GR95SR  RCT  FCTB FILE TYPE        0000         |
|        BOR  BEGIN ORDINAL    00000000  EOR  FACE END ORDINAL  00000000         |
|                                                                                |
|        ID1  80   BIT 0 - 1  NAB TYPE                                           |
|        ID4  10   BIT 3 - 1  NEW STYLE DBDEF                                    |
|                                                                                |
|        STP  MONITOR BRANCH VECTOR  00  LEV  STRUCTURE LEVEL CTRL    00         |
|        PFC  POS. OF FCH ADDRESS  0008  NAB  INITIAL NAB VALUE     001A         |
|        CBV  TPFDF FIX OR VAR ITEM  05  ITS  ITEM SIZE             0001         |
|        PNB  POS. OF DISP POINTER 0010  RDE  DEL. POINTER IN FILE  0000         |
|        FSZ  SIZE OF NAB/COUNT FLD  03  ISZ  LENGTH OF SIZE FLD      03         |
|        DIS  POS. OF DISP POINTER 0000  TIM  TIMEOUT VALUE FLD     0384         |
|        MPR  DEPENDENT RECORD ID  0000  MPP  DEPENDENT CPU ID         C         |
|        RCI  RCI DEPENDENT ITEM   FD05  NXT  NEXT ID TO CHASE      0000         |
+--------------------------------------------------------------------------------+

The following example displays the file IDs that are backward referenced from the specified ID in an index structure.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/FD05/BRF                                                |
|                                                                                |
|System: UDFM0311I          BACKREFERENCE OF INDEXED FILES                       |
|        ---------------------------------------------------------------         |
|        6. LEV   5. LEV   4. LEV   3. LEV   2. LEV   1. LEV   FIXED ID          |
|                                                                                |
|                                                     FD05 00  FDED 00           |
|                                                                                |
|        WID  FILE ID              FD05  FVN  FILE DEF VERSION NO.    00         |
|        FIL  FILE NAME          GR95SR  RCT  FCTB FILE TYPE        0000         |
|        BOR  BEGIN ORDINAL    00000000  EOR  FACE END ORDINAL  00000000         |
|                                                                                |
|        ID1  80   BIT 0 - 1  NAB TYPE                                           |
|        ID4  10   BIT 3 - 1  NEW STYLE DBDEF                                    |
|                                                                                |
|        STP  MONITOR BRANCH VECTOR  00  LEV  STRUCTURE LEVEL CTRL    00         |
|        PFC  POS. OF FCH ADDRESS  0008  NAB  INITIAL NAB VALUE     001A         |
|        CBV  TPFDF FIX OR VAR ITEM  05  ITS  ITEM SIZE             0001         |
|        PNB  POS. OF DISP POINTER 0010  RDE  DEL. POINTER IN FILE  0000         |
|        FSZ  SIZE OF NAB/COUNT FLD  03  ISZ  LENGTH OF SIZE FLD      03         |
|        DIS  POS. OF DISP POINTER 0000  TIM  TIMEOUT VALUE FLD     0384         |
+--------------------------------------------------------------------------------+

The following example displays the relationship between the file ID specified and other file definitions.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/FD05/REL                                                |
|                                                                                |
|System: UDFM0324I          RELATIONS FOR ID-FD05 FILE-GR95SR                    |
|        R RECOUP/C RCI/Z CRUISE/I INDEX  VAR VARIABLE ID                        |
|        FIXED ID   1.LEV      2.LEV      3.LEV      4.LEV      5.LEV            |
|                                                                                |
|        FDEC00-R-I-FD0400-C-I-FD0500                                            |
|                                                                                |
|        FDED00-C-I-FD0500                                                       |
+--------------------------------------------------------------------------------+

The following describes the parameters in the previous example:

 R 
The reference is a recoup reference (ID2= or ID3=) that will be used for recoup and CRUISE.

 C 
The reference is a recoup reference (ID2= or ID3=) that will be used for recoup and CRUISE and is also a recoup chain-chasing indicator (RCI) candidate.

 Z 
The reference is a ZFCRU reference (ID2= or ID3=) that will be used for ZFCRU only.

 I 
A backward reference using the TPFDF index mechanism.

 VAR 
The referenced ID is variable. The referenced ID can only be found in the logical record (LREC) itself and is not determined in the DBDEF.

The following example initializes ID relationship files using the DBDEF definitions.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/REL/CREATE                                              |
|                                                                                |
|System: CSMP0097I 16.05.46 CPU-B SS-BSS  SSU-HPN  IS-01                         |
|        UDFM0322I 16.05.46 TPFDF FILE RELATION TABLE BUILD STARTED              |
|        CSMP0097I 16.05.48 CPU-B SS-BSS  SSU-HPN  IS-01                         |
|        UDFM0323I 16.05.48 TPFDF FILE RELATION TABLE BUILD ENDED                |
+--------------------------------------------------------------------------------+

The following example displays the fast-link directory on a TPF 4.1 system.

+--------------------------------------------------------------------------------+
|User:     ZUDFM OAI/DBTAB/LINK                                                  |
|                                                                                |
|System:   UDFM0314I          TPFDF FAST-LINK AREA DISPLAY                       |
|                      FAST LINK TABLE BASE:     032E1000                        |
|          PROGRAM FAST LINKAGES:                                                |
|          CASE  PROGRAM DC DESCRIPTION                                          |
|             0  UWAA  0  Y DBADD LAST/NBR                                       |
|             1  UWAA  1  Y DBADD AFTER                                          |
|             2  UWAA  2  Y DBADD BEFORE                                         |
|             8  UWAB  0  Y DBADR                                                |
|            16  UWAC  0  Y DBCKP                                                |
|            24  UWAD  0  Y DBCLS                                                |
|            32  UWAE  0  Y DBCPY                                                |
|            40  UWAF  0  Y DBCRE                                                |
|            48  UWAG  0  Y DBDEL LAST                                           |
|            49  UWAG  1  Y DBDEL NEXT/BEGIN/LRECNBR                             |
|            50  UWAG  2  Y DBDEL LOCATED                                        |
|            (...)                                                               |
|           448  UWBK  0  N DBOPN/INTERNAL                                       |
|           449  UWBK  1  N DBIFB REF/INTERNAL                                   |
|           450  UWBK  2  N DBIFB FIRST/INTERNAL                                 |
|           451  UWBK  3  N DBIFB NEXT/INTERNAL                                  |
+--------------------------------------------------------------------------------+

The following example displays the fast-link directory in an ALCS environment.

+--------------------------------------------------------------------------------+
|User:     ZUDFM OAI/DBTAB/LINK                                                  |
|                                                                                |
|System:   UDFM0314I          TPFDF FAST-LINK AREA DISPLAY                       |
|          UWAA   UWAB   UWAC   UWAD   UWAE   UWAF   UWAG   UWAH                 |
|          UWAI   UWAJ   UWAK   UWAL   UWAM   UWAN   UWAO   UWAP                 |
|          UWAQ   UWAR   UWAS   UWAT   UWAU   UWAV   UWAW   UWAX                 |
|          UWAY   UWA9   UWB0   UWB1   UWB2   UWB3   UWB4   UWB5                 |
|          UWB6   UWB7   UWB8   UWB9   UWBA   UWBB   UWBC   UWBD                 |
|          UWBE   UWBF   UWBG   UWBI   UWBJ   UWBK                               |
+--------------------------------------------------------------------------------+

The following example displays option bit settings in the DBDEF of the specified file.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/GRT1SR/OPT                                              |
|                                                                                |
|System: UDFM0313I          DISPLAY OF OPTIONBITS IN SW02SR                      |
|        ----------------------------------------------------------------        |
|                                                                                |
|        FIL GRT1SR    WID C211    FVN 00                                        |
|          OP1 00                                                                |
|              BIT                                                               |
|              6 - 0  PACK ONLY AFTER -DELETE- COMMAND                           |
|          OP2 06                                                                |
|              BIT                                                               |
|              4 - 0  -FIWHC- PRIME BLOCK RETRIEVAL  -FINWC- IN SHORTTERM        |
|              5 - 1  -FINWC- CHAIN BLOCK RETRIEVAL IF -HOLD- IS GIVEN           |
|              6 - 1  -SERRC R DB010C- IF FILE MODIFIED WITHOUT -HOLD-           |
|                                                                                |
|          OP3 00                                                                |
|                                                                                |
|          OP4 00                                                                |
|                                                                                |
|          CIN 00                                                                |
|                                                                                |
+--------------------------------------------------------------------------------+

The following example displays the file IDs for an application type.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/WID/APLG                                                |
|                                                                                |
|System: UDFM0316I          IDENTIFIER USAGE BY APPLICATION                      |
|             CURRENTLY USED DATA IDENTIFIERS FOR APPLICATION  -  G              |
|                                                                                |
|        ID   V  NAME   T DB | ID   V  NAME   T DB | ID   V  NAME   T DB         |
|        --------------------|---------------------|---------------------        |
|         B K 00 BK0RP  F    |  B K 01 BK0RP  F    |  S W 00 SW00SR P            |
|        FD00 00 GR26SR P *  | FD01 00 GR29SR P *  | FD02 00 GR30SR P *          |
|        FD03 00 GR3NSR P *  | FD04 00 GR94SR P *  | FD05 00 GR95SR P *          |
|        FD06 00 IW01DF P *  | FD0B 00 ZZZZZZ P *  | FD0C 00 IIIIII P *          |
|        FD0D 00 GW01SR P *  | FD0E 00 SW05SR P *  | FD0F 00 SR05SR P *          |
|        FDE2 00 BF0WK  F    | FDEA 00 IRQ1DF F *  | FDEB 00 IRD1DF F *          |
|        FDEC 00 GR93SR F *  | FDED 00 GR92SR F *  | FDEE 00 GR91SR F *          |
|        FDF0 00 SR0GSR F *  | FDF1 00 SR01SR F *  | FDF2 00 SR00SR F *          |
|        FDF3 00 GR3MSR F *  | FDF4 00 GR0ZSR F *  | FDF5 00 GR3OSR F *          |
|        FDF6 00 GR25SR F *  | FDF7 00 GR28SR F *  | FDF8 00 GR27SR F *          |
|        FDF9 00 GR0YSR F *  | FDFA 00 GR0WSR F *  | FDFB 00 GR0VSR F *          |
|        FDFC 00 SATAS  F    | FDFD 00 GR32SR F *  | FDFF 00 GR31SR F *          |
|                              TOTAL OF FILES:  35                               |
+--------------------------------------------------------------------------------+

The previous example provides the following information:

 ID 
The file ID

 V 
The file version number

 NAME 
The DSECT name

 T 
The file type (P=pool file and F=fixed file)

 DB 
The TPFDF file (*); not a TPFDF file (blank).

The following example specifies a range of IDs that are to be added to application C.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/WID/ADD/CR1F700-F7FF                                    |
|                                                                                |
|System: UDFM0315I 08.41.20 UFB-WID-RESTRICTION TABLE MODIFIED                   |
|        END OF DISPLAY                                                          |
+--------------------------------------------------------------------------------+

The following example displays the type that each application is using in the ID restriction table.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/WID/DIS                                                 |
|                                                                                |
|System: UDFM0318I          ID RESTRICTION TABLE                                 |
|                                                                                |
|        APL TYP PRI   ID RANGE        APL TYP PRI   ID RANGE                    |
|        ----------------------------------------------------                    |
|         C   G   0    4 A- 9 9  *      C   R   0    4 A- 9 9  *                 |
|         C   R   1   F700-F7FF         C   W   0   F000-F0FF                    |
|        ----------------------------------------------------                    |
|         E   G   0   F400-F4FF         E   R   0    3 A- 3 9  *                 |
|         E   R   1   F300-F3FF         E   W   0   F400-F4FF                    |
|        ----------------------------------------------------                    |
|         F   G   0    F A- F 9  *      F   G   1   C6C1-C6F9                    |
|         F   R   0    F A- F 9  *      F   R   1   C6C1-C6F9                    |
|         F   R   2   F200-F2FF         F   W   0   F100-F1FF                    |
|        ----------------------------------------------------                    |
|         G   G   0    1 0- 2 9  *      G   R   0    1 A- 2 9  *                 |
|         G   R   1   C000-C0FF         G   W   0   C000-C0FF                    |
|         G   X   0   C200-C2FF                                                  |
|        ----------------------------------------------------                    |
|         I   G   0   C100-C1FF                                                  |
+--------------------------------------------------------------------------------+

In the previous example, the following headings correspond to parameters that are used to add IDs to the restriction table:

 APL 
The application type

 TYP 
The file category

 PRI 
The priority

 ID RANGE 
The range of file IDs.

The asterisk (*) indicates that IDs were added with the C option.

The following example requests to reserve six IDs. The specific IDs that were requested are displayed.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/WID/NEW/GR6                                             |
|                                                                                |
|System: UDFM0319I          NEXT ID-S FOR APPLICATION G AND TYPE R ARE:          |
|        1 A   1 B   1 C   1 D   1 E   1 F                                       |
|        END OF DISPLAY                                                          |
+--------------------------------------------------------------------------------+

The following example displays the IDs and ID ranges that have been reserved.

+--------------------------------------------------------------------------------+
|User:   ZUDFM OAI/DBTAB/WID/DID                                                 |
|                                                                                |
|System: UDFM0317I          ALREADY USED ID-S                                    |
|                                                                                |
|        27JUN97  GR  1 A  1 B  1 C  1 D  1 E  1 F                               |
+--------------------------------------------------------------------------------+

References

See TPFDF Database Administration for more information about application types.