13 Replies Latest reply on Nov 3, 2011 2:13 PM by Rakesh Balguri

    Sub-query in Where Clause support

    Rakesh Balguri Expert

      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.

        • 1. Re: Sub-query in Where Clause support
          Ramesh Reddy Master

          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

          • 2. Re: Sub-query in Where Clause support
            Ramesh Reddy Master

            Rakesh,

             

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

             

            Ramesh..

            • 3. Re: Sub-query in Where Clause support
              Rakesh Balguri Expert

              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

              • 4. Re: Sub-query in Where Clause support
                Steven Hawkins Master

                Rakesh,

                 

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

                 

                Steve

                • 5. Re: Sub-query in Where Clause support
                  Rakesh Balguri Expert

                  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

                  • 6. Re: Sub-query in Where Clause support
                    Steven Hawkins Master

                    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

                    • 7. Re: Sub-query in Where Clause support
                      Ramesh Reddy Master

                      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,,

                      • 8. Re: Sub-query in Where Clause support
                        Rakesh Balguri Expert

                        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; }

                             */

                        }

                        • 9. Re: Sub-query in Where Clause support
                          Rakesh Balguri Expert

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

                           

                          Please help me in solving this problem.

                           

                          Thanks

                          Rakesh

                          • 10. Re: Sub-query in Where Clause support
                            Steven Hawkins Master

                            Rakesh,

                             

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

                             

                            Steve

                            • 11. Re: Sub-query in Where Clause support
                              Rakesh Balguri Expert

                              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.

                              • 12. Re: Sub-query in Where Clause support
                                Steven Hawkins Master

                                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

                                • 13. Re: Sub-query in Where Clause support
                                  Rakesh Balguri Expert

                                  I will try and check for the translator code.

                                  Thanks for your help.