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) |
****************************************************************
* USERS AFFECTED: *
* Users on V98fp3 *
****************************************************************
* 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 V98fp4 *
**************************************************************** |
