USER COMMAND: SELECT u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode FROM ((SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1) AS u LEFT OUTER JOIN SECCM.EVTTYPE AS tp ON tp.evttypecode = u.evttypecode) LEFT OUTER JOIN SECCM.CATEGORY AS ct ON u.evtcatcode = ct.evtcatcode WHERE (u.evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (u.evtutctod <= {ts'2015-06-03 19:20:01.0'}) ORDER BY u.evtsysid LIMIT 8 ---------------------------------------------------------------------------- OPTIMIZE: SELECT u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode FROM ((SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1) AS u LEFT OUTER JOIN SECCM.EVTTYPE AS tp ON tp.evttypecode = u.evttypecode) LEFT OUTER JOIN SECCM.CATEGORY AS ct ON u.evtcatcode = ct.evtcatcode WHERE (u.evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (u.evtutctod <= {ts'2015-06-03 19:20:01.0'}) ORDER BY u.evtsysid LIMIT 8 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode FROM ((SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1) AS u LEFT OUTER JOIN SECCM.EVTTYPE AS tp ON tp.evttypecode = u.evttypecode) LEFT OUTER JOIN SECCM.CATEGORY AS ct ON u.evtcatcode = ct.evtcatcode WHERE (u.evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (u.evtutctod <= {ts'2015-06-03 19:20:01.0'}) ORDER BY u.evtsysid LIMIT 8 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}}) Join(groups=[u, SECCM.EVTTYPE AS tp, SECCM.CATEGORY AS ct], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = ct.evtcatcode]}) Join(groups=[u, SECCM.EVTTYPE AS tp], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[tp.evttypecode = u.evttypecode]}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=SECCM.VIEWOBJ1.evttypecode, u.evtsysid=SECCM.VIEWOBJ1.evtsysid, u.evtutctod=SECCM.VIEWOBJ1.evtutctod, u.evtsystod=SECCM.VIEWOBJ1.evtsystod, u.evtcatcode=SECCM.VIEWOBJ1.evtcatcode}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[SECCM.VIEWOBJ1], props={PROJECT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode]}) Source(groups=[SECCM.VIEWOBJ1], props={NESTED_COMMAND=SELECT convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, convert(rsncode, integer) AS rsncode, convert(prvcode, integer) AS prvcode, polkey, convert(polline, integer) AS polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1) AS t, SYMBOL_MAP={SECCM.VIEWOBJ1.evttypecode=convert(evttypecode, integer), SECCM.VIEWOBJ1.evtversion=convert(evtversion, integer), SECCM.VIEWOBJ1.evtcatcode=convert(evtcatcode, integer), SECCM.VIEWOBJ1.evtsysid=evtsysid, SECCM.VIEWOBJ1.evtsysplex=evtsysplex, SECCM.VIEWOBJ1.evtutctod=evtutctod, SECCM.VIEWOBJ1.evtsystod=evtsystod, SECCM.VIEWOBJ1.evtesmcode=evtesmcode, SECCM.VIEWOBJ1.evtpuuid=evtpuuid, SECCM.VIEWOBJ1.evtuserid=evtuserid, SECCM.VIEWOBJ1.evtusername=evtusername, SECCM.VIEWOBJ1.evtjobname=evtjobname, SECCM.VIEWOBJ1.evtsource=evtsource, SECCM.VIEWOBJ1.admtarget=admtarget, SECCM.VIEWOBJ1.Commandstr=Commandstr, SECCM.VIEWOBJ1.oprcode=convert(oprcode, integer), SECCM.VIEWOBJ1.vio1code=convert(vio1code, integer), SECCM.VIEWOBJ1.vio2code=convert(vio2code, integer), SECCM.VIEWOBJ1.usrfacility=usrfacility, SECCM.VIEWOBJ1.usrseclabel=usrseclabel, SECCM.VIEWOBJ1.objseclabel=objseclabel, SECCM.VIEWOBJ1.objclass=objclass, SECCM.VIEWOBJ1.objvolume=objvolume, SECCM.VIEWOBJ1.objentity=objentity, SECCM.VIEWOBJ1.rsncode=convert(rsncode, integer), SECCM.VIEWOBJ1.prvcode=convert(prvcode, integer), SECCM.VIEWOBJ1.polkey=polkey, SECCM.VIEWOBJ1.polline=convert(polline, integer), SECCM.VIEWOBJ1.poltod=poltod, SECCM.VIEWOBJ1.polacidtype=polacidtype, SECCM.VIEWOBJ1.polacid=polacid, SECCM.VIEWOBJ1.polpermit=polpermit, SECCM.VIEWOBJ1.evttypedesc=evttypedesc, SECCM.VIEWOBJ1.evtcatdesc=evtcatdesc, SECCM.VIEWOBJ1.accdesc=accdesc, SECCM.VIEWOBJ1.prvdesc=prvdesc, SECCM.VIEWOBJ1.rsndesc=rsndesc}}) Project(groups=[t], props={PROJECT_COLS=[convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, convert(rsncode, integer) AS rsncode, convert(prvcode, integer) AS prvcode, polkey, convert(polline, integer) AS polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc]}) Source(groups=[t], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1, SYMBOL_MAP={t.EVTTYPECODE=evttypecode, t.EVTVERSION=evtversion, t.EVTCATCODE=evtcatcode, t.EVTSYSID=evtsysid, t.EVTSYSPLEX=evtsysplex, t.EVTUTCTOD=evtutctod, t.EVTSYSTOD=evtsystod, t.EVTESMCODE=evtesmcode, t.EVTPUUID=evtpuuid, t.EVTUSERID=evtuserid, t.EVTUSERNAME=evtusername, t.EVTJOBNAME=evtjobname, t.EVTSOURCE=evtsource, t.ADMTARGET=admtarget, t.COMMANDSTR=Commandstr, t.OPRCODE=oprcode, t.VIO1CODE=vio1code, t.VIO2CODE=vio2code, t.USRFACILITY=usrfacility, t.USRSECLABEL=usrseclabel, t.OBJSECLABEL=objseclabel, t.OBJCLASS=objclass, t.OBJVOLUME=objvolume, t.OBJENTITY=objentity, t.RSNCODE=rsncode, t.PRVCODE=prvcode, t.POLKEY=polkey, t.POLLINE=polline, t.POLTOD=poltod, t.POLACIDTYPE=polacidtype, t.POLACID=polacid, t.POLPERMIT=polpermit, t.EVTTYPEDESC=evttypedesc, t.EVTCATDESC=evtcatdesc, t.ACCDESC=accdesc, t.PRVDESC=prvdesc, t.RSNDESC=rsndesc}}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc]}) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[SECCM.VIEWADM1], props={PROJECT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode]}) Source(groups=[SECCM.VIEWADM1], props={NESTED_COMMAND=SELECT convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1) AS t, SYMBOL_MAP={SECCM.VIEWADM1.evttypecode=convert(evttypecode, integer), SECCM.VIEWADM1.evtversion=convert(evtversion, integer), SECCM.VIEWADM1.evtcatcode=convert(evtcatcode, integer), SECCM.VIEWADM1.evtsysid=evtsysid, SECCM.VIEWADM1.evtsysplex=evtsysplex, SECCM.VIEWADM1.evtutctod=evtutctod, SECCM.VIEWADM1.evtsystod=evtsystod, SECCM.VIEWADM1.evtesmcode=evtesmcode, SECCM.VIEWADM1.evtpuuid=evtpuuid, SECCM.VIEWADM1.evtuserid=evtuserid, SECCM.VIEWADM1.evtusername=evtusername, SECCM.VIEWADM1.evtjobname=evtjobname, SECCM.VIEWADM1.evtsource=evtsource, SECCM.VIEWADM1.admtarget=admtarget, SECCM.VIEWADM1.reckey=reckey, SECCM.VIEWADM1.Commandstr=Commandstr, SECCM.VIEWADM1.oprcode=convert(oprcode, integer), SECCM.VIEWADM1.vio1code=convert(vio1code, integer), SECCM.VIEWADM1.vio2code=convert(vio2code, integer), SECCM.VIEWADM1.rsnfield=rsnfield, SECCM.VIEWADM1.evttypedesc=evttypedesc, SECCM.VIEWADM1.evtcatdesc=evtcatdesc, SECCM.VIEWADM1.oprdesc=oprdesc}}) Project(groups=[t], props={PROJECT_COLS=[convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc]}) Source(groups=[t], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1, SYMBOL_MAP={t.EVTTYPECODE=evttypecode, t.EVTVERSION=evtversion, t.EVTCATCODE=evtcatcode, t.EVTSYSID=evtsysid, t.EVTSYSPLEX=evtsysplex, t.EVTUTCTOD=evtutctod, t.EVTSYSTOD=evtsystod, t.EVTESMCODE=evtesmcode, t.EVTPUUID=evtpuuid, t.EVTUSERID=evtuserid, t.EVTUSERNAME=evtusername, t.EVTJOBNAME=evtjobname, t.EVTSOURCE=evtsource, t.ADMTARGET=admtarget, t.RECKEY=reckey, t.COMMANDSTR=Commandstr, t.OPRCODE=oprcode, t.VIO1CODE=vio1code, t.VIO2CODE=vio2code, t.RSNFIELD=rsnfield, t.EVTTYPEDESC=evttypedesc, t.EVTCATDESC=evtcatdesc, t.OPRDESC=oprdesc}}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc]}) Source(groups=[DB2DS.VIEWADM1]) Source(groups=[SECCM.EVTTYPE AS tp], props={NESTED_COMMAND=SELECT convert(evttypecode, integer) AS evttypecode, evttypedesc FROM (SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE) AS t, SYMBOL_MAP={tp.evttypecode=convert(evttypecode, integer), tp.evttypedesc=evttypedesc}}) Project(groups=[t], props={PROJECT_COLS=[convert(evttypecode, integer) AS evttypecode, evttypedesc]}) Source(groups=[t], props={NESTED_COMMAND=SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE, SYMBOL_MAP={t.EVTTYPECODE=evttypecode, t.EVTTYPEDESC=evttypedesc}}) Project(groups=[DB2DS.EVTTYPE], props={PROJECT_COLS=[evttypecode, evttypedesc]}) Source(groups=[DB2DS.EVTTYPE]) Source(groups=[SECCM.CATEGORY AS ct], props={NESTED_COMMAND=SELECT convert(evtcatcode, integer) AS evtcatcode, evtcatdesc FROM (SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY) AS t, SYMBOL_MAP={ct.evtcatcode=convert(evtcatcode, integer), ct.evtcatdesc=evtcatdesc}}) Project(groups=[t], props={PROJECT_COLS=[convert(evtcatcode, integer) AS evtcatcode, evtcatdesc]}) Source(groups=[t], props={NESTED_COMMAND=SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY, SYMBOL_MAP={t.EVTCATCODE=evtcatcode, t.EVTCATDESC=evtcatdesc}}) Project(groups=[DB2DS.CATEGORY], props={PROJECT_COLS=[evtcatcode, evtcatdesc]}) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}}) Join(groups=[u, SECCM.EVTTYPE AS tp, SECCM.CATEGORY AS ct], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = ct.evtcatcode]}) Join(groups=[u, SECCM.EVTTYPE AS tp], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[tp.evttypecode = u.evttypecode]}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=SECCM.VIEWOBJ1.evttypecode, u.evtsysid=SECCM.VIEWOBJ1.evtsysid, u.evtutctod=SECCM.VIEWOBJ1.evtutctod, u.evtsystod=SECCM.VIEWOBJ1.evtsystod, u.evtcatcode=SECCM.VIEWOBJ1.evtcatcode}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[SECCM.VIEWOBJ1], props={PROJECT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode]}) Source(groups=[SECCM.VIEWOBJ1], props={NESTED_COMMAND=SELECT convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, convert(rsncode, integer) AS rsncode, convert(prvcode, integer) AS prvcode, polkey, convert(polline, integer) AS polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1) AS t, SYMBOL_MAP={SECCM.VIEWOBJ1.evttypecode=convert(evttypecode, integer), SECCM.VIEWOBJ1.evtversion=convert(evtversion, integer), SECCM.VIEWOBJ1.evtcatcode=convert(evtcatcode, integer), SECCM.VIEWOBJ1.evtsysid=evtsysid, SECCM.VIEWOBJ1.evtsysplex=evtsysplex, SECCM.VIEWOBJ1.evtutctod=evtutctod, SECCM.VIEWOBJ1.evtsystod=evtsystod, SECCM.VIEWOBJ1.evtesmcode=evtesmcode, SECCM.VIEWOBJ1.evtpuuid=evtpuuid, SECCM.VIEWOBJ1.evtuserid=evtuserid, SECCM.VIEWOBJ1.evtusername=evtusername, SECCM.VIEWOBJ1.evtjobname=evtjobname, SECCM.VIEWOBJ1.evtsource=evtsource, SECCM.VIEWOBJ1.admtarget=admtarget, SECCM.VIEWOBJ1.Commandstr=Commandstr, SECCM.VIEWOBJ1.oprcode=convert(oprcode, integer), SECCM.VIEWOBJ1.vio1code=convert(vio1code, integer), SECCM.VIEWOBJ1.vio2code=convert(vio2code, integer), SECCM.VIEWOBJ1.usrfacility=usrfacility, SECCM.VIEWOBJ1.usrseclabel=usrseclabel, SECCM.VIEWOBJ1.objseclabel=objseclabel, SECCM.VIEWOBJ1.objclass=objclass, SECCM.VIEWOBJ1.objvolume=objvolume, SECCM.VIEWOBJ1.objentity=objentity, SECCM.VIEWOBJ1.rsncode=convert(rsncode, integer), SECCM.VIEWOBJ1.prvcode=convert(prvcode, integer), SECCM.VIEWOBJ1.polkey=polkey, SECCM.VIEWOBJ1.polline=convert(polline, integer), SECCM.VIEWOBJ1.poltod=poltod, SECCM.VIEWOBJ1.polacidtype=polacidtype, SECCM.VIEWOBJ1.polacid=polacid, SECCM.VIEWOBJ1.polpermit=polpermit, SECCM.VIEWOBJ1.evttypedesc=evttypedesc, SECCM.VIEWOBJ1.evtcatdesc=evtcatdesc, SECCM.VIEWOBJ1.accdesc=accdesc, SECCM.VIEWOBJ1.prvdesc=prvdesc, SECCM.VIEWOBJ1.rsndesc=rsndesc}}) Project(groups=[t], props={PROJECT_COLS=[convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, convert(rsncode, integer) AS rsncode, convert(prvcode, integer) AS prvcode, polkey, convert(polline, integer) AS polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc]}) Source(groups=[t], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1, SYMBOL_MAP={t.EVTTYPECODE=evttypecode, t.EVTVERSION=evtversion, t.EVTCATCODE=evtcatcode, t.EVTSYSID=evtsysid, t.EVTSYSPLEX=evtsysplex, t.EVTUTCTOD=evtutctod, t.EVTSYSTOD=evtsystod, t.EVTESMCODE=evtesmcode, t.EVTPUUID=evtpuuid, t.EVTUSERID=evtuserid, t.EVTUSERNAME=evtusername, t.EVTJOBNAME=evtjobname, t.EVTSOURCE=evtsource, t.ADMTARGET=admtarget, t.COMMANDSTR=Commandstr, t.OPRCODE=oprcode, t.VIO1CODE=vio1code, t.VIO2CODE=vio2code, t.USRFACILITY=usrfacility, t.USRSECLABEL=usrseclabel, t.OBJSECLABEL=objseclabel, t.OBJCLASS=objclass, t.OBJVOLUME=objvolume, t.OBJENTITY=objentity, t.RSNCODE=rsncode, t.PRVCODE=prvcode, t.POLKEY=polkey, t.POLLINE=polline, t.POLTOD=poltod, t.POLACIDTYPE=polacidtype, t.POLACID=polacid, t.POLPERMIT=polpermit, t.EVTTYPEDESC=evttypedesc, t.EVTCATDESC=evtcatdesc, t.ACCDESC=accdesc, t.PRVDESC=prvdesc, t.RSNDESC=rsndesc}}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc]}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000}) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[SECCM.VIEWADM1], props={PROJECT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode]}) Source(groups=[SECCM.VIEWADM1], props={NESTED_COMMAND=SELECT convert(t__1.EVTTYPECODE, integer) AS evttypecode, convert(t__1.EVTVERSION, integer) AS evtversion, convert(t__1.EVTCATCODE, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, convert(t__1.OPRCODE, integer) AS oprcode, convert(t__1.VIO1CODE, integer) AS vio1code, convert(t__1.VIO2CODE, integer) AS vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1) AS t, SYMBOL_MAP={SECCM.VIEWADM1.evttypecode=convert(t__1.EVTTYPECODE, integer), SECCM.VIEWADM1.evtversion=convert(t__1.EVTVERSION, integer), SECCM.VIEWADM1.evtcatcode=convert(t__1.EVTCATCODE, integer), SECCM.VIEWADM1.evtsysid=t__1.EVTSYSID, SECCM.VIEWADM1.evtsysplex=t__1.EVTSYSPLEX, SECCM.VIEWADM1.evtutctod=t__1.EVTUTCTOD, SECCM.VIEWADM1.evtsystod=t__1.EVTSYSTOD, SECCM.VIEWADM1.evtesmcode=t__1.EVTESMCODE, SECCM.VIEWADM1.evtpuuid=t__1.EVTPUUID, SECCM.VIEWADM1.evtuserid=t__1.EVTUSERID, SECCM.VIEWADM1.evtusername=t__1.EVTUSERNAME, SECCM.VIEWADM1.evtjobname=t__1.EVTJOBNAME, SECCM.VIEWADM1.evtsource=t__1.EVTSOURCE, SECCM.VIEWADM1.admtarget=t__1.ADMTARGET, SECCM.VIEWADM1.reckey=t__1.RECKEY, SECCM.VIEWADM1.Commandstr=t__1.COMMANDSTR, SECCM.VIEWADM1.oprcode=convert(t__1.OPRCODE, integer), SECCM.VIEWADM1.vio1code=convert(t__1.VIO1CODE, integer), SECCM.VIEWADM1.vio2code=convert(t__1.VIO2CODE, integer), SECCM.VIEWADM1.rsnfield=t__1.RSNFIELD, SECCM.VIEWADM1.evttypedesc=t__1.EVTTYPEDESC, SECCM.VIEWADM1.evtcatdesc=t__1.EVTCATDESC, SECCM.VIEWADM1.oprdesc=t__1.OPRDESC}}) Project(groups=[t AS t__1], props={PROJECT_COLS=[convert(t__1.EVTTYPECODE, integer) AS evttypecode, convert(t__1.EVTVERSION, integer) AS evtversion, convert(t__1.EVTCATCODE, integer) AS evtcatcode, t__1.EVTSYSID, t__1.EVTSYSPLEX, t__1.EVTUTCTOD, t__1.EVTSYSTOD, t__1.EVTESMCODE, t__1.EVTPUUID, t__1.EVTUSERID, t__1.EVTUSERNAME, t__1.EVTJOBNAME, t__1.EVTSOURCE, t__1.ADMTARGET, t__1.RECKEY, t__1.COMMANDSTR, convert(t__1.OPRCODE, integer) AS oprcode, convert(t__1.VIO1CODE, integer) AS vio1code, convert(t__1.VIO2CODE, integer) AS vio2code, t__1.RSNFIELD, t__1.EVTTYPEDESC, t__1.EVTCATDESC, t__1.OPRDESC]}) Source(groups=[t AS t__1], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1, SYMBOL_MAP={t__1.EVTTYPECODE=evttypecode, t__1.EVTVERSION=evtversion, t__1.EVTCATCODE=evtcatcode, t__1.EVTSYSID=evtsysid, t__1.EVTSYSPLEX=evtsysplex, t__1.EVTUTCTOD=evtutctod, t__1.EVTSYSTOD=evtsystod, t__1.EVTESMCODE=evtesmcode, t__1.EVTPUUID=evtpuuid, t__1.EVTUSERID=evtuserid, t__1.EVTUSERNAME=evtusername, t__1.EVTJOBNAME=evtjobname, t__1.EVTSOURCE=evtsource, t__1.ADMTARGET=admtarget, t__1.RECKEY=reckey, t__1.COMMANDSTR=Commandstr, t__1.OPRCODE=oprcode, t__1.VIO1CODE=vio1code, t__1.VIO2CODE=vio2code, t__1.RSNFIELD=rsnfield, t__1.EVTTYPEDESC=evttypedesc, t__1.EVTCATDESC=evtcatdesc, t__1.OPRDESC=oprdesc}}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc]}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000}) Source(groups=[DB2DS.VIEWADM1]) Source(groups=[SECCM.EVTTYPE AS tp], props={NESTED_COMMAND=SELECT convert(t__2.EVTTYPECODE, integer) AS evttypecode, evttypedesc FROM (SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE) AS t, SYMBOL_MAP={tp.evttypecode=convert(t__2.EVTTYPECODE, integer), tp.evttypedesc=t__2.EVTTYPEDESC}}) Project(groups=[t AS t__2], props={PROJECT_COLS=[convert(t__2.EVTTYPECODE, integer) AS evttypecode, t__2.EVTTYPEDESC]}) Source(groups=[t AS t__2], props={NESTED_COMMAND=SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE, SYMBOL_MAP={t__2.EVTTYPECODE=evttypecode, t__2.EVTTYPEDESC=evttypedesc}}) Project(groups=[DB2DS.EVTTYPE], props={PROJECT_COLS=[evttypecode, evttypedesc]}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000}) Source(groups=[DB2DS.EVTTYPE]) Source(groups=[SECCM.CATEGORY AS ct], props={NESTED_COMMAND=SELECT convert(t__3.EVTCATCODE, integer) AS evtcatcode, evtcatdesc FROM (SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY) AS t, SYMBOL_MAP={ct.evtcatcode=convert(t__3.EVTCATCODE, integer), ct.evtcatdesc=t__3.EVTCATDESC}}) Project(groups=[t AS t__3], props={PROJECT_COLS=[convert(t__3.EVTCATCODE, integer) AS evtcatcode, t__3.EVTCATDESC]}) Source(groups=[t AS t__3], props={NESTED_COMMAND=SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY, SYMBOL_MAP={t__3.EVTCATCODE=evtcatcode, t__3.EVTCATDESC=evtcatdesc}}) Project(groups=[DB2DS.CATEGORY], props={PROJECT_COLS=[evtcatcode, evtcatdesc]}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000}) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], UNRELATED_SORT=false}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}, OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, SECCM.EVTTYPE AS tp, SECCM.CATEGORY AS ct], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = ct.evtcatcode], OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, SECCM.EVTTYPE AS tp], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[tp.evttypecode = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod]}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=SECCM.VIEWOBJ1.evttypecode, u.evtcatcode=SECCM.VIEWOBJ1.evtcatcode, u.evtutctod=SECCM.VIEWOBJ1.evtutctod, u.evtsysid=SECCM.VIEWOBJ1.evtsysid, u.evtsystod=SECCM.VIEWOBJ1.evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtutctod, u.evtsysid, u.evtsystod]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod]}) Project(groups=[SECCM.VIEWOBJ1], props={PROJECT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod], OUTPUT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod]}) Source(groups=[SECCM.VIEWOBJ1], props={NESTED_COMMAND=SELECT convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, convert(rsncode, integer) AS rsncode, convert(prvcode, integer) AS prvcode, polkey, convert(polline, integer) AS polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1) AS t, SYMBOL_MAP={SECCM.VIEWOBJ1.evttypecode=convert(evttypecode, integer), SECCM.VIEWOBJ1.evtcatcode=convert(evtcatcode, integer), SECCM.VIEWOBJ1.evtutctod=evtutctod, SECCM.VIEWOBJ1.evtsysid=evtsysid, SECCM.VIEWOBJ1.evtsystod=evtsystod}, OUTPUT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod]}) Project(groups=[t], props={PROJECT_COLS=[convert(evttypecode, integer) AS evttypecode, convert(evtcatcode, integer) AS evtcatcode, evtutctod, evtsysid, evtsystod], OUTPUT_COLS=[convert(evttypecode, integer) AS evttypecode, convert(evtcatcode, integer) AS evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[t], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1, SYMBOL_MAP={t.EVTTYPECODE=evttypecode, t.EVTCATCODE=evtcatcode, t.EVTUTCTOD=evtutctod, t.EVTSYSID=evtsysid, t.EVTSYSTOD=evtsystod}, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod], OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Project(groups=[SECCM.VIEWADM1], props={PROJECT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtcatcode, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtsystod], OUTPUT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtcatcode, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtsystod]}) Source(groups=[SECCM.VIEWADM1], props={NESTED_COMMAND=SELECT convert(t__1.EVTTYPECODE, integer) AS evttypecode, convert(t__1.EVTVERSION, integer) AS evtversion, convert(t__1.EVTCATCODE, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, convert(t__1.OPRCODE, integer) AS oprcode, convert(t__1.VIO1CODE, integer) AS vio1code, convert(t__1.VIO2CODE, integer) AS vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1) AS t, SYMBOL_MAP={SECCM.VIEWADM1.evttypecode=convert(t__1.EVTTYPECODE, integer), SECCM.VIEWADM1.evtcatcode=convert(t__1.EVTCATCODE, integer), SECCM.VIEWADM1.evtutctod=t__1.EVTUTCTOD, SECCM.VIEWADM1.evtsysid=t__1.EVTSYSID, SECCM.VIEWADM1.evtsystod=t__1.EVTSYSTOD}, OUTPUT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtcatcode, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtsystod]}) Project(groups=[t AS t__1], props={PROJECT_COLS=[convert(t__1.EVTTYPECODE, integer) AS evttypecode, convert(t__1.EVTCATCODE, integer) AS evtcatcode, t__1.EVTUTCTOD, t__1.EVTSYSID, t__1.EVTSYSTOD], OUTPUT_COLS=[convert(t__1.EVTTYPECODE, integer) AS evttypecode, convert(t__1.EVTCATCODE, integer) AS evtcatcode, t__1.EVTUTCTOD, t__1.EVTSYSID, t__1.EVTSYSTOD]}) Source(groups=[t AS t__1], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1, SYMBOL_MAP={t__1.EVTTYPECODE=evttypecode, t__1.EVTCATCODE=evtcatcode, t__1.EVTUTCTOD=evtutctod, t__1.EVTSYSID=evtsysid, t__1.EVTSYSTOD=evtsystod}, OUTPUT_COLS=[t__1.EVTTYPECODE, t__1.EVTCATCODE, t__1.EVTUTCTOD, t__1.EVTSYSID, t__1.EVTSYSTOD]}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod], OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[SECCM.EVTTYPE AS tp], props={NESTED_COMMAND=SELECT convert(t__2.EVTTYPECODE, integer) AS evttypecode, evttypedesc FROM (SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE) AS t, SYMBOL_MAP={tp.evttypecode=convert(t__2.EVTTYPECODE, integer)}, OUTPUT_COLS=[tp.evttypecode]}) Project(groups=[t AS t__2], props={PROJECT_COLS=[convert(t__2.EVTTYPECODE, integer) AS evttypecode], OUTPUT_COLS=[convert(t__2.EVTTYPECODE, integer) AS evttypecode]}) Source(groups=[t AS t__2], props={NESTED_COMMAND=SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE, SYMBOL_MAP={t__2.EVTTYPECODE=evttypecode}, OUTPUT_COLS=[t__2.EVTTYPECODE]}) Project(groups=[DB2DS.EVTTYPE], props={PROJECT_COLS=[evttypecode], OUTPUT_COLS=[evttypecode]}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode]}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=[evttypecode]}) Source(groups=[SECCM.CATEGORY AS ct], props={NESTED_COMMAND=SELECT convert(t__3.EVTCATCODE, integer) AS evtcatcode, evtcatdesc FROM (SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY) AS t, SYMBOL_MAP={ct.evtcatcode=convert(t__3.EVTCATCODE, integer)}, OUTPUT_COLS=[ct.evtcatcode]}) Project(groups=[t AS t__3], props={PROJECT_COLS=[convert(t__3.EVTCATCODE, integer) AS evtcatcode], OUTPUT_COLS=[convert(t__3.EVTCATCODE, integer) AS evtcatcode]}) Source(groups=[t AS t__3], props={NESTED_COMMAND=SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY, SYMBOL_MAP={t__3.EVTCATCODE=evtcatcode}, OUTPUT_COLS=[t__3.EVTCATCODE]}) Project(groups=[DB2DS.CATEGORY], props={PROJECT_COLS=[evtcatcode], OUTPUT_COLS=[evtcatcode]}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode]}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=[evtcatcode]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u]) Join(groups=[u, SECCM.EVTTYPE AS tp, SECCM.CATEGORY AS ct], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = ct.evtcatcode], OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, SECCM.EVTTYPE AS tp], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[tp.evttypecode = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod]}) Source(groups=[u]) SetOperation(groups=[]) Project(groups=[SECCM.VIEWOBJ1]) Source(groups=[SECCM.VIEWOBJ1], props={NESTED_COMMAND=SELECT convert(evttypecode, integer) AS evttypecode, convert(evtversion, integer) AS evtversion, convert(evtcatcode, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, convert(oprcode, integer) AS oprcode, convert(vio1code, integer) AS vio1code, convert(vio2code, integer) AS vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, convert(rsncode, integer) AS rsncode, convert(prvcode, integer) AS prvcode, polkey, convert(polline, integer) AS polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1) AS t, SYMBOL_MAP={SECCM.VIEWOBJ1.evttypecode=convert(evttypecode, integer), SECCM.VIEWOBJ1.evtcatcode=convert(evtcatcode, integer), SECCM.VIEWOBJ1.evtutctod=evtutctod, SECCM.VIEWOBJ1.evtsysid=evtsysid, SECCM.VIEWOBJ1.evtsystod=evtsystod}, OUTPUT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod]}) Project(groups=[t]) Source(groups=[t], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, Commandstr, oprcode, vio1code, vio2code, usrfacility, usrseclabel, objseclabel, objclass, objvolume, objentity, rsncode, prvcode, polkey, polline, poltod, polacidtype, polacid, polpermit, evttypedesc, evtcatdesc, accdesc, prvdesc, rsndesc FROM DB2DS.VIEWOBJ1, SYMBOL_MAP={t.EVTTYPECODE=evttypecode, t.EVTCATCODE=evtcatcode, t.EVTUTCTOD=evtutctod, t.EVTSYSID=evtsysid, t.EVTSYSTOD=evtsystod}, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Project(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[SECCM.VIEWADM1]) Source(groups=[SECCM.VIEWADM1], props={NESTED_COMMAND=SELECT convert(t__1.EVTTYPECODE, integer) AS evttypecode, convert(t__1.EVTVERSION, integer) AS evtversion, convert(t__1.EVTCATCODE, integer) AS evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, convert(t__1.OPRCODE, integer) AS oprcode, convert(t__1.VIO1CODE, integer) AS vio1code, convert(t__1.VIO2CODE, integer) AS vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM (SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1) AS t, SYMBOL_MAP={SECCM.VIEWADM1.evttypecode=convert(t__1.EVTTYPECODE, integer), SECCM.VIEWADM1.evtcatcode=convert(t__1.EVTCATCODE, integer), SECCM.VIEWADM1.evtutctod=t__1.EVTUTCTOD, SECCM.VIEWADM1.evtsysid=t__1.EVTSYSID, SECCM.VIEWADM1.evtsystod=t__1.EVTSYSTOD}, OUTPUT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtcatcode, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtsystod]}) Project(groups=[t AS t__1]) Source(groups=[t AS t__1], props={NESTED_COMMAND=SELECT evttypecode, evtversion, evtcatcode, evtsysid, evtsysplex, evtutctod, evtsystod, evtesmcode, evtpuuid, evtuserid, evtusername, evtjobname, evtsource, admtarget, reckey, Commandstr, oprcode, vio1code, vio2code, rsnfield, evttypedesc, evtcatdesc, oprdesc FROM DB2DS.VIEWADM1, SYMBOL_MAP={t__1.EVTTYPECODE=evttypecode, t__1.EVTCATCODE=evtcatcode, t__1.EVTUTCTOD=evtutctod, t__1.EVTSYSID=evtsysid, t__1.EVTSYSTOD=evtsystod}, OUTPUT_COLS=[t__1.EVTTYPECODE, t__1.EVTCATCODE, t__1.EVTUTCTOD, t__1.EVTSYSID, t__1.EVTSYSTOD]}) Project(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[DB2DS.VIEWADM1]) Source(groups=[SECCM.EVTTYPE AS tp]) Project(groups=[t AS t__2]) Source(groups=[t AS t__2], props={NESTED_COMMAND=SELECT evttypecode, evttypedesc FROM DB2DS.EVTTYPE, SYMBOL_MAP={t__2.EVTTYPECODE=evttypecode}, OUTPUT_COLS=[t__2.EVTTYPECODE]}) Project(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode]}) Source(groups=[DB2DS.EVTTYPE]) Source(groups=[SECCM.CATEGORY AS ct]) Project(groups=[t AS t__3]) Source(groups=[t AS t__3], props={NESTED_COMMAND=SELECT evtcatcode, evtcatdesc FROM DB2DS.CATEGORY, SYMBOL_MAP={t__3.EVTCATCODE=evtcatcode}, OUTPUT_COLS=[t__3.EVTCATCODE]}) Project(groups=[DB2DS.CATEGORY]) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode]}) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], UNRELATED_SORT=false}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}, OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod]}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtutctod, u.evtsysid, u.evtsystod]}) SetOperation(groups=[]) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod]}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtcatcode, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtsystod]}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode]}) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode]}) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING DecomposeJoin AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Select(groups=[u]) Select(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod]}) Source(groups=[u]) SetOperation(groups=[]) Project(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod]}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], IS_PHANTOM=true}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}, OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode], IS_PHANTOM=true}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtutctod, u.evtsysid, u.evtsystod]}) SetOperation(groups=[]) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=[SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtcatcode, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtsystod]}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'})}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=[SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtcatcode, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtsystod]}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'})}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=[evttypecode, evtcatcode, evtutctod, evtsysid, evtsystod]}) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], UNRELATED_SORT=false}) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY]) Join(groups=[u, DB2DS.EVTTYPE]) Select(groups=[u]) Select(groups=[u]) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtutctod, u.evtsysid, u.evtsystod]}) SetOperation(groups=[]) Project(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evtutctod, u.evttypecode, u.evtsysid, u.evtsystod]}) Select(groups=[u]) Select(groups=[u]) Source(groups=[u]) SetOperation(groups=[]) Project(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=null}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=null}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}, OUTPUT_COLS=null, IS_PHANTOM=true}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}, OUTPUT_COLS=null, IS_PHANTOM=true}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=null}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=null}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanUnions AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY]) Join(groups=[u, DB2DS.EVTTYPE]) Select(groups=[u]) Select(groups=[u]) Source(groups=[u]) SetOperation(groups=[]) Project(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null}) Select(groups=[u]) Select(groups=[u]) Source(groups=[u]) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null}) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null}) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING CopyCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod <= {ts'2015-06-03 19:20:01.0'}, OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true}) Select(groups=[u], props={SELECT_CRITERIA=u.evtutctod >= {ts'2015-06-03 19:20:00.8'}, OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true}) Source(groups=[u]) SetOperation(groups=[]) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=null}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=null}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=null}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=null}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=null}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[u]) SetOperation(groups=[]) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY]) Join(groups=[u, DB2DS.EVTTYPE]) Source(groups=[u]) SetOperation(groups=[]) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[u]) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null}) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[u.evtcatcode], RIGHT_EXPRESSIONS=[convert(evtcatcode, integer)], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[]}) Source(groups=[u]) SetOperation(groups=[]) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING ChooseDependent LOW Relational Planner node is on outer side of the join - Rejecting dependent join Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}} LOW Relational Planner node is on outer side of the join - Rejecting dependent join Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=null, u.evtsysid=null, u.evtutctod=null, u.evtsystod=null, ...}} AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[u.evtcatcode], RIGHT_EXPRESSIONS=[convert(evtcatcode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=null, IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtutctod=evtutctod, u.evtsysid=evtsysid, u.evtsystod=evtsystod}, OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=null, u.evtsysid=null, u.evtutctod=null, u.evtsystod=null, ...}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=null, EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtutctod AS evtutctod, evtsysid AS evtsysid, evtsystod AS evtsystod], OUTPUT_COLS=null, EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=null, EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null, EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=null, EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=null, EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=null, EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) ============================================================================ EXECUTING PushLimit AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=null}) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY]) Join(groups=[u, DB2DS.EVTTYPE]) Source(groups=[u]) SetOperation(groups=[]) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], UNRELATED_SORT=false}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode]}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evtcatcode], RIGHT_EXPRESSIONS=[convert(evtcatcode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtsysid=evtsysid, u.evtutctod=evtutctod, u.evtsystod=evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtsysid, u.evtutctod, u.evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=null, u.evtsysid=null, u.evtutctod=null, u.evtsystod=null, ...}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=[evttypecode, evtcatcode, evtsysid, evtutctod, evtsystod], IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=[evtutctod, evttypecode, evtcatcode, evtsysid, evtsystod], EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=[evttypecode, evtcatcode, evtsysid, evtutctod, evtsystod], IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=[evtutctod, evttypecode, evtcatcode, evtsysid, evtsystod], EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=[evttypecode], EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=[evtcatcode], EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) ============================================================================ EXECUTING CalculateCost AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], UNRELATED_SORT=false, EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evtcatcode], RIGHT_EXPRESSIONS=[convert(evtcatcode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtsysid=evtsysid, u.evtutctod=evtutctod, u.evtsystod=evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtsysid, u.evtutctod, u.evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=null, u.evtsysid=null, u.evtutctod=null, u.evtsystod=null, ...}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=[evttypecode, evtcatcode, evtsysid, evtutctod, evtsystod], IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=[evtutctod, evttypecode, evtcatcode, evtsysid, evtsystod], EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=[evttypecode, evtcatcode, evtsysid, evtutctod, evtsystod], IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=[evtutctod, evttypecode, evtcatcode, evtsysid, evtsystod], EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=[evttypecode], EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=[evtcatcode], EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evtcatcode], RIGHT_EXPRESSIONS=[convert(evtcatcode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}, SORT_LEFT=SORT}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}, SORT_LEFT=SORT}) Source(groups=[u], props={NESTED_COMMAND=SELECT SECCM.VIEWOBJ1.evttypecode, SECCM.VIEWOBJ1.evtsysid, SECCM.VIEWOBJ1.evtutctod, SECCM.VIEWOBJ1.evtsystod, SECCM.VIEWOBJ1.evtcatcode FROM SECCM.VIEWOBJ1 UNION ALL SELECT SECCM.VIEWADM1.evttypecode, SECCM.VIEWADM1.evtsysid, SECCM.VIEWADM1.evtutctod, SECCM.VIEWADM1.evtsystod, SECCM.VIEWADM1.evtcatcode FROM SECCM.VIEWADM1, SYMBOL_MAP={u.evttypecode=convert(evttypecode, integer), u.evtcatcode=convert(evtcatcode, integer), u.evtsysid=evtsysid, u.evtutctod=evtutctod, u.evtsystod=evtsystod}, OUTPUT_COLS=[u.evttypecode, u.evtcatcode, u.evtsysid, u.evtutctod, u.evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=null, u.evtsysid=null, u.evtutctod=null, u.evtsystod=null, ...}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWOBJ1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWOBJ1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=[evttypecode, evtcatcode, evtsysid, evtutctod, evtsystod], IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWOBJ1], props={OUTPUT_COLS=[evtutctod, evttypecode, evtcatcode, evtsysid, evtsystod], EST_COL_STATS={DB2DS.VIEWOBJ1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWOBJ1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Project(groups=[DB2DS.VIEWADM1], props={PROJECT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Select(groups=[DB2DS.VIEWADM1], props={SELECT_CRITERIA=(evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'}), OUTPUT_COLS=[evttypecode, evtcatcode, evtsysid, evtutctod, evtsystod], IS_COPIED=true, EST_CARDINALITY=NaN, EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}}) Source(groups=[DB2DS.VIEWADM1], props={OUTPUT_COLS=[evtutctod, evttypecode, evtcatcode, evtsysid, evtsystod], EST_COL_STATS={DB2DS.VIEWADM1.EVTTYPECODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTVERSION=[-1.0, -1.0], DB2DS.VIEWADM1.EVTCATCODE=[-1.0, -1.0], DB2DS.VIEWADM1.EVTSYSID=[-1.0, -1.0], ...}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, convert(evttypecode, integer)], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}}) Sort(groups=[], props={SORT_ORDER=ORDER BY convert(evttypecode, integer), OUTPUT_COLS=[evttypecode, convert(evttypecode, integer)]}) Source(groups=[DB2DS.EVTTYPE], props={OUTPUT_COLS=[evttypecode], EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode, convert(evtcatcode, integer)], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}}) Sort(groups=[], props={SORT_ORDER=ORDER BY convert(evtcatcode, integer), OUTPUT_COLS=[evtcatcode, convert(evtcatcode, integer)]}) Source(groups=[DB2DS.CATEGORY], props={OUTPUT_COLS=[evtcatcode], EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}, EST_CARDINALITY=0.0}) ============================================================================ EXECUTING MergeCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[u]) Project(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY]) Join(groups=[u, DB2DS.EVTTYPE]) Source(groups=[u]) SetOperation(groups=[]) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Sort(groups=[]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Sort(groups=[]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[u], props={PROJECT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=8, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Sort(groups=[u], props={SORT_ORDER=ORDER BY u.evtsysid, OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], UNRELATED_SORT=false, EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}}) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[u.evtcatcode = convert(evtcatcode, integer)], OUTPUT_COLS=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evtcatcode], RIGHT_EXPRESSIONS=[convert(evtcatcode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}, SORT_LEFT=SORT}) Join(groups=[u, DB2DS.EVTTYPE], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[convert(evttypecode, integer) = u.evttypecode], OUTPUT_COLS=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod], IS_COPIED=true, LEFT_EXPRESSIONS=[u.evttypecode], RIGHT_EXPRESSIONS=[convert(evttypecode, integer)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=NaN, EST_COL_STATS={u.evttypecode=[NaN, -1.0], u.evtsysid=[NaN, -1.0], u.evtutctod=[NaN, -1.0], u.evtsystod=[NaN, -1.0], ...}, SORT_LEFT=SORT}) Source(groups=[u]) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Access(groups=[DB2DS.VIEWOBJ1]) Project(groups=[DB2DS.VIEWOBJ1]) Select(groups=[DB2DS.VIEWOBJ1]) Source(groups=[DB2DS.VIEWOBJ1]) Access(groups=[DB2DS.VIEWADM1]) Project(groups=[DB2DS.VIEWADM1]) Select(groups=[DB2DS.VIEWADM1]) Source(groups=[DB2DS.VIEWADM1]) Access(groups=[DB2DS.EVTTYPE]) Sort(groups=[]) Source(groups=[DB2DS.EVTTYPE]) Access(groups=[DB2DS.CATEGORY]) Sort(groups=[]) Source(groups=[DB2DS.CATEGORY]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[u]) TupleLimit(groups=[]) Sort(groups=[u]) Join(groups=[u, DB2DS.EVTTYPE, DB2DS.CATEGORY]) Join(groups=[u, DB2DS.EVTTYPE]) Source(groups=[u]) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}}) Access(groups=[DB2DS.VIEWOBJ1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod FROM DB2DS.VIEWOBJ1 WHERE (evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'})}) Access(groups=[DB2DS.VIEWADM1], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod], EST_CARDINALITY=NaN, EST_COL_STATS={convert(evttypecode, integer)=[-1.0, -1.0], convert(evtcatcode, integer)=[-1.0, -1.0], evtutctod AS evtutctod=[-1.0, -1.0], evtsysid AS evtsysid=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod FROM DB2DS.VIEWADM1 WHERE (evtutctod >= {ts'2015-06-03 19:20:00.8'}) AND (evtutctod <= {ts'2015-06-03 19:20:01.0'})}) Access(groups=[DB2DS.EVTTYPE], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evttypecode, convert(evttypecode, integer)], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.EVTTYPE.EVTTYPECODE=[-1.0, -1.0], DB2DS.EVTTYPE.EVTTYPEDESC=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT evttypecode, convert(evttypecode, integer) FROM DB2DS.EVTTYPE ORDER BY convert(evttypecode, integer)}) Access(groups=[DB2DS.CATEGORY], props={SOURCE_HINT=null, MODEL_ID=Schema name=DB2DS, nameInSource=null, uuid=tid:f891633b302a-bae11a85-00000000, OUTPUT_COLS=[evtcatcode, convert(evtcatcode, integer)], EST_CARDINALITY=0.0, EST_COL_STATS={DB2DS.CATEGORY.EVTCATCODE=[-1.0, -1.0], DB2DS.CATEGORY.EVTCATDESC=[-1.0, -1.0]}, ATOMIC_REQUEST=SELECT evtcatcode, convert(evtcatcode, integer) FROM DB2DS.CATEGORY ORDER BY convert(evtcatcode, integer)}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(0) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] [u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] LimitNode(1) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] limit 8 SortNode(2) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] [SORT] [u.evtsysid] JoinNode(3) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.evtcatcode=convert(evtcatcode, integer)] output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] JoinNode(4) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.evttypecode=convert(evttypecode, integer)] output=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod] UnionAllNode(5) output=[u.evttypecode, u.evtcatcode, u.evtsysid, u.evtutctod, u.evtsystod] AccessNode(6) output=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod] SELECT convert(g_0.EVTTYPECODE, integer), convert(g_0.EVTCATCODE, integer), g_0.EVTSYSID, g_0.EVTUTCTOD, g_0.EVTSYSTOD FROM DB2DS.VIEWOBJ1 AS g_0 WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) AccessNode(7) output=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod] SELECT convert(g_0.EVTTYPECODE, integer), convert(g_0.EVTCATCODE, integer), g_0.EVTSYSID, g_0.EVTUTCTOD, g_0.EVTSYSTOD FROM DB2DS.VIEWADM1 AS g_0 WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) AccessNode(8) output=[evttypecode, convert(evttypecode, integer)] SELECT g_0.EVTTYPECODE AS c_0, convert(g_0.EVTTYPECODE, integer) AS c_1 FROM DB2DS.EVTTYPE AS g_0 ORDER BY c_1 AccessNode(9) output=[evtcatcode, convert(evtcatcode, integer)] SELECT g_0.EVTCATCODE AS c_0, convert(g_0.EVTCATCODE, integer) AS c_1 FROM DB2DS.CATEGORY AS g_0 ORDER BY c_1 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(0) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] [u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] LimitNode(1) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] limit 8 SortNode(2) output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] [SORT] [u.evtsysid] JoinNode(3) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.evtcatcode=convert(evtcatcode, integer)] output=[u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod, u.evtcatcode] JoinNode(4) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[u.evttypecode=convert(evttypecode, integer)] output=[u.evtcatcode, u.evttypecode, u.evtsysid, u.evtutctod, u.evtsystod] UnionAllNode(5) output=[u.evttypecode, u.evtcatcode, u.evtsysid, u.evtutctod, u.evtsystod] AccessNode(6) output=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod] SELECT convert(g_0.EVTTYPECODE, integer), convert(g_0.EVTCATCODE, integer), g_0.EVTSYSID, g_0.EVTUTCTOD, g_0.EVTSYSTOD FROM DB2DS.VIEWOBJ1 AS g_0 WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) AccessNode(7) output=[convert(evttypecode, integer), convert(evtcatcode, integer), evtsysid AS evtsysid, evtutctod AS evtutctod, evtsystod AS evtsystod] SELECT convert(g_0.EVTTYPECODE, integer), convert(g_0.EVTCATCODE, integer), g_0.EVTSYSID, g_0.EVTUTCTOD, g_0.EVTSYSTOD FROM DB2DS.VIEWADM1 AS g_0 WHERE (g_0.EVTUTCTOD >= {ts'2015-06-03 19:20:00.8'}) AND (g_0.EVTUTCTOD <= {ts'2015-06-03 19:20:01.0'}) AccessNode(8) output=[evttypecode, convert(evttypecode, integer)] SELECT g_0.EVTTYPECODE AS c_0, convert(g_0.EVTTYPECODE, integer) AS c_1 FROM DB2DS.EVTTYPE AS g_0 ORDER BY c_1 AccessNode(9) output=[evtcatcode, convert(evtcatcode, integer)] SELECT g_0.EVTCATCODE AS c_0, convert(g_0.EVTCATCODE, integer) AS c_1 FROM DB2DS.CATEGORY AS g_0 ORDER BY c_1 ============================================================================