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.
- 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
orNO
.
- Starting position for the field
- Ending position for the field
- Free form description of the field, which can contain the valid value constraints.
- 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
Group record formats
- 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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 | Char | 53 | 56 | Indicates if the group must be specifically authorized to use a particular terminal through the use of the PERMIT command. Valid Values include "Yes" and "No". |
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 | Char | 359 | 362 | Indicates if the group has the UNIVERSAL attribute. Valid Values include "Yes" and "No". |
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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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.
Field Name | Type | Position | Comments | |
---|---|---|---|---|
Start | 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. |