============================================================================ USER COMMAND: SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r ---------------------------------------------------------------------------- OPTIMIZE: SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f UNION SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r CANONICAL PLAN: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r]) ============================================================================ EXECUTING PlaceAccess AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r]) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r]) ============================================================================ EXECUTING PlanUnions AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r]) ============================================================================ EXECUTING RaiseAccess AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o]) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m]) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s]) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f]) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r]) ============================================================================ EXECUTING AssignOutputElements AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={OUTPUT_COLS=[c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, c.admsecstr]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={OUTPUT_COLS=[f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup, f.acccode, f.esmrc, f.esmreason]}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code]}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code]}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={OUTPUT_COLS=[r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser, r.usrgroup, r.ussfunction, r.esmrc, r.esmreason]}) ============================================================================ EXECUTING CalculateCost AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code], EST_COL_STATS={a.evttypecode=[-1.0, -1.0], a.evtversion=[-1.0, -1.0], a.evtcatcode=[-1.0, -1.0], a.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code], EST_COL_STATS={p.evttypecode=[-1.0, -1.0], p.evtversion=[-1.0, -1.0], p.evtcatcode=[-1.0, -1.0], p.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code], EST_COL_STATS={o.evttypecode=[-1.0, -1.0], o.evtversion=[-1.0, -1.0], o.evtcatcode=[-1.0, -1.0], o.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={OUTPUT_COLS=[c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, c.admsecstr], EST_COL_STATS={c.evttypecode=[-1.0, -1.0], c.evtversion=[-1.0, -1.0], c.evtcatcode=[-1.0, -1.0], c.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code], EST_COL_STATS={m.evttypecode=[-1.0, -1.0], m.evtversion=[-1.0, -1.0], m.evtcatcode=[-1.0, -1.0], m.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code], EST_COL_STATS={s.evttypecode=[-1.0, -1.0], s.evtversion=[-1.0, -1.0], s.evtcatcode=[-1.0, -1.0], s.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={OUTPUT_COLS=[f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup, f.acccode, f.esmrc, f.esmreason], EST_COL_STATS={f.evttypecode=[-1.0, -1.0], f.evtversion=[-1.0, -1.0], f.evtcatcode=[-1.0, -1.0], f.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={OUTPUT_COLS=[r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser, r.usrgroup, r.ussfunction, r.esmrc, r.esmreason], EST_COL_STATS={r.evttypecode=[-1.0, -1.0], r.evtversion=[-1.0, -1.0], r.evtcatcode=[-1.0, -1.0], r.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PlanSorts AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code], EST_COL_STATS={a.evttypecode=[-1.0, -1.0], a.evtversion=[-1.0, -1.0], a.evtcatcode=[-1.0, -1.0], a.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code], EST_COL_STATS={p.evttypecode=[-1.0, -1.0], p.evtversion=[-1.0, -1.0], p.evtcatcode=[-1.0, -1.0], p.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code], EST_COL_STATS={o.evttypecode=[-1.0, -1.0], o.evtversion=[-1.0, -1.0], o.evtcatcode=[-1.0, -1.0], o.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={OUTPUT_COLS=[c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, c.admsecstr], EST_COL_STATS={c.evttypecode=[-1.0, -1.0], c.evtversion=[-1.0, -1.0], c.evtcatcode=[-1.0, -1.0], c.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code], EST_COL_STATS={m.evttypecode=[-1.0, -1.0], m.evtversion=[-1.0, -1.0], m.evtcatcode=[-1.0, -1.0], m.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code], EST_COL_STATS={s.evttypecode=[-1.0, -1.0], s.evtversion=[-1.0, -1.0], s.evtcatcode=[-1.0, -1.0], s.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={OUTPUT_COLS=[f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup, f.acccode, f.esmrc, f.esmreason], EST_COL_STATS={f.evttypecode=[-1.0, -1.0], f.evtversion=[-1.0, -1.0], f.evtcatcode=[-1.0, -1.0], f.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={OUTPUT_COLS=[r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser, r.usrgroup, r.ussfunction, r.esmrc, r.esmreason], EST_COL_STATS={r.evttypecode=[-1.0, -1.0], r.evtversion=[-1.0, -1.0], r.evtcatcode=[-1.0, -1.0], r.evtsysid=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING CollapseSource AFTER: SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS a}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS p}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS o}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS c}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS m}) Project(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={PROJECT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code], EST_CARDINALITY=-1.0}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS s}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS f}) Access(groups=[SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r], props={MODEL_ID=Schema name=SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1, nameInSource=null, uuid=mmuuid:0938c610-2457-4cc0-84ec-fb48fb624097, OUTPUT_COLS=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT 'abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS r}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = SortNode(1) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(0) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(3) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(2) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(5) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(4) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(7) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(6) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(9) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(8) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(11) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(10) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(13) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(12) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] ProjectNode(14) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] AccessNode(15) output=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admtarget, g_0.admacctstr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS g_0 ProjectNode(16) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE] AccessNode(17) output=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admtarget, g_0.admpolicystr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS g_0 ProjectNode(18) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE] AccessNode(19) output=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrprogram, g_0.polrule, g_0.acccode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS g_0 AccessNode(20) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admsecstr FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS g_0 ProjectNode(21) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE] AccessNode(22) output=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admmiscstr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS g_0 ProjectNode(23) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code] ['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code] AccessNode(24) output=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrprogram, g_0.inf1code, g_0.inf2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS g_0 AccessNode(25) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrgroup, g_0.acccode, g_0.esmrc, g_0.esmreason FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS g_0 AccessNode(26) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usruser, g_0.usrgroup, g_0.ussfunction, g_0.esmrc, g_0.esmreason FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS g_0 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: SortNode(1) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(0) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(3) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(2) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(5) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(4) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(7) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(6) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(9) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(8) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(11) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(10) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] SortNode(13) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] [DUP_REMOVE] UnionAllNode(12) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] ProjectNode(14) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWADMACCOUNT' AS "__objecttype__", a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr AS Commandstr, a.oprcode, a.vio1code AS VIO1CODE, a.vio2code AS VIO2CODE] AccessNode(15) output=[a.evttypecode, a.evtversion, a.evtcatcode, a.evtsysid, a.evtsysplex, a.evtutctod, a.evtsystod, a.evtesmcode, a.evtpuuid, a.evtuserid, a.evtusername, a.evtjobname, a.evtsource, a.admtarget, a.admacctstr, a.oprcode, a.vio1code, a.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admtarget, g_0.admacctstr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMACCOUNT AS g_0 ProjectNode(16) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWADMPOLICY' AS "__objecttype__", p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr AS Commandstr, p.oprcode, p.vio1code AS VIO1CODE, p.vio2code AS VIO2CODE] AccessNode(17) output=[p.evttypecode, p.evtversion, p.evtcatcode, p.evtsysid, p.evtsysplex, p.evtutctod, p.evtsystod, p.evtesmcode, p.evtpuuid, p.evtuserid, p.evtusername, p.evtjobname, p.evtsource, p.admtarget, p.admpolicystr, p.oprcode, p.vio1code, p.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admtarget, g_0.admpolicystr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMPOLICY AS g_0 ProjectNode(18) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWOBJACCESS' AS "__objecttype__", o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram AS admtarget, o.polrule AS Commandstr, o.acccode AS oprcode, o.vio1code AS VIO1CODE, o.vio2code AS VIO2CODE] AccessNode(19) output=[o.evttypecode, o.evtversion, o.evtcatcode, o.evtsysid, o.evtsysplex, o.evtutctod, o.evtsystod, o.evtesmcode, o.evtpuuid, o.evtuserid, o.evtusername, o.evtjobname, o.evtsource, o.usrprogram, o.polrule, o.acccode, o.vio1code, o.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrprogram, g_0.polrule, g_0.acccode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.OBJACCESS AS g_0 AccessNode(20) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWSECCONTROL' AS "__objecttype__", c.evttypecode, c.evtversion, c.evtcatcode, c.evtsysid, c.evtsysplex, c.evtutctod, c.evtsystod, c.evtesmcode, c.evtpuuid, c.evtuserid, c.evtusername, c.evtjobname, c.evtsource, ' ' AS admtarget, c.admsecstr AS Commandstr, 0 AS oprcode, 0 AS vio1code, 0 AS vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admsecstr FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SECCONTROL AS g_0 ProjectNode(21) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE] ['abc' AS DATAMART_NAME, 'SECCM.VIEWADMMISC' AS "__objecttype__", m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, ' ' AS admtarget, m.admmiscstr AS Commandstr, m.oprcode, m.vio1code AS VIO1CODE, m.vio2code AS VIO2CODE] AccessNode(22) output=[m.evttypecode, m.evtversion, m.evtcatcode, m.evtsysid, m.evtsysplex, m.evtutctod, m.evtsystod, m.evtesmcode, m.evtpuuid, m.evtuserid, m.evtusername, m.evtjobname, m.evtsource, m.admmiscstr, m.oprcode, m.vio1code, m.vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.admmiscstr, g_0.oprcode, g_0.vio1code, g_0.vio2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.ADMMISC AS g_0 ProjectNode(23) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code] ['abc' AS DATAMART_NAME, 'SECCM.VIEWSYSACCESS' AS "__objecttype__", s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram AS admtarget, ' ' AS Commandstr, 0 AS oprcode, s.inf1code AS vio1code, s.inf2code AS vio2code] AccessNode(24) output=[s.evttypecode, s.evtversion, s.evtcatcode, s.evtsysid, s.evtsysplex, s.evtutctod, s.evtsystod, s.evtesmcode, s.evtpuuid, s.evtuserid, s.evtusername, s.evtjobname, s.evtsource, s.usrprogram, s.inf1code, s.inf2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrprogram, g_0.inf1code, g_0.inf2code FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.SYSACCESS AS g_0 AccessNode(25) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSFILE' AS "__objecttype__", f.evttypecode, f.evtversion, f.evtcatcode, f.evtsysid, f.evtsysplex, f.evtutctod, f.evtsystod, f.evtesmcode, f.evtpuuid, f.evtuserid, f.evtusername, f.evtjobname, f.evtsource, f.usrgroup AS admtarget, ' ' AS Commandstr, f.acccode AS oprcode, f.esmrc AS vio1code, f.esmreason AS vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usrgroup, g_0.acccode, g_0.esmrc, g_0.esmreason FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSFILE AS g_0 AccessNode(26) output=['abc' AS DATAMART_NAME, 'SECCM.VIEWUSSUSER' AS "__objecttype__", r.evttypecode, r.evtversion, r.evtcatcode, r.evtsysid, r.evtsysplex, r.evtutctod, r.evtsystod, r.evtesmcode, r.evtpuuid, r.evtuserid, r.evtusername, r.evtjobname, r.evtsource, r.usruser AS admtarget, r.usrgroup AS Commandstr, r.ussfunction AS oprcode, r.esmrc AS vio1code, r.esmreason AS vio2code] SELECT g_0.evttypecode, g_0.evtversion, g_0.evtcatcode, g_0.evtsysid, g_0.evtsysplex, g_0.evtutctod, g_0.evtsystod, g_0.evtesmcode, g_0.evtpuuid, g_0.evtuserid, g_0.evtusername, g_0.evtjobname, g_0.evtsource, g_0.usruser, g_0.usrgroup, g_0.ussfunction, g_0.esmrc, g_0.esmreason FROM SECURITY_DM_DATACOM_DEV_R140_XE59_CMGRD1.USSUSER AS g_0 ============================================================================