============================================================================ USER COMMAND: SELECT B.RESCLASS, COUNT(*) AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__" FROM SECURITY.BASERULE AS B GROUP BY B.RESCLASS ORDER BY B.RESCLASS DESC LIMIT 22 ---------------------------------------------------------------------------- OPTIMIZE: SELECT B.RESCLASS, COUNT(*) AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__" FROM SECURITY.BASERULE AS B GROUP BY B.RESCLASS ORDER BY B.RESCLASS DESC LIMIT 22 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT B.RESCLASS, COUNT(*) AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__" FROM SECURITY.BASERULE AS B GROUP BY B.RESCLASS ORDER BY B.RESCLASS DESC LIMIT 22 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY resclass DESC}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Group(groups=[SECURITY.BASERULE AS B, anon_grp0], props={GROUP_COLS=[B.RESCLASS], SYMBOL_MAP={anon_grp0.gcol0=B.RESCLASS, anon_grp0.agg0=COUNT(*)}}) Source(groups=[SECURITY.BASERULE AS B], props={NESTED_COMMAND=SELECT sysid, resclass, rulekey, authid, convert(seqnum, integer) AS seqnum, resmask, noprefix, prefix, nextkey, authtype, appind, adminby, admindate, admintime, active, until, acc_read, acc_write, acc_update, acc_delete, acc_execute, acc_add, acc_all, acc_allocate, acc_alter, acc_alterin, acc_any, acc_appc, acc_autolog, acc_bind, acc_blp, acc_browse, acc_collect, acc_control, acc_copy, acc_create, acc_createin, acc_cretab, acc_crets, acc_dbadm, acc_dbcntl, acc_dbmaint, acc_discard, acc_dispdb, acc_drop, acc_dropin, acc_eread, acc_ewrite, acc_exec, acc_feov, acc_fetch, acc_find, acc_grplogon, acc_imagecopy, acc_index, acc_inquire, acc_insert, acc_install, acc_load, acc_logon, acc_mread, acc_multi, acc_mwrite, acc_nocreate, acc_none, acc_noshr, acc_other, acc_packadm, acc_perform, acc_purge, acc_recovdb, acc_refer, acc_reorg, acc_repair, acc_replace, acc_scratch, acc_search, acc_select, acc_set, acc_shr, acc_smulti, acc_sread, acc_startdb, acc_stats, acc_stopdb, acc_surogate, acc_swrite, acc_trigger, acc_usage, acc_use, actn_audt, actn_deny, actn_exit, actn_fail, actn_nods, actn_ntfy, actn_password, actn_vrfy, actn_vmpriv, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, resprefix, owner, ownrtype, resowner, ruleowner, resadminby, resadmindate, resadmintime, userdata, AssociatedData FROM (SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND ((s.APPIND = 'T') OR (x.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey) AS t, SYMBOL_MAP={B.sysid=sysid, B.resclass=resclass, B.rulekey=rulekey, B.authid=authid, B.seqnum=convert(seqnum, integer), B.resmask=resmask, B.noprefix=noprefix, B.prefix=prefix, B.nextkey=nextkey, B.authtype=authtype, B.appind=appind, B.adminby=adminby, B.admindate=admindate, B.admintime=admintime, B.active=active, B.until=until, B.acc_read=acc_read, B.acc_write=acc_write, B.acc_update=acc_update, B.acc_delete=acc_delete, B.acc_execute=acc_execute, B.acc_add=acc_add, B.acc_all=acc_all, B.acc_allocate=acc_allocate, B.acc_alter=acc_alter, B.acc_alterin=acc_alterin, B.acc_any=acc_any, B.acc_appc=acc_appc, B.acc_autolog=acc_autolog, B.acc_bind=acc_bind, B.acc_blp=acc_blp, B.acc_browse=acc_browse, B.acc_collect=acc_collect, B.acc_control=acc_control, B.acc_copy=acc_copy, B.acc_create=acc_create, B.acc_createin=acc_createin, B.acc_cretab=acc_cretab, B.acc_crets=acc_crets, B.acc_dbadm=acc_dbadm, B.acc_dbcntl=acc_dbcntl, B.acc_dbmaint=acc_dbmaint, B.acc_discard=acc_discard, B.acc_dispdb=acc_dispdb, B.acc_drop=acc_drop, B.acc_dropin=acc_dropin, B.acc_eread=acc_eread, B.acc_ewrite=acc_ewrite, B.acc_exec=acc_exec, B.acc_feov=acc_feov, B.acc_fetch=acc_fetch, B.acc_find=acc_find, B.acc_grplogon=acc_grplogon, B.acc_imagecopy=acc_imagecopy, B.acc_index=acc_index, B.acc_inquire=acc_inquire, B.acc_insert=acc_insert, B.acc_install=acc_install, B.acc_load=acc_load, B.acc_logon=acc_logon, B.acc_mread=acc_mread, B.acc_multi=acc_multi, B.acc_mwrite=acc_mwrite, B.acc_nocreate=acc_nocreate, B.acc_none=acc_none, B.acc_noshr=acc_noshr, B.acc_other=acc_other, B.acc_packadm=acc_packadm, B.acc_perform=acc_perform, B.acc_purge=acc_purge, B.acc_recovdb=acc_recovdb, B.acc_refer=acc_refer, B.acc_reorg=acc_reorg, B.acc_repair=acc_repair, B.acc_replace=acc_replace, B.acc_scratch=acc_scratch, B.acc_search=acc_search, B.acc_select=acc_select, B.acc_set=acc_set, B.acc_shr=acc_shr, B.acc_smulti=acc_smulti, B.acc_sread=acc_sread, B.acc_startdb=acc_startdb, B.acc_stats=acc_stats, B.acc_stopdb=acc_stopdb, B.acc_surogate=acc_surogate, B.acc_swrite=acc_swrite, B.acc_trigger=acc_trigger, B.acc_usage=acc_usage, B.acc_use=acc_use, B.actn_audt=actn_audt, B.actn_deny=actn_deny, B.actn_exit=actn_exit, B.actn_fail=actn_fail, B.actn_nods=actn_nods, B.actn_ntfy=actn_ntfy, B.actn_password=actn_password, B.actn_vrfy=actn_vrfy, B.actn_vmpriv=actn_vmpriv, B.mode=mode, B.ddname=ddname, B.volume=volume, B.dayrecid=dayrecid, B.timerecid=timerecid, B.srcrecid=srcrecid, B.data=data, B.resprefix=resprefix, B.owner=owner, B.ownrtype=ownrtype, B.resowner=resowner, B.ruleowner=ruleowner, B.resadminby=resadminby, B.resadmindate=resadmindate, B.resadmintime=resadmintime, B.userdata=userdata, B.associateddata=AssociatedData}}) Project(groups=[t], props={PROJECT_COLS=[sysid, resclass, rulekey, authid, convert(seqnum, integer) AS seqnum, resmask, noprefix, prefix, nextkey, authtype, appind, adminby, admindate, admintime, active, until, acc_read, acc_write, acc_update, acc_delete, acc_execute, acc_add, acc_all, acc_allocate, acc_alter, acc_alterin, acc_any, acc_appc, acc_autolog, acc_bind, acc_blp, acc_browse, acc_collect, acc_control, acc_copy, acc_create, acc_createin, acc_cretab, acc_crets, acc_dbadm, acc_dbcntl, acc_dbmaint, acc_discard, acc_dispdb, acc_drop, acc_dropin, acc_eread, acc_ewrite, acc_exec, acc_feov, acc_fetch, acc_find, acc_grplogon, acc_imagecopy, acc_index, acc_inquire, acc_insert, acc_install, acc_load, acc_logon, acc_mread, acc_multi, acc_mwrite, acc_nocreate, acc_none, acc_noshr, acc_other, acc_packadm, acc_perform, acc_purge, acc_recovdb, acc_refer, acc_reorg, acc_repair, acc_replace, acc_scratch, acc_search, acc_select, acc_set, acc_shr, acc_smulti, acc_sread, acc_startdb, acc_stats, acc_stopdb, acc_surogate, acc_swrite, acc_trigger, acc_usage, acc_use, actn_audt, actn_deny, actn_exit, actn_fail, actn_nods, actn_ntfy, actn_password, actn_vrfy, actn_vmpriv, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, resprefix, owner, ownrtype, resowner, ruleowner, resadminby, resadmindate, resadmintime, userdata, AssociatedData]}) Source(groups=[t], props={NESTED_COMMAND=SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND ((s.APPIND = 'T') OR (x.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey, SYMBOL_MAP={t.SYSID=p.sysid, t.RESCLASS=p.resclass, t.RULEKEY=p.rulekey, t.AUTHID=p.authid, t.SEQNUM=p.seqnum, t.RESMASK=p.resmask, t.NOPREFIX=p.noprefix, t.PREFIX=p.prefix, t.NEXTKEY=p.nextkey, t.AUTHTYPE=p.authtype, t.APPIND=p.appind, t.ADMINBY=p.adminby, t.ADMINDATE=p.admindate, t.ADMINTIME=p.admintime, t.ACTIVE=p.active, t.UNTIL=p.until, t.ACC_READ=p.acc_read, t.ACC_WRITE=p.acc_write, t.ACC_UPDATE=p.acc_update, t.ACC_DELETE=p.acc_delete, t.ACC_EXECUTE=p.acc_execute, t.ACC_ADD=p.acc_add, t.ACC_ALL=p.acc_all, t.ACC_ALLOCATE=p.acc_allocate, t.ACC_ALTER=p.acc_alter, t.ACC_ALTERIN=p.acc_alterin, t.ACC_ANY=p.acc_any, t.ACC_APPC=p.acc_appc, t.ACC_AUTOLOG=p.acc_autolog, t.ACC_BIND=p.acc_bind, t.ACC_BLP=p.acc_blp, t.ACC_BROWSE=p.acc_browse, t.ACC_COLLECT=p.acc_collect, t.ACC_CONTROL=p.acc_control, t.ACC_COPY=p.acc_copy, t.ACC_CREATE=p.acc_create, t.ACC_CREATEIN=p.acc_createin, t.ACC_CRETAB=p.acc_cretab, t.ACC_CRETS=p.acc_crets, t.ACC_DBADM=p.acc_dbadm, t.ACC_DBCNTL=p.acc_dbcntl, t.ACC_DBMAINT=p.acc_dbmaint, t.ACC_DISCARD=p.acc_discard, t.ACC_DISPDB=p.acc_dispdb, t.ACC_DROP=p.acc_drop, t.ACC_DROPIN=p.acc_dropin, t.ACC_EREAD=p.acc_eread, t.ACC_EWRITE=p.acc_ewrite, t.ACC_EXEC=p.acc_exec, t.ACC_FEOV=p.acc_feov, t.ACC_FETCH=p.acc_fetch, t.ACC_FIND=p.acc_find, t.ACC_GRPLOGON=p.acc_grplogon, t.ACC_IMAGECOPY=p.acc_imagecopy, t.ACC_INDEX=p.acc_index, t.ACC_INQUIRE=p.acc_inquire, t.ACC_INSERT=p.acc_insert, t.ACC_INSTALL=p.acc_install, t.ACC_LOAD=p.acc_load, t.ACC_LOGON=p.acc_logon, t.ACC_MREAD=p.acc_mread, t.ACC_MULTI=p.acc_multi, t.ACC_MWRITE=p.acc_mwrite, t.ACC_NOCREATE=p.acc_nocreate, t.ACC_NONE=p.acc_none, t.ACC_NOSHR=p.acc_noshr, t.ACC_OTHER=p.acc_other, t.ACC_PACKADM=p.acc_packadm, t.ACC_PERFORM=p.acc_perform, t.ACC_PURGE=p.acc_purge, t.ACC_RECOVDB=p.acc_recovdb, t.ACC_REFER=p.acc_refer, t.ACC_REORG=p.acc_reorg, t.ACC_REPAIR=p.acc_repair, t.ACC_REPLACE=p.acc_replace, t.ACC_SCRATCH=p.acc_scratch, t.ACC_SEARCH=p.acc_search, t.ACC_SELECT=p.acc_select, t.ACC_SET=p.acc_set, t.ACC_SHR=p.acc_shr, t.ACC_SMULTI=p.acc_smulti, t.ACC_SREAD=p.acc_sread, t.ACC_STARTDB=p.acc_startdb, t.ACC_STATS=p.acc_stats, t.ACC_STOPDB=p.acc_stopdb, t.ACC_SUROGATE=p.acc_surogate, t.ACC_SWRITE=p.acc_swrite, t.ACC_TRIGGER=p.acc_trigger, t.ACC_USAGE=p.acc_usage, t.ACC_USE=p.acc_use, t.ACTN_AUDT=p.actn_audt, t.ACTN_DENY=p.actn_deny, t.ACTN_EXIT=p.actn_exit, t.ACTN_FAIL=p.actn_fail, t.ACTN_NODS=p.actn_nods, t.ACTN_NTFY=p.actn_ntfy, t.ACTN_PASSWORD=p.actn_password, t.ACTN_VRFY=p.actn_vrfy, t.ACTN_VMPRIV=p.actn_vmpriv, t.MODE=p.mode, t.DDNAME=p.ddname, t.VOLUME=p.volume, t.DAYRECID=p.dayrecid, t.TIMERECID=p.timerecid, t.SRCRECID=p.srcrecid, t.DATA=p.data, t.resprefix=i.prefix, t.OWNER=i.owner, t.OWNRTYPE=i.ownrtype, t.RESOWNER=i.resowner, t.RULEOWNER=i.ruleowner, t.resadminby=i.adminby, t.resadmindate=i.admindate, t.resadmintime=i.admintime, t.USERDATA=i.userdata, t.ASSOCIATEDDATA=rx.AssociatedData}}) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={PROJECT_COLS=[p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[i.sysid = p.sysid, i.resclass = p.resclass, i.rulekey = p.rulekey]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[rx.sysid = p.sysid, rx.resclass = p.resclass]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[rx], props={NESTED_COMMAND=SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND ((s.APPIND = 'T') OR (x.RESCLASS = 'DATASET')), SYMBOL_MAP={rx.SYSID=x.sysid, rx.resclass=RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' '), rx.ASSOCIATEDDATA=x.associateddata}, IS_OPTIONAL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) DupRemoval(groups=[]) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x], props={PROJECT_COLS=[x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.SYSID = x.SYSID, s.APPIND = 'A', x.RESCLASS <> 'DATASET']}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s]) DupRemoval(groups=[]) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x], props={PROJECT_COLS=[x.sysid, x.resclass, x.associateddata]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.SYSID = x.SYSID, (s.APPIND = 'T') OR (x.RESCLASS = 'DATASET')]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={IS_OPTIONAL=true}) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Group(groups=[SECURITY.BASERULE AS B, anon_grp0]) Source(groups=[SECURITY.BASERULE AS B], props={NESTED_COMMAND=SELECT sysid, resclass, rulekey, authid, convert(seqnum, integer) AS seqnum, resmask, noprefix, prefix, nextkey, authtype, appind, adminby, admindate, admintime, active, until, acc_read, acc_write, acc_update, acc_delete, acc_execute, acc_add, acc_all, acc_allocate, acc_alter, acc_alterin, acc_any, acc_appc, acc_autolog, acc_bind, acc_blp, acc_browse, acc_collect, acc_control, acc_copy, acc_create, acc_createin, acc_cretab, acc_crets, acc_dbadm, acc_dbcntl, acc_dbmaint, acc_discard, acc_dispdb, acc_drop, acc_dropin, acc_eread, acc_ewrite, acc_exec, acc_feov, acc_fetch, acc_find, acc_grplogon, acc_imagecopy, acc_index, acc_inquire, acc_insert, acc_install, acc_load, acc_logon, acc_mread, acc_multi, acc_mwrite, acc_nocreate, acc_none, acc_noshr, acc_other, acc_packadm, acc_perform, acc_purge, acc_recovdb, acc_refer, acc_reorg, acc_repair, acc_replace, acc_scratch, acc_search, acc_select, acc_set, acc_shr, acc_smulti, acc_sread, acc_startdb, acc_stats, acc_stopdb, acc_surogate, acc_swrite, acc_trigger, acc_usage, acc_use, actn_audt, actn_deny, actn_exit, actn_fail, actn_nods, actn_ntfy, actn_password, actn_vrfy, actn_vmpriv, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, resprefix, owner, ownrtype, resowner, ruleowner, resadminby, resadmindate, resadmintime, userdata, AssociatedData FROM (SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey) AS t, SYMBOL_MAP={B.sysid=sysid, B.resclass=resclass, B.rulekey=rulekey, B.authid=authid, B.seqnum=convert(seqnum, integer), B.resmask=resmask, B.noprefix=noprefix, B.prefix=prefix, B.nextkey=nextkey, B.authtype=authtype, B.appind=appind, B.adminby=adminby, B.admindate=admindate, B.admintime=admintime, B.active=active, B.until=until, B.acc_read=acc_read, B.acc_write=acc_write, B.acc_update=acc_update, B.acc_delete=acc_delete, B.acc_execute=acc_execute, B.acc_add=acc_add, B.acc_all=acc_all, B.acc_allocate=acc_allocate, B.acc_alter=acc_alter, B.acc_alterin=acc_alterin, B.acc_any=acc_any, B.acc_appc=acc_appc, B.acc_autolog=acc_autolog, B.acc_bind=acc_bind, B.acc_blp=acc_blp, B.acc_browse=acc_browse, B.acc_collect=acc_collect, B.acc_control=acc_control, B.acc_copy=acc_copy, B.acc_create=acc_create, B.acc_createin=acc_createin, B.acc_cretab=acc_cretab, B.acc_crets=acc_crets, B.acc_dbadm=acc_dbadm, B.acc_dbcntl=acc_dbcntl, B.acc_dbmaint=acc_dbmaint, B.acc_discard=acc_discard, B.acc_dispdb=acc_dispdb, B.acc_drop=acc_drop, B.acc_dropin=acc_dropin, B.acc_eread=acc_eread, B.acc_ewrite=acc_ewrite, B.acc_exec=acc_exec, B.acc_feov=acc_feov, B.acc_fetch=acc_fetch, B.acc_find=acc_find, B.acc_grplogon=acc_grplogon, B.acc_imagecopy=acc_imagecopy, B.acc_index=acc_index, B.acc_inquire=acc_inquire, B.acc_insert=acc_insert, B.acc_install=acc_install, B.acc_load=acc_load, B.acc_logon=acc_logon, B.acc_mread=acc_mread, B.acc_multi=acc_multi, B.acc_mwrite=acc_mwrite, B.acc_nocreate=acc_nocreate, B.acc_none=acc_none, B.acc_noshr=acc_noshr, B.acc_other=acc_other, B.acc_packadm=acc_packadm, B.acc_perform=acc_perform, B.acc_purge=acc_purge, B.acc_recovdb=acc_recovdb, B.acc_refer=acc_refer, B.acc_reorg=acc_reorg, B.acc_repair=acc_repair, B.acc_replace=acc_replace, B.acc_scratch=acc_scratch, B.acc_search=acc_search, B.acc_select=acc_select, B.acc_set=acc_set, B.acc_shr=acc_shr, B.acc_smulti=acc_smulti, B.acc_sread=acc_sread, B.acc_startdb=acc_startdb, B.acc_stats=acc_stats, B.acc_stopdb=acc_stopdb, B.acc_surogate=acc_surogate, B.acc_swrite=acc_swrite, B.acc_trigger=acc_trigger, B.acc_usage=acc_usage, B.acc_use=acc_use, B.actn_audt=actn_audt, B.actn_deny=actn_deny, B.actn_exit=actn_exit, B.actn_fail=actn_fail, B.actn_nods=actn_nods, B.actn_ntfy=actn_ntfy, B.actn_password=actn_password, B.actn_vrfy=actn_vrfy, B.actn_vmpriv=actn_vmpriv, B.mode=mode, B.ddname=ddname, B.volume=volume, B.dayrecid=dayrecid, B.timerecid=timerecid, B.srcrecid=srcrecid, B.data=data, B.resprefix=resprefix, B.owner=owner, B.ownrtype=ownrtype, B.resowner=resowner, B.ruleowner=ruleowner, B.resadminby=resadminby, B.resadmindate=resadmindate, B.resadmintime=resadmintime, B.userdata=userdata, B.associateddata=AssociatedData}}) Project(groups=[t], props={PROJECT_COLS=[sysid, resclass, rulekey, authid, convert(seqnum, integer) AS seqnum, resmask, noprefix, prefix, nextkey, authtype, appind, adminby, admindate, admintime, active, until, acc_read, acc_write, acc_update, acc_delete, acc_execute, acc_add, acc_all, acc_allocate, acc_alter, acc_alterin, acc_any, acc_appc, acc_autolog, acc_bind, acc_blp, acc_browse, acc_collect, acc_control, acc_copy, acc_create, acc_createin, acc_cretab, acc_crets, acc_dbadm, acc_dbcntl, acc_dbmaint, acc_discard, acc_dispdb, acc_drop, acc_dropin, acc_eread, acc_ewrite, acc_exec, acc_feov, acc_fetch, acc_find, acc_grplogon, acc_imagecopy, acc_index, acc_inquire, acc_insert, acc_install, acc_load, acc_logon, acc_mread, acc_multi, acc_mwrite, acc_nocreate, acc_none, acc_noshr, acc_other, acc_packadm, acc_perform, acc_purge, acc_recovdb, acc_refer, acc_reorg, acc_repair, acc_replace, acc_scratch, acc_search, acc_select, acc_set, acc_shr, acc_smulti, acc_sread, acc_startdb, acc_stats, acc_stopdb, acc_surogate, acc_swrite, acc_trigger, acc_usage, acc_use, actn_audt, actn_deny, actn_exit, actn_fail, actn_nods, actn_ntfy, actn_password, actn_vrfy, actn_vmpriv, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, resprefix, owner, ownrtype, resowner, ruleowner, resadminby, resadmindate, resadmintime, userdata, AssociatedData]}) Source(groups=[t], props={NESTED_COMMAND=SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey, SYMBOL_MAP={t.SYSID=p.sysid, t.RESCLASS=p.resclass, t.RULEKEY=p.rulekey, t.AUTHID=p.authid, t.SEQNUM=p.seqnum, t.RESMASK=p.resmask, t.NOPREFIX=p.noprefix, t.PREFIX=p.prefix, t.NEXTKEY=p.nextkey, t.AUTHTYPE=p.authtype, t.APPIND=p.appind, t.ADMINBY=p.adminby, t.ADMINDATE=p.admindate, t.ADMINTIME=p.admintime, t.ACTIVE=p.active, t.UNTIL=p.until, t.ACC_READ=p.acc_read, t.ACC_WRITE=p.acc_write, t.ACC_UPDATE=p.acc_update, t.ACC_DELETE=p.acc_delete, t.ACC_EXECUTE=p.acc_execute, t.ACC_ADD=p.acc_add, t.ACC_ALL=p.acc_all, t.ACC_ALLOCATE=p.acc_allocate, t.ACC_ALTER=p.acc_alter, t.ACC_ALTERIN=p.acc_alterin, t.ACC_ANY=p.acc_any, t.ACC_APPC=p.acc_appc, t.ACC_AUTOLOG=p.acc_autolog, t.ACC_BIND=p.acc_bind, t.ACC_BLP=p.acc_blp, t.ACC_BROWSE=p.acc_browse, t.ACC_COLLECT=p.acc_collect, t.ACC_CONTROL=p.acc_control, t.ACC_COPY=p.acc_copy, t.ACC_CREATE=p.acc_create, t.ACC_CREATEIN=p.acc_createin, t.ACC_CRETAB=p.acc_cretab, t.ACC_CRETS=p.acc_crets, t.ACC_DBADM=p.acc_dbadm, t.ACC_DBCNTL=p.acc_dbcntl, t.ACC_DBMAINT=p.acc_dbmaint, t.ACC_DISCARD=p.acc_discard, t.ACC_DISPDB=p.acc_dispdb, t.ACC_DROP=p.acc_drop, t.ACC_DROPIN=p.acc_dropin, t.ACC_EREAD=p.acc_eread, t.ACC_EWRITE=p.acc_ewrite, t.ACC_EXEC=p.acc_exec, t.ACC_FEOV=p.acc_feov, t.ACC_FETCH=p.acc_fetch, t.ACC_FIND=p.acc_find, t.ACC_GRPLOGON=p.acc_grplogon, t.ACC_IMAGECOPY=p.acc_imagecopy, t.ACC_INDEX=p.acc_index, t.ACC_INQUIRE=p.acc_inquire, t.ACC_INSERT=p.acc_insert, t.ACC_INSTALL=p.acc_install, t.ACC_LOAD=p.acc_load, t.ACC_LOGON=p.acc_logon, t.ACC_MREAD=p.acc_mread, t.ACC_MULTI=p.acc_multi, t.ACC_MWRITE=p.acc_mwrite, t.ACC_NOCREATE=p.acc_nocreate, t.ACC_NONE=p.acc_none, t.ACC_NOSHR=p.acc_noshr, t.ACC_OTHER=p.acc_other, t.ACC_PACKADM=p.acc_packadm, t.ACC_PERFORM=p.acc_perform, t.ACC_PURGE=p.acc_purge, t.ACC_RECOVDB=p.acc_recovdb, t.ACC_REFER=p.acc_refer, t.ACC_REORG=p.acc_reorg, t.ACC_REPAIR=p.acc_repair, t.ACC_REPLACE=p.acc_replace, t.ACC_SCRATCH=p.acc_scratch, t.ACC_SEARCH=p.acc_search, t.ACC_SELECT=p.acc_select, t.ACC_SET=p.acc_set, t.ACC_SHR=p.acc_shr, t.ACC_SMULTI=p.acc_smulti, t.ACC_SREAD=p.acc_sread, t.ACC_STARTDB=p.acc_startdb, t.ACC_STATS=p.acc_stats, t.ACC_STOPDB=p.acc_stopdb, t.ACC_SUROGATE=p.acc_surogate, t.ACC_SWRITE=p.acc_swrite, t.ACC_TRIGGER=p.acc_trigger, t.ACC_USAGE=p.acc_usage, t.ACC_USE=p.acc_use, t.ACTN_AUDT=p.actn_audt, t.ACTN_DENY=p.actn_deny, t.ACTN_EXIT=p.actn_exit, t.ACTN_FAIL=p.actn_fail, t.ACTN_NODS=p.actn_nods, t.ACTN_NTFY=p.actn_ntfy, t.ACTN_PASSWORD=p.actn_password, t.ACTN_VRFY=p.actn_vrfy, t.ACTN_VMPRIV=p.actn_vmpriv, t.MODE=p.mode, t.DDNAME=p.ddname, t.VOLUME=p.volume, t.DAYRECID=p.dayrecid, t.TIMERECID=p.timerecid, t.SRCRECID=p.srcrecid, t.DATA=p.data, t.resprefix=i.prefix, t.OWNER=i.owner, t.OWNRTYPE=i.ownrtype, t.RESOWNER=i.resowner, t.RULEOWNER=i.ruleowner, t.resadminby=i.adminby, t.resadmindate=i.admindate, t.resadmintime=i.admintime, t.USERDATA=i.userdata, t.ASSOCIATEDDATA=rx.AssociatedData}}) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={PROJECT_COLS=[p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[i.sysid = p.sysid, i.resclass = p.resclass, i.rulekey = p.rulekey]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[rx.sysid = p.sysid, rx.resclass = p.resclass]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[rx], props={NESTED_COMMAND=SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET')), SYMBOL_MAP={rx.SYSID=x.sysid, rx.resclass=RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' '), rx.ASSOCIATEDDATA=x.associateddata}, IS_OPTIONAL=true}) SetOperation(groups=[]) DupRemoval(groups=[]) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x], props={PROJECT_COLS=[x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.SYSID = x.SYSID, s.APPIND = 'A', x.RESCLASS <> 'DATASET']}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s]) DupRemoval(groups=[]) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1], props={PROJECT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s__1.SYSID = x__1.SYSID, (s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET')]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s__1]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s__1]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={IS_OPTIONAL=true}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={}) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22, OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY resclass DESC, OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Group(groups=[SECURITY.BASERULE AS B, anon_grp0], props={GROUP_COLS=[B.RESCLASS], SYMBOL_MAP={anon_grp0.gcol0=B.RESCLASS, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0]}) Source(groups=[SECURITY.BASERULE AS B], props={NESTED_COMMAND=SELECT sysid, resclass, rulekey, authid, convert(seqnum, integer) AS seqnum, resmask, noprefix, prefix, nextkey, authtype, appind, adminby, admindate, admintime, active, until, acc_read, acc_write, acc_update, acc_delete, acc_execute, acc_add, acc_all, acc_allocate, acc_alter, acc_alterin, acc_any, acc_appc, acc_autolog, acc_bind, acc_blp, acc_browse, acc_collect, acc_control, acc_copy, acc_create, acc_createin, acc_cretab, acc_crets, acc_dbadm, acc_dbcntl, acc_dbmaint, acc_discard, acc_dispdb, acc_drop, acc_dropin, acc_eread, acc_ewrite, acc_exec, acc_feov, acc_fetch, acc_find, acc_grplogon, acc_imagecopy, acc_index, acc_inquire, acc_insert, acc_install, acc_load, acc_logon, acc_mread, acc_multi, acc_mwrite, acc_nocreate, acc_none, acc_noshr, acc_other, acc_packadm, acc_perform, acc_purge, acc_recovdb, acc_refer, acc_reorg, acc_repair, acc_replace, acc_scratch, acc_search, acc_select, acc_set, acc_shr, acc_smulti, acc_sread, acc_startdb, acc_stats, acc_stopdb, acc_surogate, acc_swrite, acc_trigger, acc_usage, acc_use, actn_audt, actn_deny, actn_exit, actn_fail, actn_nods, actn_ntfy, actn_password, actn_vrfy, actn_vmpriv, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, resprefix, owner, ownrtype, resowner, ruleowner, resadminby, resadmindate, resadmintime, userdata, AssociatedData FROM (SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey) AS t, SYMBOL_MAP={B.resclass=resclass}, OUTPUT_COLS=[B.RESCLASS]}) Project(groups=[t], props={PROJECT_COLS=[resclass], OUTPUT_COLS=[resclass]}) Source(groups=[t], props={NESTED_COMMAND=SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey, SYMBOL_MAP={t.RESCLASS=p.resclass}, OUTPUT_COLS=[resclass]}) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={PROJECT_COLS=[p.resclass], OUTPUT_COLS=[p.resclass]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[i.sysid = p.sysid, i.resclass = p.resclass, i.rulekey = p.rulekey], OUTPUT_COLS=[p.resclass]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[rx.sysid = p.sysid, rx.resclass = p.resclass], OUTPUT_COLS=[p.sysid, p.resclass, p.rulekey]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[p.sysid, p.resclass, p.rulekey]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[p.sysid, p.resclass, p.rulekey]}) Source(groups=[rx], props={NESTED_COMMAND=SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET')), SYMBOL_MAP={rx.SYSID=x.sysid, rx.resclass=RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' '), rx.ASSOCIATEDDATA=x.associateddata}, IS_OPTIONAL=true, OUTPUT_COLS=[rx.SYSID, rx.resclass, rx.ASSOCIATEDDATA]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata]}) DupRemoval(groups=[], props={OUTPUT_COLS=[x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata]}) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x], props={PROJECT_COLS=[x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata], OUTPUT_COLS=[x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s.SYSID = x.SYSID, s.APPIND = 'A', x.RESCLASS <> 'DATASET'], OUTPUT_COLS=[x.sysid, x.crossreftype, x.rsrctypecode, x.associateddata]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x], props={OUTPUT_COLS=[x.SYSID, x.RESCLASS, x.crossreftype, x.rsrctypecode, x.associateddata]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x], props={OUTPUT_COLS=[x.SYSID, x.RESCLASS, x.crossreftype, x.rsrctypecode, x.associateddata]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s], props={OUTPUT_COLS=[s.SYSID, s.APPIND]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s], props={OUTPUT_COLS=[s.SYSID, s.APPIND]}) DupRemoval(groups=[], props={OUTPUT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA]}) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1], props={PROJECT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA], OUTPUT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA]}) Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[s__1.SYSID = x__1.SYSID, (s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET')], OUTPUT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1], props={OUTPUT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x__1], props={OUTPUT_COLS=[x__1.SYSID, x__1.RESCLASS, x__1.ASSOCIATEDDATA]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s__1], props={OUTPUT_COLS=[s__1.SYSID, s__1.APPIND]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s__1], props={OUTPUT_COLS=[s__1.SYSID, s__1.APPIND]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={IS_OPTIONAL=true, OUTPUT_COLS=[i.sysid, i.resclass, i.rulekey]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={OUTPUT_COLS=[i.sysid, i.resclass, i.rulekey]}) ============================================================================ EXECUTING RemoveOptionalJoins LOW Relational Planner node was marked as optional - Removing join node Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[i.sysid = p.sysid, i.resclass = p.resclass, i.rulekey = p.rulekey], OUTPUT_COLS=[p.resclass]} LOW Relational Planner node was marked as optional - Removing join node Join(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p, rx], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[rx.sysid = p.sysid, rx.resclass = p.resclass], OUTPUT_COLS=[p.resclass]} AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[SECURITY.BASERULE AS B, anon_grp0]) Source(groups=[SECURITY.BASERULE AS B], props={NESTED_COMMAND=SELECT sysid, resclass, rulekey, authid, convert(seqnum, integer) AS seqnum, resmask, noprefix, prefix, nextkey, authtype, appind, adminby, admindate, admintime, active, until, acc_read, acc_write, acc_update, acc_delete, acc_execute, acc_add, acc_all, acc_allocate, acc_alter, acc_alterin, acc_any, acc_appc, acc_autolog, acc_bind, acc_blp, acc_browse, acc_collect, acc_control, acc_copy, acc_create, acc_createin, acc_cretab, acc_crets, acc_dbadm, acc_dbcntl, acc_dbmaint, acc_discard, acc_dispdb, acc_drop, acc_dropin, acc_eread, acc_ewrite, acc_exec, acc_feov, acc_fetch, acc_find, acc_grplogon, acc_imagecopy, acc_index, acc_inquire, acc_insert, acc_install, acc_load, acc_logon, acc_mread, acc_multi, acc_mwrite, acc_nocreate, acc_none, acc_noshr, acc_other, acc_packadm, acc_perform, acc_purge, acc_recovdb, acc_refer, acc_reorg, acc_repair, acc_replace, acc_scratch, acc_search, acc_select, acc_set, acc_shr, acc_smulti, acc_sread, acc_startdb, acc_stats, acc_stopdb, acc_surogate, acc_swrite, acc_trigger, acc_usage, acc_use, actn_audt, actn_deny, actn_exit, actn_fail, actn_nods, actn_ntfy, actn_password, actn_vrfy, actn_vmpriv, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, resprefix, owner, ownrtype, resowner, ruleowner, resadminby, resadmindate, resadmintime, userdata, AssociatedData FROM (SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey) AS t, SYMBOL_MAP={B.resclass=resclass}, OUTPUT_COLS=[B.RESCLASS]}) Project(groups=[t]) Source(groups=[t], props={NESTED_COMMAND=SELECT p.sysid, p.resclass, p.rulekey, p.authid, p.seqnum, p.resmask, p.noprefix, p.prefix, p.nextkey, p.authtype, p.appind, p.adminby, p.admindate, p.admintime, p.active, p.until, p.acc_read, p.acc_write, p.acc_update, p.acc_delete, p.acc_execute, p.acc_add, p.acc_all, p.acc_allocate, p.acc_alter, p.acc_alterin, p.acc_any, p.acc_appc, p.acc_autolog, p.acc_bind, p.acc_blp, p.acc_browse, p.acc_collect, p.acc_control, p.acc_copy, p.acc_create, p.acc_createin, p.acc_cretab, p.acc_crets, p.acc_dbadm, p.acc_dbcntl, p.acc_dbmaint, p.acc_discard, p.acc_dispdb, p.acc_drop, p.acc_dropin, p.acc_eread, p.acc_ewrite, p.acc_exec, p.acc_feov, p.acc_fetch, p.acc_find, p.acc_grplogon, p.acc_imagecopy, p.acc_index, p.acc_inquire, p.acc_insert, p.acc_install, p.acc_load, p.acc_logon, p.acc_mread, p.acc_multi, p.acc_mwrite, p.acc_nocreate, p.acc_none, p.acc_noshr, p.acc_other, p.acc_packadm, p.acc_perform, p.acc_purge, p.acc_recovdb, p.acc_refer, p.acc_reorg, p.acc_repair, p.acc_replace, p.acc_scratch, p.acc_search, p.acc_select, p.acc_set, p.acc_shr, p.acc_smulti, p.acc_sread, p.acc_startdb, p.acc_stats, p.acc_stopdb, p.acc_surogate, p.acc_swrite, p.acc_trigger, p.acc_usage, p.acc_use, p.actn_audt, p.actn_deny, p.actn_exit, p.actn_fail, p.actn_nods, p.actn_ntfy, p.actn_password, p.actn_vrfy, p.actn_vmpriv, p.mode, p.ddname, p.volume, p.dayrecid, p.timerecid, p.srcrecid, p.data, i.prefix AS resprefix, i.owner, i.ownrtype, i.resowner, i.ruleowner, i.adminby AS resadminby, i.admindate AS resadmindate, i.admintime AS resadmintime, i.userdata, rx.AssociatedData FROM (SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p LEFT OUTER JOIN /*+ optional */ (SELECT DISTINCT x.sysid, RPAD(concat(x.crossreftype, x.rsrctypecode), 8, ' ') AS resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s.SYSID = x.SYSID AND s.APPIND = 'A' AND x.RESCLASS <> 'DATASET' UNION SELECT DISTINCT x.sysid, x.resclass, x.associateddata FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESXREF AS x INNER JOIN SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.SYSINFOVIEW AS s ON s__1.SYSID = x__1.SYSID AND ((s__1.APPIND = 'T') OR (x__1.RESCLASS = 'DATASET'))) AS rx ON rx.sysid = p.sysid AND rx.resclass = p.resclass) LEFT OUTER JOIN /*+ optional */ SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.RESINFOVIEW AS i ON i.sysid = p.sysid AND i.resclass = p.resclass AND i.rulekey = p.rulekey, SYMBOL_MAP={t.RESCLASS=p.resclass}, OUTPUT_COLS=[resclass]}) Project(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={PROJECT_COLS=[p.resclass], OUTPUT_COLS=[p.resclass]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[p.resclass]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={GROUP_COLS=[p.resclass], SYMBOL_MAP={anon_grp0.gcol0=p.resclass, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0]}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[p.resclass]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING DecomposeJoin AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING CopyCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22, OUTPUT_COLS=null}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY resclass DESC, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=null}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={GROUP_COLS=[p.resclass], SYMBOL_MAP={anon_grp0.gcol0=p.resclass, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=null}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanUnions AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Access(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=null}) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=null, MODEL_ID=Schema name=SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01, nameInSource=null, uuid=tid:ac193d0fd5c1-39997486-00000000}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={GROUP_COLS=[p.resclass], SYMBOL_MAP={anon_grp0.gcol0=p.resclass, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=null}) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=null, MODEL_ID=Schema name=SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01, nameInSource=null, uuid=tid:ac193d0fd5c1-39997486-00000000}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING PushAggregates AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING PushLimit AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22, OUTPUT_COLS=null}) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22, OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY resclass DESC, OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"]}) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], MODEL_ID=Schema name=SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01, nameInSource=null, uuid=tid:ac193d0fd5c1-39997486-00000000}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={GROUP_COLS=[p.resclass], SYMBOL_MAP={anon_grp0.gcol0=p.resclass, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0]}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[p.resclass]}) ============================================================================ EXECUTING CalculateCost AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22, OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], EST_CARDINALITY=22.0, EST_COL_STATS={anon_grp0.gcol0 AS resclass=[22.0, 0.0], anon_grp0.agg0 AS GROUPING_COUNT=[22.0, 0.0], 'SECURITY.BASERULE' AS "__objecttype__"=[22.0, 0.0]}}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY resclass DESC, OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], MODEL_ID=Schema name=SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01, nameInSource=null, uuid=tid:ac193d0fd5c1-39997486-00000000, EST_CARDINALITY=-1.0}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={GROUP_COLS=[p.resclass], SYMBOL_MAP={anon_grp0.gcol0=p.resclass, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], EST_CARDINALITY=-1.0}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[p.resclass], EST_COL_STATS={p.resclass=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING MergeCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], OUTPUT_COLS=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], MODEL_ID=Schema name=SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01, nameInSource=null, uuid=tid:ac193d0fd5c1-39997486-00000000}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=22, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], EST_CARDINALITY=22.0, EST_COL_STATS={anon_grp0.gcol0 AS resclass=[22.0, 0.0], anon_grp0.agg0 AS GROUPING_COUNT=[22.0, 0.0], 'SECURITY.BASERULE' AS "__objecttype__"=[22.0, 0.0]}}) Group(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={GROUP_COLS=[p.resclass], SYMBOL_MAP={anon_grp0.gcol0=p.resclass, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY anon_grp0.gcol0 DESC}) Source(groups=[SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp0]) Access(groups=[anon_grp0, SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p], props={OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.agg0], MODEL_ID=Schema name=SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01, nameInSource=null, uuid=tid:ac193d0fd5c1-39997486-00000000, ATOMIC_REQUEST=SELECT p.resclass AS gcol0, COUNT(*) FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS p GROUP BY p.resclass LIMIT 22}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(1) output=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"] [anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"] AccessNode(2) output=[anon_grp0.gcol0, anon_grp0.agg0] SELECT g_0.RESCLASS, COUNT(*) FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS g_0 GROUP BY g_0.RESCLASS LIMIT 22 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(1) output=[anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"] [anon_grp0.gcol0 AS resclass, anon_grp0.agg0 AS GROUPING_COUNT, 'SECURITY.BASERULE' AS "__objecttype__"] AccessNode(2) output=[anon_grp0.gcol0, anon_grp0.agg0] SELECT g_0.RESCLASS, COUNT(*) FROM SECURITY_CIA_DATACOM_DEV_R140_CA31_CIADB01.BASERULE AS g_0 GROUP BY g_0.RESCLASS LIMIT 22 ============================================================================