3 Replies Latest reply on Sep 15, 2011 9:17 AM by Ramesh Reddy

    OrderBy in the sub queries is not passed to the translator

    Rakesh Balguri Expert

      Hi all,

       

      I am using Teiid 7.3.

      When I execute the following SQL against teiid

       

      select CHORUS_B."NAME", CHORUS_B."DBNAME",CHORUS_B."CREATOR", CHORUS_B."DBID",CHORUS_B."LOG", CHORUS_B."NACTIVEF", CHORUS_B."DSSIZE",CHORUS_B."OLDEST_VERSION", CHORUS_B."CURRENT_VERSION", CHORUS_B."AVGROWLEN",CHORUS_B."SPACEF"

      from

      (select TS.* from DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase TS,

      (select DISTINCT TSNAME from DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase where STORNAME = 'PTSG') TP

      where TS.NAME = TP.TSNAME order by TS.NAME ) CHORUS_B where CHORUS_B.dsConf='DEFAULT'

      and CHORUS_B.dsGroup='DA0G' and CHORUS_B.dsSystem='' and CHORUS_B.dsSSID=''

       

      I get the following query in the translator:

       

      SELECT g_0.NAME, g_0.DBNAME, g_0.CREATOR, g_0.DBID, g_0.LOG, g_0.NACTIVEF, g_0.DSSIZE, g_0.OLDEST_VERSION,

      g_0.CURRENT_VERSION, g_0.AVGROWLEN, g_0.SPACEF FROM CAT_SYSTABLESPACE_Rbase_Vbase AS g_0,

      (SELECT DISTINCT g_1.TSNAME AS c_0 FROM CAT_SYSTABLEPART_Rbase_Vbase AS g_1 WHERE g_1.STORNAME = 'PTSG')

      AS v_0 WHERE g_0.NAME = v_0.c_0 AND g_0.dsConf = 'DEFAULT' AND g_0.dsGroup = 'DA0G' AND g_0.dsSystem = ''

      AND g_0.dsSSID = ''

       

      The SQL in the translator does not contain the Order By clause. Some how teiid is removing the Order By clause from the sub query.

       

      My translator supports Order By and all the other supports.

       

      Please help me in resolving this problem.

       

      The plan for the SQL is as follows:

       

      [PLANNER]

      ============================================================================

      USER COMMAND:

      SELECT CHORUS_B.NAME, CHORUS_B.DBNAME, CHORUS_B.CREATOR, CHORUS_B.DBID, CHORUS_B.LOG, CHORUS_B.NACTIVEF, CHORUS_B.DSSIZE, CHORUS_B.OLDEST_VERSION, CHORUS_B.CURRENT_VERSION, CHORUS_B.AVGROWLEN, CHORUS_B.SPACEF FROM (SELECT TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '')

       

      ----------------------------------------------------------------------------

      OPTIMIZE:

      SELECT CHORUS_B.NAME, CHORUS_B.DBNAME, CHORUS_B.CREATOR, CHORUS_B.DBID, CHORUS_B.LOG, CHORUS_B.NACTIVEF, CHORUS_B.DSSIZE, CHORUS_B.OLDEST_VERSION, CHORUS_B.CURRENT_VERSION, CHORUS_B.AVGROWLEN, CHORUS_B.SPACEF FROM (SELECT TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '')

       

      ----------------------------------------------------------------------------

      GENERATE CANONICAL:

      SELECT CHORUS_B.NAME, CHORUS_B.DBNAME, CHORUS_B.CREATOR, CHORUS_B.DBID, CHORUS_B.LOG, CHORUS_B.NACTIVEF, CHORUS_B.DSSIZE, CHORUS_B.OLDEST_VERSION, CHORUS_B.CURRENT_VERSION, CHORUS_B.AVGROWLEN, CHORUS_B.SPACEF FROM (SELECT TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME) AS CHORUS_B WHERE (CHORUS_B.dsConf = 'DEFAULT') AND (CHORUS_B.dsGroup = 'DA0G') AND (CHORUS_B.dsSystem = '') AND (CHORUS_B.dsSSID = '')

       

      CANONICAL PLAN:

      Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.NAME, CHORUS_B.DBNAME, CHORUS_B.CREATOR, CHORUS_B.DBID, CHORUS_B.LOG, CHORUS_B.NACTIVEF, CHORUS_B.DSSIZE, CHORUS_B.OLDEST_VERSION, CHORUS_B.CURRENT_VERSION, CHORUS_B.AVGROWLEN, CHORUS_B.SPACEF]})

         Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSSID = ''})

           Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSystem = ''})

             Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G'})

               Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsConf = 'DEFAULT'})

                 Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.DBID=TS.DBID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.LOG=TS.LOG, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.NAME=TS.NAME, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.OBID=TS.OBID, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.PSID=TS.PSID, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.TYPE=TS.TYPE}})

                   Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsQuerySet, TS.dsSystem, TS.dsSSID, TS.ALTEREDTS, TS.AVGROWLEN, TS.BPOOL, TS.CLOSERULE, TS.CREATEDBY, TS.CREATEDTS, TS.CREATOR, TS.CURRENT_VERSION, TS.DBCS_CCSID, TS.DBID, TS.DBNAME, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.ERASERULE, TS.IBMREQD, TS.IMPLICIT, TS.LOCKMAX, TS.LOCKPART, TS.LOCKRULE, TS.LOG, TS.MAXROWS, TS.MIXED_CCSID, TS.NACTIVE, TS.NACTIVEF, TS.NAME, TS.NTABLES, TS.OBID, TS.OLDEST_VERSION, TS.PARTITIONS, TS.PGSIZE, TS.PSID, TS.ROOTCREATOR, TS.ROOTNAME, TS.SBCS_CCSID, TS.SEGSIZE, TS.SPACE, TS.SPACEF, TS.STATSTIME, TS.STATUS, TS.TYPE]})

                     Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME})

                       Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], JOIN_TYPE=CROSS JOIN})

                         Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                         Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

                           DupRemoval(groups=[])

                             Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                               Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})

                                 Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING PlaceAccess

       

      AFTER:

      Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.NAME, CHORUS_B.DBNAME, CHORUS_B.CREATOR, CHORUS_B.DBID, CHORUS_B.LOG, CHORUS_B.NACTIVEF, CHORUS_B.DSSIZE, CHORUS_B.OLDEST_VERSION, CHORUS_B.CURRENT_VERSION, CHORUS_B.AVGROWLEN, CHORUS_B.SPACEF]})

         Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSSID = ''})

           Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsSystem = ''})

             Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G'})

               Select(groups=[CHORUS_B], props={SELECT_CRITERIA=CHORUS_B.dsConf = 'DEFAULT'})

                 Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.DBID=TS.DBID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.LOG=TS.LOG, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.NAME=TS.NAME, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.OBID=TS.OBID, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.PSID=TS.PSID, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.TYPE=TS.TYPE}})

                   Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsQuerySet, TS.dsSystem, TS.dsSSID, TS.ALTEREDTS, TS.AVGROWLEN, TS.BPOOL, TS.CLOSERULE, TS.CREATEDBY, TS.CREATEDTS, TS.CREATOR, TS.CURRENT_VERSION, TS.DBCS_CCSID, TS.DBID, TS.DBNAME, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.ERASERULE, TS.IBMREQD, TS.IMPLICIT, TS.LOCKMAX, TS.LOCKPART, TS.LOCKRULE, TS.LOG, TS.MAXROWS, TS.MIXED_CCSID, TS.NACTIVE, TS.NACTIVEF, TS.NAME, TS.NTABLES, TS.OBID, TS.OLDEST_VERSION, TS.PARTITIONS, TS.PGSIZE, TS.PSID, TS.ROOTCREATOR, TS.ROOTNAME, TS.SBCS_CCSID, TS.SEGSIZE, TS.SPACE, TS.SPACEF, TS.STATSTIME, TS.STATUS, TS.TYPE]})

                     Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={SELECT_CRITERIA=TS.NAME = TP.TSNAME})

                       Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], JOIN_TYPE=CROSS JOIN})

                         Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                           Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                         Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

                           DupRemoval(groups=[])

                             Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                               Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})

                                 Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

                                   Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING PushSelectCriteria

       

      AFTER:

      Project(groups=[CHORUS_B], props={PROJECT_COLS=[CHORUS_B.NAME, CHORUS_B.DBNAME, CHORUS_B.CREATOR, CHORUS_B.DBID, CHORUS_B.LOG, CHORUS_B.NACTIVEF, CHORUS_B.DSSIZE, CHORUS_B.OLDEST_VERSION, CHORUS_B.CURRENT_VERSION, CHORUS_B.AVGROWLEN, CHORUS_B.SPACEF]})

         Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsSSID = ''})

           Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsSystem = ''})

             Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsGroup = 'DA0G'})

               Select(groups=[CHORUS_B], props={IS_PHANTOM=true, SELECT_CRITERIA=CHORUS_B.dsConf = 'DEFAULT'})

                 Source(groups=[CHORUS_B], props={NESTED_COMMAND=SELECT TS.* FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS CROSS JOIN (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE TS.NAME = TP.TSNAME, SYMBOL_MAP={CHORUS_B.dsConf=TS.dsConf, CHORUS_B.dsGroup=TS.dsGroup, CHORUS_B.dsQuerySet=TS.dsQuerySet, CHORUS_B.dsSystem=TS.dsSystem, CHORUS_B.dsSSID=TS.dsSSID, CHORUS_B.ALTEREDTS=TS.ALTEREDTS, CHORUS_B.AVGROWLEN=TS.AVGROWLEN, CHORUS_B.BPOOL=TS.BPOOL, CHORUS_B.CLOSERULE=TS.CLOSERULE, CHORUS_B.CREATEDBY=TS.CREATEDBY, CHORUS_B.CREATEDTS=TS.CREATEDTS, CHORUS_B.CREATOR=TS.CREATOR, CHORUS_B.CURRENT_VERSION=TS.CURRENT_VERSION, CHORUS_B.DBCS_CCSID=TS.DBCS_CCSID, CHORUS_B.DBID=TS.DBID, CHORUS_B.DBNAME=TS.DBNAME, CHORUS_B.DSETPASS=TS.DSETPASS, CHORUS_B.DSSIZE=TS.DSSIZE, CHORUS_B.ENCODING_SCHEME=TS.ENCODING_SCHEME, CHORUS_B.ERASERULE=TS.ERASERULE, CHORUS_B.IBMREQD=TS.IBMREQD, CHORUS_B.IMPLICIT=TS.IMPLICIT, CHORUS_B.LOCKMAX=TS.LOCKMAX, CHORUS_B.LOCKPART=TS.LOCKPART, CHORUS_B.LOCKRULE=TS.LOCKRULE, CHORUS_B.LOG=TS.LOG, CHORUS_B.MAXROWS=TS.MAXROWS, CHORUS_B.MIXED_CCSID=TS.MIXED_CCSID, CHORUS_B.NACTIVE=TS.NACTIVE, CHORUS_B.NACTIVEF=TS.NACTIVEF, CHORUS_B.NAME=TS.NAME, CHORUS_B.NTABLES=TS.NTABLES, CHORUS_B.OBID=TS.OBID, CHORUS_B.OLDEST_VERSION=TS.OLDEST_VERSION, CHORUS_B.PARTITIONS=TS.PARTITIONS, CHORUS_B.PGSIZE=TS.PGSIZE, CHORUS_B.PSID=TS.PSID, CHORUS_B.ROOTCREATOR=TS.ROOTCREATOR, CHORUS_B.ROOTNAME=TS.ROOTNAME, CHORUS_B.SBCS_CCSID=TS.SBCS_CCSID, CHORUS_B.SEGSIZE=TS.SEGSIZE, CHORUS_B.SPACE=TS.SPACE, CHORUS_B.SPACEF=TS.SPACEF, CHORUS_B.STATSTIME=TS.STATSTIME, CHORUS_B.STATUS=TS.STATUS, CHORUS_B.TYPE=TS.TYPE}})

                   Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.dsConf, TS.dsGroup, TS.dsQuerySet, TS.dsSystem, TS.dsSSID, TS.ALTEREDTS, TS.AVGROWLEN, TS.BPOOL, TS.CLOSERULE, TS.CREATEDBY, TS.CREATEDTS, TS.CREATOR, TS.CURRENT_VERSION, TS.DBCS_CCSID, TS.DBID, TS.DBNAME, TS.DSETPASS, TS.DSSIZE, TS.ENCODING_SCHEME, TS.ERASERULE, TS.IBMREQD, TS.IMPLICIT, TS.LOCKMAX, TS.LOCKPART, TS.LOCKRULE, TS.LOG, TS.MAXROWS, TS.MIXED_CCSID, TS.NACTIVE, TS.NACTIVEF, TS.NAME, TS.NTABLES, TS.OBID, TS.OLDEST_VERSION, TS.PARTITIONS, TS.PGSIZE, TS.PSID, TS.ROOTCREATOR, TS.ROOTNAME, TS.SBCS_CCSID, TS.SEGSIZE, TS.SPACE, TS.SPACEF, TS.STATSTIME, TS.STATUS, TS.TYPE]})

                     Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

                       Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                         Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

                           Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                       Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

                         DupRemoval(groups=[])

                           Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                             Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                               Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})

                                 Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING MergeVirtual

       

      AFTER:

      Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsSSID = ''})

           Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsSystem = ''})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsGroup = 'DA0G'})

               Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsConf = 'DEFAULT'})

                 Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

                   Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                     Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

                       Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                   Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

                     DupRemoval(groups=[])

                       Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                         Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                           Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})

                             Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING PushNonJoinCriteria

       

      AFTER:

      Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsSSID = ''})

           Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsSystem = ''})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsGroup = 'DA0G'})

               Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_PHANTOM=true, SELECT_CRITERIA=TS.dsConf = 'DEFAULT'})

                 Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

                   Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                     Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

                       Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                   Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

                     DupRemoval(groups=[])

                       Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                         Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                           Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={SELECT_CRITERIA=STORNAME = 'PTSG'})

                             Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING CopyCriteria

       

      AFTER:

      Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TS.dsSSID = ''})

           Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TS.dsSystem = ''})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TS.dsGroup = 'DA0G'})

               Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, IS_PHANTOM=true, SELECT_CRITERIA=TS.dsConf = 'DEFAULT'})

                 Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

                   Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                     Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

                       Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

                   Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

                     DupRemoval(groups=[])

                       Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                         Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                           Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                             Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING CleanCriteria

       

      AFTER:

      Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

           Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

           Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', SYMBOL_MAP={TP.TSNAME=TSNAME}})

             DupRemoval(groups=[])

               Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                 Access(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING RaiseAccess

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[])

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING PlanJoins

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[])

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING PushSelectCriteria

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[])

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING RaiseAccess

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[])

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING ChooseJoinStrategy

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[])

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING ChooseDependent

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS])

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[])

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase])

       

       

      ============================================================================

      EXECUTING CalculateCost

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = '')})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0})

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, EST_CARDINALITY=-1.0, SYMBOL_MAP={TP.TSNAME=TSNAME}})

               DupRemoval(groups=[], props={EST_CARDINALITY=-1.0})

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG'})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0})

       

       

      ============================================================================

      EXECUTING AssignOutputElements

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, EST_CARDINALITY=-1.0, SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})

               DupRemoval(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TSNAME]})

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[STORNAME, TSNAME]})

       

       

      ============================================================================

      EXECUTING ImplementJoinStrategy

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, EST_CARDINALITY=-1.0, SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})

               DupRemoval(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TSNAME]})

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[STORNAME, TSNAME]})

       

       

      ============================================================================

      EXECUTING MergeCriteria

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, EST_CARDINALITY=-1.0, SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})

               DupRemoval(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TSNAME]})

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[STORNAME, TSNAME]})

       

       

      ============================================================================

      EXECUTING PlanSorts

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

         Project(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

           Join(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={EST_CARDINALITY=-1.0, IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, JOIN_CRITERIA=[TS.NAME = TP.TSNAME], OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF], JOIN_TYPE=INNER JOIN})

             Select(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=(TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

               Source(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TS.dsConf, TS.dsGroup, TS.dsSystem, TS.dsSSID, TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

             Source(groups=[TP], props={NESTED_COMMAND=SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG', INLINE_VIEW=true, EST_CARDINALITY=-1.0, SYMBOL_MAP={TP.TSNAME=TSNAME}, OUTPUT_COLS=[TP.TSNAME]})

               DupRemoval(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[TSNAME]})

                 Project(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[TSNAME], OUTPUT_COLS=[TSNAME]})

                   Select(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, IS_COPIED=true, SELECT_CRITERIA=STORNAME = 'PTSG', OUTPUT_COLS=[TSNAME]})

                     Source(groups=[DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[STORNAME, TSNAME]})

       

       

      ============================================================================

      EXECUTING CollapseSource

       

      AFTER:

      Access(groups=[DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, TP], props={ATOMIC_REQUEST=SELECT TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS TS, (SELECT DISTINCT TSNAME FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase WHERE STORNAME = 'PTSG') AS TP WHERE (TS.NAME = TP.TSNAME) AND (TS.dsConf = 'DEFAULT') AND (TS.dsGroup = 'DA0G') AND (TS.dsSystem = '') AND (TS.dsSSID = ''), EST_CARDINALITY=-1.0, MODEL_ID=Schema name=DBMzDB2c, nameInSource=null, uuid=mmuuid:16376c49-9214-4128-99ad-8135fc8de203, OUTPUT_COLS=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF]})

       

       

      ============================================================================

      CONVERTING PLAN TREE TO PROCESS TREE

       

      PROCESS PLAN =

      AccessNode(1) output=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF] SELECT g_0.NAME, g_0.DBNAME, g_0.CREATOR, g_0.DBID, g_0.LOG, g_0.NACTIVEF, g_0.DSSIZE, g_0.OLDEST_VERSION, g_0.CURRENT_VERSION, g_0.AVGROWLEN, g_0.SPACEF FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS g_0, (SELECT DISTINCT g_1.TSNAME AS c_0 FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase AS g_1 WHERE g_1.STORNAME = 'PTSG') AS v_0 WHERE (g_0.NAME = v_0.c_0) AND (g_0.dsConf = 'DEFAULT') AND (g_0.dsGroup = 'DA0G') AND (g_0.dsSystem = '') AND (g_0.dsSSID = '')

       

      ============================================================================

       

      ----------------------------------------------------------------------------

      OPTIMIZATION COMPLETE:

      PROCESSOR PLAN:

      AccessNode(1) output=[TS.NAME, TS.DBNAME, TS.CREATOR, TS.DBID, TS.LOG, TS.NACTIVEF, TS.DSSIZE, TS.OLDEST_VERSION, TS.CURRENT_VERSION, TS.AVGROWLEN, TS.SPACEF] SELECT g_0.NAME, g_0.DBNAME, g_0.CREATOR, g_0.DBID, g_0.LOG, g_0.NACTIVEF, g_0.DSSIZE, g_0.OLDEST_VERSION, g_0.CURRENT_VERSION, g_0.AVGROWLEN, g_0.SPACEF FROM DBMzDB2c.CAT_SYSTABLESPACE_Rbase_Vbase AS g_0, (SELECT DISTINCT g_1.TSNAME AS c_0 FROM DBMzDB2c.CAT_SYSTABLEPART_Rbase_Vbase AS g_1 WHERE g_1.STORNAME = 'PTSG') AS v_0 WHERE (g_0.NAME = v_0.c_0) AND (g_0.dsConf = 'DEFAULT') AND (g_0.dsGroup = 'DA0G') AND (g_0.dsSystem = '') AND (g_0.dsSSID = '')

       

      ============================================================================