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

-901 ERROR IS RETURNED WHILE CREATING EVENT MONITOR ERROR
MESSAGE: THIS IS NOT A CONSTANT QNC

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The following error is encountered while trying to create an 
event monitor: 
 
CREATE EVENT MONITOR ILUSER 
 
FOR STATEMENTS WHERE AUTH_ID = 'ILUSER' , TRANSACTIONS  WHERE 
AUTH_ID = 'ILUSER' WRITE TO TABLE CONNHEADER (TABLE 
db2inst1.CONNHEADER_ILUSER in userspace1), STMT       (TABLE 
db2inst1.STMT_ILUSER in userspace1), CONTROL    (TABLE 
db2inst1.CONTROL_ILUSER in userspace1), XACT (TABLE 
db2inst1.XACT_ILUSER in userspace1) ; 
 
 
SQL0901N  The SQL statement failed because of a non-severe 
system error. Subsequent SQL statements can be processed. 
(Reason "This is not a constant qnc".)  SQLSTATE=58004 
 
The db2diag.log shows the following: 
 
2010-04-13-16.47.04.314580+330 E12361893A552      LEVEL: Severe 
PID     : 266476               TID  : 31898       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : DBATEST 
APPHDL  : 0-12577              APPID: 
*LOCAL.db2inst1.100413111521 
AUTHID  : DB2INST1 
EDUID   : 31898                EDUNAME: db2agent (DBATEST) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:200 
MESSAGE : ADM0001C  A severe error has occurred.  Examine the 
administration 
          notification log and contact IBM Support if necessary. 
 
2010-04-13-16.47.04.315278+330 I12362446A453      LEVEL: Severe 
PID     : 266476               TID  : 31898       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : DBATEST 
APPHDL  : 0-12577              APPID: 
*LOCAL.db2inst1.100413111521 
AUTHID  : DB2INST1 
EDUID   : 31898                EDUNAME: db2agent (DBATEST) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:250 
RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown" 
 
2010-04-13-16.47.04.315564+330 I12362900A626      LEVEL: Severe 
PID     : 266476               TID  : 31898       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : DBATEST 
APPHDL  : 0-12577              APPID: 
*LOCAL.db2inst1.100413111521 
AUTHID  : DB2INST1 
EDUID   : 31898                EDUNAME: db2agent (DBATEST) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:275 
MESSAGE : MASTER TIME INFO 
DATA #1 : Hexdump, 32 bytes 
0x070000013F1D9488 : 0000 0000 4BC4 52A3 03DB 0000 000F 114B 
....K.R........K 
0x070000013F1D9498 : 0002 2C66 DB32 9287 0000 0000 001F 3A41 
..,f.2........:A 
 
2010-04-13-16.47.04.315834+330 I12363527A187      LEVEL: Severe 
PID:266476 TID:31898 NODE:000 Title: MASTER TIME INFO 
Dump 
File:/db2home/db2inst1/sqllib/db2dump/266476.31898.000.dump.bin 
 
2010-04-13-16.47.04.323932+330 I12363715A854      LEVEL: Severe 
PID     : 266476               TID  : 31898       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : DBATEST 
APPHDL  : 0-12577              APPID: 
*LOCAL.db2inst1.100413111521 
AUTHID  : DB2INST1 
EDUID   : 31898                EDUNAME: db2agent (DBATEST) 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: 26 
 sqlerrmc: This is not a constant qnc 
 sqlerrp : SQLNQ248 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFFCE      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
.... 
..... 
 
