|
Problem IC78109
|
Status: Closed |
A SQL STATEMENT CAUSES AN INSTANCE CRASH FOLLOWING A SQL0901N ERROR WITH REASON "THIS->QNCQNCDER.PP() != NULL". |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A SQL statement causes an instance crash following a SQL0901N
error with reason "this->qncqncder.pp() != NULL". User can
see the following entry in the db2diag.log:
EDUID : 47099 EDUNAME: db2agent (SMPLDB) 0
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: 28
sqlerrmc: this->qncqncder.pp() != NULL
sqlerrp : SQLNQ253
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFF92 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
User can also see the following stack for the process
reporting the SQL0901N error:
sqlzeSqlCode + 0x238
sqlnn_erds__FiN41e + 0x340
relins + 0x174
sqlnr_qncdereqc + 0x64
sqlnx_exp_gsql_get_sample_tab + 0x508
sqlnx_exp_gsql_std + 0x630
[.... SKIP ....] |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 9.7 FP4 and below *
****************************************************************
* PROBLEM DESCRIPTION: *
* A SQL statement causes an instance crash following a *
* SQL0901N *
* error with reason "this->qncqncder.pp() != NULL". User can *
* see the following entry in the db2diag.log: *
* *
* *
* EDUID : 47099 EDUNAME: db2agent (SMPLDB) 0 *
* 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: 28 *
* sqlerrmc: this->qncqncder.pp() != NULL *
* sqlerrp : SQLNQ253 *
* sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) *
* 0x00000000 *
* (4) 0x00000000 (5) 0xFFFFFF92 (6) *
* 0x00000000 *
* sqlwarn : (1) (2) (3) (4) (5) *
* (6) *
* (7) (8) (9) (10) (11) *
* sqlstate: *
* *
* User can also see the following stack for the process *
* reporting the SQL0901N error: *
* *
* *
* sqlzeSqlCode + 0x238 *
* sqlnn_erds__FiN41e + 0x340 *
* relins + 0x174 *
* sqlnr_qncdereqc + 0x64 *
* sqlnx_exp_gsql_get_sample_tab + 0x508 *
* sqlnx_exp_gsql_std + 0x630 *
* [.... SKIP ....] *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP5 *
**************************************************************** |
| Local Fix: |
This crash has been determined to be caused by db2advis tool.
Avoid using db2advis to avoid the crash. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.08.2011
03.10.2013
03.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
