Hi Ramesh,
The plan for the SQL is as follows:
============================================================================
USER COMMAND:
SELECT CHORUS_B.NAME, CHORUS_B.CREATOR, CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.TSNAME, CHORUS_B.CHILDREN, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.CLUSTERTYPE, CHORUS_B.NUM_DEP_MQTS, CHORUS_B.TYPE, CHORUS_B.RELCREATED, CHORUS_B.RECLENGTH, CHORUS_B.KEYCOLUMNS, CHORUS_B.SECURITY_LABEL, CHORUS_B.AUDITING, CHORUS_B.AVGROWLEN, CHORUS_B.CARD, CHORUS_B.COLCOUNT, CHORUS_B.OBID, CHORUS_B.NPAGESF, CHORUS_B.NPAGES, CHORUS_B.VALPROC, CHORUS_B.ENCODING_SCHEME, CHORUS_B.CHECKFLAG, CHORUS_B.PCTPAGES, CHORUS_B.TABLESTATUS, CHORUS_B.REMARKS, CHORUS_B.DATACAPTURE, CHORUS_B.IBMREQD, CHORUS_B.STATUS, CHORUS_B.PCTROWCOMP, CHORUS_B.SPLIT_ROWS, CHORUS_B.PARTKEYCOLNUM, CHORUS_B.CHECKRID, CHORUS_B.dsQuerySet, CHORUS_B.CLUSTERRID, CHORUS_B.PARENTS, CHORUS_B.SPACEF, CHORUS_B.LABEL, CHORUS_B.CREATEDTS, CHORUS_B.RBA1, CHORUS_B.RBA2, CHORUS_B.LOCATION, CHORUS_B.ALTEREDTS, CHORUS_B.CHECKRID5B, CHORUS_B.STATSTIME, CHORUS_B.KEYOBID, CHORUS_B.TBCREATOR, CHORUS_B.CARDF, CHORUS_B.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__" FROM (SELECT TB.* FROM DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, (SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS WHERE (TS.NAME = TP.TSNAME) AND (TS.DBNAME = TP.DBNAME) AND (TB.TSNAME = TS.NAME) AND (TB.DBNAME = TS.DBNAME) AND (TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X'))) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') LIMIT 10
----------------------------------------------------------------------------
OPTIMIZE:
SELECT CHORUS_B.NAME, CHORUS_B.CREATOR, CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.TSNAME, CHORUS_B.CHILDREN, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.CLUSTERTYPE, CHORUS_B.NUM_DEP_MQTS, CHORUS_B.TYPE, CHORUS_B.RELCREATED, CHORUS_B.RECLENGTH, CHORUS_B.KEYCOLUMNS, CHORUS_B.SECURITY_LABEL, CHORUS_B.AUDITING, CHORUS_B.AVGROWLEN, CHORUS_B.CARD, CHORUS_B.COLCOUNT, CHORUS_B.OBID, CHORUS_B.NPAGESF, CHORUS_B.NPAGES, CHORUS_B.VALPROC, CHORUS_B.ENCODING_SCHEME, CHORUS_B.CHECKFLAG, CHORUS_B.PCTPAGES, CHORUS_B.TABLESTATUS, CHORUS_B.REMARKS, CHORUS_B.DATACAPTURE, CHORUS_B.IBMREQD, CHORUS_B.STATUS, CHORUS_B.PCTROWCOMP, CHORUS_B.SPLIT_ROWS, CHORUS_B.PARTKEYCOLNUM, CHORUS_B.CHECKRID, CHORUS_B.dsQuerySet, CHORUS_B.CLUSTERRID, CHORUS_B.PARENTS, CHORUS_B.SPACEF, CHORUS_B.LABEL, CHORUS_B.CREATEDTS, CHORUS_B.RBA1, CHORUS_B.RBA2, CHORUS_B.LOCATION, CHORUS_B.ALTEREDTS, CHORUS_B.CHECKRID5B, CHORUS_B.STATSTIME, CHORUS_B.KEYOBID, CHORUS_B.TBCREATOR, CHORUS_B.CARDF, CHORUS_B.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__" FROM (SELECT TB.* FROM DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, (SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS WHERE (TS.NAME = TP.TSNAME) AND (TS.DBNAME = TP.DBNAME) AND (TB.TSNAME = TS.NAME) AND (TB.DBNAME = TS.DBNAME) AND (TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X'))) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') LIMIT 10
----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT CHORUS_B.NAME, CHORUS_B.CREATOR, CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.TSNAME, CHORUS_B.CHILDREN, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.CLUSTERTYPE, CHORUS_B.NUM_DEP_MQTS, CHORUS_B.TYPE, CHORUS_B.RELCREATED, CHORUS_B.RECLENGTH, CHORUS_B.KEYCOLUMNS, CHORUS_B.SECURITY_LABEL, CHORUS_B.AUDITING, CHORUS_B.AVGROWLEN, CHORUS_B.CARD, CHORUS_B.COLCOUNT, CHORUS_B.OBID, CHORUS_B.NPAGESF, CHORUS_B.NPAGES, CHORUS_B.VALPROC, CHORUS_B.ENCODING_SCHEME, CHORUS_B.CHECKFLAG, CHORUS_B.PCTPAGES, CHORUS_B.TABLESTATUS, CHORUS_B.REMARKS, CHORUS_B.DATACAPTURE, CHORUS_B.IBMREQD, CHORUS_B.STATUS, CHORUS_B.PCTROWCOMP, CHORUS_B.SPLIT_ROWS, CHORUS_B.PARTKEYCOLNUM, CHORUS_B.CHECKRID, CHORUS_B.dsQuerySet, CHORUS_B.CLUSTERRID, CHORUS_B.PARENTS, CHORUS_B.SPACEF, CHORUS_B.LABEL, CHORUS_B.CREATEDTS, CHORUS_B.RBA1, CHORUS_B.RBA2, CHORUS_B.LOCATION, CHORUS_B.ALTEREDTS, CHORUS_B.CHECKRID5B, CHORUS_B.STATSTIME, CHORUS_B.KEYOBID, CHORUS_B.TBCREATOR, CHORUS_B.CARDF, CHORUS_B.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__" FROM (SELECT TB.* FROM DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, (SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS WHERE (TS.NAME = TP.TSNAME) AND (TS.DBNAME = TP.DBNAME) AND (TB.TSNAME = TS.NAME) AND (TB.DBNAME = TS.DBNAME) AND (TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X'))) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') LIMIT 10
CANONICAL PLAN:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.NAME, CHORUS_B.CREATOR, CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.TSNAME, CHORUS_B.CHILDREN, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.CLUSTERTYPE, CHORUS_B.NUM_DEP_MQTS, CHORUS_B.TYPE, CHORUS_B.RELCREATED, CHORUS_B.RECLENGTH, CHORUS_B.KEYCOLUMNS, CHORUS_B.SECURITY_LABEL, CHORUS_B.AUDITING, CHORUS_B.AVGROWLEN, CHORUS_B.CARD, CHORUS_B.COLCOUNT, CHORUS_B.OBID, CHORUS_B.NPAGESF, CHORUS_B.NPAGES, CHORUS_B.VALPROC, CHORUS_B.ENCODING_SCHEME, CHORUS_B.CHECKFLAG, CHORUS_B.PCTPAGES, CHORUS_B.TABLESTATUS, CHORUS_B.REMARKS, CHORUS_B.DATACAPTURE, CHORUS_B.IBMREQD, CHORUS_B.STATUS, CHORUS_B.PCTROWCOMP, CHORUS_B.SPLIT_ROWS, CHORUS_B.PARTKEYCOLNUM, CHORUS_B.CHECKRID, CHORUS_B.dsQuerySet, CHORUS_B.CLUSTERRID, CHORUS_B.PARENTS, CHORUS_B.SPACEF, CHORUS_B.LABEL, CHORUS_B.CREATEDTS, CHORUS_B.RBA1, CHORUS_B.RBA2, CHORUS_B.LOCATION, CHORUS_B.ALTEREDTS, CHORUS_B.CHECKRID5B, CHORUS_B.STATSTIME, CHORUS_B.KEYOBID, CHORUS_B.TBCREATOR, CHORUS_B.CARDF, CHORUS_B.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' 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 = 'DEFAULT'})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT TB.* FROM (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB CROSS JOIN (SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP) CROSS JOIN DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS WHERE (TS.NAME = TP.TSNAME) AND (TS.DBNAME = TP.DBNAME) AND (TB.TSNAME = TS.NAME) AND (TB.DBNAME = TS.DBNAME) AND (TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')), SYMBOL_MAP={CHORUS_B.dsConf=TB.dsConf, CHORUS_B.dsGroup=TB.dsGroup, CHORUS_B.dsQuerySet=TB.dsQuerySet, CHORUS_B.dsSystem=TB.dsSystem, CHORUS_B.dsSSID=TB.dsSSID, CHORUS_B.ALTEREDTS=TB.ALTEREDTS, CHORUS_B.AUDITING=TB.AUDITING, CHORUS_B.AVGROWLEN=TB.AVGROWLEN, CHORUS_B.CARD=TB.CARD, CHORUS_B.CARDF=TB.CARDF, CHORUS_B.CHECKFLAG=TB.CHECKFLAG, CHORUS_B.CHECKRID=TB.CHECKRID, CHORUS_B.CHECKRID5B=TB.CHECKRID5B, CHORUS_B.CHECKS=TB.CHECKS, CHORUS_B.CHILDREN=TB.CHILDREN, CHORUS_B.CLUSTERRID=TB.CLUSTERRID, CHORUS_B.CLUSTERTYPE=TB.CLUSTERTYPE, CHORUS_B.COLCOUNT=TB.COLCOUNT, CHORUS_B.CREATEDBY=TB.CREATEDBY, CHORUS_B.CREATEDTS=TB.CREATEDTS, CHORUS_B.CREATOR=TB.CREATOR, CHORUS_B.DATACAPTURE=TB.DATACAPTURE, CHORUS_B.DBID=TB.DBID, CHORUS_B.DBNAME=TB.DBNAME, CHORUS_B.EDPROC=TB.EDPROC, CHORUS_B.ENCODING_SCHEME=TB.ENCODING_SCHEME, CHORUS_B.IBMREQD=TB.IBMREQD, CHORUS_B.KEYCOLUMNS=TB.KEYCOLUMNS, CHORUS_B.KEYOBID=TB.KEYOBID, CHORUS_B.LABEL=TB.LABEL, CHORUS_B.LOCATION=TB.LOCATION, CHORUS_B.NAME=TB.NAME, CHORUS_B.NPAGES=TB.NPAGES, CHORUS_B.NPAGESF=TB.NPAGESF, CHORUS_B.NUM_DEP_MQTS=TB.NUM_DEP_MQTS, CHORUS_B.OBID=TB.OBID, CHORUS_B.PARENTS=TB.PARENTS, CHORUS_B.PARTKEYCOLNUM=TB.PARTKEYCOLNUM, CHORUS_B.PCTPAGES=TB.PCTPAGES, CHORUS_B.PCTROWCOMP=TB.PCTROWCOMP, CHORUS_B.RBA1=TB.RBA1, CHORUS_B.RBA2=TB.RBA2, CHORUS_B.RECLENGTH=TB.RECLENGTH, CHORUS_B.RELCREATED=TB.RELCREATED, CHORUS_B.REMARKS=TB.REMARKS, CHORUS_B.SECURITY_LABEL=TB.SECURITY_LABEL, CHORUS_B.SPACEF=TB.SPACEF, CHORUS_B.SPLIT_ROWS=TB.SPLIT_ROWS, CHORUS_B.STATSTIME=TB.STATSTIME, CHORUS_B.STATUS=TB.STATUS, CHORUS_B.TABLESTATUS=TB.TABLESTATUS, CHORUS_B.TBCREATOR=TB.TBCREATOR, CHORUS_B.TBNAME=TB.TBNAME, CHORUS_B.TSNAME=TB.TSNAME, CHORUS_B.TYPE=TB.TYPE, CHORUS_B.VALPROC=TB.VALPROC, CHORUS_B.VERSION=TB.VERSION}})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.dsConf, TB.dsGroup, TB.dsQuerySet, TB.dsSystem, TB.dsSSID, TB.ALTEREDTS, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.CARDF, TB.CHECKFLAG, TB.CHECKRID, TB.CHECKRID5B, TB.CHECKS, TB.CHILDREN, TB.CLUSTERRID, TB.CLUSTERTYPE, TB.COLCOUNT, TB.CREATEDBY, TB.CREATEDTS, TB.CREATOR, TB.DATACAPTURE, TB.DBID, TB.DBNAME, TB.EDPROC, TB.ENCODING_SCHEME, TB.IBMREQD, TB.KEYCOLUMNS, TB.KEYOBID, TB.LABEL, TB.LOCATION, TB.NAME, TB.NPAGES, TB.NPAGESF, TB.NUM_DEP_MQTS, TB.OBID, TB.PARENTS, TB.PARTKEYCOLNUM, TB.PCTPAGES, TB.PCTROWCOMP, TB.RBA1, TB.RBA2, TB.RECLENGTH, TB.RELCREATED, TB.REMARKS, TB.SECURITY_LABEL, TB.SPACEF, TB.SPLIT_ROWS, TB.STATSTIME, TB.STATUS, TB.TABLESTATUS, TB.TBCREATOR, TB.TBNAME, TB.TSNAME, TB.TYPE, TB.VALPROC, TB.VERSION]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=TB.DBNAME = TS.DBNAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=TB.TSNAME = TS.NAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={SELECT_CRITERIA=TS.DBNAME = TP.DBNAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING PlaceAccess
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.NAME, CHORUS_B.CREATOR, CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.TSNAME, CHORUS_B.CHILDREN, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.CLUSTERTYPE, CHORUS_B.NUM_DEP_MQTS, CHORUS_B.TYPE, CHORUS_B.RELCREATED, CHORUS_B.RECLENGTH, CHORUS_B.KEYCOLUMNS, CHORUS_B.SECURITY_LABEL, CHORUS_B.AUDITING, CHORUS_B.AVGROWLEN, CHORUS_B.CARD, CHORUS_B.COLCOUNT, CHORUS_B.OBID, CHORUS_B.NPAGESF, CHORUS_B.NPAGES, CHORUS_B.VALPROC, CHORUS_B.ENCODING_SCHEME, CHORUS_B.CHECKFLAG, CHORUS_B.PCTPAGES, CHORUS_B.TABLESTATUS, CHORUS_B.REMARKS, CHORUS_B.DATACAPTURE, CHORUS_B.IBMREQD, CHORUS_B.STATUS, CHORUS_B.PCTROWCOMP, CHORUS_B.SPLIT_ROWS, CHORUS_B.PARTKEYCOLNUM, CHORUS_B.CHECKRID, CHORUS_B.dsQuerySet, CHORUS_B.CLUSTERRID, CHORUS_B.PARENTS, CHORUS_B.SPACEF, CHORUS_B.LABEL, CHORUS_B.CREATEDTS, CHORUS_B.RBA1, CHORUS_B.RBA2, CHORUS_B.LOCATION, CHORUS_B.ALTEREDTS, CHORUS_B.CHECKRID5B, CHORUS_B.STATSTIME, CHORUS_B.KEYOBID, CHORUS_B.TBCREATOR, CHORUS_B.CARDF, CHORUS_B.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' 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 = 'DEFAULT'})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT TB.* FROM (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB CROSS JOIN (SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP) CROSS JOIN DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS WHERE (TS.NAME = TP.TSNAME) AND (TS.DBNAME = TP.DBNAME) AND (TB.TSNAME = TS.NAME) AND (TB.DBNAME = TS.DBNAME) AND (TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')), SYMBOL_MAP={CHORUS_B.dsConf=TB.dsConf, CHORUS_B.dsGroup=TB.dsGroup, CHORUS_B.dsQuerySet=TB.dsQuerySet, CHORUS_B.dsSystem=TB.dsSystem, CHORUS_B.dsSSID=TB.dsSSID, CHORUS_B.ALTEREDTS=TB.ALTEREDTS, CHORUS_B.AUDITING=TB.AUDITING, CHORUS_B.AVGROWLEN=TB.AVGROWLEN, CHORUS_B.CARD=TB.CARD, CHORUS_B.CARDF=TB.CARDF, CHORUS_B.CHECKFLAG=TB.CHECKFLAG, CHORUS_B.CHECKRID=TB.CHECKRID, CHORUS_B.CHECKRID5B=TB.CHECKRID5B, CHORUS_B.CHECKS=TB.CHECKS, CHORUS_B.CHILDREN=TB.CHILDREN, CHORUS_B.CLUSTERRID=TB.CLUSTERRID, CHORUS_B.CLUSTERTYPE=TB.CLUSTERTYPE, CHORUS_B.COLCOUNT=TB.COLCOUNT, CHORUS_B.CREATEDBY=TB.CREATEDBY, CHORUS_B.CREATEDTS=TB.CREATEDTS, CHORUS_B.CREATOR=TB.CREATOR, CHORUS_B.DATACAPTURE=TB.DATACAPTURE, CHORUS_B.DBID=TB.DBID, CHORUS_B.DBNAME=TB.DBNAME, CHORUS_B.EDPROC=TB.EDPROC, CHORUS_B.ENCODING_SCHEME=TB.ENCODING_SCHEME, CHORUS_B.IBMREQD=TB.IBMREQD, CHORUS_B.KEYCOLUMNS=TB.KEYCOLUMNS, CHORUS_B.KEYOBID=TB.KEYOBID, CHORUS_B.LABEL=TB.LABEL, CHORUS_B.LOCATION=TB.LOCATION, CHORUS_B.NAME=TB.NAME, CHORUS_B.NPAGES=TB.NPAGES, CHORUS_B.NPAGESF=TB.NPAGESF, CHORUS_B.NUM_DEP_MQTS=TB.NUM_DEP_MQTS, CHORUS_B.OBID=TB.OBID, CHORUS_B.PARENTS=TB.PARENTS, CHORUS_B.PARTKEYCOLNUM=TB.PARTKEYCOLNUM, CHORUS_B.PCTPAGES=TB.PCTPAGES, CHORUS_B.PCTROWCOMP=TB.PCTROWCOMP, CHORUS_B.RBA1=TB.RBA1, CHORUS_B.RBA2=TB.RBA2, CHORUS_B.RECLENGTH=TB.RECLENGTH, CHORUS_B.RELCREATED=TB.RELCREATED, CHORUS_B.REMARKS=TB.REMARKS, CHORUS_B.SECURITY_LABEL=TB.SECURITY_LABEL, CHORUS_B.SPACEF=TB.SPACEF, CHORUS_B.SPLIT_ROWS=TB.SPLIT_ROWS, CHORUS_B.STATSTIME=TB.STATSTIME, CHORUS_B.STATUS=TB.STATUS, CHORUS_B.TABLESTATUS=TB.TABLESTATUS, CHORUS_B.TBCREATOR=TB.TBCREATOR, CHORUS_B.TBNAME=TB.TBNAME, CHORUS_B.TSNAME=TB.TSNAME, CHORUS_B.TYPE=TB.TYPE, CHORUS_B.VALPROC=TB.VALPROC, CHORUS_B.VERSION=TB.VERSION}})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.dsConf, TB.dsGroup, TB.dsQuerySet, TB.dsSystem, TB.dsSSID, TB.ALTEREDTS, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.CARDF, TB.CHECKFLAG, TB.CHECKRID, TB.CHECKRID5B, TB.CHECKS, TB.CHILDREN, TB.CLUSTERRID, TB.CLUSTERTYPE, TB.COLCOUNT, TB.CREATEDBY, TB.CREATEDTS, TB.CREATOR, TB.DATACAPTURE, TB.DBID, TB.DBNAME, TB.EDPROC, TB.ENCODING_SCHEME, TB.IBMREQD, TB.KEYCOLUMNS, TB.KEYOBID, TB.LABEL, TB.LOCATION, TB.NAME, TB.NPAGES, TB.NPAGESF, TB.NUM_DEP_MQTS, TB.OBID, TB.PARENTS, TB.PARTKEYCOLNUM, TB.PCTPAGES, TB.PCTROWCOMP, TB.RBA1, TB.RBA2, TB.RECLENGTH, TB.RELCREATED, TB.REMARKS, TB.SECURITY_LABEL, TB.SPACEF, TB.SPLIT_ROWS, TB.STATSTIME, TB.STATUS, TB.TABLESTATUS, TB.TBCREATOR, TB.TBNAME, TB.TSNAME, TB.TYPE, TB.VALPROC, TB.VERSION]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=TB.DBNAME = TS.DBNAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=TB.TSNAME = TS.NAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={SELECT_CRITERIA=TS.DBNAME = TP.DBNAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING PushSelectCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.NAME, CHORUS_B.CREATOR, CHORUS_B.dsConf, CHORUS_B.dsGroup, CHORUS_B.dsSystem, CHORUS_B.dsSSID, CHORUS_B.TSNAME, CHORUS_B.CHILDREN, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.CLUSTERTYPE, CHORUS_B.NUM_DEP_MQTS, CHORUS_B.TYPE, CHORUS_B.RELCREATED, CHORUS_B.RECLENGTH, CHORUS_B.KEYCOLUMNS, CHORUS_B.SECURITY_LABEL, CHORUS_B.AUDITING, CHORUS_B.AVGROWLEN, CHORUS_B.CARD, CHORUS_B.COLCOUNT, CHORUS_B.OBID, CHORUS_B.NPAGESF, CHORUS_B.NPAGES, CHORUS_B.VALPROC, CHORUS_B.ENCODING_SCHEME, CHORUS_B.CHECKFLAG, CHORUS_B.PCTPAGES, CHORUS_B.TABLESTATUS, CHORUS_B.REMARKS, CHORUS_B.DATACAPTURE, CHORUS_B.IBMREQD, CHORUS_B.STATUS, CHORUS_B.PCTROWCOMP, CHORUS_B.SPLIT_ROWS, CHORUS_B.PARTKEYCOLNUM, CHORUS_B.CHECKRID, CHORUS_B.dsQuerySet, CHORUS_B.CLUSTERRID, CHORUS_B.PARENTS, CHORUS_B.SPACEF, CHORUS_B.LABEL, CHORUS_B.CREATEDTS, CHORUS_B.RBA1, CHORUS_B.RBA2, CHORUS_B.LOCATION, CHORUS_B.ALTEREDTS, CHORUS_B.CHECKRID5B, CHORUS_B.STATSTIME, CHORUS_B.KEYOBID, CHORUS_B.TBCREATOR, CHORUS_B.CARDF, CHORUS_B.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsSSID = ''})
Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsSystem = ''})
Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G'})
Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsConf = 'DEFAULT'})
Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT TB.* FROM (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB CROSS JOIN (SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP) CROSS JOIN DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS WHERE (TS.NAME = TP.TSNAME) AND (TS.DBNAME = TP.DBNAME) AND (TB.TSNAME = TS.NAME) AND (TB.DBNAME = TS.DBNAME) AND (TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')), SYMBOL_MAP={CHORUS_B.dsConf=TB.dsConf, CHORUS_B.dsGroup=TB.dsGroup, CHORUS_B.dsQuerySet=TB.dsQuerySet, CHORUS_B.dsSystem=TB.dsSystem, CHORUS_B.dsSSID=TB.dsSSID, CHORUS_B.ALTEREDTS=TB.ALTEREDTS, CHORUS_B.AUDITING=TB.AUDITING, CHORUS_B.AVGROWLEN=TB.AVGROWLEN, CHORUS_B.CARD=TB.CARD, CHORUS_B.CARDF=TB.CARDF, CHORUS_B.CHECKFLAG=TB.CHECKFLAG, CHORUS_B.CHECKRID=TB.CHECKRID, CHORUS_B.CHECKRID5B=TB.CHECKRID5B, CHORUS_B.CHECKS=TB.CHECKS, CHORUS_B.CHILDREN=TB.CHILDREN, CHORUS_B.CLUSTERRID=TB.CLUSTERRID, CHORUS_B.CLUSTERTYPE=TB.CLUSTERTYPE, CHORUS_B.COLCOUNT=TB.COLCOUNT, CHORUS_B.CREATEDBY=TB.CREATEDBY, CHORUS_B.CREATEDTS=TB.CREATEDTS, CHORUS_B.CREATOR=TB.CREATOR, CHORUS_B.DATACAPTURE=TB.DATACAPTURE, CHORUS_B.DBID=TB.DBID, CHORUS_B.DBNAME=TB.DBNAME, CHORUS_B.EDPROC=TB.EDPROC, CHORUS_B.ENCODING_SCHEME=TB.ENCODING_SCHEME, CHORUS_B.IBMREQD=TB.IBMREQD, CHORUS_B.KEYCOLUMNS=TB.KEYCOLUMNS, CHORUS_B.KEYOBID=TB.KEYOBID, CHORUS_B.LABEL=TB.LABEL, CHORUS_B.LOCATION=TB.LOCATION, CHORUS_B.NAME=TB.NAME, CHORUS_B.NPAGES=TB.NPAGES, CHORUS_B.NPAGESF=TB.NPAGESF, CHORUS_B.NUM_DEP_MQTS=TB.NUM_DEP_MQTS, CHORUS_B.OBID=TB.OBID, CHORUS_B.PARENTS=TB.PARENTS, CHORUS_B.PARTKEYCOLNUM=TB.PARTKEYCOLNUM, CHORUS_B.PCTPAGES=TB.PCTPAGES, CHORUS_B.PCTROWCOMP=TB.PCTROWCOMP, CHORUS_B.RBA1=TB.RBA1, CHORUS_B.RBA2=TB.RBA2, CHORUS_B.RECLENGTH=TB.RECLENGTH, CHORUS_B.RELCREATED=TB.RELCREATED, CHORUS_B.REMARKS=TB.REMARKS, CHORUS_B.SECURITY_LABEL=TB.SECURITY_LABEL, CHORUS_B.SPACEF=TB.SPACEF, CHORUS_B.SPLIT_ROWS=TB.SPLIT_ROWS, CHORUS_B.STATSTIME=TB.STATSTIME, CHORUS_B.STATUS=TB.STATUS, CHORUS_B.TABLESTATUS=TB.TABLESTATUS, CHORUS_B.TBCREATOR=TB.TBCREATOR, CHORUS_B.TBNAME=TB.TBNAME, CHORUS_B.TSNAME=TB.TSNAME, CHORUS_B.TYPE=TB.TYPE, CHORUS_B.VALPROC=TB.VALPROC, CHORUS_B.VERSION=TB.VERSION}})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.dsConf, TB.dsGroup, TB.dsQuerySet, TB.dsSystem, TB.dsSSID, TB.ALTEREDTS, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.CARDF, TB.CHECKFLAG, TB.CHECKRID, TB.CHECKRID5B, TB.CHECKS, TB.CHILDREN, TB.CLUSTERRID, TB.CLUSTERTYPE, TB.COLCOUNT, TB.CREATEDBY, TB.CREATEDTS, TB.CREATOR, TB.DATACAPTURE, TB.DBID, TB.DBNAME, TB.EDPROC, TB.ENCODING_SCHEME, TB.IBMREQD, TB.KEYCOLUMNS, TB.KEYOBID, TB.LABEL, TB.LOCATION, TB.NAME, TB.NPAGES, TB.NPAGESF, TB.NUM_DEP_MQTS, TB.OBID, TB.PARENTS, TB.PARTKEYCOLNUM, TB.PCTPAGES, TB.PCTROWCOMP, TB.RBA1, TB.RBA2, TB.RECLENGTH, TB.RELCREATED, TB.REMARKS, TB.SECURITY_LABEL, TB.SPACEF, TB.SPLIT_ROWS, TB.STATSTIME, TB.STATUS, TB.TABLESTATUS, TB.TBCREATOR, TB.TBNAME, TB.TSNAME, TB.TYPE, TB.VALPROC, TB.VERSION]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING MergeVirtual
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSSID = ''})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSystem = ''})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsGroup = 'DA0G'})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsConf = 'DEFAULT'})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING PushNonJoinCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSSID = ''})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSystem = ''})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsGroup = 'DA0G'})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsConf = 'DEFAULT'})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING CopyCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSSID = ''})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSystem = ''})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TB.dsGroup = 'DA0G'})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TB.dsConf = 'DEFAULT'})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={IS_COPIED=true, JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={IS_COPIED=true, JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING CleanCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={IS_COPIED=true, JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={IS_COPIED=true, JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING RaiseAccess
cannot push dupremove, since distinct is not supported by source DupRemoval(groups=[]
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={IS_COPIED=true, JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={IS_COPIED=true, JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB])
Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[])
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])
============================================================================
EXECUTING PlanJoins
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_SELECTIVITY=0.12577777, SELECT_CRITERIA=TB.DBNAME = TS.DBNAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_SELECTIVITY=0.12577777, SELECT_CRITERIA=TB.TSNAME = TS.NAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_SELECTIVITY=0.12577777, SELECT_CRITERIA=TS.DBNAME = TP.DBNAME})
Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_SELECTIVITY=0.12577777, SELECT_CRITERIA=TS.NAME = TP.TSNAME})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PushSelectCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING RaiseAccess
cannot push dupremove, since distinct is not supported by source DupRemoval(groups=[], props={EST_CARDINALITY=-1.0}
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ChooseJoinStrategy
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], JOIN_STRATEGY=MERGE, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ChooseDependent
Rejecting dependent access node as parent join is CROSS or FULL OUTER: Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0}
Rejecting dependent access node as parent join is CROSS or FULL OUTER: Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}}
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], JOIN_STRATEGY=MERGE, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PushLimit
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], JOIN_STRATEGY=MERGE, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING CalculateCost
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=10.0, PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, EST_CARDINALITY=10.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, EST_CARDINALITY=-1.0, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], JOIN_STRATEGY=MERGE, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"], EST_CARDINALITY=10.0, PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=10.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=-1.0, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], JOIN_STRATEGY=MERGE, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, OUTPUT_COLS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Source(groups=[TP], props={OUTPUT_COLS=[TP.STORNAME, TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ImplementJoinStrategy
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"], EST_CARDINALITY=10.0, PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=10.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=-1.0, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, OUTPUT_COLS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Source(groups=[TP], props={OUTPUT_COLS=[TP.STORNAME, TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
Sort(groups=[], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], SORT_ORDER=ORDER BY TS.NAME NULLS FIRST, TS.DBNAME NULLS FIRST})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING MergeCriteria
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"], EST_CARDINALITY=10.0, PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=10.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=-1.0, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, OUTPUT_COLS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Source(groups=[TP], props={OUTPUT_COLS=[TP.STORNAME, TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
DupRemoval(groups=[], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
Sort(groups=[], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], SORT_ORDER=ORDER BY TS.NAME NULLS FIRST, TS.DBNAME NULLS FIRST})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PlanSorts
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"], EST_CARDINALITY=10.0, PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=10.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=-1.0, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, OUTPUT_COLS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0})
Source(groups=[TP], props={OUTPUT_COLS=[TP.STORNAME, TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
Sort(groups=[], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], IS_DUP_REMOVAL=true, EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, PROJECT_COLS=[STORNAME, DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
Sort(groups=[], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], SORT_ORDER=ORDER BY TS.NAME NULLS FIRST, TS.DBNAME NULLS FIRST})
Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING CollapseSource
AFTER:
Project(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"], EST_CARDINALITY=10.0, PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=10.0})
Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={LEFT_EXPRESSIONS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME], JOIN_TYPE=INNER JOIN, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME], EST_CARDINALITY=-1.0, RIGHT_EXPRESSIONS=[TS.NAME, TS.DBNAME, TS.NAME, TS.DBNAME], SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, NON_EQUI_JOIN_CRITERIA=[], JOIN_CRITERIA=[TS.NAME = TP.TSNAME, TS.DBNAME = TP.DBNAME, TB.TSNAME = TS.NAME, TB.DBNAME = TS.DBNAME]})
Join(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB, TP], props={JOIN_TYPE=CROSS JOIN, OUTPUT_COLS=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, JOIN_STRATEGY=NESTED_LOOP})
Select(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={IS_COPIED=true, OUTPUT_COLS=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, SELECT_CRITERIA=TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')})
Access(groups=[DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF FROM DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase AS TB WHERE (TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '')})
Source(groups=[TP], props={OUTPUT_COLS=[TP.STORNAME, TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0, NESTED_COMMAND=SELECT DISTINCT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.STORNAME=STORNAME, TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}})
Sort(groups=[], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], IS_DUP_REMOVAL=true, EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT STORNAME, DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG'})
Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:683b4f37-cd64-404d-a7db-d20da46b4d69, OUTPUT_COLS=[TS.NAME, TS.DBNAME], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT TS.NAME, TS.DBNAME FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS ORDER BY TS.NAME NULLS FIRST, TS.DBNAME NULLS FIRST})
============================================================================
CONVERTING PLAN TREE TO PROCESS TREE
PROCESS PLAN =
ProjectNode(1) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"] [TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]
LimitNode(2) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME] limit 10
JoinNode(3) [PARTITIONED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[TP.TSNAME=TS.NAME, TP.DBNAME=TS.DBNAME, TB.TSNAME=TS.NAME, TB.DBNAME=TS.DBNAME] output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME]
JoinNode(4) [NESTED LOOP JOIN] [CROSS JOIN] output=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF]
SelectNode(5) output=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF] TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')
AccessNode(6) output=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF] SELECT DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TYPE, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TSNAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.DBNAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CREATOR, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsConf, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsGroup, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSystem, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSSID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHILDREN, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.DBID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CREATEDBY, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.EDPROC, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.VERSION, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TBNAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CLUSTERTYPE, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NUM_DEP_MQTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RELCREATED, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RECLENGTH, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.KEYCOLUMNS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.SECURITY_LABEL, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.AUDITING, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.AVGROWLEN, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CARD, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.COLCOUNT, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.OBID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NPAGESF, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NPAGES, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.VALPROC, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.ENCODING_SCHEME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKFLAG, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PCTPAGES, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TABLESTATUS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.REMARKS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.DATACAPTURE, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.IBMREQD, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.STATUS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PCTROWCOMP, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.SPLIT_ROWS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PARTKEYCOLNUM, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKRID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsQuerySet, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CLUSTERRID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PARENTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.SPACEF, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.LABEL, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CREATEDTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RBA1, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RBA2, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.LOCATION, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.ALTEREDTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKRID5B, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.STATSTIME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.KEYOBID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TBCREATOR, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CARDF FROM DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase WHERE (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsConf = 'DEFAULT') AND (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsGroup = 'DA0G') AND (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSystem = '') AND (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSSID = '')
SortNode(7) output=[TP.STORNAME, TP.DBNAME, TP.TSNAME] [DUP_REMOVE_SORT] null
AccessNode(8) output=[STORNAME, DBNAME, TSNAME] SELECT DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.STORNAME, DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.DBNAME, DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.STORNAME = 'PTSG'
AccessNode(9) output=[TS.NAME, TS.DBNAME] SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.NAME, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.DBNAME FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase ORDER BY DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.NAME NULLS FIRST, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.DBNAME NULLS FIRST
============================================================================
----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(1) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"] [TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME, 'DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase' AS "__objecttype__"]
LimitNode(2) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME] limit 10
JoinNode(3) [PARTITIONED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[TP.TSNAME=TS.NAME, TP.DBNAME=TS.DBNAME, TB.TSNAME=TS.NAME, TB.DBNAME=TS.DBNAME] output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF, TB.DBNAME]
JoinNode(4) [NESTED LOOP JOIN] [CROSS JOIN] output=[TP.TSNAME, TP.DBNAME, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF]
SelectNode(5) output=[TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.TYPE, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF] TB.TYPE IN ('C', 'G', 'M', 'P', 'T', 'X')
AccessNode(6) output=[TB.TYPE, TB.TSNAME, TB.DBNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.CHILDREN, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.CLUSTERTYPE, TB.NUM_DEP_MQTS, TB.RELCREATED, TB.RECLENGTH, TB.KEYCOLUMNS, TB.SECURITY_LABEL, TB.AUDITING, TB.AVGROWLEN, TB.CARD, TB.COLCOUNT, TB.OBID, TB.NPAGESF, TB.NPAGES, TB.VALPROC, TB.ENCODING_SCHEME, TB.CHECKFLAG, TB.PCTPAGES, TB.TABLESTATUS, TB.REMARKS, TB.DATACAPTURE, TB.IBMREQD, TB.STATUS, TB.PCTROWCOMP, TB.SPLIT_ROWS, TB.PARTKEYCOLNUM, TB.CHECKRID, TB.dsQuerySet, TB.CLUSTERRID, TB.PARENTS, TB.SPACEF, TB.LABEL, TB.CREATEDTS, TB.RBA1, TB.RBA2, TB.LOCATION, TB.ALTEREDTS, TB.CHECKRID5B, TB.STATSTIME, TB.KEYOBID, TB.TBCREATOR, TB.CARDF] SELECT DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TYPE, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TSNAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.DBNAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CREATOR, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsConf, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsGroup, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSystem, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSSID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHILDREN, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.DBID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CREATEDBY, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.EDPROC, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.VERSION, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TBNAME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CLUSTERTYPE, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NUM_DEP_MQTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RELCREATED, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RECLENGTH, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.KEYCOLUMNS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.SECURITY_LABEL, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.AUDITING, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.AVGROWLEN, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CARD, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.COLCOUNT, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.OBID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NPAGESF, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.NPAGES, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.VALPROC, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.ENCODING_SCHEME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKFLAG, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PCTPAGES, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TABLESTATUS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.REMARKS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.DATACAPTURE, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.IBMREQD, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.STATUS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PCTROWCOMP, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.SPLIT_ROWS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PARTKEYCOLNUM, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKRID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsQuerySet, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CLUSTERRID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.PARENTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.SPACEF, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.LABEL, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CREATEDTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RBA1, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.RBA2, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.LOCATION, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.ALTEREDTS, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CHECKRID5B, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.STATSTIME, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.KEYOBID, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.TBCREATOR, DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.CARDF FROM DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase WHERE (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsConf = 'DEFAULT') AND (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsGroup = 'DA0G') AND (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSystem = '') AND (DBMzDB2c.CAT_SYSTABLES_Rbase_Vbase.dsSSID = '')
SortNode(7) output=[TP.STORNAME, TP.DBNAME, TP.TSNAME] [DUP_REMOVE_SORT] null
AccessNode(8) output=[STORNAME, DBNAME, TSNAME] SELECT DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.STORNAME, DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.DBNAME, DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase.STORNAME = 'PTSG'
AccessNode(9) output=[TS.NAME, TS.DBNAME] SELECT DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.NAME, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.DBNAME FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase ORDER BY DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.NAME NULLS FIRST, DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase.DBNAME NULLS FIRST
============================================================================