suche 36x36
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 IT21803 Status: Closed

AUTO_REORG ON ITC TABLES MAY FAIL WITH SQL0960, INDEX EVALUATIONIS
LOOPING

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
DB2 AUTO REORG may fail to evaluate ITC (Insert Time Clustering)
tables and cause SQLCODE -960 (SQL0960N) errors in db2diag.log:

2016-09-12-01.36.10.332692+120 I846576A571          LEVEL: Error
PID     : 40960108             TID : 1239           PROC :
db2acd 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPID   : *LOCAL.db2inst1.160910162203
HOSTNAME: localhost
EDUID   : 1239                 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalReorg, probe:997
MESSAGE : Failed to evaluate table "SSSSS"."ITCTAB". Probe 805 .
SQLCODE = -960
DATA #1 : Hexdump, 4 bytes
0x00000001120DEE34 : FFFF FC40
..

AND sometimes this as well:

2016-08-30-09.44.08.243692+120 I1578561A573 LEVEL: Error
PID : 40960108 TID : 2554 PROC : db2acd 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPID : *LOCAL.db2inst1.160830042201
HOSTNAME: localhost
EDUID : 2554 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalReorg, probe:997
MESSAGE : Failed to evaluate table "SSSSS "."TTTTTT". Probe 535
.
SQLCODE = -960
DATA #1 : Hexdump, 4 bytes
0x0000000113935E34 : FFFF FC40 ...@

The SQL0960N error is caused by a endless loop that creates temp
tables in SYSTOOLSTMPSPACE till it's limit of objects is
reached.

Note: The message in 'Probe 535' is a subsequent error caused by
the original problem in 'Probe 805' and may not necessarily show
an ITC table (it could be any table).
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Problem Description above.                               *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 Version 11.1 Fix Pack 2.                      *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT17725 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.08.2017
10.10.2017
10.10.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)