Sub-query in Where Clause support

[rakeshsagar]

Hi,

Does Teiid support Sub-Query in the Where Clause?

I have the following SQL:

select CHORUS_B."LOCATION", CHORUS_B."COLLID", CHORUS_B."NAME", CHORUS_B."CONTOKEN", CHORUS_B."SEQNO", CHORUS_B."STMTNO", CHORUS_B."SECTNO", CHORUS_B."dsConf", CHORUS_B."dsGroup", CHORUS_B."dsSystem", CHORUS_B."dsSSID", CHORUS_B."BINDERROR", CHORUS_B."IBMREQD", CHORUS_B."VERSION", CHORUS_B."STMT", CHORUS_B."ISOLATION", CHORUS_B."STATUS", CHORUS_B."ACCESSPATH", CHORUS_B."STMTNOI", CHORUS_B."SECTNOI", CHORUS_B."EXPLAINABLE", CHORUS_B."QUERYNO", (select count(*) from (select * from chorus_notes.RETRIEVE_NOTES where OBJECT_PKEY = xmlserialize(xmlelement("DBMzDB2c.CAT_SYSPACKSTMT_Rbase_Vbase", XMLATTRIBUTES(convert(CHORUS_B."LOCATION", String) as "LOCATION",convert(CHORUS_B."COLLID", String) as "COLLID",convert(CHORUS_B."NAME", String) as "NAME",convert(CHORUS_B."CONTOKEN", String) as "CONTOKEN",convert(CHORUS_B."SEQNO", String) as "SEQNO",convert(CHORUS_B."STMTNO", String) as "STMTNO",convert(CHORUS_B."SECTNO", String) as "SECTNO",convert(CHORUS_B."dsConf", String) as "dsConf",convert(CHORUS_B."dsGroup", String) as "dsGroup",convert(CHORUS_B."dsSystem", String) as "dsSystem",convert(CHORUS_B."dsSSID", String) as "dsSSID")) as String)) as foo) as CHORUS_C_notesForObject, CHORUS_B."dsQuerySet" ,'DBMzDB2c.CAT_SYSPACKSTMT_Rbase_Vbase' as "__objecttype__" from (select PS.* from DBMzDB2c.CAT_SYSPACKSTMT_Rbase_Vbase PS where PS.LOCATION = '' and PS.COLLID = 'undefined' and PS.NAME = 'undefined' and PS.CONTOKEN = (SELECT CONTOKEN FROM DBMzDB2c.CAT_SYSPACKAGE_Rbase_Vbase where LOCATION = '' and COLLID = 'undefined' and NAME = 'undefined' and VERSION = '')) CHORUS_B where CHORUS_B.dsConf='PRD6600' and CHORUS_B.dsGroup='' and CHORUS_B.dsSystem='CA31' and CHORUS_B.dsSSID='D81A'    LIMIT 100

Teiid is breaking the SQL into two parts and sending one SQL at a time to the translator.

The first query is marked in RED and the rest of the query is the remaining query.

I am using Teiid 7.3 and added all the supports that Teiid says that it supports.

Please let me know if this is supported in teiid or not.

Thanks

Rakesh.

[rareddy]

Rakesh,

Did you have "supportsScalarSubqueries" returning true? That is capability needed. If this is turned on, then it got to be one of the fields can not be pushed down because of the data type requires a convert. For that you would need to go through query plan to determine.

Ramesh

[rareddy]

Rakesh,

Can you send me private email at rareddy at jboss dot org, I would like to ask you something.

Ramesh..

[rakeshsagar]

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

[shawkins]

Rakesh,

Check the super class(es) implementation of supportsSelectDistinct.  Ensure that you are returning true.

Steve

[rakeshsagar]

I specifically added setSupportsSelectDistinct(true); in my translator and still it doesnot work.

Please let me know if I need to do any changes.

Thanks,

Rakesh

[shawkins]

Rakesh,

