You can use the DB2® load
utility or its equivalent to process the records produced by the
database unload utility. The definition and control statements for
a DB2 utilization of the output,
all of which are contained in SYS1.SAMPLIB, are as follows:
- Sample data definition language (DDL) statements to define the relational presentation
of the RACF® database and sample DB2 definitions which perform database
and index creation. These are contained in member RACDBUTB.
- Sample control statements for the DB2 load
utility that map the output from the
database unload utility (IRRDBU00). These are contained in member
RACDBULD.
- Sample structured query language (SQL) queries that perform the
following queries. These are contained in member RACDBUQR.
- Listing all of the members of a group, including a universal group
- Listing all of the users with the SPECIAL attribute
- Finding all of the groups to which a user is connected
- Finding all of the data set access lists that contain
user IDs that are no longer valid
- Listing of z/OS UNIX user
identifiers (UIDs) with associated user ID and programmer name
- Listing of z/OS UNIX group
identifiers (GIDs) with associated group name
- Listing of UIDs including only those users who are connected to
a group that has a GID (for each UID, the user ID and programmer name
are listed)
For more information on DB2,
visit IBM Information Management Software for z/OS Solutions Information Center.