============================================================================ USER COMMAND: SELECT DISTINCT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23 FROM (SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION ALL SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID) AS u ORDER BY c_1 ---------------------------------------------------------------------------- OPTIMIZE: SELECT DISTINCT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23 FROM (SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION ALL SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID) AS u ORDER BY c_1 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT DISTINCT c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23 FROM (SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION ALL SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID) AS u ORDER BY c_1 CANONICAL PLAN: Sort(groups=[u], props={SORT_ORDER=ORDER BY c_1}) DupRemoval(groups=[]) Project(groups=[u], props={PROJECT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) Source(groups=[u], props={NESTED_COMMAND=SELECT '__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION ALL SELECT '__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID, SYMBOL_MAP={u.c_0='__column__', u.c_1=anon_grp0.gcol0, u.c_2='dsConf', u.c_3=null, u.c_4='__constant__', u.c_5='Data Sharing Groups', u.c_6=null, u.c_7=null, u.c_8='__column__', u.c_9=anon_grp0.gcol1, u.c_10='dsGroup', u.c_11=null, u.c_12='__column__', u.c_13=anon_grp0.gcol2, u.c_14='dsSystem', u.c_15=null, u.c_16='__column__', u.c_17=anon_grp0.gcol3, u.c_18='dsSSID', u.c_19=null, u.c_20='__objectname__', u.c_21='00000', u.c_22='DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase', u.c_23=null}, PARTITION_INFO={u.c_5=[['Data Sharing Groups'], ['Non-Data Sharing Subsystems']], u.c_16=[['__column__'], ['__objectname__']], u.c_18=[['dsSSID'], ['DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase']], u.c_14=[['dsSystem'], ['dsSSID']], u.c_20=[['__objectname__'], [null]], u.c_10=[['dsGroup'], ['dsSystem']], u.c_22=[['DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase'], [null]], u.c_21=[['00000'], [null]]}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase]) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23]}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp1], props={GROUP_COLS=[dsConf, dsSystem, dsSSID], SYMBOL_MAP={anon_grp1.gcol0=dsConf, anon_grp1.gcol1=dsSystem, anon_grp1.gcol2=dsSSID}}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[u], props={SORT_ORDER=ORDER BY c_1}) DupRemoval(groups=[]) Project(groups=[u], props={PROJECT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) Source(groups=[u], props={NESTED_COMMAND=SELECT '__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION ALL SELECT '__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID, SYMBOL_MAP={u.c_0='__column__', u.c_1=anon_grp0.gcol0, u.c_2='dsConf', u.c_3=null, u.c_4='__constant__', u.c_5='Data Sharing Groups', u.c_6=null, u.c_7=null, u.c_8='__column__', u.c_9=anon_grp0.gcol1, u.c_10='dsGroup', u.c_11=null, u.c_12='__column__', u.c_13=anon_grp0.gcol2, u.c_14='dsSystem', u.c_15=null, u.c_16='__column__', u.c_17=anon_grp0.gcol3, u.c_18='dsSSID', u.c_19=null, u.c_20='__objectname__', u.c_21='00000', u.c_22='DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase', u.c_23=null}, PARTITION_INFO={u.c_5=[['Data Sharing Groups'], ['Non-Data Sharing Subsystems']], u.c_16=[['__column__'], ['__objectname__']], u.c_18=[['dsSSID'], ['DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase']], u.c_14=[['dsSystem'], ['dsSSID']], u.c_20=[['__objectname__'], [null]], u.c_10=[['dsGroup'], ['dsSystem']], u.c_22=[['DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase'], [null]], u.c_21=[['00000'], [null]]}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase]) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase]) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23]}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1]) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1]) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[u], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) DupRemoval(groups=[], props={OUTPUT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) Project(groups=[u], props={PROJECT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23], OUTPUT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) Source(groups=[u], props={NESTED_COMMAND=SELECT '__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION ALL SELECT '__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsSystem, dsSSID, SYMBOL_MAP={u.c_0='__column__', u.c_1=anon_grp0.gcol0, u.c_2='dsConf', u.c_3=null, u.c_4='__constant__', u.c_5='Data Sharing Groups', u.c_6=null, u.c_7=null, u.c_8='__column__', u.c_9=anon_grp0.gcol1, u.c_10='dsGroup', u.c_11=null, u.c_12='__column__', u.c_13=anon_grp0.gcol2, u.c_14='dsSystem', u.c_15=null, u.c_16='__column__', u.c_17=anon_grp0.gcol3, u.c_18='dsSSID', u.c_19=null, u.c_20='__objectname__', u.c_21='00000', u.c_22='DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase', u.c_23=null}, PARTITION_INFO={u.c_5=[['Data Sharing Groups'], ['Non-Data Sharing Subsystems']], u.c_16=[['__column__'], ['__objectname__']], u.c_18=[['dsSSID'], ['DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase']], u.c_14=[['dsSystem'], ['dsSSID']], u.c_20=[['__objectname__'], [null]], u.c_10=[['dsGroup'], ['dsSystem']], u.c_22=[['DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase'], [null]], u.c_21=[['00000'], [null]]}, OUTPUT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3]}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID]}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID]}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23]}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2]}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID]}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID]}) ============================================================================ EXECUTING MergeVirtual AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=[c_0, c_1, c_2, c_3, c_4, c_5, c_6, c_7, c_8, c_9, c_10, c_11, c_12, c_13, c_14, c_15, c_16, c_17, c_18, c_19, c_20, c_21, c_22, c_23]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3]}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID]}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID]}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23]}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2]}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID]}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID]}) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=null}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=null}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=null}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=null}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanUnions AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=null}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=null, MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=null}) Access(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=null, MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Access(groups=[], props={OUTPUT_COLS=null, MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=null}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=null}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PushAggregates AFTER: Access(groups=[], props={OUTPUT_COLS=null, MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=null}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=null}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=null}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING AssignOutputElements AFTER: Access(groups=[], props={OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23]}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3]}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID]}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23]}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2]}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID]}) ============================================================================ EXECUTING CalculateCost AFTER: Access(groups=[], props={OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba, EST_CARDINALITY=-1.0}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3], EST_CARDINALITY=-1.0}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID], EST_COL_STATS={dsConf=[-1.0, -1.0], dsGroup=[-1.0, -1.0], dsSystem=[-1.0, -1.0], dsSSID=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2], EST_CARDINALITY=-1.0}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], EST_COL_STATS={IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf=[-1.0, -1.0], IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem=[-1.0, -1.0], IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PlanSorts AFTER: Access(groups=[], props={OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba, EST_CARDINALITY=-1.0}) Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY c_1, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) Project(groups=[anon_grp0], props={PROJECT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) Group(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase, anon_grp0], props={GROUP_COLS=[dsConf, dsGroup, dsSystem, dsSSID], SYMBOL_MAP={anon_grp0.gcol0=dsConf, anon_grp0.gcol1=dsGroup, anon_grp0.gcol2=dsSystem, anon_grp0.gcol3=dsSSID}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.gcol3], EST_CARDINALITY=-1.0}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase], props={OUTPUT_COLS=[dsConf, dsGroup, dsSystem, dsSSID], EST_COL_STATS={dsConf=[-1.0, -1.0], dsGroup=[-1.0, -1.0], dsSystem=[-1.0, -1.0], dsSSID=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp1], props={PROJECT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], OUTPUT_COLS=['__column__' AS c_0, anon_grp1.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp1.gcol1 AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp1.gcol2 AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23], EST_CARDINALITY=-1.0}) Group(groups=[anon_grp1, DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={GROUP_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], SYMBOL_MAP={anon_grp1.gcol0=IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, anon_grp1.gcol1=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, anon_grp1.gcol2=IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2], EST_CARDINALITY=-1.0}) Source(groups=[DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1], props={OUTPUT_COLS=[IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID], EST_COL_STATS={IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf=[-1.0, -1.0], IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem=[-1.0, -1.0], IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING CollapseSource AFTER: Access(groups=[], props={OUTPUT_COLS=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23], MODEL_ID=Schema name=DBMzDB2, nameInSource=null, uuid=mmuuid:7f3bb7de-21e5-4784-bd9d-47e2fa0945ba, EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT '__column__' AS c_0, dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase GROUP BY dsConf, dsGroup, dsSystem, dsSSID UNION SELECT '__column__' AS c_0, IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS IDB2_DSQSYSOA_Rbase_Vbase__1 GROUP BY IDB2_DSQSYSOA_Rbase_Vbase__1.dsConf, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSystem, IDB2_DSQSYSOA_Rbase_Vbase__1.dsSSID ORDER BY c_1}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = AccessNode(2) output=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23] SELECT '__column__' AS c_0, g_1.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, g_1.dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, g_1.dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, g_1.dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS g_1 GROUP BY g_1.dsConf, g_1.dsGroup, g_1.dsSystem, g_1.dsSSID UNION SELECT '__column__' AS c_0, g_0.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, g_0.dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, g_0.dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS g_0 GROUP BY g_0.dsConf, g_0.dsSystem, g_0.dsSSID ORDER BY c_1 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: AccessNode(2) output=['__column__' AS c_0, anon_grp0.gcol0 AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, anon_grp0.gcol1 AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, anon_grp0.gcol2 AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, anon_grp0.gcol3 AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23] SELECT '__column__' AS c_0, g_1.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, g_1.dsGroup AS c_9, 'dsGroup' AS c_10, null AS c_11, '__column__' AS c_12, g_1.dsSystem AS c_13, 'dsSystem' AS c_14, null AS c_15, '__column__' AS c_16, g_1.dsSSID AS c_17, 'dsSSID' AS c_18, null AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS g_1 GROUP BY g_1.dsConf, g_1.dsGroup, g_1.dsSystem, g_1.dsSSID UNION SELECT '__column__' AS c_0, g_0.dsConf AS c_1, 'dsConf' AS c_2, null AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, null AS c_6, null AS c_7, '__column__' AS c_8, g_0.dsSystem AS c_9, 'dsSystem' AS c_10, null AS c_11, '__column__' AS c_12, g_0.dsSSID AS c_13, 'dsSSID' AS c_14, null AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, null AS c_19, null AS c_20, null AS c_21, null AS c_22, null AS c_23 FROM DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase AS g_0 GROUP BY g_0.dsConf, g_0.dsSystem, g_0.dsSSID ORDER BY c_1 ============================================================================ 29 Feb 2012 19:21:20,290 PST ERROR [PROCESSOR] Unexpected exception for request GEobChYjYAdE.0 java.lang.AssertionError: Assertion failed. at org.teiid.core.util.Assertion.failed(Assertion.java:73) at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) at org.teiid.query.processor.relational.SortUtility.(SortUtility.java:145) at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96) at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:180) at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:307) at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:239) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:137) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386) at sun.reflect.GeneratedMethodAccessor356.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:393) at $Proxy328.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor356.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110) at $Proxy328.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:599) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:533) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:230) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86) at com.ca.chorus.teiid.safety.SafetyHarnessExecution.execute(SafetyHarnessExecution.java:80) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:272) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:344) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) 29 Feb 2012 19:21:20,291 PST WARN [CONNECTOR] Connector worker process failed for atomic-request=IQ/8d8dYXm6t.0.2.170 [JDBCExecutionException] 0: Error Code:0 Message:'Assertion failed.' error executing statement(s): [Prepared Values: [] SQL: SELECT '__column__' AS c_0, g_1.dsConf AS c_1, 'dsConf' AS c_2, NULL AS c_3, '__constant__' AS c_4, 'Data Sharing Groups' AS c_5, NULL AS c_6, NULL AS c_7, '__column__' AS c_8, g_1.dsGroup AS c_9, 'dsGroup' AS c_10, NULL AS c_11, '__column__' AS c_12, g_1.dsSystem AS c_13, 'dsSystem' AS c_14, NULL AS c_15, '__column__' AS c_16, g_1.dsSSID AS c_17, 'dsSSID' AS c_18, NULL AS c_19, '__objectname__' AS c_20, '00000' AS c_21, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_22, NULL AS c_23 FROM "DBMzDB2p"."IDB2_DSQSYSOA_Rbase_Vbase" AS "g_1" GROUP BY g_1.dsConf, g_1.dsGroup, g_1.dsSystem, g_1.dsSSID UNION SELECT '__column__' AS c_0, g_0.dsConf AS c_1, 'dsConf' AS c_2, NULL AS c_3, '__constant__' AS c_4, 'Non-Data Sharing Subsystems' AS c_5, NULL AS c_6, NULL AS c_7, '__column__' AS c_8, g_0.dsSystem AS c_9, 'dsSystem' AS c_10, NULL AS c_11, '__column__' AS c_12, g_0.dsSSID AS c_13, 'dsSSID' AS c_14, NULL AS c_15, '__objectname__' AS c_16, '00001' AS c_17, 'DBMzDB2.IDB2_DSQSYSOA_Rbase_Vbase' AS c_18, NULL AS c_19, NULL AS c_20, NULL AS c_21, NULL AS c_22, NULL AS c_23 FROM "DBMzDB2p"."IDB2_DSQSYSOA_Rbase_Vbase" AS "g_0" GROUP BY g_0.dsConf, g_0.dsSystem, g_0.dsSSID ORDER BY c_1] 1 [TeiidSQLException]Assertion failed. 2 [TeiidException]Assertion failed. 3 [AssertionError]Assertion failed. at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90) at com.ca.chorus.teiid.safety.SafetyHarnessExecution.execute(SafetyHarnessExecution.java:80) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:272) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:344) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722) Caused by: org.teiid.jdbc.TeiidSQLException: Assertion failed. at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:624) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:72) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:539) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:535) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:230) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:86) ... 14 more Caused by: [TeiidException]Assertion failed. 1 [AssertionError]Assertion failed. at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:736) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:472) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:314) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386) at sun.reflect.GeneratedMethodAccessor356.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:393) at $Proxy328.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor356.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) at java.util.concurrent.FutureTask.run(FutureTask.java:166) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110) at $Proxy328.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:599) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:533) ... 16 more Caused by: java.lang.AssertionError: Assertion failed. at org.teiid.core.util.Assertion.failed(Assertion.java:73) at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) at org.teiid.query.processor.relational.SortUtility.(SortUtility.java:145) at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:96) at org.teiid.query.processor.relational.SortNode.getFinalBuffer(SortNode.java:180) at org.teiid.query.processor.relational.RelationalPlan.getFinalBuffer(RelationalPlan.java:307) at org.teiid.query.processor.QueryProcessor.getFinalBuffer(QueryProcessor.java:239) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:137) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:374) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:287) ... 37 more