Without seeing your super class(es) I cannot say for certian what effect that is having.  You can easily test this by creating a new instance of your DB2ToolsCatalogExecutionFactory, calling start, then seeing what the value of supportsSelectDistinct is.  If it is returning true, please retest your query after installing the translator again and restarting the server.  If it returns false, the issue is in your super class(es).

Steve

[rareddy]

Rakesh,

yes, we see that. What Steve is suggesting is make sure in your "CoptdsExecutionFactory" super class you are not reverting it to false etc, and you are using the correct translator name in the vdb.

Ramesh,,

[rakeshsagar]

The followiing is my super class

Please help me in solving this problem.

@Translator(name = "coptds")

public class CoptdsExecutionFactory

    extends ExecutionFactory<ConnectionFactory, CoptdsConnection>

{

    private static final Logger log = Logger.getLogger(CoptdsExecutionFactory.class);

    /**

           *

           */

    public CoptdsExecutionFactory()

    {

    }

    @Override

    public void start() throws TranslatorException

    {

        super.start();

        log.debug("start ");

    }

    @Override

    public Execution createExecution(final Command command,

        final ExecutionContext executionContext,

        final RuntimeMetadata metadata,

        final CoptdsConnection connection) throws TranslatorException

    {

        log.debug("Command received to exceute" + command.toString());

        return createResultSetExecution((QueryExpression) command, executionContext, metadata, connection);

    }

    @Override

    public ResultSetExecution createResultSetExecution(final QueryExpression command,

        final ExecutionContext executionContext,

        final RuntimeMetadata metadata,

        final CoptdsConnection connection) throws TranslatorException

    {

        return new CoptdsExecution(command, metadata, executionContext, connection);

    }

    @Override

    public void getMetadata(final MetadataFactory metadataFactory, final CoptdsConnection connection) throws TranslatorException

    {

        log.debug("Start of CoptdsExecutionFactory getMetadata");

        final Map<String, Schema> schemaMap = metadataFactory.getMetadataStore().getSchemas();

        final Set<String> keySet = schemaMap.keySet();

        final Iterator<String> iterator = keySet.iterator();

        final MetadataCreator creator = new MetadataCreator();

        while (iterator.hasNext())

        {

            final String schemaName = iterator.next();

            log.debug("loading metadata for  " + schemaName + " schema");

            creator.loadMetadata(metadataFactory, "DBMzDB2-property.txt");

        }

        log.debug("End of CoptdsExecutionFactory getMetadata");

    }

    /*

     * @Override public boolean supportsCompareCriteriaEquals() { // where

     * clause log.debug("Start of supportsCompareCriteriaEquals"); return true;

     * }

     *

     * @Override public boolean supportsBetweenCriteria() {

     * log.debug("Start of supportsBetweenCriteria"); return true; }

     *

     * @Override public boolean supportsCompareCriteriaOrdered() { return true;

     * }

     *

     * @Override public boolean supportsNotCriteria() { return true; }

     *

     * @Override public boolean supportsOrCriteria() { return true; }

     *

     * @Override public boolean supportsRowLimit() { return true; }

     *

     * @Override public boolean supportsRowOffset() { return true; }

     */

}

[rakeshsagar]

I tried printing super.supportsSelectDistinct() and it is printing true.

Please help me in solving this problem.

Thanks

Rakesh

[shawkins]

Rakesh,

So then there is likely an issue with packaging.  Please reinstall your translator jar and restart the server.

Steve

[rakeshsagar]

I re-created the jar file and put it in JBoss and restarted JBoss.

I was seeing the value as true in the JBoss server log.

But when I tried executing the SQL, its splitting the SQL into two.

[shawkins]

Then ensure that you are seeing the same issue.  If you are seeing a message along the lines of "cannot push dupremove, since distinct is not supported by source DupRemoval", then you still have an issue with your translator.  For instance make sure that you are actually using your custom translator in the vdb.xml and not another one.  You can also simplify the situation by just issuing select distinct against a source table.

Steve

[rakeshsagar]

I will try and check for the translator code.

Thanks for your help.