zOs/SQL/DBXQUA

SELECT s.*
    FROM SYSIBM.SYSTABLESPACE S
    WHERE (S.DBNAME = 'DGDB0426' AND S.NAME = 'PDZINSFQ')
       or (S.DBNAME = 'DGDB9998' AND S.NAME = 'PDZINSFQ')
       or (S.DBNAME = 'DA540769' AND S.NAME LIKE 'A10%')
       or (S.DBNAME = 'DGDB3456' AND S.NAME LIKE 'A%')
 union     select s.*
    FROM SYSIBM.SYSTABLESPACE S, SYSIBM.SYSTABLES T
    where s.dbName = t.dbName and s.name = t.tsName
    and (
            (T.CREATOR = 'GDB9998A' AND T.NAME LIKE 'TWK1%')
         or (T.CREATOR like 'F54076%' AND T.NAME LIKE 'TWK1%')
        )
 union     select s.*
    FROM SYSIBM.SYSTABLESPACE S, SYSIBM.SYSTABLES T, SYSIBM.SYSINDEXES X
    where s.dbName = t.dbName and s.name = t.tsName
      and t.creator = x.tbCreator and t.name = x.tbName
    and (   (X.CREATOR = 'GDB9998' AND X.NAME LIKE 'IWK001%')
         or (X.CREATOR like 'F54076%' AND X.NAME LIKE 'IWK001%')
        )
;
dELETE FROM PLAN_TABLE;
SET CURRENT SQLID = 'A540769';
EXPLAIN PLAN SET QUERYNO = 111 FOR
SELECT s.*
    FROM SYSIBM.SYSTABLESPACE S
    WHERE (S.DBNAME = 'DGDB0426' AND S.NAME = 'PDZINSFQ')
       or (S.DBNAME = 'DGDB9998' AND S.NAME = 'PDZINSFQ')
       or (S.DBNAME = 'DA540769' AND S.NAME LIKE 'A10%')
       or (S.DBNAME = 'DGDB3456' AND S.NAME LIKE 'A%')
 union     select s.*
    FROM SYSIBM.SYSTABLESPACE S, SYSIBM.SYSTABLES T
    where s.dbName = t.dbName and s.name = t.tsName
    and (
            (T.CREATOR = 'GDB9998A' AND T.NAME LIKE 'TWK1%')
         or (T.CREATOR like 'F54076%' AND T.NAME LIKE 'TWK1%')
        )
 union     select s.*
    FROM SYSIBM.SYSTABLESPACE S, SYSIBM.SYSTABLES T, SYSIBM.SYSINDEXES X
    where s.dbName = t.dbName and s.name = t.tsName
      and t.creator = x.tbCreator and t.name = x.tbName
    and (   (X.CREATOR = 'GDB9998' AND X.NAME LIKE 'IWK001%')
         or (X.CREATOR like 'F54076%' AND X.NAME LIKE 'IWK001%')
        )
;
select * from plan_view5a
    where queryno in ( 111, 222)
    order by applname, progname, queryNo, qblockno, planno
;
rollback
;
xollBack
;
SELECT DBNAME,NAME,TYPE,PARTITIONS,SEGSIZE
    FROM SYSIBM.SYSTABLESPACE S
    WHERE (S.DBNAME = 'DGDB0426' AND S.NAME = 'PDZINSFQ')
 OR (S.DBNAME, S.NAME) IN
      ( SELECT T.DBNAME, T.TSNAME
            FROM SYSIBM.SYSTABLES T
            WHERE (T.CREATOR = 'GDB9998A' AND T.NAME LIKE 'TWK1%')
              OR (S.CREATOR, S.NAME) IN
              ( SELECT X.CREATOR, X.TBNAME
                    FROM SYSIBM.SYSINDEXES X
                    WHERE (X.CREATOR = 'GDB9998'
                        AND X.NAME LIKE 'IWK001%')
              )
      )
;
                    SELECT DBNAME,NAME,TYPE,PARTITIONS,SEGSIZE FROM SYSI
ABLESPACE S WHERE (S.DBNAME = 'DGDB0426' AND S.NAME = 'PDZINSFQ') OR (S.
 S.NAME) IN (SELECT T.DBNAME, T.TSNAME FROM SYSIBM.SYSTABLES T WHERE (T.
 = 'GDB9998A' AND T.NAME LIKE 'TWK1%') OR (S.CREATOR, S.NAME) IN (SELECT
EATOR, X.TBNAME FROM SYSIBM.SYSINDEXES X WHERE (X.CREATOR = 'GDB9998' AN
E LIKE 'IWK001%')))"