3537788 - DB6: SQL 1224 Error on ADC

• Frequent error messages SQL1224N related to BW temporary tables (e.g. /BI0/02*) were noticed in db2diag.log file.
• The error was related to interrupted Automatic Dictionary Creation (ADC). 
• The pattern was only observed on temporary tables (e.g. /BI0/02*).
• Runstats was called at same timestamp on the same temporary tables (e.g. /BI0/02*), which is seen in db2optstats.*.log.
  
  

db2diag.log

2024-10-31-09.30.10.196968-240 I4546A1316           LEVEL: Info
PID     : 7079416              TID : 652751         PROC : db2sysc 0
INSTANCE: db2<sid>               NODE : 000           DB   : <sid>
APPHDL  : 0-221                APPID: *N0.DB2.241031134449
AUTHID  : DB2<sid>               HOSTNAME: *
EDUID   : 652751               EDUNAME: db2taskp (*) 0
FUNCTION: DB2 UDB, ADC, adcProcessError, probe:291
MESSAGE : ZRC=0x82A90066=-2102853530=ABP_SUSPEND_TASK_PRO
          "Suspend the task processor"
DATA #1 : String, 20 bytes
Suspending ADC task:
DATA #2 : ABP Task Processor Descriptor, PD_ABP_TYPE_TASK_PRO_DESC, 40 bytes

DATA #3 : String, 72 bytes
Build task for Automatic Dictionary Creation on SAP<sid>  ./BI0/0200000960

2024-10-31-09.30.10.199807-240 E5863A940            LEVEL: Error
PID     : 7079416              TID : 652751         PROC : db2sysc 0
INSTANCE: db2<sid>               NODE : 000           DB   : <sid>
APPHDL  : 0-221                APPID: *N0.DB2.241031134449
AUTHID  : DB2<sid>               HOSTNAME: *
EDUID   : 652751               EDUNAME: db2taskp (*) 0
FUNCTION: DB2 UDB, base sys utilities, sqleMergeSqlca, probe:20
DATA #1 : String, 62 bytes
Received sqlcode -1224 for request 80000017 from node number 0
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1224   sqlerrml: 0
 sqlerrmc: 
 sqlerrp : SQLE05A 

db2optstats.*.log

2024-10-31-09.30.10.188080-240 E2635008A695         LEVEL: Event
PID     : 7079416              TID : 724308         PROC : db2sysc 0
INSTANCE: db2<sid>               NODE : 000           DB   : <sid>
APPHDL  : 0-1098               APPID: 30.93.209.82.40404.241031133008
UOWID   : 14                   ACTID: 1              
AUTHID  : SAP<sid>               HOSTNAME: *
EDUID   : 724308               EDUNAME: db2agent (*) 0
FUNCTION: DB2 UDB, relation data serv, sqlrLocalRunstats, probe:10
COLLECT : TABLE AND INDEX STATS : Object name with schema : AT "2024-10-31-09.30.10.188002" : BY "User" : start
OBJECT  : Object name with schema, 24 bytes
SAPBP1  ./BI0/0200000960
IMPACT  : None

2024-10-31-09.30.10.225152-240 E2635704A852         LEVEL: Event
PID     : 7079416              TID : 724308         PROC : db2sysc 0
INSTANCE: db2<sid>               NODE : 000           DB   : <sid>
APPHDL  : 0-1098               APPID: 30.93.209.82.40404.241031133008
UOWID   : 14                   ACTID: 1              
AUTHID  : SAP<sid>               HOSTNAME: *
EDUID   : 724308               EDUNAME: db2agent (*) 0
FUNCTION: DB2 UDB, relation data serv, sqlrLocalRunstats, probe:220
COLLECT : TABLE AND INDEX STATS : Object name with schema : AT "2024-10-31-09.30.10.225084" : BY "User" : success
OBJECT  : Object name with schema, 24 bytes
SAP<sid>  ./BI0/0200000960
IMPACT  : None
DATA #1 : String, 125 bytes
RUNSTATS ON TABLE "SAP<SID>"."/BI0/0200000960" ON ALL COLUMNS WITH DISTRIBUTION ON ALL COLUMNS AND SAMPLED DETAILED INDEXES ALL

• SAP on IBM Db2 for Linux, UNIX, and Windows

SQL 1224 Error, ADC, BW temporary tables, sqlcode -1224, /BI0/02*,  Suspend the task processor , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem