home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC72824 Status: Geschlossen

INSTANCE MAY ABEND DURING COMPILATION OF A QUERY IF AN SQL0101N IS
ENCOUNTERED.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Instance may abend during compilation of a query if an SQL0101N 
is encountered. 
 
Such a scenario may be identified by an entry in db2diag.log 
that looks similar to: 
... 
YYYY-MM-DD-HH24.MI.SS.NNNNNN+NNN xxxxxxxxxxxxxx   LEVEL: Severe 
PID     : xxxxxx               TID  : xxxxx       PROC : db2sysc 
x 
INSTANCE: xxxxxx               NODE : xxx         DB   : 
xxxxxxxx 
APPHDL  : xxxxxx               APPID: xxxxxx 
AUTHID  : xxxxxx 
EDUID   : xxxxxx               EDUNAME: db2agent (xxxxxx) xxx 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -101   sqlerrml: 0 
 sqlerrmc: 
 sqlerrp : SQLNQ155 
 sqlerrd : (1) 0x8B0F000C      (2) 0x0000000C      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFF74      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
... 
 
Followed by a subsequent instance abend, whose stack trace looks 
similar to: 
sqlofmblkEx 
sqlnq_describe_output 
sqlnq_describe 
sqlnn_cmpl 
sqlnn_cmpl 
...
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fix Pack 8 or later.              * 
****************************************************************
Local-Fix:
Increase the value of the STMTHEAP database configuration 
parameter.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in DB2 Version 9.5 Fix Pack 8.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75195 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.11.2010
11.07.2011
11.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList