Record formats produced by the database unload utility

The following topics contain a detailed description of the records that are produced by the database unload utility.

Each row in the tabular description of the records that are produced by the utility contains five pieces of information:

Descriptive name for the field
Type of field
Char

Character data.

Int

IntegerEBCDIC numeric data.

Time

A time value, in the form hh:mm:ss.

Date

A date value, in the form yyyy-mm-dd.

Yes/No

Flag data, having the value YES or NO.
Starting position for the field
Ending position for the field
Free form description of the field, which can contain the valid value constraints.

The complete record formats are located as follows:

Group records, see Group record formats
User records, see User record formats
Data set records, see Data set record formats
General Resource records, see General resource record formats

Note: For some applications, such as SQL/DS, the start and end positions must account for a 4-position length indicator at the front of each record. For applications such as these, 4 would be added to each of the start and end positions indicated.

Group record formats

The records associated with groups are:

Group Basic Data
Group Subgroups
Group Members
Group Installation Data
Group DFP Data
Group OMVS Data
Group OVM Data
Group TME Role
Group CSDATA Custom Fields

Group basic data record (0100)

The Group Basic Data record defines the basic information that defines a group. There is one record per group.

Table 1. Group Basic Data Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPBD_RECORD_TYPE	Int	1	4	Record type of the Group Basic Data record (0100).
GPBD_NAME	Char	6	13	Group name as taken from the profile name.
GPBD_SUPGRP_ID	Char	15	22	Name of the superior group to this group.
GPBD_CREATE_DATE	Date	24	33	Date that the group was defined.
GPBD_OWNER_ID	Char	35	42	The user ID or group name which owns the profile.
GPBD_UACC	Char	44	51	The default universal access. Valid values are `NONE` for all groups other than the IBM®-defined `VSAMDSET` group which has `CREATE`.
GPBD_NOTERMUACC	Yes/ No	53	56	Indicates if the group must be specifically authorized to use a particular terminal through the use of the PERMIT command.
GPBD_INSTALL_DATA	Char	58	312	Installation-defined data.
GPBD_MODEL	Char	314	357	Data set profile that is used as a model for this group.
GPBD_UNIVERSAL	Yes/ No	359	362	Indicates if the group has the UNIVERSAL attribute.

Group subgroups record (0101)

The Group Subgroups record defines the relationship between a group and any subgroups that are within the group. There is one record per group/subgroup combination.

Table 2. Group Subgroups Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPSGRP_RECORD_TYPE	Int	1	4	Record type of the Group Subgroups record (0101).
GPSGRP_NAME	Char	6	13	Group name as taken from the profile name.
GPSGRP_SUBGRP_ID	Char	15	22	The name of a subgroup within the group.

Group members record (0102)

The Group Members record defines the relationship between a group and the members of the group. There is one record per group/member combination.

Table 3. Group Members Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPMEM_RECORD_TYPE	Int	1	4	Record type of the Group Members record (0102).
GPMEM_NAME	Char	6	13	Group name as taken from the profile name.
GPMEM_MEMBER_ID	Char	15	22	A user ID within the group.
GPMEM_AUTH	Char	24	31	Indicates the authority that the user ID has within the group. Valid values are `USE`, `CONNECT`, `JOIN`, and `CREATE`.

Group installation data record (0103)

The Group Installation Data record defines the user data associated with a group.

This record type contains the data stored in the USRCNT repeat group, which is a field in the RACF® database that is reserved for your installation's use. None of the RACF commands manipulate this field. Do not confuse this field with the GPBD_INSTALL_DATA field, shown in Table 3, which you enter into the database using the ADDGROUP and ALTGROUP commands.

There is one record per group/installation data combination.

Table 4. Group Installation Data Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPINSTD_RECORD_TYPE	Int	1	4	Record type of the Group Installation Data record (0103).
GPINSTD_NAME	Char	6	13	Group name as taken from the profile name.
GPINSTD_USR_NAME	Char	15	22	The name of the installation-defined field.
GPINSTD_USR_DATA	Char	24	278	The data for the installation-defined field.
GPINSTD_USR_FLAG	Char	280	287	The flag for the installation-defined field in the form `X<cc>`.

Group DFP data record (0110)

The Group DFP Data record defines the information required by the System Managed Storage (SMS) facility of the Data Facility Product (DFP). The fields in these records define the characteristics of the data that this profile protects.

There is one record per group/DFP data combination.

Table 5. Group DFP Data Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPDFP_RECORD_TYPE	Int	1	4	Record type of the Group DFP Data record (0110).
GPDFP_NAME	Char	6	13	Group name as taken from the profile name.
GPDFP_DATAAPPL	Char	15	22	Default application name for the group.
GPDFP_DATACLAS	Char	24	31	Default data class for the group.
GPDFP_MGMTCLAS	Char	33	40	Default management class for the group.
GPDFP_STORCLAS	Char	42	49	Default storage class for the group.

Group OMVS data record (0120)

The Group OMVS Data record defines the information required by z/OS UNIX to verify that users are associated with a valid z/OS UNIX group identifier (GID). These records define the GIDs that are assigned to RACF groups.

There is one record per group/GID combination.

Table 6. Group OMVS Data Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPOMVS_RECORD_TYPE	Int	1	4	Record type of the Group OMVS Data record (0120).
GPOMVS_NAME	Char	6	13	Group name as taken from the profile name.
GPOMVS_GID	Char	15	24	OMVS z/OS UNIX group identifier (GID) associated with the group name from the profile.

Group OVM data record (0130)

The Group OVM Data record defines the OpenExtensions group identifiers (GIDs) that are assigned to RACF groups.

There is one record per group/GID combination.

Table 7. Group OVM Data Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPOVM_RECORD_TYPE	Int	1	4	Record type of the Group OVM Data record (0130).
GPOVM_NAME	Char	6	13	Group name as taken from the profile name.
GPOVM_GID	Char	15	24	OpenExtensions group identifier (GID) associated with the group name from the profile.

Group TME role record (0141)

The Group TME Data record identifies ROLE profiles in which the group is referenced.

There is one record per group/role combination.

Table 8. Group TME Data Record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPTME_RECORD_TYPE	Int	1	4	Record type of the Group TME Data record (0141).
GPTME_NAME	Char	6	13	Group name as taken from the profile name.
GPTME_ROLE	Char	15	260	Role profile name.

Group CSDATA custom fields record (0151)

The Group CSDATA custom fields record defines the custom fields associated with a group. There is one record per combination of group and CSDATA custom fields.

Table 9. Group CSDATA custom fields record
Field Name	Type	Position	Comments
Field Name	Type	Start	Comments	End
GPCSD_RECORD_TYPE	Int	1	4	Record type of the Group CSDATA custom fields (0151).
GPCSD_NAME	Char	6	13	Group name.
GPCSD_TYPE	Char	15	18	Data type for the custom field. Valid values are CHAR, FLAG, HEX, NUM.
GPCSD_KEY	Char	20	51	Custom field keyword; maximum length = 8.
GPCSD_VALUE	Char	53	1152	Custom field value.