1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
TOTAL_CPU_TIME ELAPSED_TIME_SEC ROWS_READ ROWS_RETURNED QUERY_COST_ESTIMATE ACTIVITY_STATE STMT_TEXT
-------------------- ---------------- -------------------- -------------------- -------------------- -------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- 4143 - - - EXECUTING INSERT INTO session.#tt133 (Period, RecorderTRef, RecorderRRef, LineNo, Correspond, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Fld509) SELECT CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN (EXISTS(SELECT 1 FROM AccRg520 T2 INNER JOIN SYSIBM.SYSDUMMY1 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T3 INNER JOIN SYSIBM.SYSDUMMY1 ON T1.RecorderTRef = T3.RecorderTRef AND T1.RecorderRRef = T3.RecorderRRef AND T1.LineNo = T3.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T4 INNER JOIN Reference39 T5 ON 1=1 WHERE (((T5.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T6 WHERE ((T6.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T6.Fld7948RRef = T5.IDRRef) AND (T6.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T6.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T6.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T6.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T6.Fld7951_RRRef = T3.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T7 WHERE ((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T7.Fld7948RRef = T5.IDRRef) AND (T7.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T7.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T4.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld9588RRef = T4.IDRRef) AND (T8.Fld9589RRef = T5.IDRRef)))) AND T5.IDRRef IN (SELECT T9.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T9 INNER JOIN InfoRg8729 T10 ON ((T10.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T10.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T10.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T10.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T10.Fld8730_TYPE = T9.Fld814_TYPE AND T10.Fld8730_RTRef = T9.Fld814_RTRef AND T10.Fld8730_RRRef = T9.Fld814_RRRef)) WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T10.Fld509 = CAST(? AS NUMERIC(1, 0)))))))) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T1.Period END, T1.RecorderTRef, T1.RecorderRRef, T1.LineNo, T1.Correspond, T1.KindRRef, T1.Value_TYPE, T1.Value_RTRef, T1.Value_RRRef, T1.Fld509 FROM AccRgED553 T1 WHERE ((T1.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA)
- 5366 - - - EXECUTING INSERT INTO session.#tt23 (RecorderTRef, RecorderRRef, LineNo, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Correspond, AccEdKindLineNo) SELECT CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderTRef END, CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderRRef END, T2.LineNo_, T2.KindRRef, T2.Value_TYPE, T2.Value_RTRef, T2.Value_RRRef, T2.Correspond_, T13.LineNo FROM session.#tt22 T1 LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT 1 FROM AccRg520 T4 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T4.RecorderTRef AND T3.RecorderRRef = T4.RecorderRRef AND T3.LineNo = T4.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T5 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T5.RecorderTRef AND T3.RecorderRRef = T5.RecorderRRef AND T3.LineNo = T5.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T6 INNER JOIN Reference39 T7 ON 1=1 WHERE (((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld7948RRef = T7.IDRRef) AND (T8.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T8.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T8.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T8.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T8.Fld7951_RRRef = T5.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T9 WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T9.Fld7948RRef = T7.IDRRef) AND (T9.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T9.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T6.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T10 WHERE ((T10.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T10.Fld9588RRef = T6.IDRRef) AND (T10.Fld9589RRef = T7.IDRRef)))) AND T7.IDRRef IN (SELECT T11.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T11 INNER JOIN InfoRg8729 T12 ON ((T12.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T12.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T12.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T12.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T12.Fld8730_TYPE = T11.Fld814_TYPE AND T12.Fld8730_RTRef = T11.Fld814_RTRef AND T12.Fld8730_RRRef = T11.Fld814_RRRef)) WHERE ((T11.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T12.Fld509 = CAST(? AS NUMERIC(1, 0)))))))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END AS SDBL_RLS_SIGNAL_, T3.RecorderTRef AS RecorderTRef, T3.RecorderRRef AS RecorderRRef, T3.LineNo AS LineNo_, T3.Correspond AS Correspond_, T3.KindRRef AS KindRRef, T3.Value_TYPE AS Value_TYPE, T3.Value_RTRef AS Value_RTRef, T3.Value_RRRef AS Value_RRRef, T3.Fld509 AS Fld509_ FROM AccRgED553 T3 WHERE (T3.Fld509 = CAST(? AS NUMERIC(1, 0)))) T2 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo_ LEFT OUTER JOIN Acc10_ExtDim515 T13 ON (CASE WHEN T2.Correspond_ = CAST(? AS NUMERIC(1, 0)) THEN T1.AccountDtRRef ELSE T1.AccountCtRRef END = T13.Acc10_IDRRef AND T2.KindRRef = T13.DimKindRRef) AND (T13.Fld509 = CAST(? AS NUMERIC(1, 0))) WHERE NOT (T2.RecorderTRef IS NULL AND T2.RecorderRRef IS NULL)
- 3106 - - - EXECUTING INSERT INTO session.#tt144 (RecorderTRef, RecorderRRef, LineNo, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Correspond, AccEdKindLineNo) SELECT CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderTRef END, CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderRRef END, T2.LineNo_, T2.KindRRef, T2.Value_TYPE, T2.Value_RTRef, T2.Value_RRRef, T2.Correspond_, T13.LineNo FROM session.#tt143 T1 LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT 1 FROM AccRg520 T4 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T4.RecorderTRef AND T3.RecorderRRef = T4.RecorderRRef AND T3.LineNo = T4.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T5 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T5.RecorderTRef AND T3.RecorderRRef = T5.RecorderRRef AND T3.LineNo = T5.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T6 INNER JOIN Reference39 T7 ON 1=1 WHERE (((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld7948RRef = T7.IDRRef) AND (T8.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T8.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T8.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T8.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T8.Fld7951_RRRef = T5.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T9 WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T9.Fld7948RRef = T7.IDRRef) AND (T9.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T9.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T6.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T10 WHERE ((T10.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T10.Fld9588RRef = T6.IDRRef) AND (T10.Fld9589RRef = T7.IDRRef)))) AND T7.IDRRef IN (SELECT T11.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T11 INNER JOIN InfoRg8729 T12 ON ((T12.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T12.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T12.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T12.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T12.Fld8730_TYPE = T11.Fld814_TYPE AND T12.Fld8730_RTRef = T11.Fld814_RTRef AND T12.Fld8730_RRRef = T11.Fld814_RRRef)) WHERE ((T11.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T12.Fld509 = CAST(? AS NUMERIC(1, 0)))))))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END AS SDBL_RLS_SIGNAL_, T3.RecorderTRef AS RecorderTRef, T3.RecorderRRef AS RecorderRRef, T3.LineNo AS LineNo_, T3.Correspond AS Correspond_, T3.KindRRef AS KindRRef, T3.Value_TYPE AS Value_TYPE, T3.Value_RTRef AS Value_RTRef, T3.Value_RRRef AS Value_RRRef, T3.Fld509 AS Fld509_ FROM AccRgED553 T3 WHERE (T3.Fld509 = CAST(? AS NUMERIC(1, 0)))) T2 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo_ LEFT OUTER JOIN Acc10_ExtDim515 T13 ON (CASE WHEN T2.Correspond_ = CAST(? AS NUMERIC(1, 0)) THEN T1.AccountDtRRef ELSE T1.AccountCtRRef END = T13.Acc10_IDRRef AND T2.KindRRef = T13.DimKindRRef) AND (T13.Fld509 = CAST(? AS NUMERIC(1, 0))) WHERE NOT (T2.RecorderTRef IS NULL AND T2.RecorderRRef IS NULL)
- 4 - - - EXECUTING SELECT AGENT_ID, AGENT_ID_HOLDING_LK FROM SYSIBMADM.LOCKWAITS
- 1335 - - - EXECUTING INSERT INTO session.#tt39 (Period, RecorderTRef, RecorderRRef, LineNo, Correspond, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Fld509) SELECT CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN (EXISTS(SELECT 1 FROM AccRg520 T2 INNER JOIN SYSIBM.SYSDUMMY1 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T3 INNER JOIN SYSIBM.SYSDUMMY1 ON T1.RecorderTRef = T3.RecorderTRef AND T1.RecorderRRef = T3.RecorderRRef AND T1.LineNo = T3.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T4 INNER JOIN Reference39 T5 ON 1=1 WHERE (((T5.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T6 WHERE ((T6.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T6.Fld7948RRef = T5.IDRRef) AND (T6.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T6.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T6.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T6.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T6.Fld7951_RRRef = T3.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T7 WHERE ((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T7.Fld7948RRef = T5.IDRRef) AND (T7.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T7.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T4.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld9588RRef = T4.IDRRef) AND (T8.Fld9589RRef = T5.IDRRef)))) AND T5.IDRRef IN (SELECT T9.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T9 INNER JOIN InfoRg8729 T10 ON ((T10.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T10.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T10.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T10.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T10.Fld8730_TYPE = T9.Fld814_TYPE AND T10.Fld8730_RTRef = T9.Fld814_RTRef AND T10.Fld8730_RRRef = T9.Fld814_RRRef)) WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T10.Fld509 = CAST(? AS NUMERIC(1, 0)))))))) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T1.Period END, T1.RecorderTRef, T1.RecorderRRef, T1.LineNo, T1.Correspond, T1.KindRRef, T1.Value_TYPE, T1.Value_RTRef, T1.Value_RRRef, T1.Fld509 FROM AccRgED553 T1 WHERE ((T1.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA)
- 2952 - - - EXECUTING INSERT INTO session.#tt21 (RecorderTRef, RecorderRRef, LineNo, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Correspond, AccEdKindLineNo) SELECT T2.RecorderTRef, T2.RecorderRRef, T2.LineNo_, T2.KindRRef, T2.Value_TYPE, T2.Value_RTRef, T2.Value_RRRef, T2.Correspond_, T13.LineNo FROM session.#tt20 T1 LEFT OUTER JOIN (SELECT T3.RecorderTRef AS RecorderTRef, T3.RecorderRRef AS RecorderRRef, T3.LineNo AS LineNo_, T3.Correspond AS Correspond_, T3.KindRRef AS KindRRef, T3.Value_TYPE AS Value_TYPE, T3.Value_RTRef AS Value_RTRef, T3.Value_RRRef AS Value_RRRef, T3.Fld509 AS Fld509_ FROM AccRgED553 T3 WHERE ((EXISTS(SELECT 1 FROM AccRg520 T4 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T4.RecorderTRef AND T3.RecorderRRef = T4.RecorderRRef AND T3.LineNo = T4.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T5 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T5.RecorderTRef AND T3.RecorderRRef = T5.RecorderRRef AND T3.LineNo = T5.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T6 INNER JOIN Reference39 T7 ON 1=1 WHERE (((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld7948RRef = T7.IDRRef) AND (T8.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T8.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T8.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T8.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T8.Fld7951_RRRef = T5.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T9 WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T9.Fld7948RRef = T7.IDRRef) AND (T9.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T9.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T6.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T10 WHERE ((T10.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T10.Fld9588RRef = T6.IDRRef) AND (T10.Fld9589RRef = T7.IDRRef)))) AND T7.IDRRef IN (SELECT T11.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T11 INNER JOIN InfoRg8729 T12 ON ((T12.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T12.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T12.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T12.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T12.Fld8730_TYPE = T11.Fld814_TYPE AND T12.Fld8730_RTRef = T11.Fld814_RTRef AND T12.Fld8730_RRRef = T11.Fld814_RRRef)) WHERE ((T11.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T12.Fld509 = CAST(? AS NUMERIC(1, 0))))))))) AND (T3.Fld509 = CAST(? AS NUMERIC(1, 0)))) T2 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo_ LEFT OUTER JOIN Acc10_ExtDim515 T13 ON (CASE WHEN T2.Correspond_ = CAST(? AS NUMERIC(1, 0)) THEN T1.AccountDtRRef ELSE T1.AccountCtRRef END = T13.Acc10_IDRRef AND T2.KindRRef = T13.DimKindRRef) AND (T13.Fld509 = CAST(? AS NUMERIC(1, 0))) WHERE NOT (T2.RecorderTRef IS NULL AND T2.RecorderRRef IS NULL)
- 1616 - - - EXECUTING INSERT INTO session.#tt127 (RecorderTRef, RecorderRRef, LineNo, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Correspond, AccEdKindLineNo) SELECT CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderTRef END, CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderRRef END, T2.LineNo_, T2.KindRRef, T2.Value_TYPE, T2.Value_RTRef, T2.Value_RRRef, T2.Correspond_, T13.LineNo FROM session.#tt126 T1 LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT 1 FROM AccRg520 T4 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T4.RecorderTRef AND T3.RecorderRRef = T4.RecorderRRef AND T3.LineNo = T4.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T5 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T5.RecorderTRef AND T3.RecorderRRef = T5.RecorderRRef AND T3.LineNo = T5.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T6 INNER JOIN Reference39 T7 ON 1=1 WHERE (((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld7948RRef = T7.IDRRef) AND (T8.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T8.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T8.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T8.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T8.Fld7951_RRRef = T5.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T9 WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T9.Fld7948RRef = T7.IDRRef) AND (T9.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T9.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T6.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T10 WHERE ((T10.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T10.Fld9588RRef = T6.IDRRef) AND (T10.Fld9589RRef = T7.IDRRef)))) AND T7.IDRRef IN (SELECT T11.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T11 INNER JOIN InfoRg8729 T12 ON ((T12.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T12.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T12.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T12.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T12.Fld8730_TYPE = T11.Fld814_TYPE AND T12.Fld8730_RTRef = T11.Fld814_RTRef AND T12.Fld8730_RRRef = T11.Fld814_RRRef)) WHERE ((T11.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T12.Fld509 = CAST(? AS NUMERIC(1, 0)))))))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END AS SDBL_RLS_SIGNAL_, T3.RecorderTRef AS RecorderTRef, T3.RecorderRRef AS RecorderRRef, T3.LineNo AS LineNo_, T3.Correspond AS Correspond_, T3.KindRRef AS KindRRef, T3.Value_TYPE AS Value_TYPE, T3.Value_RTRef AS Value_RTRef, T3.Value_RRRef AS Value_RRRef, T3.Fld509 AS Fld509_ FROM AccRgED553 T3 WHERE (T3.Fld509 = CAST(? AS NUMERIC(1, 0)))) T2 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo_ LEFT OUTER JOIN Acc10_ExtDim515 T13 ON (CASE WHEN T2.Correspond_ = CAST(? AS NUMERIC(1, 0)) THEN T1.AccountDtRRef ELSE T1.AccountCtRRef END = T13.Acc10_IDRRef AND T2.KindRRef = T13.DimKindRRef) AND (T13.Fld509 = CAST(? AS NUMERIC(1, 0))) WHERE NOT (T2.RecorderTRef IS NULL AND T2.RecorderRRef IS NULL)
- 657 - - - EXECUTING INSERT INTO session.#tt214 (RecorderTRef, RecorderRRef, LineNo, KindRRef, Value_TYPE, Value_RTRef, Value_RRRef, Correspond, AccEdKindLineNo) SELECT CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderTRef END, CASE WHEN (1=1) AND CASE WHEN 1=1 THEN CASE WHEN COALESCE(T2.SDBL_RLS_SIGNAL_,CAST(? AS CHAR(1) FOR BIT DATA)) = CAST(? AS CHAR(1) FOR BIT DATA) THEN 0 ELSE RAISE_ERROR('11IBB','Data access denied') END ELSE 0 END = 0 THEN T2.RecorderRRef END, T2.LineNo_, T2.KindRRef, T2.Value_TYPE, T2.Value_RTRef, T2.Value_RRRef, T2.Correspond_, T13.LineNo FROM session.#tt213 T1 LEFT OUTER JOIN (SELECT CASE WHEN (EXISTS(SELECT 1 FROM AccRg520 T4 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T4.RecorderTRef AND T3.RecorderRRef = T4.RecorderRRef AND T3.LineNo = T4.LineNo WHERE 1=0) OR EXISTS(SELECT 1 FROM AccRg520 T5 INNER JOIN SYSIBM.SYSDUMMY1 ON T3.RecorderTRef = T5.RecorderTRef AND T3.RecorderRRef = T5.RecorderRRef AND T3.LineNo = T5.LineNo WHERE EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_001_F_000_ FROM Reference63 T6 INNER JOIN Reference39 T7 ON 1=1 WHERE (((T7.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_002_F_000_ FROM InfoRg7947 T8 WHERE ((T8.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T8.Fld7948RRef = T7.IDRRef) AND (T8.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T8.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)) AND (T8.Fld7951_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T8.Fld7951_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T8.Fld7951_RRRef = T5.Fld521RRef))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CASE WHEN CAST(? AS CHAR(1) FOR BIT DATA) IN (SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_003_F_000_ FROM InfoRg7947 T9 WHERE ((T9.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T9.Fld7948RRef = T7.IDRRef) AND (T9.Fld7949RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T9.Fld7950 = CAST(? AS CHAR(1) FOR BIT DATA)))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END))) AND (((T6.Fld1162 = CAST(? AS VARGRAPHIC(38))) AND EXISTS(SELECT CAST(? AS CHAR(1) FOR BIT DATA) AS Q_004_F_000_ FROM InfoRg9587 T10 WHERE ((T10.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND ((T10.Fld9588RRef = T6.IDRRef) AND (T10.Fld9589RRef = T7.IDRRef)))) AND T7.IDRRef IN (SELECT T11.Reference39_IDRRef AS Q_005_F_000RRef FROM Reference39_VT812 T11 INNER JOIN InfoRg8729 T12 ON ((T12.Fld9652 = CAST(? AS CHAR(1) FOR BIT DATA) AND (T12.Fld8731_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T12.Fld8731_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T12.Fld8731_RRRef = CAST(? AS CHAR(16) FOR BIT DATA))) AND (T12.Fld8730_TYPE = T11.Fld814_TYPE AND T12.Fld8730_RTRef = T11.Fld814_RTRef AND T12.Fld8730_RRRef = T11.Fld814_RRRef)) WHERE ((T11.Fld509 = CAST(? AS NUMERIC(1, 0)))) AND (T12.Fld509 = CAST(? AS NUMERIC(1, 0)))))))) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END AS SDBL_RLS_SIGNAL_, T3.RecorderTRef AS RecorderTRef, T3.RecorderRRef AS RecorderRRef, T3.LineNo AS LineNo_, T3.Correspond AS Correspond_, T3.KindRRef AS KindRRef, T3.Value_TYPE AS Value_TYPE, T3.Value_RTRef AS Value_RTRef, T3.Value_RRRef AS Value_RRRef, T3.Fld509 AS Fld509_ FROM AccRgED553 T3 WHERE (T3.Fld509 = CAST(? AS NUMERIC(1, 0)))) T2 ON T1.RecorderTRef = T2.RecorderTRef AND T1.RecorderRRef = T2.RecorderRRef AND T1.LineNo = T2.LineNo_ LEFT OUTER JOIN Acc10_ExtDim515 T13 ON (CASE WHEN T2.Correspond_ = CAST(? AS NUMERIC(1, 0)) THEN T1.AccountDtRRef ELSE T1.AccountCtRRef END = T13.Acc10_IDRRef AND T2.KindRRef = T13.DimKindRRef) AND (T13.Fld509 = CAST(? AS NUMERIC(1, 0))) WHERE NOT (T2.RecorderTRef IS NULL AND T2.RecorderRRef IS NULL)
- 2 - - - EXECUTING SELECT A.TOTAL_CPU_TIME , TIMESTAMPDIFF(2, CHAR(CURRENT TIMESTAMP - A.LOCAL_START_TIME)) AS ELAPSED_TIME_SEC , A.ROWS_READ , A.ROWS_RETURNED , A.QUERY_COST_ESTIMATE , A.ACTIVITY_STATE , P.STMT_TEXT FROM TABLE(WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES_V97(NULL, -2)) A , TABLE(MON_GET_PKG_CACHE_STMT(NULL, A.EXECUTABLE_ID, NULL, A.DBPARTITIONNUM)) P ORDER BY A.TOTAL_CPU_TIME DESC
9 записей выбрано.
