Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / IBM DB2, WebSphere, IMS, U2, etc Новый топик    Ответить
 DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Здравствуйте!
Такая проблема:
Сервер windows 2003
Intel Xeon CPU E7 - 8860 @ 2.27 Гц
16 Гб ОЗУ

при этом загрузка ЦПУ процессом db2syscs.exe на 100%



Подскажите пожалуйста.
10 июн 13, 14:39    [14415244]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4949
chiz,

Здравствуйте.

По запросам, выполняющимся в данный момент:

SELECT 
TOTAL_CPU_TIME, ROWS_READ, ROWS_RETURNED
, QUERY_COST_ESTIMATE, ACTIVITY_STATE, STMT_TEXT
FROM SYSIBMADM.MON_CURRENT_SQL
ORDER BY TOTAL_CPU_TIME DESC
10 июн 13, 15:15    [14415596]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Вот что выдало.



------------------------------ Введенные команды ------------------------------
SELECT
TOTAL_CPU_TIME, ROWS_READ, ROWS_RETURNED
, QUERY_COST_ESTIMATE, ACTIVITY_STATE, STMT_TEXT
FROM SYSIBMADM.MON_CURRENT_SQL
ORDER BY TOTAL_CPU_TIME DESC;
------------------------------------------------------------------------------
SELECT TOTAL_CPU_TIME, ROWS_READ, ROWS_RETURNED , QUERY_COST_ESTIMATE, ACTIVITY_STATE, STMT_TEXT FROM SYSIBMADM.MON_CURRENT_SQL ORDER BY TOTAL_CPU_TIME DESC
SQL0204N Имя "SYSIBMADM.MON_CURRENT_SQL" не было определено. SQLSTATE=42704

SQL0204N Имя "SYSIBMADM.MON_CURRENT_SQL " не было определено.

+
Объяснение:

Эта ошибка может возникнуть по одной из следующих причин:

* Объект, обозначенный именем "<имя>", не был определен в базе данных.
* Объект, обозначенный именем "<имя>", определен в модуле и не является
опубликованным объектом модуля, но используется вне модуля.
* Раздел данных c именем "<имя>" не был определен на таблице.
* Имя обозначает тип данных. Эта ошибка может возникнуть по следующим
причинам:
* Если имя "<имя>" содержит спецификаторы, такого типа данных нет
либо в схеме, соответствующей спецификатору, или в модуле,
соответствующем спецификатору и найденному первым в
пользовательском пути SQL.
* Если имя "<имя>" не содержит спецификаторов, пользовательский путь
не содержит схемы, к которой принадлежит требуемый тип данных, или
тип данных не определен в модуле, но используется в подпрограмме
модуля.
* Тип данных не существует в базе данных с отметкой времени создания
до момента связывания пакета (этот вариант относится к статическим
операторам).
* Если тип данных входит в условие UNDER оператора CREATE TYPE,
возможно, имя типа совпадает с именем определяемого типа, что
недопустимо.

* Обозначенная этим именем функция используется в одном из следующих:
* оператор DROP FUNCTION
* оператор COMMENT ON FUNCTION
* условие SOURCE оператора CREATE FUNCTION

Если имя "<имя>" содержит спецификаторы, такой функции не
существует. Если имя "<имя>" не содержит спецификаторов, функции с
таким именем не существует ни в одной схеме в текущем пути.



Заметим, что функция не может быть порождена встроенными функциями
COALESCE, DBPARTITIONNUM, GREATEST, HASHEDVALUE, LEAST, MAX
(скалярной), MIN (скалярной), NULLIF, RID, NVL, RAISE_ERROR,
TYPE_ID, TYPE_NAME, TYPE_SCHEMA или VALUE.

* Элемент с именем "<имя>" используется в операторе CREATE SECURITY
LABEL COMPONENT справа от условия UNDER, но этот элемент еще не
определен как ROOT (корневой) или UNDER (под каким-то другим
элементом)
* Элемент компонента метки защиты с именем "<имя>" еще не определен.
* Одна из приведенных ниже скалярных функций задала правила защиты с
именем "<имя>", которые не определены в базе данных.
* SECLABEL
* SECLABEL_TO_CHAR
* SECLABEL_BY_NAME

Такой код возврата может быть сгенерирован для любого типа объектов базы
данных.

Пользователи системы объединения: объект с именем "<имя>" не определен в
базе данных, или же "<имя>" в операторе DROP NICKNAME - не псевдоним.

Некоторые источники данных не передают правильные значения
параметров"<имя>" для этого сообщения. В таком случае параметр этого
сообщения будет иметь следующий формат: "OBJECT:<источник-данных>
TABLE/VIEW", указывая тем самым, что для заданного источника данных
действительное значение этого параметра неизвестно.

