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

-901 ERROR MAY OCCUR WHILE REVALIDATING ROUTINE WITH UNUSED CTE,FOLLOWED BY
INSTANCE TRAP AT SQLNQ_FTB.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If an unused declaration of CTE (Common Tables Expressions) 
exists ,the -901 error will raise while revalidating (For 
example, by calling SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS) the 
routine. 
 
From db2diag.log: 
 
2012-10-29-00.56.39.625939-240 I117181E880         LEVEL: Severe 
PID     : 30465                TID  : 46912824666432PROC : 
db2sysc 
INSTANCE: hujinpei             NODE : 000          DB   : ALANDB 
APPHDL  : 0-1886               APPID: 
*LOCAL.hujinpei.121029045408 
AUTHID  : HUJINPEI 
EDUID   : 125                  EDUNAME: db2agent (ALANDB) 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCAL    sqlcabc: 136   sqlcode: -901   sqlerrml: 52 
 sqlerrmc: No column information found in the packed descriptor 
 sqlerrp : SQLNQ1FD 
 sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3) 
0x0000002D 
           (4) 0x00000000      (5) 0xFFFFFF9C      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
With the stack info from generated FODC_AppErr package: 
 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00002AAAB083F417 ossDumpStackTraceEx + 0x01ef 
0x00002AAAB083A1D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
0x00002AAAAD756894 sqlo_trce + 0x040a 
0x00002AAAAD79D3D5 sqloDumpDiagInfoHandler + 0x00ed 
0x00002AAAAABD2005 pthread_kill + 0x0035 
0x00002AAAAD79C7BF sqloDumpEDU + 0x0045 
0x00002AAAAC9F4CEA _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi + 
0x069e 
0x00002AAAAC237541 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0555 
0x00002AAAAC4490AC _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x0020 
0x00002AAAAC448207 
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x00f7 
0x00002AAAABF2BB8B _Z10sqlnn_erdsiiiiiz + 0x014b 
0x00002AAAAC04D2EF _ZN9sqlnq_ftb14refftb_numcolsEPS_Pi + 0x046b 
0x00002AAAAC0B3EA1 
_Z27sqlnq_handle_qtb_extref_rec20sqlnq_multipart_namePP9sqlnq_qt 
biP3loc21sqlnq_hierarchy_usage + 0x0a55 
 
During the error handling in sqlnq_ftb::refftb_numcols that we 
report -901 may later cause the instance trap with Signal #11: 
 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00002AAAB083F417 ossDumpStackTraceEx + 0x01ef 
0x00002AAAB083A1D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
0x00002AAAAD756894 sqlo_trce + 0x040a 
0x00002AAAAD79D78F sqloEDUCodeTrapHandler + 0x025f 
0x00002AAAAC04D38D _ZN9sqlnq_ftb14refftb_numcolsEPS_Pi + 0x0509 
0x00002AAAAC0B3EA1 
_Z27sqlnq_handle_qtb_extref_rec20sqlnq_multipart_namePP9sqlnq_qt 
biP3loc21sqlnq_hierarchy_usage + 0x0a55 
0x00002AAAAC0AF022 
_Z29sqlnq_handle_named_ref_in_srcP12sqlnq_stringiPP9sqlnq_qtbPP9 
sqlnq_qunPP9sqlnq_qncP3loc21sqlnq_hierarchy_usageP20sqlnq_multip 
art_name + 0x040a 
0x00002AAAAC0DDD5E 
_Z22sqlnq_handle_table_refP20sqlnq_multipart_namePP9sqlnq_qunP9s 
qlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usage + 0x0090 
0x00002AAAAC0DD966 
_Z27sqlnq_handle_from_table_refP20sqlnq_multipart_namePhiPP9sqln 
q_qunP9sqlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usagePP8stknod 
e_ + 0x007a 
0x00002AAAAE4FAD68 _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc + 
0xf1e4
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL USERS                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If an unused declaration of CTE (Common Tables Expressions)  * 
* exists ,the -901 error will raise while revalidating (For    * 
* example, by calling SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS) the * 
* routine.                                                     * 
*                                                              * 
* From db2diag.log:                                            * 
*                                                              * 
* 2012-10-29-00.56.39.625939-240 I117181E880         LEVEL:    * 
* Severe                                                       * 
* PID     : 30465                TID  : 46912824666432PROC :   * 
* db2sysc                                                      * 
* INSTANCE: hujinpei             NODE : 000          DB   :    * 
* ALANDB                                                       * 
* APPHDL  : 0-1886               APPID:                        * 
* *LOCAL.hujinpei.121029045408                                 * 
* AUTHID  : HUJINPEI                                           * 
* EDUID   : 125                  EDUNAME: db2agent (ALANDB)    * 
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,      * 
* probe:300                                                    * 
* DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes                * 
*  sqlcaid : SQLCAL    sqlcabc: 136   sqlcode: -901            * 
* sqlerrml: 52                                                 * 
*  sqlerrmc: No column information found in the packed         * 
* descriptor                                                   * 
*  sqlerrp : SQLNQ1FD                                          * 
*  sqlerrd : (1) 0x801A006D      (2) 0x00000000      (3)       * 
* 0x0000002D                                                   * 
*            (4) 0x00000000      (5) 0xFFFFFF9C      (6)       * 
* 0x00000000                                                   * 
*  sqlwarn : (1)      (2)      (3)      (4)        (5)         * 
* (6)                                                          * 
*                                                              * 
*            (7)      (8)      (9)      (10)        (11)       * 
*  sqlstate:                                                   * 
*                                                              * 
* With the stack info from generated FODC_AppErr package:      * 
*                                                              * 
* <StackTrace>                                                 * 
* -----FUNC-ADDR---- ------FUNCTION + OFFSET------             * 
* 0x00002AAAB083F417 ossDumpStackTraceEx + 0x01ef              * 
* 0x00002AAAB083A1D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +  * 
* 0x00cc                                                       * 
* 0x00002AAAAD756894 sqlo_trce + 0x040a                        * 
* 0x00002AAAAD79D3D5 sqloDumpDiagInfoHandler + 0x00ed          * 
* 0x00002AAAAABD2005 pthread_kill + 0x0035                     * 
* 0x00002AAAAD79C7BF sqloDumpEDU + 0x0045                      * 
* 0x00002AAAAC9F4CEA _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi * 
* +                                                            * 
* 0x069e                                                       * 
* 0x00002AAAAC237541 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0555  * 
* 0x00002AAAAC4490AC _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai +    * 
* 0x0020                                                       * 
* 0x00002AAAAC448207                                           * 
* _Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag +     * 
* 0x00f7                                                       * 
* 0x00002AAAABF2BB8B _Z10sqlnn_erdsiiiiiz + 0x014b             * 
* 0x00002AAAAC04D2EF _ZN9sqlnq_ftb14refftb_numcolsEPS_Pi +     * 
* 0x046b                                                       * 
* 0x00002AAAAC0B3EA1                                           * 
* _Z27sqlnq_handle_qtb_extref_rec20sqlnq_multipart_namePP9sqln * 
* q_qt                                                         * 
* biP3loc21sqlnq_hierarchy_usage + 0x0a55                      * 
*                                                              * 
* During the error handling in sqlnq_ftb::refftb_numcols that  * 
* we                                                           * 
* report -901 may later cause the instance trap with Signal    * 
* #11:                                                         * 
*                                                              * 
* <StackTrace>                                                 * 
* -----FUNC-ADDR---- ------FUNCTION + OFFSET------             * 
* 0x00002AAAB083F417 ossDumpStackTraceEx + 0x01ef              * 
* 0x00002AAAB083A1D6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +  * 
* 0x00cc                                                       * 
* 0x00002AAAAD756894 sqlo_trce + 0x040a                        * 
* 0x00002AAAAD79D78F sqloEDUCodeTrapHandler + 0x025f           * 
* 0x00002AAAAC04D38D _ZN9sqlnq_ftb14refftb_numcolsEPS_Pi +     * 
* 0x0509                                                       * 
* 0x00002AAAAC0B3EA1                                           * 
* _Z27sqlnq_handle_qtb_extref_rec20sqlnq_multipart_namePP9sqln * 
* q_qt                                                         * 
* biP3loc21sqlnq_hierarchy_usage + 0x0a55                      * 
* 0x00002AAAAC0AF022                                           * 
* _Z29sqlnq_handle_named_ref_in_srcP12sqlnq_stringiPP9sqlnq_qt * 
* bPP9                                                         * 
* sqlnq_qunPP9sqlnq_qncP3loc21sqlnq_hierarchy_usageP20sqlnq_mu * 
* ltip                                                         * 
* art_name + 0x040a                                            * 
* 0x00002AAAAC0DDD5E                                           * 
* _Z22sqlnq_handle_table_refP20sqlnq_multipart_namePP9sqlnq_qu * 
* nP9s                                                         * 
* qlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usage + 0x0090     * 
* 0x00002AAAAC0DD966                                           * 
* _Z27sqlnq_handle_from_table_refP20sqlnq_multipart_namePhiPP9 * 
* sqln                                                         * 
* q_qunP9sqlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usagePP8st * 
* knod                                                         * 
* e_ + 0x007a                                                  * 
* 0x00002AAAAE4FAD68                                           * 
* _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc +                * 
* 0xf1e4                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to...                                                * 
****************************************************************
Local-Fix:
Removes 'unused' declaration of CTE (Common Tables Expressions) 
from the routine.
verfügbare FixPacks:
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

Lösung
This problem will be fixed in...
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC88178 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2012
01.04.2013
01.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.8 FixList