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