IRRDBU00 record types

The database unload utility gives every record it creates a record type. This record type is a 4-byte identification number in the first four positions of every record. For details about the format of the identification number, see Format of the record type identification number.

The record types and their associated names are:

Record Type: Record Name
0100: Group Basic Data
0101: Group Subgroups
0102: Group Members
0103: Group Installation Data
0110: Group DFP Data
0120: Group OMVS Data
0130: Group OVM Data
0140: Reserved
0141: Group TME Data
0150: Reserved
0151: Group CSDATA Custom Fields
0200: User Basic Data
0201: User Categories
0202: User Classes
0203: User Group Connections
0204: User Installation Data
0205: User Connect Data
0206: User RRSF Data
0207: User Certificate Name
0208: User Associated Mappings
0209: User Associated Distributed Mappings
0210: User DFP Data
0220: User TSO Data
0230: User CICS® Data
0231: User CICS Operator Classes
0232: User CICS RSL Keys
0233: User CICS TSL Keys
0240: User Language Data
0250: User OPERPARM Data
0251: User OPERPARM Scope
0260: User WORKATTR Data
0270: User OMVS Data
0280: User NETVIEW Segment
0281: User OPCLASS
0282: User DOMAINS
0290: User DCE Data
02A0: User OVM Data
02B0: User LNOTES Data
02C0: User NDS Data
02D0: User KERB Data
02E0: User PROXY Data
02F0: User EIM Data
02G0: Reserved
02G1: User CSDATA Custom Fields
0400: Data Set Basic Data
0401: Data Set Categories
0402: Data Set Conditional Access
0403: Data Set Volumes
0404: Data Set Access
0405: Data Set Installation Data
0410: Data Set DFP Data
0420: Reserved
0421: Data Set TME Data
0500: General Resource Basic Data
0501: General Resource Tape Volume Data
0502: General Resource Categories
0503: General Resource Members
0504: General Resource Volumes
0505: General Resource Access
0506: General Resource Installation Data
0507: General Resource Conditional Access
0508: Filter Data
0509: General Resource Distributed Identity Mapping Data
0510: General Resource Session Data
0511: General Resource Session Entities
0520: General Resource DLF Data
0521: General Resource DLF Job Names
0530: Reserved
0540: General Resource Started Task Data
0550: General Resource SystemView® Data
0560: General Resource Certificate Data
0561: General Resource Certificate References
0562: General Resource Key Ring Data
0570: General Resource TME Data
0571: General Resource TME Child
0572: General Resource TME Resource
0573: General Resource TME Group
0574: General Resource TME Role
0580: General Resource KERB Data
0590: General Resource PROXY Data
05A0: General Resource EIM Data
05B0: General Resource Alias Data
05C0: General Resource CDTINFO Data
05D0: General Resource ICTX Data
05E0: General Resource CFDEF Data
05F0: General Resource SIGVER Data
05G0: General Resource ICSF
05G1: General Resource ICSF Key Label
05G2: General Resource ICSF Certificate Identifier
1560: General Resource Certificate Information

Format of the record type identification number

The identification number for the record type is in the format PPSF, where

PP

Profile type

01: For groups
02: For users
04: For data sets
05: For general resources
1n: For extension records, where n indicates profile type: 1, 2, 4, or 5, as listed above.
For example, record number 1560 identifies the General Resource Certificate Data extension record.

S

Segment number

0: Base segment
all others: Segment value as determined by the position of the segment in the template

F

Additional record qualifier

For example, when the profile type is 01 - 05, the additional record qualifier identifies a repeat group within the segment. A zero (0) indicates a non-repeat group within the segment.

The relationships among unloaded database records

The following figures describe how the records produced by the database unload utility relate to each other. The conventions used in the figures are:

Only fields showing a relationship to another record type are described.
A line shows a relationship between different types of records.
The complete field names are in the format
```
prefix_fieldname
```
where prefix is the unique record prefix assigned to the record and fieldname identifies the field in the record. Each section provides the prefix added to the field names.
The arrows on the connecting line clarify the relationship; they point to the field that had to have existed first in the RACF® database.
For example, there is a user named GARREN. GARREN creates a group named TEST. The user ID named GARREN had to exist before the group TEST was created.

In terms of the output from database unload, there exists a user basic data record with GARREN in the USBD_NAME field. There also exists a group basic data record with TEST in the GPBD_NAME field and GARREN in the GPBD_OWNER_ID field.

The figures illustrating the relationships are located as follows:

Group records, see Figure 1
User records, see Figure 3
Data set records, see Figure 4
General Resource records, see Figure 5.

Unloaded group record types

The prefix representing the record identifier is omitted in the pictorial diagrams. For group records, the prefixes are:

   Record Name                      Record Type       Record Prefix
   Group Basic Data                 0100              GPBD
   Group Subgroups                  0101              GPSGRP
   Group Members                    0102              GPMEM
   Group Installation Data          0103              GPINSTD
   Group DFP Data                   0110              GPDFP
   Group OMVS Data                  0120              GPOMVS
   Group OVM Data                   0130              GPOVM
   Group TME Data                   0141              GPTME
   Group CSDATA Custom Fields       0151              GPCSD

