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 IC68980 Status: Geschlossen

-901 SQLCODE DURING DGTT CREATION IN DPF AFTER A NODEFAILURE

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
In DPF a -901 sqlcode can result during the creation of a DGTT 
with the following probes in the db2diag.log: 
 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 33 
 sqlerrmc: sqlrl_dgtt_rcv: buffer pool error 
 sqlerrp : SQLRL15C 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFD8      (6) 
0x0000000F 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 
 
This can happen if the aftermath of a node or communication 
failure where the partition failing had DGTT partitions defined 
on it at the time of the node failure.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF. applications that have declared global temporary tables * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* -901 sqlcode during declare of global temporary table        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Move to  DB2 for LUW version 9.5 fixpack 6                   * 
****************************************************************
Local-Fix:
bring down the database after node failure.   Otherwise no 
workaround available
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
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
Fixed in DB2 for LUW version 9.5 fixpack 6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC68982 IC68983 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
02.06.2010
22.06.2010
22.06.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP6
Problem behoben lt. FixList in der Version