Hi Ramesh,
I am facing this problem again. I am not sure what the problem is
Please help me in solving this problem
I found the following from the PLAN
EXECUTING RaiseAccess
cannot push dupremove, since distinct is not supported by source DupRemoval(groups=[], props={EST_CARDINALITY=-1.0}
The following is my execution factory class
==========================================================================================================
@Translator(name="db2tools-catalog")
public class DB2ToolsCatalogExecutionFactory extends CoptdsExecutionFactory {
public DB2ToolsCatalogExecutionFactory() {
}
@Override
public void start() throws TranslatorException {
super.start();
super.setSupportsOuterJoins(true);
super.setSupportsFullOuterJoins(true);
super.setSupportsInnerJoins(true);
super.setSupportsOrderBy(true);
super.setSupportsSelectDistinct(true);
setSupportsSelectDistinct(true);
}
@Override
public ResultSetExecution createResultSetExecution(QueryExpression command, ExecutionContext executionContext, RuntimeMetadata metadata, CoptdsConnection connection) throws TranslatorException {
return super.createResultSetExecution(command, executionContext, metadata, connection);
}
@Override
public void getMetadata(MetadataFactory metadataFactory, CoptdsConnection connection) throws TranslatorException {
Map<String,Schema> schemaMap=metadataFactory.getMetadataStore().getSchemas();
Set<String> keySet=schemaMap.keySet();
Iterator<String> iterator=keySet.iterator();
MetadataCreator creator=new MetadataCreator();
while(iterator.hasNext()){
String schemaName=iterator.next();
creator.loadMetadata(metadataFactory,"DBMzDB2-cat-property.txt");
}
}
@Override
public boolean supportsAggregatesAvg()
{
return true;
}
@Override
public boolean supportsAggregatesDistinct()
{
return true;
}
@Override
public boolean supportsAggregatesCountStar()
{
return true;
}
@Override
public boolean supportsBetweenCriteria()
{
return true;
}
@Override
public boolean supportsLikeCriteria()
{
return true;
}
@Override
public boolean supportsNotCriteria()
{
return true;
}
@Override
public boolean supportsRowLimit()
{
return true;
}
@Override
public boolean supportsRowOffset()
{
return true;
}
@Override
public boolean supportsAggregatesCount()
{
return true;
}
// @Override
// public boolean supportsOrderByNullOrdering()
// {
// return true;
// }
@Override
public boolean supportsOrderByUnrelated()
{
return true;
}
@Override
public boolean supportsInCriteria()
{
return true;
}
@Override
public boolean supportsInlineViews()
{
return true;
}
// -- rokan01 --
@Override
public boolean supportsAliasedTable()
{
return true;
}
@Override
public boolean supportsSelfJoins()
{
return true;
}
@Override
public boolean supportsUnions()
{
return true;
}
@Override
public boolean supportsCompareCriteriaOrdered()
{
return true;
}
@Override
public boolean supportsCompareCriteriaEquals()
{
return true;
}
@Override
public boolean supportsLikeCriteriaEscapeCharacter()
{
return true;
}
@Override
public boolean supportsInCriteriaSubquery()
{
return true;
}
@Override
public boolean supportsIsNullCriteria()
{
return true;
}
@Override
public boolean supportsOrCriteria()
{
return true;
}
@Override
public boolean supportsExistsCriteria()
{
return true;
}
@Override
public boolean supportsQuantifiedCompareCriteriaAll()
{
return true;
}
@Override
public boolean supportsQuantifiedCompareCriteriaSome()
{
return true;
}
// @Override
// public boolean supportsGroupBy()
// {
// return true;
// }
@Override
public boolean supportsHaving()
{
return true;
}
@Override
public boolean supportsAggregatesMax()
{
return true;
}
@Override
public boolean supportsAggregatesMin()
{
return true;
}
@Override
public boolean supportsAggregatesSum()
{
return true;
}
@Override
public boolean supportsAggregatesEnhancedNumeric()
{
return true;
}
@Override
public boolean supportsCorrelatedSubqueries()
{
return true;
}
@Override
public boolean supportsCaseExpressions()
{
return true;
}
@Override
public boolean supportsIntersect()
{
return true;
}
@Override
public boolean supportsExcept()
{
return true;
}
@Override
public boolean supportsInsertWithQueryExpression()
{
return true;
}
@Override
public boolean supportsFunctionsInGroupBy()
{
return true;
}
@Override
public boolean supportsCommonTableExpressions()
{
return true;
}
@Override
public boolean supportsScalarSubqueries()
{
return true;
}
@Override
public boolean supportsSearchedCaseExpressions()
{
return true;
}
}
=========================================================================================================
The following is the PLAN for the SQL
============================================================================
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.APPEND, CHORUS_B.CHILDREN, CHORUS_B.OWNER, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__" FROM (SELECT TB.* FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, (SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE (TB.DBNAME = TP.DBNAME) AND (TB.TSNAME = TP.TSNAME)) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') AND (CHORUS_B.dsQuerySet = '1') LIMIT 100
----------------------------------------------------------------------------
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.APPEND, CHORUS_B.CHILDREN, CHORUS_B.OWNER, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__" FROM (SELECT TB.* FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, (SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE (TB.DBNAME = TP.DBNAME) AND (TB.TSNAME = TP.TSNAME)) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') AND (CHORUS_B.dsQuerySet = '1') LIMIT 100
----------------------------------------------------------------------------
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.APPEND, CHORUS_B.CHILDREN, CHORUS_B.OWNER, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__" FROM (SELECT TB.* FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, (SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE (TB.DBNAME = TP.DBNAME) AND (TB.TSNAME = TP.TSNAME)) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '') AND (CHORUS_B.dsQuerySet = '1') LIMIT 100
CANONICAL PLAN:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
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.APPEND, CHORUS_B.CHILDREN, CHORUS_B.OWNER, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsQuerySet = '1'})
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={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.APPEND=TB.APPEND, 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.OWNER=TB.OWNER, CHORUS_B.OWNERTYPE=TB.OWNERTYPE, 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}, NESTED_COMMAND=SELECT TB.* FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB CROSS JOIN (SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE (TB.DBNAME = TP.DBNAME) AND (TB.TSNAME = TP.TSNAME)})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.dsConf, TB.dsGroup, TB.dsQuerySet, TB.dsSystem, TB.dsSSID, TB.ALTEREDTS, TB.APPEND, 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.OWNER, TB.OWNERTYPE, 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_TABLES_Rbase_V091 AS TB, TP], props={SELECT_CRITERIA=TB.TSNAME = TP.TSNAME})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={SELECT_CRITERIA=TB.DBNAME = TP.DBNAME})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING PlaceAccess
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
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.APPEND, CHORUS_B.CHILDREN, CHORUS_B.OWNER, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsQuerySet = '1'})
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={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.APPEND=TB.APPEND, 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.OWNER=TB.OWNER, CHORUS_B.OWNERTYPE=TB.OWNERTYPE, 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}, NESTED_COMMAND=SELECT TB.* FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB CROSS JOIN (SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE (TB.DBNAME = TP.DBNAME) AND (TB.TSNAME = TP.TSNAME)})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.dsConf, TB.dsGroup, TB.dsQuerySet, TB.dsSystem, TB.dsSSID, TB.ALTEREDTS, TB.APPEND, 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.OWNER, TB.OWNERTYPE, 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_TABLES_Rbase_V091 AS TB, TP], props={SELECT_CRITERIA=TB.TSNAME = TP.TSNAME})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={SELECT_CRITERIA=TB.DBNAME = TP.DBNAME})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING PushSelectCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
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.APPEND, CHORUS_B.CHILDREN, CHORUS_B.OWNER, CHORUS_B.CHECKS, CHORUS_B.DBID, CHORUS_B.CREATEDBY, CHORUS_B.EDPROC, CHORUS_B.VERSION, CHORUS_B.TBNAME, CHORUS_B.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsQuerySet = '1'})
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={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.APPEND=TB.APPEND, 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.OWNER=TB.OWNER, CHORUS_B.OWNERTYPE=TB.OWNERTYPE, 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}, NESTED_COMMAND=SELECT TB.* FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB CROSS JOIN (SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG') AS TP WHERE (TB.DBNAME = TP.DBNAME) AND (TB.TSNAME = TP.TSNAME)})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.dsConf, TB.dsGroup, TB.dsQuerySet, TB.dsSystem, TB.dsSSID, TB.ALTEREDTS, TB.APPEND, 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.OWNER, TB.OWNERTYPE, 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_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1')})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING MergeVirtual
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsQuerySet = '1'})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSSID = ''})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSystem = ''})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsGroup = 'DA0G'})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsConf = 'DEFAULT'})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1')})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING PushNonJoinCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsQuerySet = '1'})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSSID = ''})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSystem = ''})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsGroup = 'DA0G'})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsConf = 'DEFAULT'})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1')})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG'})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING CopyCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsQuerySet = '1', IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSSID = '', IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsSystem = '', IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsGroup = 'DA0G', IS_COPIED=true})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={IS_PHANTOM=true, SELECT_CRITERIA=TB.dsConf = 'DEFAULT', IS_COPIED=true})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, IS_COPIED=true, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING CleanCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, IS_COPIED=true, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING RaiseAccess
cannot push dupremove, since distinct is not supported by source DupRemoval(groups=[]
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, IS_COPIED=true, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB])
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG'})
DupRemoval(groups=[])
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME]})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091])
============================================================================
EXECUTING PlanJoins
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={EST_SELECTIVITY=0.12577777, SELECT_CRITERIA=TB.TSNAME = TP.TSNAME})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={EST_SELECTIVITY=0.12577777, SELECT_CRITERIA=TB.DBNAME = TP.DBNAME})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PushSelectCriteria
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], 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=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ChooseJoinStrategy
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ChooseDependent
AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PushLimit
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING CalculateCost
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, EST_CARDINALITY=100.0})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], EST_CARDINALITY=-1.0, NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={EST_CARDINALITY=-1.0})
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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=100.0})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], JOIN_STRATEGY=MERGE, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], EST_CARDINALITY=-1.0, NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.dsQuerySet, TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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.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={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', OUTPUT_COLS=[TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[DBNAME, TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ImplementJoinStrategy
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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=100.0})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], SORT_RIGHT=SORT, SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], EST_CARDINALITY=-1.0, NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.dsQuerySet, TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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.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={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', OUTPUT_COLS=[TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[DBNAME, TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING MergeCriteria
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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=100.0})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], SORT_RIGHT=SORT, SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], EST_CARDINALITY=-1.0, NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.dsQuerySet, TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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.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={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', OUTPUT_COLS=[TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0})
DupRemoval(groups=[], props={OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[DBNAME, TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING PlanSorts
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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=100.0})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], SORT_RIGHT=SORT_DISTINCT, SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], EST_CARDINALITY=-1.0, NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={SELECT_CRITERIA=(TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={OUTPUT_COLS=[TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.dsQuerySet, TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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.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={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', OUTPUT_COLS=[TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={PROJECT_COLS=[DBNAME, TSNAME], OUTPUT_COLS=[DBNAME, TSNAME], EST_CARDINALITY=-1.0})
Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[DBNAME, TSNAME], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={OUTPUT_COLS=[STORNAME, DBNAME, TSNAME], EST_CARDINALITY=-1.0})
============================================================================
EXECUTING CollapseSource
AFTER:
Project(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={PROJECT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"], EST_CARDINALITY=100.0})
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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=100.0})
Join(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB, TP], props={RIGHT_EXPRESSIONS=[TP.DBNAME, TP.TSNAME], JOIN_TYPE=INNER JOIN, LEFT_EXPRESSIONS=[TB.DBNAME, TB.TSNAME], SORT_RIGHT=SORT_DISTINCT, SORT_LEFT=SORT, JOIN_STRATEGY=PARTITIONED_SORT, OUTPUT_COLS=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], JOIN_CRITERIA=[TB.DBNAME = TP.DBNAME, TB.TSNAME = TP.TSNAME], EST_CARDINALITY=-1.0, NON_EQUI_JOIN_CRITERIA=[]})
Access(groups=[DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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], ATOMIC_REQUEST=SELECT TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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 FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS TB WHERE (TB.dsConf = 'DEFAULT') AND (TB.dsGroup = 'DA0G') AND (TB.dsSystem = '') AND (TB.dsSSID = '') AND (TB.dsQuerySet = '1'), EST_CARDINALITY=-1.0})
Source(groups=[TP], props={SYMBOL_MAP={TP.DBNAME=DBNAME, TP.TSNAME=TSNAME}, NESTED_COMMAND=SELECT DISTINCT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', OUTPUT_COLS=[TP.DBNAME, TP.TSNAME], EST_CARDINALITY=-1.0})
Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:11ec977d-21c9-46dd-a7bc-89935bc4d2bc, OUTPUT_COLS=[DBNAME, TSNAME], ATOMIC_REQUEST=SELECT DBNAME, TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 WHERE STORNAME = 'PTSG', EST_CARDINALITY=-1.0})
============================================================================
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.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"] [TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]
LimitNode(2) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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 100
JoinNode(3) [PARTITIONED SORT JOIN (SORT/SORT_DISTINCT)] [INNER JOIN] criteria=[TB.DBNAME=TP.DBNAME, TB.TSNAME=TP.TSNAME] output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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]
AccessNode(4) output=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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] SELECT g_0.DBNAME, g_0.TSNAME, g_0.NAME, g_0.CREATOR, g_0.dsConf, g_0.dsGroup, g_0.dsSystem, g_0.dsSSID, g_0.APPEND, g_0.CHILDREN, g_0.OWNER, g_0.CHECKS, g_0.DBID, g_0.CREATEDBY, g_0.EDPROC, g_0.VERSION, g_0.TBNAME, g_0.OWNERTYPE, g_0.CLUSTERTYPE, g_0.NUM_DEP_MQTS, g_0.TYPE, g_0.RELCREATED, g_0.RECLENGTH, g_0.KEYCOLUMNS, g_0.SECURITY_LABEL, g_0.AUDITING, g_0.AVGROWLEN, g_0.CARD, g_0.COLCOUNT, g_0.OBID, g_0.NPAGESF, g_0.NPAGES, g_0.VALPROC, g_0.ENCODING_SCHEME, g_0.CHECKFLAG, g_0.PCTPAGES, g_0.TABLESTATUS, g_0.REMARKS, g_0.DATACAPTURE, g_0.IBMREQD, g_0.STATUS, g_0.PCTROWCOMP, g_0.SPLIT_ROWS, g_0.PARTKEYCOLNUM, g_0.CHECKRID, g_0.dsQuerySet, g_0.CLUSTERRID, g_0.PARENTS, g_0.SPACEF, g_0.LABEL, g_0.CREATEDTS, g_0.RBA1, g_0.RBA2, g_0.LOCATION, g_0.ALTEREDTS, g_0.CHECKRID5B, g_0.STATSTIME, g_0.KEYOBID, g_0.TBCREATOR, g_0.CARDF FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS g_0 WHERE (g_0.dsConf = 'DEFAULT') AND (g_0.dsGroup = 'DA0G') AND (g_0.dsSystem = '') AND (g_0.dsSSID = '') AND (g_0.dsQuerySet = '1')
AccessNode(5) output=[TP.DBNAME, TP.TSNAME] SELECT g_0.DBNAME, g_0.TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 AS g_0 WHERE g_0.STORNAME = 'PTSG'
============================================================================
----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(1) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"] [TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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_TABLES_Rbase_V091' AS "__objecttype__"]
LimitNode(2) output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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 100
JoinNode(3) [PARTITIONED SORT JOIN (SORT/SORT_DISTINCT)] [INNER JOIN] criteria=[TB.DBNAME=TP.DBNAME, TB.TSNAME=TP.TSNAME] output=[TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.TSNAME, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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]
AccessNode(4) output=[TB.DBNAME, TB.TSNAME, TB.NAME, TB.CREATOR, TB.dsConf, TB.dsGroup, TB.dsSystem, TB.dsSSID, TB.APPEND, TB.CHILDREN, TB.OWNER, TB.CHECKS, TB.DBID, TB.CREATEDBY, TB.EDPROC, TB.VERSION, TB.TBNAME, TB.OWNERTYPE, 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] SELECT g_0.DBNAME, g_0.TSNAME, g_0.NAME, g_0.CREATOR, g_0.dsConf, g_0.dsGroup, g_0.dsSystem, g_0.dsSSID, g_0.APPEND, g_0.CHILDREN, g_0.OWNER, g_0.CHECKS, g_0.DBID, g_0.CREATEDBY, g_0.EDPROC, g_0.VERSION, g_0.TBNAME, g_0.OWNERTYPE, g_0.CLUSTERTYPE, g_0.NUM_DEP_MQTS, g_0.TYPE, g_0.RELCREATED, g_0.RECLENGTH, g_0.KEYCOLUMNS, g_0.SECURITY_LABEL, g_0.AUDITING, g_0.AVGROWLEN, g_0.CARD, g_0.COLCOUNT, g_0.OBID, g_0.NPAGESF, g_0.NPAGES, g_0.VALPROC, g_0.ENCODING_SCHEME, g_0.CHECKFLAG, g_0.PCTPAGES, g_0.TABLESTATUS, g_0.REMARKS, g_0.DATACAPTURE, g_0.IBMREQD, g_0.STATUS, g_0.PCTROWCOMP, g_0.SPLIT_ROWS, g_0.PARTKEYCOLNUM, g_0.CHECKRID, g_0.dsQuerySet, g_0.CLUSTERRID, g_0.PARENTS, g_0.SPACEF, g_0.LABEL, g_0.CREATEDTS, g_0.RBA1, g_0.RBA2, g_0.LOCATION, g_0.ALTEREDTS, g_0.CHECKRID5B, g_0.STATSTIME, g_0.KEYOBID, g_0.TBCREATOR, g_0.CARDF FROM DBMzDB2c.CAT_TABLES_Rbase_V091 AS g_0 WHERE (g_0.dsConf = 'DEFAULT') AND (g_0.dsGroup = 'DA0G') AND (g_0.dsSystem = '') AND (g_0.dsSSID = '') AND (g_0.dsQuerySet = '1')
AccessNode(5) output=[TP.DBNAME, TP.TSNAME] SELECT g_0.DBNAME, g_0.TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_V091 AS g_0 WHERE g_0.STORNAME = 'PTSG'
============================================================================
Thanks,
Rakesh