Оператор невозможно обработать.

Действия пользователя:

Убедитесь, что в операторе SQL правильно задано имя объекта (включая все
необходимые спецификаторы) и что этот объект существует. Если имя
указывает на раздел данных, сделайте запрос к таблице каталога
SYSCAT.DATAPARTITIONS, чтобы узнать имена всех разделов данных для
таблицы. Если ненайденный тип данных или функция заданы в условии
SOURCE, то может оказаться, что такой объект не существует, или же он
может существовать в какой-либо схеме, но эта схема не входит в ваш
путь.

Для оператора CREATE или ALTER SECURITY LABEL COMPONENT убедитесь, что
каждый элемент, задаваемый в условии UNDER как ссылочный для
позиционирования положения нового элемента, уже существует в компоненте
метки защиты.

Для оператора CREATE SECURITY LABEL COMPONENT убедитесь, что каждый
элемент, задаваемый в условии UNDER как родительский, ранее задан либо
как ROOT, либо как дочерний элемент в условии UNDER.

Для скалярных функций SECLABEL, SECLABEL_TO_CHAR или SECLABEL_BY_NAME
убедитесь, что в качестве аргумента имя_правил_защиты задано допустимое
имя правил защиты.

Пользователи системы объединения: для оператора DROP NICKNAME убедитесь,
что объект - действительно псевдоним. Объект может не существовать в
базе данных объединения или на источнике данных. Убедитесь, что объекты
существуют в базе данных объединения и на источниках данных.

sqlcode: -204

sqlstate: 42704
10 июн 13, 15:44    [14415907]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4949
chiz,

Версия DB2 какая?
10 июн 13, 15:56    [14416011]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Mark Barinstein,

DB2 v.9.7.0.441
10 июн 13, 15:57    [14416022]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4949
chiz
DB2 v.9.7.0.441
На db2 9.7 без фикспаков гонять 1С...

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
10 июн 13, 16:39    [14416364]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Mark Barinstein,

Извините, забыл сказать, что грущится на 100% когда пользователи начинают активную работу.

Выполнил команду для 3х ситуаций.
+=Низкий процент - около 2х пользователей
Картинка с другого сайта.


+=50% - около 15 пользователей
Картинка с другого сайта.


+=100% - 30 пользователей
Картинка с другого сайта.


Но на 100% вышло только тогда когда пользователи стали именно активно работать.

К сообщению приложен файл. Размер - 58Kb
11 июн 13, 09:24    [14418583]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4949
chiz,

Текст запроса вы увидите, если сделаете (у меня по-ангийски, не знаю, как там по-русски переведено):
Tools (Инструменты) -> Tools Settings (последний пункт подменю) -> Command Editor (предпоследняя вкладка)
и снимите флаг Display results for a single query on the Query Results page (в нижней группе переключателей).
11 июн 13, 09:36    [14418621]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Mark Barinstein,

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 записей выбрано.
11 июн 13, 09:42    [14418664]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Mark Barinstein,

Посоветуете фикспаки?

В другом регионе стоит Microsoft SQL и там проблем нет.
11 июн 13, 10:47    [14419036]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4949
chiz
Посоветуете фикспаки?
Где-то на сайте 1c есть db2 express-c 9.7.6 - поставьте его.
11 июн 13, 11:17    [14419240]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Mark Barinstein,

а по получившимся результатам запроса можно что-то сказать?
11 июн 13, 11:38    [14419410]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
Mark Barinstein
Member

Откуда: Москва
Сообщений: 4949
chiz
а по получившимся результатам запроса можно что-то сказать?

Ну, из вывода видно, что у вас висят несколько долго выполняющих запросов.
Надо планы этих запросов смотреть.
Надо понимать, что это за запросы, что они вообще логически делают и как можно повлиять на систему, чтобы эти запросы изменились.
Я не специалист в 1c и не могу сказать, что эти запросы делают.

Можно попытаться собрать статистику на таблицы, лежащие под представлениями в этих запросах, если эта статистика по какой-то причине не собирается сама...
11 июн 13, 13:28    [14420244]     Ответить | Цитировать Сообщить модератору
 Re: DB2 + 1с - загрузка ЦПУ процессом db2syscs.exe на 100%  [new]
chiz
Member

Откуда:
Сообщений: 89
Mark Barinstein,

Thanks!
11 июн 13, 13:39    [14420344]     Ответить | Цитировать Сообщить модератору
Все форумы / IBM DB2, WebSphere, IMS, U2, etc Ответить