Figure 1. Relationship among the group record types

Unloaded user record types

The high level qualifier which represents the table identifier is omitted. For user records, these qualifiers are:

   Record Name                                   Record Type       Record Prefix
   User Basic Data                               0200              USBD
   User Categories                               0201              USCAT
   User Classes                                  0202              USCLA
   User Group Connections                        0203              USGCON
   User Installation Data                        0204              USINSTD
   User Connect Data                             0205              USCON
   User RRSF Data                                0206              USRSF
   User Certificate Data                         0207              USCERT
   User Mappings                                 0208              USNMAP
   User Associated Distributed Mappings          0209              USDMAP
   User DFP Data                                 0210              USDFP
   User TSO Data                                 0220              USTSO
   User CICS Data                                0230              USCICS
   User CICS Operator Classes                    0231              USCOPC
   User CICS RSL Keys                            0232              USCRSL
   User CICS TSL Keys                            0233              USCTSL
   User Language Data                            0240              USLAN
   User OPERPARM Data                            0250              USOPR
   User OPERPARM Scope                           0251              USOPRP
   User WORKATTR Data                            0260              USWRK
   User OMVS Data                                0270              USOMVS
   User NETVIEW Segment                          0280              USNETV
   User OPCLASS                                  0281              USNOPC
   User DOMAINS                                  0282              USNDOM
   User DCE Data                                 0290              USDCE
   User OVM Data                                 02A0              USOVM
   User LNOTES Data                              02B0              USLNOT
   User NDS Data                                 02C0              USNDS
   User KERB Data                                02D0              USKERB
   User PROXY Data                               02E0              USPROXY
   User EIM Data                                 02F0              USEIM
   User CSDATA Custom Fields                     02G1              USCSD

Figure 2. Relationship among the user record types (Part 1 of 2)

Figure 3. Relationship among the user record types (Part 2 of 2)

Unloaded data set record types

The high level qualifier which represents the table identifier is omitted. For data set records, these qualifiers are:

   Record Name                   Record Type       Record Prefix
   Data Set Basic Data           0400              DSBD
   Data Set Categories           0401              DSCAT
   Data Set Conditional Access   0402              DSCACC
   Data Set Volumes              0403              DSVOL
   Data Set Access               0404              DSACC
   Data Set Installation Data    0405              DSINSTD
   Data Set DFP Data             0410              DSDFP
   Data Set TME Role             0421              DSTME

The NAME/VOL field is a concatenation of the NAME field and VOLUME field.

Figure 4. Relationship among the data set record types

Unloaded general resource record types

The high level qualifier which represents the table identifier is omitted. For general resource records, these qualifiers are:

   Record Name                                                 Record Type          Record Prefix
   General Resource Basic Data                                 0500                 GRBD
   General Resource Tape Volume Data                           0501                 GRTVOL
   General Resource Categories                                 0502                 GRCAT
   General Resource Members                                    0503                 GRMEM
   General Resource Volumes                                    0504                 GRVOL
   General Resource Access                                     0505                 GRACC
   General Resource Installation Data                          0506                 GRINSTD
   General Resource Conditional Access                         0507                 GRCACC
   General Filter Data                                         0508                 GRFLTR
   General Resource Distributed Identity Mapping Data          0509                 GRDMAP
   General Resource Session Data                               0510                 GRSES
   General Resource Session Entities                           0511                 GRSESE
   General Resource DLF Data                                   0520                 GRDLF
   General Resource DLF Job Names                              0521                 GRDLFJ
   General Resource Started Task Data                          0540                 GRST
   General Resource SystemView Data                            0550                 GRSV
   General Resource Certificate Data                           0560                 GRCERT
   General Resource Certificate References                     0561                 CERTR
   General Resource Key Ring Data                              0562                 KEYR
   General Resource TME Data                                   0570                 GRTME
   General Resource TME Child                                  0571                 GRTMEC
   General Resource TME Resource                               0572                 GRTMER
   General Resource TME Group                                  0573                 GRTMEG
   General Resource TME Role                                   0574                 GRTMEE
   General Resource KERB Data                                  0580                 GRKERB
   General Resource PROXY Data                                 0590                 GRPROXY
   General Resource EIM Data                                   05A0                 GREIM
   General Resource Alias Data                                 05B0                 GRALIAS
   General Resource CDTINFO Data                               05C0                 GRCDT
   General Resource ICTX Data                                  05D0                 GRICTX
   General Resource CFDEF Data                                 05E0                 GRCFDEF
   General Resource SIGVER Data                                05F0                 GRSIG
   General Resource ICSF                                       05G0                 GRCSF
   General Resource ICSF Key Label                             05G1                 GRCSFK
   General Resource ICSF Certificate Identifier                05G2                 GRCSFC
   General Resource Certificate Information                    1560                 CERTN

Figure 5. Relationship among the general resource record types