invispix 10x10
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT38609 Status: Closed

Reorg reclaim throws -901 as internal query compilation for synopsis table
was interrupted

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
Customer before 11.5.7 could encounter a false error when they
run Reorg Reclaim. Reorg reclaim was trying to execute an
internal SQL query and was interrupted during the compilation.
In most cases with interrupts, the response would be to rollback
the reclaim and allow it to retry at a later time. However,
because the interrupt occurred during this timing window, reorg
reclaim considered the interrupt as a severe error and threw an
error. Here, the RC - SQLNN_E_BADNEWS says that the query
compilation was interrupted.

This is a case where we are too harshly handling an interrupt
returned from the internal query executed by reclaim. This
problem should not have resulted from any issues with the table
or database.

2021-08-26-07.34.33.026026+000 I8828853A2019        LEVEL:
Severe
PID     : 677810191             TID : 4778758         PROC :
db2sysc 8
INSTANCE: db2inst1             NODE : 008           DB   :
testdb
APPHDL  : 8-17082              APPID: *NA.DB2.21082607003
AUTHID  : testdb             HOSTNAME: abc2-a-db2inst1
EDUID   : 394709              EDUNAME: db2taskp (CMDP) 8
FUNCTION: DB2 UDB, CDE Data,
DatabaseTableReorger::purgeSynopsisRowsBySQL, probe:387
MESSAGE : ZRC=0x803100AF=-2144272209=SQLNN_E_BADNEWS
          "unexpected error but state is OK"
DATA #1 : String, 25 bytes
Programming logic error.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
  [0] 0x090000001ED1D4E0
throwZrcException__Q3_7ibm_cde4data19BaseZrcErrorHandlerCFiUiUlT
1e + 0x1C0
  [1] 0x0900000026AB1C7C
purgeSynopsisRowsBySQL__Q3_7ibm_cde4data20DatabaseTableReorgerCF
RCQ2_3std12basic_stringXTcTQ2_3std11char_traitsXTc_TQ3_7ibm_cde
+ 0x32C
  [2] 0x090000001EF9A980
deleteSynopsisTableRows__Q3_7ibm_cde4data12TableReorgerFv +
0x5C0
  [3] 0x0900000026A93A50
reclaimExtents__Q3_7ibm_cde4data11TableActionFP8sqeAgentUsT2PCci
T4T5UlT5 + 0x710
  [4] 0x0900000026B403E4
reclaimExtents__Q3_7ibm_cde4data23cdeTableActionInterfaceFP8sqeA
gentUsT2PCciT4T5UlT5 + 0xD4
  [5] 0x090000000DB30E08
sqlrreorg_reclaim__FP8sqlrr_cbUsT2P8sqlrg_idiUlPUcT5T7T5UcbT2T5
+ 0x308
  [6] 0x0900000010B0E8DC reclaimTruncateTableTaskProcessor +
0xE6C
  [7] 0x0900000010CA5A48
taskProcessorDriver__8ABPAgentFP17ABPTaskProContext + 0x918
  [8] 0x0900000010CA5F10 main__8ABPAgentFP17ABPTaskProContext +
0x2B0
  [9] 0x090000000BB1E18C
abpAgentEntryPoint__FP8sqeAgentP17ABPTaskProContext + 0x6C
  [10] 0x09000000102E15EC
sqleIndCoordProcessRequest__FP8sqeAgent + 0x127C
  [11] 0x09000000098C1B10 RunEDU__8sqeAgentFv + 0xB10
  [12] 0x0900000009887BA0 EDUDriver__9sqzEDUObjFv + 0x2F0
  [13] 0x090000000979E7F4 sqloEDUEntry + 0x364
  [14] 0x09000000005ABFE8 _pthread_body + 0xE8
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to latest Cumulative Special Build of 11.5.6 and     *
* above.                                                       *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to latest Cumulative Special Build of 11.5.6 and     *
* above.                                                       *
****************************************************************
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.10.2021
21.11.2021
21.11.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10