z/OS Security Server RACF Security Administrator's Guide
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


Using the database unload utility output with DB2

z/OS Security Server RACF Security Administrator's Guide
SA23-2289-00

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.

Go to the previous page Go to the next page




Copyright IBM Corporation 1990, 2014