Loading the DB2 tables

Figure 1 shows the statements that are required to load the job initiation records. The IRRADULD member of SYS1.SAMPLIB contains statements that load all of the record types produced by the RACF® SMF data unload utility. You can choose not to load some of the tables.

Figure 1. DB2 Utility Statements Required to Load the Tables

LOAD DATA INDDN ddname   RESUME YES    LOG NO
    INTO TABLE userid.JOBINIT
    WHEN(1:8)='JOBINIT' (
      INIT_EVENT_TYPE    POSITION(1:8)       CHAR(8),
      INIT_EVENT_QUAL    POSITION(10:17)     CHAR(8),
      INIT_TIME_WRITTEN  POSITION(19:26)     TIME    EXTERNAL(8),
      INIT_DATE_WRITTEN  POSITION(28:37)     DATE    EXTERNAL(10),
      INIT_SYSTEM_SMFID  POSITION(39:42)     CHAR(4),
      INIT_VIOLATION     POSITION(44:44)     CHAR(1),
      INIT_USER_NDFND    POSITION(49:49)     CHAR(1),
      INIT_USER_WARNING  POSITION(54:54)     CHAR(1),
      INIT_EVT_USER_ID   POSITION(59:66)     CHAR(8),
      INIT_EVT_GRP_ID    POSITION(68:75)     CHAR(8),
      .
      .
      .
      INIT_AUTH_OMVSSU   POSITION(258:258)   CHAR(1),
      INIT_AUTH_OMVSSYS  POSITION(263:263)   CHAR(1),
      INIT_USR_SECL      POSITION(268:275)   CHAR(8),
      INIT_RACF_VERSION  POSITION(277:280)   CHAR(4),
      INIT_APPL          POSITION(282:289)   CHAR(8),
      INIT_LOGSTR        POSITION(291:545)   CHAR(255),
      INIT_BAD_JOBNAME   POSITION(547:554)   CHAR(8),
      INIT_USER_NAME     POSITION(556:575)   CHAR(20),
      INIT_UTK_ENCR      POSITION(577:577)   CHAR(1),
      INIT_UTK_PRE19     POSITION(582:582)   CHAR(1),
      INIT_UTK_VERPROF   POSITION(587:587)   CHAR(1),
      INIT_UTK_NJEUNUSR  POSITION(592:592)   CHAR(1),
      INIT_UTK_LOGUSR    POSITION(597:597)   CHAR(1),
      INIT_UTK_SPECIAL   POSITION(602:602)   CHAR(1),
      INIT_UTK_DEFAULT   POSITION(607:607)   CHAR(1),
      INIT_UTK_UNKNUSR   POSITION(612:612)   CHAR(1),
      INIT_UTK_ERROR     POSITION(617:617)   CHAR(1),
      INIT_UTK_TRUSTED   POSITION(622:622)   CHAR(1),
      INIT_UTK_SESSTYPE  POSITION(627:634)   CHAR(8),
      INIT_UTK_SURROGAT  POSITION(636:636)   CHAR(1),
      INIT_UTK_REMOTE    POSITION(641:641)   CHAR(1),
      INIT_UTK_PRIV      POSITION(646:646)   CHAR(1),
      INIT_UTK_SECL      POSITION(651:658)   CHAR(8),
      INIT_UTK_EXECNODE  POSITION(660:667)   CHAR(8),
      INIT_UTK_SUSER_ID  POSITION(669:676)   CHAR(8),
      INIT_UTK_SNODE     POSITION(678:685)   CHAR(8),
      INIT_UTK_SGRP_ID   POSITION(687:694)   CHAR(8),
      INIT_UTK_SPOE      POSITION(696:703)   CHAR(8),
      INIT_UTK_SPCLASS   POSITION(705:712)   CHAR(8),
      INIT_UTK_USER_ID   POSITION(714:721)   CHAR(8),
      INIT_UTK_GRP_ID    POSITION(723:730)   CHAR(8),
      INIT_UTK_DFT_GRP   POSITION(732:732)   CHAR(1),
      INIT_UTK_DFT_SECL  POSITION(737:737)   CHAR(1),
      INIT_APPC_LINK     POSITION(742:757)   CHAR(16),
      INIT_UTK_NETW      POSITION(759:766)   CHAR(8)),
      INIT_RES_NAME      POSITION(768:1022)  VARCHAR(255),
      INIT_CLASS         POSITION(1024:1031) CHAR(8),
      INIT_X500_SUBJECT  POSITION(1033:1287) VARCHAR(255),
      INIT_X500_ISSUER   POSITION(1289:1543) VARCHAR(255),
      INIT_SERVSECL POSITION(1545:1552) CHAR(8), 
      INIT_SERV_POENAME POSITION(1554:1617) CHAR(64), 
      INIT_CTX_USER POSITION(1619:2128) CHAR(510), 
      INIT_CTX_REG POSITION(2130:2384) CHAR(255), 
      INIT_CTX_HOST POSITION(2386:2513) CHAR(128), 
      INIT_CTX_MECH POSITION(2515:2530) CHAR(16)