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: |
