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
(Part 1 of 2)
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)
INIT_IDID_USER POSITION(2532:3516) CHAR(985)
INIT_IDID_REG POSITION(3518:4538) CHAR(1021)
Figure 2. DB2 Utility
Statements Required to Load the Tables (Part 2 of 2)
INIT_ACEE_VLF POSITION(4540:4540) CHAR(1)
INIT_MFA_USR POSITION(4545:4545) CHAR(1)
INIT_MFA_FALLBACK POSITION(4550:4550) CHAR(1)
INIT_MFA_UNAVAIL POSITION(4555:4555) CHAR(1)
INIT_MFA_PWD_EXPIRED POSITION(4560:4560) CHAR(1)
INIT_MFA_NPWD_INV POSITION(4565:4565) CHAR(1)
INIT_MFA_PART_SUCC POSITION(4570:4570) CHAR(1)
.
INIT_PASSWORD_EVAL POSITION(4580:4580) CHAR(1)
INIT_PASSWORD_SUCC POSITION(4585:4585) CHAR(1)
INIT_PHRASE_EVAL POSITION(4590:4590) CHAR(1)
INIT_PHRASE_SUCC POSITION(4595:4595) CHAR(1)
INIT_PASSTICKET_EVAL POSITION(4600:4600) CHAR(1)
INIT_PASSTICKET_SUCC POSITION(4605:4605) CHAR(1)
INIT_MFA_SUCC POSITION(4610:4610) CHAR(1)
INIT_MFA_FAIL POSITION(4615:4615) CHAR(1)
INIT_AUTH_RSN1 POSITION(4620:4627) CHAR(7)
INIT_AUTH_RSN2 POSITION(4629:4636) CHAR(8)