|
Problem IT32612
|
Status: Closed |
-901 ERROR IS HAPPENED(BAD PLAN; UNRESOLVED QNC FOUND) WHEN EXECUTING PACKAGE REBIND IN V11.5.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When the package with usage of to_char/varchar_format already
exists in Db2v11.1 in the database and the format input is NOT
CONSTANT, the recompilation during rebind is failing with -901
when user upgrade the database after installing Db2v11.5.
-Error message -
db2 rebind package xxxx.Pxxxxxxxx
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "Bad Plan; Unresolved QNC found".) SQLSTATE=58004
Because of the error above,the FODC_AppErr dump file will
generate and we can look at the stack trace below.
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F472EF9F376
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
(/fsudb/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F472EF9EFBB ossDumpStackTraceV98 + 0x002b
(/fsudb/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F472EF9B1A7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
(/fsudb/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F4738974C57 sqlo_trce + 0x03c7
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4738B0D9BB sqloDumpDiagInfoHandler + 0x020b
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F47417215D0 address: 0x00007F47417215D0 ; dladdress:
0x00007F4741712000 ; offset in lib: 0x000000000000F5D0 ;
(/lib64/libpthread.so.0)
0x00007F474171E9D1 pthread_kill + 0x0031
(/lib64/libpthread.so.0)
0x00007F4738B0D572 sqloDumpEDU + 0x0052
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4731F2B959 _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
0x1199
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473918A645 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0695
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473A6A5857 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00a7
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473A6A5679
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x0199
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473792BA62 _Z10sqlnn_erdsiiiiiz + 0x0172
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737805904
_Z29sqlng_process_parse_tree_nodeP9sqlng_blkP9sqlnq_pid + 0x0a94
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F47378049C3
_Z21sqlng_process_BF_nodeP9sqlng_blkP9sqlnq_pid + 0x01c3
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737797982 _Z18sqlngBuildFragmentP9sqlnq_pidP9sqlnq_qur
+ 0x0a12
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737F13D8D
_Z22sqlnq_compile_fragmentPP8stknode_i10actiontypePhP3loc +
0x03dd
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737DEF8CE _Z12sqlnp_smactnP8sqlnp_cbi + 0x06ce
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737DDFDA8 _Z12sqlnp_parserP8sqlnp_cb + 0x1808
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737DE7B47
_Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x0827
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473793166F
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_enviiPP9sqlnq_qur + 0x302f
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473792E631
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq
lrr_cmpl_env + 0x0021
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473920582C
_Z10sqlrr_cmplP8sqlrr_cbP11sqlrrstrings17sqlnn_compileModehP5sql
daPiPjPP9sqlri_shdP11compileInfo + 0x04dc
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F47394C3739
_Z18sqlra_recreate_pkgP8sqlrr_cbiicP15sqlra_func_pathh + 0x2bd9
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4739447100
_Z16sqlra_rebind_pkgP8sqlrr_cbPhsS1_sS1_iicP15sqlra_func_pathb +
0x0320
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F47391B5D70
_Z12sqlrr_rebindP14db2UCinterfaceP12bind_options + 0x0940
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473724A783
_Z16sqljs_ddm_rebindP14db2UCinterfaceP13sqljDDMObject + 0x0403
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473720A22B
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x00bb
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473720B358
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x0558
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F47371FE0AC address: 0x00007F47371FE0AC ; dladdress:
0x00007F472F50D000 ; offset in lib: 0x0000000007CF10AC ;
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4737204926 address: 0x00007F4737204926 ; dladdress:
0x00007F472F50D000 ; offset in lib: 0x0000000007CF7926 ;
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473720551F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x011f
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4736C070B4 _ZN8sqeAgent6RunEDUEv + 0x0e24
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F473A6A5E5E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4738B0B429 sqloEDUEntry + 0x0589
(/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F4741719DD5 address: 0x00007F4741719DD5 ; dladdress:
0x00007F4741712000 ; offset in lib: 0x0000000000007DD5 ;
(/lib64/libpthread.so.0)
0x00007F472DF99EAD clone + 0x006d
(/lib64/libc.so.6) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 v11.5.4.0 or higher *
**************************************************************** |
| Local Fix: |
Re-create function that was failed to rebind package. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.04.2020
30.06.2020
30.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
