Creating the DB2® tables

After the database and the table space are created, SQL statements that define the tables are executed. Figure 1 contains an example of the SQL statements that are required to create a table for the job initiation records created by the RACF® SMF data unload utility.

Member IRRADUTB in SYS1.SAMPLIB contains examples that create separate tables for each record type that is produced by the RACF SMF data unload utility. The user must supply the user ID (userid).

Figure 1. Sample SQL Utility Statements Creating a Table

CREATE TABLE userid.JOBINIT (
          INIT_EVENT_TYPE    CHAR(8),
          INIT_EVENT_QUAL    CHAR(8),
          INIT_TIME_WRITTEN  TIME,
          INIT_DATE_WRITTEN  DATE,
          INIT_SYSTEM_SMFID  CHAR(4),
          INIT_VIOLATION     CHAR(1),
          INIT_USER_NDFND    CHAR(1),
          INIT_USER_WARNING  CHAR(1),
          INIT_EVT_USER_ID   CHAR(8),
          INIT_EVT_GRP_ID    CHAR(8),
          INIT_AUTH_NORMAL   CHAR(1),
          INIT_AUTH_SPECIAL  CHAR(1),
          INIT_AUTH_OPER     CHAR(1),
          INIT_AUTH_AUDIT    CHAR(1),
          INIT_AUTH_EXIT     CHAR(1),
          INIT_AUTH_FAILSFT  CHAR(1),
          INIT_AUTH_BYPASS   CHAR(1),
          INIT_AUTH_TRUSTED  CHAR(1),
          INIT_LOG_CLASS     CHAR(1),
          INIT_LOG_USER      CHAR(1),
          INIT_LOG_SPECIAL   CHAR(1),
          .
          .
          .
          INIT_UTK_SECL      CHAR(8),
          INIT_UTK_EXECNODE  CHAR(8),
          INIT_UTK_SUSER_ID  CHAR(8),
          INIT_UTK_SNODE     CHAR(8),
          INIT_UTK_SGRP_ID   CHAR(8),
          INIT_UTK_SPOE      CHAR(8),
          INIT_UTK_SPCLASS   CHAR(8),
          INIT_UTK_USER_ID   CHAR(8),
          INIT_UTK_GRP_ID    CHAR(8),
          INIT_UTK_DFT_GRP   CHAR(1),
          INIT_UTK_DFT_SECL  CHAR(1),
          INIT_APPC_LINK     CHAR(16),
          INIT_UTK_NETW      CHAR(8),
          INIT_RES_NAME      VARCHAR(255),
          INIT_CLASS         CHAR(8),
          INIT_X500_SUBJECT  VARCHAR(255),
          INIT_X500_ISSUER   VARCHAR(255),
          INIT_SERVSECL CHAR(8), 
          INIT_SERV_POENAME CHAR(64), 
          INIT_CTX_USER VARCHAR(510), 
          INIT_CTX_REG VARCHAR(255), 
          INIT_CTX_HOST CHAR(128), 
          INIT_CTX_MECH CHAR(16) 
          )  IN databasename.tablespacename