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

DB2 MAY RETURN SQL901 ERROR OR TERMINATE ABNORMALLY DUE TO IMPROPER
HANDLING OF ARRAY INSERT IN DPF ENVIRONMENT

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In some rare situation, DB2 may return SQL901 error with message 
"BQS Sequencing Error" or terminate abnormally due to improper 
handling of array insert in DPF environment. 
 
You might see the following db2diag.log entries: 
 
2015-02-25-20.56.28.650865-300 I4254475E468        LEVEL: Severe 
PID     : 14838                TID  : 140705905239808PROC : 
db2sysc 79 
INSTANCE: db2inst1             NODE : 079          DB   : SAMPLE 
APPHDL  : 1-5859               APPID: 
10.195.176.210.38005.150312140432 
AUTHID  : db2user 
EDUID   : 353571               EDUNAME: db2agntp (SAMPLE) 79 
FUNCTION: DB2 UDB, buffer Q services, sqlkqrcv, probe:70 
MESSAGE : BQS Sequencing Error! Conn: 0, Rcvd: 7, Expected: 6 
 
2015-02-25-20.56.28.651180-300 I4254944E584        LEVEL: Error 
PID     : 14838                TID  : 140705905239808PROC : 
db2sysc 79 
INSTANCE: db2inst1             NODE : 079          DB   : SAMPLE 
APPHDL  : 1-5859               APPID: 
10.195.176.210.38005.150312140432 
AUTHID  : db2user 
EDUID   : 353571               EDUNAME: db2agntp (SAMPLE) 79 
FUNCTION: DB2 UDB, table Q services, sqlktrcv, probe:50 
MESSAGE : DIA0001E An internal error occurred. Report the 
following error code 
          : "Line=00625, rc1=0x82180001, rc2=0x00000000, 
rc3=(nil), 
          msg=sqlkqrcv(conn)". 
 
2015-02-25-20.56.28.653235-300 I4259870E877        LEVEL: Severe 
PID     : 14838                TID  : 140705905239808PROC : 
db2sysc 79 
INSTANCE: db2inst1             NODE : 079          DB   : SAMPLE 
APPHDL  : 1-5859               APPID: 
10.195.176.210.38005.150312140432 
AUTHID  : db2user 
EDUID   : 353571               EDUNAME: db2agntp (SAMPLE) 79 
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: -901   sqlerrml: 43 
 sqlerrmc: probe 050 in sqlktrcv(), msg=sqlkqrcv(conn) 
 sqlerrp : SQLRI087 
 sqlerrd : (1) 0x82180001      (2) 0x00000001      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFE0C      (6) 
0x0000004F 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description below.                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 11.                      * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 Version 9.7 Fix Pack 11.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.04.2015
26.10.2015
26.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP11
Problem behoben lt. FixList in der Version
9.7.0.11 FixList