Using the database unload utility output with DB2®

You can use the Db2z/OS® 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)