We are running on teiid 7.7.1.
Here is the debug plan
17 Apr 2012 11:42:26,455 PDT INFO [org.teiid.PLANNER] (Worker136_QueryProcessorQueue5697)
============================================================================
USER COMMAND:
SELECT CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__" FROM (SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'PRD6600') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') ORDER BY CHORUS_B.CREATOR LIMIT 100
----------------------------------------------------------------------------
OPTIMIZE:
SELECT CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__" FROM (SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'PRD6600') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') ORDER BY CHORUS_B.CREATOR LIMIT 100
----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__" FROM (SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'PRD6600') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') ORDER BY CHORUS_B.CREATOR LIMIT 100
CANONICAL PLAN:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true})
Sort(groups=[CHORUS_B], props={SORT_ORDER=ORDER BY CHORUS_B.CREATOR})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSSID = ''})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSystem = ''})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G'})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsConf = 'PRD6600'})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.CLONE=TS.CLONE, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.CREATORTYPE=TS.CREATORTYPE, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.DBID=TS.DBID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.INSTANCE=TS.INSTANCE, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.LOG=TS.LOG, CHORUS_B.MAXPARTITIONS=TS.MAXPARTITIONS, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.NAME=TS.NAME, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.OBID=TS.OBID, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.PSID=TS.PSID, CHORUS_B.RELCREATED=TS.RELCREATED, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.TYPE=TS.TYPE}})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsQuerySet, TS.dsSystem, TS.dsSSID, TS.ALTEREDTS, TS.AVGROWLEN, TS.BPOOL, TS.CLONE, TS.CLOSERULE, TS.CREATEDBY, TS.CREATEDTS, TS.CREATOR, TS.CREATORTYPE, TS.CURRENT_VERSION, TS.DBCS_CCSID, TS.DBID, TS.DBNAME, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.ERASERULE, TS.IBMREQD, TS.IMPLICIT, TS.INSTANCE, TS.LOCKMAX, TS.LOCKPART, TS.LOCKRULE, TS.LOG, TS.MAXPARTITIONS, TS.MAXROWS, TS.MIXED_CCSID, TS.NACTIVE, TS.NACTIVEF, TS.NAME, TS.NTABLES, TS.OBID, TS.OLDEST_VERSION, TS.PARTITIONS, TS.PGSIZE, TS.PSID, TS.RELCREATED, TS.ROOTCREATOR, TS.ROOTNAME, TS.SBCS_CCSID, TS.SEGSIZE, TS.SPACE, TS.SPACEF, TS.STATSTIME, TS.STATUS, TS.TYPE]})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
----------------------------------------------------------------------------
OPTIMIZE:
SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo
----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo
CANONICAL PLAN:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count]})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
Source(groups=[foo], props={NESTED_COMMAND=SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), SYMBOL_MAP={foo.ID=chorus_notes.RETRIEVE_NOTES.ID, foo.NOTE=chorus_notes.RETRIEVE_NOTES.NOTE, foo.USER_ID=chorus_notes.RETRIEVE_NOTES.USER_ID, foo.NOTES_TYPE=chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, foo.ACCESS_MODE=chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, foo.CREATED_ON=chorus_notes.RETRIEVE_NOTES.CREATED_ON, foo.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}})
Project(groups=[chorus_notes.RETRIEVE_NOTES], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY]})
Select(groups=[chorus_notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.ID=X.ID, chorus_notes.RETRIEVE_NOTES.NOTE=X.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}})
Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={X.ID=chorus_notes.RETRIEVE_NOTES.ID, X.NOTE=chorus_notes.RETRIEVE_NOTES.NOTE, X.USER_ID=chorus_notes.RETRIEVE_NOTES.USER_ID, X.NOTES_TYPE=chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, X.ACCESS_MODE=chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, X.CREATED_ON=chorus_notes.RETRIEVE_NOTES.CREATED_ON}})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON]})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)})
============================================================================
EXECUTING PlaceAccess
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count]})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
Source(groups=[foo], props={NESTED_COMMAND=SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), SYMBOL_MAP={foo.ID=chorus_notes.RETRIEVE_NOTES.ID, foo.NOTE=chorus_notes.RETRIEVE_NOTES.NOTE, foo.USER_ID=chorus_notes.RETRIEVE_NOTES.USER_ID, foo.NOTES_TYPE=chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, foo.ACCESS_MODE=chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, foo.CREATED_ON=chorus_notes.RETRIEVE_NOTES.CREATED_ON, foo.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}})
Project(groups=[chorus_notes.RETRIEVE_NOTES], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY]})
Select(groups=[chorus_notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.ID=X.ID, chorus_notes.RETRIEVE_NOTES.NOTE=X.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY] History [[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY]]]})
Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={X.ID=chorus_notes.RETRIEVE_NOTES.ID, X.NOTE=chorus_notes.RETRIEVE_NOTES.NOTE, X.USER_ID=chorus_notes.RETRIEVE_NOTES.USER_ID, X.NOTES_TYPE=chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, X.ACCESS_MODE=chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, X.CREATED_ON=chorus_notes.RETRIEVE_NOTES.CREATED_ON}})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON]})
Access(groups=[chorus_notes.RETRIEVE_NOTES])
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)})
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count]})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
Source(groups=[foo], props={NESTED_COMMAND=SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Select(groups=[chorus_notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), OUTPUT_COLS=[]})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, ACCESS_PATTERNS=[Access Pattern: Unsatisfied [chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY] History [[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY]]], OUTPUT_COLS=[OBJECT_PKEY]})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON]})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[]})
============================================================================
EXECUTING PushSelectCriteria
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count]})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
Source(groups=[foo], props={NESTED_COMMAND=SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Select(groups=[chorus_notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), OUTPUT_COLS=[], IS_PHANTOM=true})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, OUTPUT_COLS=[OBJECT_PKEY]})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]})
Select(groups=[], props={SELECT_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON]})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[]})
============================================================================
EXECUTING MergeVirtual
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count]})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
Select(groups=[chorus_notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), OUTPUT_COLS=[], IS_PHANTOM=true})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, OUTPUT_COLS=[OBJECT_PKEY]})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]})
Select(groups=[], props={SELECT_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON]})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[]})
============================================================================
EXECUTING CleanCriteria
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=null})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=null})
Select(groups=[], props={SELECT_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), OUTPUT_COLS=null})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=null})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=null})
============================================================================
EXECUTING RaiseAccess
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=null})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=null})
Select(groups=[], props={SELECT_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), OUTPUT_COLS=null})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=null})
============================================================================
EXECUTING PushAggregates
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=null})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=null})
Select(groups=[], props={SELECT_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), OUTPUT_COLS=null})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=null})
============================================================================
EXECUTING PlanProcedures
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=null})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY], OUTPUT_COLS=null})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=null})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=null, MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=null})
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count]})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[]})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON], MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[]})
============================================================================
EXECUTING CalculateCost
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 AS count=[1.0, 1.0]}})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 0.0]}})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON], MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true, EST_CARDINALITY=-1.0})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[], EST_COL_STATS={}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING MergeCriteria
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 AS count=[1.0, 1.0]}})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 0.0]}})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON], MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true, EST_CARDINALITY=-1.0})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[], EST_COL_STATS={}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PlanSorts
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 AS count=[1.0, 1.0]}})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 0.0]}})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON], MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true, EST_CARDINALITY=-1.0})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), OUTPUT_COLS=[], EST_COL_STATS={}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING CollapseSource
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 AS count=[1.0, 1.0]}})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 0.0]}})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON], MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true, EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)})
============================================================================
EXECUTING AccessPatternValidation
AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS count], OUTPUT_COLS=[anon_grp0.agg0 AS count], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0 AS count=[1.0, 1.0]}})
Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 0.0]}})
Source(groups=[chorus_notes.RETRIEVE_NOTES], props={NESTED_COMMAND=SELECT X.*, chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X, SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Source(groups=[X], props={NESTED_COMMAND=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY), SYMBOL_MAP={}, OUTPUT_COLS=[], EST_CARDINALITY=-1.0, EST_COL_STATS={}})
Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=-1.0})
Access(groups=[chorus_notes.RETRIEVE_NOTES], props={OUTPUT_COLS=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON], MODEL_ID=__TEMP__, PROCEDURE_CRITERIA=chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String), PROCEDURE_INPUTS=[chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY], PROCEDURE_DEFAULTS=[null], IS_DEPENDENT_SET=true, EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)})
============================================================================
CONVERTING PLAN TREE TO PROCESS TREE
PROCESS PLAN =
ProjectNode(1) output=[anon_grp0.agg0 AS count] [anon_grp0.agg0 AS count]
GroupingNode(2) output=[anon_grp0.agg0] null{anon_grp0.agg0=COUNT(*)}
ProjectNode(3) output=[] []
ProjectNode(4) output=[] []
DependentProcedureAccessNode(5) output=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON] EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)
============================================================================
----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(1) output=[anon_grp0.agg0 AS count] [anon_grp0.agg0 AS count]
GroupingNode(2) output=[anon_grp0.agg0] null{anon_grp0.agg0=COUNT(*)}
ProjectNode(3) output=[] []
ProjectNode(4) output=[] []
DependentProcedureAccessNode(5) output=[chorus_notes.RETRIEVE_NOTES.ID, chorus_notes.RETRIEVE_NOTES.NOTE, chorus_notes.RETRIEVE_NOTES.USER_ID, chorus_notes.RETRIEVE_NOTES.NOTES_TYPE, chorus_notes.RETRIEVE_NOTES.ACCESS_MODE, chorus_notes.RETRIEVE_NOTES.CREATED_ON] EXEC chorus_notes.RETRIEVE_NOTES(chorus_notes.RETRIEVE_NOTES.OBJECT_PKEY)
============================================================================
============================================================================
EXECUTING PlaceAccess
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true})
Sort(groups=[CHORUS_B], props={SORT_ORDER=ORDER BY CHORUS_B.CREATOR})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSSID = ''})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSystem = ''})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G'})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsConf = 'PRD6600'})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.CLONE=TS.CLONE, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.CREATORTYPE=TS.CREATORTYPE, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.DBID=TS.DBID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.INSTANCE=TS.INSTANCE, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.LOG=TS.LOG, CHORUS_B.MAXPARTITIONS=TS.MAXPARTITIONS, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.NAME=TS.NAME, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.OBID=TS.OBID, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.PSID=TS.PSID, CHORUS_B.RELCREATED=TS.RELCREATED, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.TYPE=TS.TYPE}})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsQuerySet, TS.dsSystem, TS.dsSSID, TS.ALTEREDTS, TS.AVGROWLEN, TS.BPOOL, TS.CLONE, TS.CLOSERULE, TS.CREATEDBY, TS.CREATEDTS, TS.CREATOR, TS.CREATORTYPE, TS.CURRENT_VERSION, TS.DBCS_CCSID, TS.DBID, TS.DBNAME, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.ERASERULE, TS.IBMREQD, TS.IMPLICIT, TS.INSTANCE, TS.LOCKMAX, TS.LOCKPART, TS.LOCKRULE, TS.LOG, TS.MAXPARTITIONS, TS.MAXROWS, TS.MIXED_CCSID, TS.NACTIVE, TS.NACTIVEF, TS.NAME, TS.NTABLES, TS.OBID, TS.OLDEST_VERSION, TS.PARTITIONS, TS.PGSIZE, TS.PSID, TS.RELCREATED, TS.ROOTCREATOR, TS.ROOTNAME, TS.SBCS_CCSID, TS.SEGSIZE, TS.SPACE, TS.SPACEF, TS.STATSTIME, TS.STATUS, TS.TYPE]})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING AssignOutputElements
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Sort(groups=[CHORUS_B], props={SORT_ORDER=ORDER BY CHORUS_B.CREATOR, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSSID = '', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSystem = '', OUTPUT_COLS=[CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G', OUTPUT_COLS=[CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsConf = 'PRD6600', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION]})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.NAME=TS.NAME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.MAXPARTITIONS=TS.MAXPARTITIONS, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.INSTANCE=TS.INSTANCE, CHORUS_B.DBID=TS.DBID, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.LOG=TS.LOG, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.OBID=TS.OBID, CHORUS_B.RELCREATED=TS.RELCREATED, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.TYPE=TS.TYPE, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.CLONE=TS.CLONE, CHORUS_B.CREATORTYPE=TS.CREATORTYPE, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.PSID=TS.PSID, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION}, OUTPUT_COLS=[CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION]})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.NAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.NAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME, OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.NAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[TS.NAME, TP.TSNAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME]})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
============================================================================
EXECUTING PushSelectCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Sort(groups=[CHORUS_B], props={SORT_ORDER=ORDER BY CHORUS_B.CREATOR, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSSID = '', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSystem = '', OUTPUT_COLS=[CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G', OUTPUT_COLS=[CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsConf = 'PRD6600', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.NAME=TS.NAME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.MAXPARTITIONS=TS.MAXPARTITIONS, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.INSTANCE=TS.INSTANCE, CHORUS_B.DBID=TS.DBID, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.LOG=TS.LOG, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.OBID=TS.OBID, CHORUS_B.RELCREATED=TS.RELCREATED, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.TYPE=TS.TYPE, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.CLONE=TS.CLONE, CHORUS_B.CREATORTYPE=TS.CREATORTYPE, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.PSID=TS.PSID, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION}, OUTPUT_COLS=[CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION]})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.NAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.NAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TP.TSNAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME]})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
============================================================================
EXECUTING MergeVirtual
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsSSID = '', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsSystem = '', OUTPUT_COLS=[CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsGroup = 'DA0G', OUTPUT_COLS=[CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsConf = 'PRD6600', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TP.TSNAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME]})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
============================================================================
EXECUTING PushNonJoinCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsSSID = '', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsSystem = '', OUTPUT_COLS=[CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsGroup = 'DA0G', OUTPUT_COLS=[CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsConf = 'PRD6600', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TP.TSNAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME]})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
============================================================================
EXECUTING CopyCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsSSID = '', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.dsSSID, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true, IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsSystem = '', OUTPUT_COLS=[CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.dsSystem, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true, IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsGroup = 'DA0G', OUTPUT_COLS=[CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsGroup, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true, IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=TS.dsConf = 'PRD6600', OUTPUT_COLS=[CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.dsConf, CHORUS_B.DBNAME, CHORUS_B.NAME, CHORUS_B.ERASERULE, CHORUS_B.CREATOR, CHORUS_B.MAXPARTITIONS, CHORUS_B.SBCS_CCSID, CHORUS_B.DSETPASS, CHORUS_B.DSSIZE, CHORUS_B.ENCODING_SCHEME, CHORUS_B.INSTANCE, CHORUS_B.DBID, CHORUS_B.MAXROWS, CHORUS_B.LOCKPART, CHORUS_B.CREATEDBY, CHORUS_B.SPACEF, CHORUS_B.LOG, CHORUS_B.LOCKRULE, CHORUS_B.dsQuerySet, CHORUS_B.AVGROWLEN, CHORUS_B.OBID, CHORUS_B.RELCREATED, CHORUS_B.NTABLES, CHORUS_B.SEGSIZE, CHORUS_B.LOCKMAX, CHORUS_B.TYPE, CHORUS_B.DBCS_CCSID, CHORUS_B.CLONE, CHORUS_B.CREATORTYPE, CHORUS_B.CREATEDTS, CHORUS_B.PARTITIONS, CHORUS_B.STATSTIME, CHORUS_B.CURRENT_VERSION, CHORUS_B.CLOSERULE, CHORUS_B.NACTIVE, CHORUS_B.ALTEREDTS, CHORUS_B.IBMREQD, CHORUS_B.PSID, CHORUS_B.BPOOL, CHORUS_B.IMPLICIT, CHORUS_B.SPACE, CHORUS_B.ROOTCREATOR, CHORUS_B.MIXED_CCSID, CHORUS_B.ROOTNAME, CHORUS_B.STATUS, CHORUS_B.NACTIVEF, CHORUS_B.PGSIZE, CHORUS_B.OLDEST_VERSION], IS_PHANTOM=true, IS_COPIED=true})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TP.TSNAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], IS_COPIED=true})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.NAME, TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME]})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME], IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
============================================================================
EXECUTING CleanCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING RaiseAccess
Subquery cannot be pushed down DBMzDB2c: SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING PlanJoins
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING PushSelectCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING RaiseAccess
Subquery cannot be pushed down DBMzDB2c: SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING ChooseJoinStrategy
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING ChooseDependent
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING PushLimit
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=null})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=null})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=null, IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=null})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=null})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=null, INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=null})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=null})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=null})
============================================================================
EXECUTING AssignOutputElements
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"]})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=[TS.NAME, TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME], INLINE_VIEW=true})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME]})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME], IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME]})
============================================================================
EXECUTING CalculateCost
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0, EST_COL_STATS={TS.dsGroup=[100.0, 0.0], TS.dsConf=[100.0, 0.0], TS.DBNAME=[100.0, 0.0], TS.dsSSID=[100.0, 0.0], ...}})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=[TS.NAME, TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_COL_STATS={TS.dsConf=[-1.0, -1.0], TS.dsGroup=[-1.0, -1.0], TS.dsSystem=[-1.0, -1.0], TS.dsSSID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME], INLINE_VIEW=true, EST_CARDINALITY=-1.0, EST_COL_STATS={TP.TSNAME=[-1.0, -1.0]}})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], EST_COL_STATS={STORNAME=[-1.0, -1.0], TSNAME=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ImplementJoinStrategy
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0, EST_COL_STATS={TS.dsGroup=[100.0, 0.0], TS.dsConf=[100.0, 0.0], TS.DBNAME=[100.0, 0.0], TS.dsSSID=[100.0, 0.0], ...}})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=[TS.NAME, TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_COL_STATS={TS.dsConf=[-1.0, -1.0], TS.dsGroup=[-1.0, -1.0], TS.dsSystem=[-1.0, -1.0], TS.dsSSID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME], INLINE_VIEW=true, EST_CARDINALITY=-1.0, EST_COL_STATS={TP.TSNAME=[-1.0, -1.0]}})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], EST_COL_STATS={STORNAME=[-1.0, -1.0], TSNAME=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING MergeCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0, EST_COL_STATS={TS.dsGroup=[100.0, 0.0], TS.dsConf=[100.0, 0.0], TS.DBNAME=[100.0, 0.0], TS.dsSSID=[100.0, 0.0], ...}})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=[TS.NAME, TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_COL_STATS={TS.dsConf=[-1.0, -1.0], TS.dsGroup=[-1.0, -1.0], TS.dsSystem=[-1.0, -1.0], TS.dsSSID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME], INLINE_VIEW=true, EST_CARDINALITY=-1.0, EST_COL_STATS={TP.TSNAME=[-1.0, -1.0]}})
DupRemoval(groups=[], props={OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], EST_COL_STATS={STORNAME=[-1.0, -1.0], TSNAME=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PlanSorts
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={PROJECT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, (SELECT COUNT(*) FROM (SELECT * FROM chorus_notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091, XMLATTRIBUTES(CHORUS_B.dsGroup AS dsGroup, CHORUS_B.dsConf AS dsConf, CHORUS_B.DBNAME AS DBNAME, CHORUS_B.dsSSID AS dsSSID, CHORUS_B.NAME AS NAME, CHORUS_B.dsSystem AS dsSystem)) AS String)) AS foo) AS CHORUS_C_notesForObject, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION, 'DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=-1.0})
Access(groups=[TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=100.0, EST_COL_STATS={TS.dsGroup=[100.0, 0.0], TS.dsConf=[100.0, 0.0], TS.DBNAME=[100.0, 0.0], TS.dsSSID=[100.0, 0.0], ...}})
Sort(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SORT_ORDER=ORDER BY TS.CREATOR, OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.NAME, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], IS_COPIED=true, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:4c28ab19-5535-42a9-8e66-fdc3aa522bc0, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'PRD6600') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), IS_COPIED=true, OUTPUT_COLS=[TS.NAME, TS.dsGroup, TS.dsConf, TS.DBNAME, TS.dsSSID, TS.dsSystem, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_V091 AS TS], props={OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.ERASERULE, TS.CREATOR, TS.MAXPARTITIONS, TS.SBCS_CCSID, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.INSTANCE, TS.DBID, TS.MAXROWS, TS.LOCKPART, TS.CREATEDBY, TS.SPACEF, TS.LOG, TS.LOCKRULE, TS.dsQuerySet, TS.AVGROWLEN, TS.OBID, TS.RELCREATED, TS.NTABLES, TS.SEGSIZE, TS.LOCKMAX, TS.TYPE, TS.DBCS_CCSID, TS.CLONE, TS.CREATORTYPE, TS.CREATEDTS, TS.PARTITIONS, TS.STATSTIME, TS.CURRENT_VERSION, TS.CLOSERULE, TS.NACTIVE, TS.ALTEREDTS, TS.IBMREQD, TS.PSID, TS.BPOOL, TS.IMPLICIT, TS.SPACE, TS.ROOTCREATOR, TS.MIXED_CCSID, TS.ROOTNAME, TS.STATUS, TS.NACTIVEF, TS.PGSIZE, TS.OLDEST_VERSION], EST_COL_STATS={TS.dsConf=[-1.0, -1.0], TS.dsGroup=[-1.0, -1.0], TS.dsSystem=[-1.0, -1.0], TS.dsSSID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME], INLINE_VIEW=true, EST_CARDINALITY=-1.0, EST_COL_STATS={TP.TSNAME=[-1.0, -1.0]}})
Sort(groups=[], props={OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0, IS_DUP_REMOVAL=true})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, TSNAME], EST_COL_STATS={STORNAME=[-1.0, -1.0], TSNAME=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING CollapseSource
17 Apr 2012 11:42:26,469 PDT ERROR [org.teiid.PROCESSOR] (Worker136_QueryProcessorQueue5697) Unexpected exception for request CalrJUMyLGsl.0
java.lang.NullPointerException
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.processOrderBy(RuleCollapseSource.java:490)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.buildQuery(RuleCollapseSource.java:390)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.createQuery(RuleCollapseSource.java:228)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.buildQuery(RuleCollapseSource.java:359)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.buildQuery(RuleCollapseSource.java:328)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.buildQuery(RuleCollapseSource.java:373)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.buildQuery(RuleCollapseSource.java:373)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.buildQuery(RuleCollapseSource.java:373)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.createQuery(RuleCollapseSource.java:228)
at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.execute(RuleCollapseSource.java:99)
at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:455)
at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:199)
at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190)
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436)
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459)
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:516)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)