2010-04-13-16.47.04.328445+330 I12367839A2246     LEVEL: Severe 
PID     : 266476               TID  : 31898       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : DBATEST 
APPHDL  : 0-12577              APPID: 
*LOCAL.db2inst1.100413111521 
AUTHID  : DB2INST1 
EDUID   : 31898                EDUNAME: db2agent (DBATEST) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling, 
probe:200 
MESSAGE : section stmt 
DATA #1 : Hexdump, 352 bytes 
0x070000012001AD84 : 4352 4541 5445 2045 5645 4E54 204D 4F4E 
CREATE EVENT MON 
0x070000012001AD94 : 4954 4F52 2049 4C55 5345 5220 464F 5220 
ITOR ILUSER FOR 
0x070000012001ADA4 : 5354 4154 454D 454E 5453 2057 4845 5245 
STATEMENTS WHERE 
0x070000012001ADB4 : 2041 5554 485F 4944 203D 2027 494C 5553 
AUTH_ID = 'ILUS 
0x070000012001ADC4 : 4552 2720 2C20 5452 414E 5341 4354 494F 
ER' , TRANSACTIO 
0x070000012001ADD4 : 4E53 2020 5748 4552 4520 2041 5554 485F 
NS  WHERE  AUTH_ 
0x070000012001ADE4 : 4944 203D 2027 494C 5553 4552 2720 5752 
ID = 'ILUSER' WR 
0x070000012001ADF4 : 4954 4520 544F 2054 4142 4C45 2043 4F4E 
ITE TO TABLE CON 
0x070000012001AE04 : 4E48 4541 4445 5220 2854 4142 4C45 2064 
NHEADER (TABLE d 
0x070000012001AE14 : 6232 696E 7374 312E 434F 4E4E 4845 4144 
b2inst1.CONNHEAD 
0x070000012001AE24 : 4552 5F49 4C55 5345 5220 696E 2075 7365 
ER_ILUSER in use 
0x070000012001AE34 : 7273 7061 6365 3129 2C20 5354 4D54 2020 
rspace1), STMT 
0x070000012001AE44 : 2020 2020 2028 5441 424C 4520 6462 3269 
(TABLE db2i 
0x070000012001AE54 : 6E73 7431 2E53 544D 545F 494C 5553 4552 
nst1.STMT_ILUSER 
0x070000012001AE64 : 2069 6E20 7573 6572 7370 6163 6531 292C 
in userspace1), 
0x070000012001AE74 : 2043 4F4E 5452 4F4C 2020 2020 2854 4142 
CONTROL    (TAB 
0x070000012001AE84 : 4C45 2064 6232 696E 7374 312E 434F 4E54 
LE db2inst1.CONT 
0x070000012001AE94 : 524F 4C5F 494C 5553 4552 2069 6E20 7573 
ROL_ILUSER in us 
0x070000012001AEA4 : 6572 7370 6163 6531 292C 2058 4143 5420 
erspace1), XACT 
0x070000012001AEB4 : 2020 2020 2020 2854 4142 4C45 2064 6232 
(TABLE db2 
0x070000012001AEC4 : 696E 7374 312E 5841 4354 5F49 4C55 5345 
inst1.XACT_ILUSE 
0x070000012001AED4 : 5220 696E 2075 7365 7273 7061 6365 3129 
R in userspace1)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* V97Fp3                                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The following error is encountered while trying to create an * 
*                                                              * 
* event monitor:                                               * 
*                                                              * 
*                                                              * 
*                                                              * 
* CREATE EVENT MONITOR ILUSER                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* FOR STATEMENTS WHERE AUTH_ID = 'ILUSER' , TRANSACTIONS       * 
* WHERE                                                        * 
* AUTH_ID = 'ILUSER' WRITE TO TABLE CONNHEADER (TABLE          * 
*                                                              * 
* db2inst1.CONNHEADER_ILUSER in userspace1), STMT      (TABLE  * 
*                                                              * 
* db2inst1.STMT_ILUSER in userspace1), CONTROL    (TABLE       * 
*                                                              * 
* db2inst1.CONTROL_ILUSER in userspace1), XACT (TABLE          * 
*                                                              * 
* db2inst1.XACT_ILUSER in userspace1) ;                        * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* SQL0901N  The SQL statement failed because of a non-severe   * 
*                                                              * 
* system error. Subsequent SQL statements can be processed.    * 
*                                                              * 
* (Reason "This is not a constant qnc".)  SQLSTATE=58004       * 
*                                                              * 
*                                                              * 
*                                                              * 
* The db2diag.log shows the following:                         * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2010-04-13-16.47.04.314580+330 E12361893A552      LEVEL:     * 
* Severe                                                       * 
* PID    : 266476              TID  : 31898      PROC :        * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 000        DB  :        * 
* DBATEST                                                      * 
* APPHDL  : 0-12577              APPID:                        * 
*                                                              * 
* *LOCAL.db2inst1.100413111521                                 * 
*                                                              * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 31898                EDUNAME: db2agent (DBATEST) 0  * 
*                                                              * 
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,      * 
*                                                              * 
* probe:200                                                    * 
*                                                              * 
* MESSAGE : ADM0001C  A severe error has occurred.  Examine    * 
* the                                                          * 
* administration                                               * 
*                                                              * 
* notification log and contact IBM Support if                  * 
* necessary.                                                   * 
*                                                              * 
*                                                              * 
* 2010-04-13-16.47.04.315278+330 I12362446A453      LEVEL:     * 
* Severe                                                       * 
* PID    : 266476              TID  : 31898      PROC :        * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 000        DB  :        * 
* DBATEST                                                      * 
* APPHDL  : 0-12577              APPID:                        * 
*                                                              * 
* *LOCAL.db2inst1.100413111521                                 * 
*                                                              * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 31898                EDUNAME: db2agent (DBATEST) 0  * 
*                                                              * 
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,      * 
*                                                              * 
* probe:250                                                    * 
*                                                              * 
* RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2010-04-13-16.47.04.315564+330 I12362900A626      LEVEL:     * 
* Severe                                                       * 
* PID    : 266476              TID  : 31898      PROC :        * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 000        DB  :        * 
* DBATEST                                                      * 
* APPHDL  : 0-12577              APPID:                        * 
*                                                              * 
* *LOCAL.db2inst1.100413111521                                 * 
*                                                              * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 31898                EDUNAME: db2agent (DBATEST) 0  * 
*                                                              * 
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,      * 
*                                                              * 
* probe:275                                                    * 
*                                                              * 
* MESSAGE : MASTER TIME INFO                                   * 
*                                                              * 
* DATA #1 : Hexdump, 32 bytes                                  * 
*                                                              * 
* 0x070000013F1D9488 : 0000 0000 4BC4 52A3 03DB 0000 000F 114B * 
*                                                              * 
* ....K.R........K                                             * 
*                                                              * 
* 0x070000013F1D9498 : 0002 2C66 DB32 9287 0000 0000 001F 3A41 * 
*                                                              * 
* ..,f.2........:A                                             * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2010-04-13-16.47.04.315834+330 I12363527A187      LEVEL:     * 
* Severe                                                       * 
* PID:266476 TID:31898 NODE:000 Title: MASTER TIME INFO        * 
*                                                              * 
* Dump                                                         * 
*                                                              * 
* File:/db2home/db2inst1/sqllib/db2dump/266476.31898.000.dump.bi 
*                                                              * 
*                                                              * 
* 2010-04-13-16.47.04.323932+330 I12363715A854      LEVEL:     * 
* Severe                                                       * 
* PID    : 266476              TID  : 31898      PROC :        * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 000        DB  :        * 
* DBATEST                                                      * 
* APPHDL  : 0-12577              APPID:                        * 
*                                                              * 
* *LOCAL.db2inst1.100413111521                                 * 
*                                                              * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 31898                EDUNAME: db2agent (DBATEST) 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: 26 * 
* sqlerrmc: This is not a constant qnc                         * 
*                                                              * 
* sqlerrp : SQLNQ248                                           * 
*                                                              * 
* sqlerrd : (1) 0x00000000      (2) 0x00000000      (3)        * 
*                                                              * 
* 0x00000000                                                   * 
*                                                              * 
* (4) 0x00000000      (5) 0xFFFFFFCE      (6)                  * 
*                                                              * 
* 0x00000000                                                   * 
*                                                              * 
* sqlwarn : (1)      (2)      (3)      (4)        (5)      (6) * 
*                                                              * 
* (7)      (8)      (9)      (10)        (11)                  * 
*                                                              * 
* sqlstate:                                                    * 
*                                                              * 
* ....                                                         * 
*                                                              * 
* .....                                                        * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2010-04-13-16.47.04.328445+330 I12367839A2246    LEVEL:      * 
* Severe                                                       * 
* PID    : 266476              TID  : 31898      PROC :        * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 000        DB  :        * 
* DBATEST                                                      * 
* APPHDL  : 0-12577              APPID:                        * 
*                                                              * 
* *LOCAL.db2inst1.100413111521                                 * 
*                                                              * 
* AUTHID  : DB2INST1                                           * 
*                                                              * 
* EDUID  : 31898                EDUNAME: db2agent (DBATEST) 0  * 
*                                                              * 
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling,   * 
*                                                              * 
* probe:200                                                    * 
*                                                              * 
* MESSAGE : section stmt                                       * 
*                                                              * 
* DATA #1 : Hexdump, 352 bytes                                 * 
*                                                              * 
* 0x070000012001AD84 : 4352 4541 5445 2045 5645 4E54 204D 4F4E * 
*                                                              * 
* CREATE EVENT MON                                             * 
*                                                              * 
* 0x070000012001AD94 : 4954 4F52 2049 4C55 5345 5220 464F 5220 * 
*                                                              * 
* ITOR ILUSER FOR                                              * 
*                                                              * 
* 0x070000012001ADA4 : 5354 4154 454D 454E 5453 2057 4845 5245 * 
*                                                              * 
* STATEMENTS WHERE                                             * 
*                                                              * 
* 0x070000012001ADB4 : 2041 5554 485F 4944 203D 2027 494C 5553 * 
*                                                              * 
* AUTH_ID = 'ILUS                                              * 
*                                                              * 
* 0x070000012001ADC4 : 4552 2720 2C20 5452 414E 5341 4354 494F * 
*                                                              * 
* ER' , TRANSACTIO                                             * 
*                                                              * 
* 0x070000012001ADD4 : 4E53 2020 5748 4552 4520 2041 5554 485F * 
*                                                              * 
* NS  WHERE  AUTH_                                             * 
*                                                              * 
* 0x070000012001ADE4 : 4944 203D 2027 494C 5553 4552 2720 5752 * 
*                                                              * 
* ID = 'ILUSER' WR                                             * 
*                                                              * 
* 0x070000012001ADF4 : 4954 4520 544F 2054 4142 4C45 2043 4F4E * 
*                                                              * 
* ITE TO TABLE CON                                             * 
*                                                              * 
* 0x070000012001AE04 : 4E48 4541 4445 5220 2854 4142 4C45 2064 * 
*                                                              * 
* NHEADER (TABLE d                                             * 
*                                                              * 
* 0x070000012001AE14 : 6232 696E 7374 312E 434F 4E4E 4845 4144 * 
*                                                              * 
* b2inst1.CONNHEAD                                             * 
*                                                              * 
* 0x070000012001AE24 : 4552 5F49 4C55 5345 5220 696E 2075 7365 * 
*                                                              * 
* ER_ILUSER in use                                             * 
*                                                              * 
* 0x070000012001AE34 : 7273 7061 6365 3129 2C20 5354 4D54 2020 * 
*                                                              * 
* rspace1), STMT                                               * 
*                                                              * 
* 0x070000012001AE44 : 2020 2020 2028 5441 424C 4520 6462 3269 * 
*                                                              * 
* (TABLE db2i                                                  * 
*                                                              * 
* 0x070000012001AE54 : 6E73 7431 2E53 544D 545F 494C 5553 4552 * 
*                                                              * 
* nst1.STMT_ILUSER                                             * 
*                                                              * 
* 0x070000012001AE64 : 2069 6E20 7573 6572 7370 6163 6531 292C * 
*                                                              * 
* in userspace1),                                              * 
*                                                              * 
* 0x070000012001AE74 : 2043 4F4E 5452 4F4C 2020 2020 2854 4142 * 
*                                                              * 
* CONTROL    (TAB                                              * 
*                                                              * 
* 0x070000012001AE84 : 4C45 2064 6232 696E 7374 312E 434F 4E54 * 
*                                                              * 
* LE db2inst1.CONT                                             * 
*                                                              * 
* 0x070000012001AE94 : 524F 4C5F 494C 5553 4552 2069 6E20 7573 * 
*                                                              * 
* ROL_ILUSER in us                                             * 
*                                                              * 
* 0x070000012001AEA4 : 6572 7370 6163 6531 292C 2058 4143 5420 * 
*                                                              * 
* erspace1), XACT                                              * 
*                                                              * 
* 0x070000012001AEB4 : 2020 2020 2020 2854 4142 4C45 2064 6232 * 
*                                                              * 
* (TABLE db2                                                   * 
*                                                              * 
* 0x070000012001AEC4 : 696E 7374 312E 5841 4354 5F49 4C55 5345 * 
*                                                              * 
* inst1.XACT_ILUSE                                             * 
*                                                              * 
* 0x070000012001AED4 : 5220 696E 2075 7365 7273 7061 6365 3129 * 
*                                                              * 
* R in userspace1)                                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v97fp3                                            * 
****************************************************************
Local-Fix:
Turn the db2 traces on while trying to create the event monitor.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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

Lösung
fixed in V97Fp3
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC70047 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
20.07.2010
24.09.2010
24.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3 FixList
9.7.0.3 FixList