Create event monitor fails with -901
db2 "CREATE EVENT MONITOR OPMN@xxxx FOR LOCKING WRITE TO
UNFORMATTED EVENT TABLE (PCTDEACTIVATE 100) MANUALSTART"
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "sqlri_ddl_common: unexpected sqlcode for DDL!".)
db2diag.log entries
2014-04-02-02.05.45.273695-240 E987964A1516 LEVEL: Info
(Origin)
PID : 2555978 TID : 25202 PROC :
db2sysc 0
INSTANCE: xxx NODE : 000 DB : xxxx
APPHDL : 0-18393 APPID:
30.128.133.133.58840.140402060546
AUTHID : xxx HOSTNAME: xxxxxx
EDUID : 25202 EDUNAME: db2agent (EDADB) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x80040001=-2147221503=SQLD_NOREC "NO MORE RECORDS
FOUND ON FETCH"
DIA8000C An unexpected end of file was reached "".
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
false
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 100 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRL083
sqlerrd : (1) 0x80040001 (2) 0x00000001 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #8 : Hex integer, 4 bytes
0x00000040
DATA #9 : String, 172 bytes
Compiler error stack for rc = -2147221503:
sqlnn_cmpl[300]
sqlnp_main[250]
sqlnp_parser[510]
sqlnp_smactn[100]
sqlnq_create_evmon_stmt[130]
sqlnq_ddl_create_evmon_end[280]
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002B6DB1D7C1A5
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0385
(/home/regress1/sqllib/lib64/libdb2osse.so.1)
0x00002B6DB1D7BDAC ossDumpStackTraceV98 + 0x002c
(/home/regress1/sqllib/lib64/libdb2osse.so.1)
0x00002B6DB1D76EAD _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00fd
(/home/regress1/sqllib/lib64/libdb2osse.so.1)
0x00002B6DABBC9EFD sqlo_trce + 0x03ed
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DABCD6439 sqloDumpDiagInfoHandler + 0x0249
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DA56A8D60 address: 0x00002B6DA56A8D60 ; dladdress:
0x00002B6DA569B000 ; offset in lib: 0x000000000000DD60 ;
(/lib64/libpthread.so.0)
0x00002B6DA56A6005 pthread_kill + 0x0035
(/lib64/libpthread.so.0)
0x00002B6DABCD5F72 sqloDumpEDU + 0x0052
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DA74169A3 _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
0x1223
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC1D0C77 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0567
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAD3FC98C _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00ac
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAD3FC7A3
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x01a3
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC2B2C41 sqlrrSqlCode + 0x00e1
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC6A2A25 _Z16sqlri_ddl_commonP8sqlrr_cb + 0x13c5
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC6A15A6 _Z8sqlriddlP8sqlrr_cb + 0x0026
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC6CA086 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x04f6
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC2002E2 _Z23sqlrr_execute_immediateP8sqlrr_cbi +
0x0582
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAC1E2CE0
_Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x0850
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA65DF2E
_Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject +
0x04be
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA6251DC
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x040c
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA626064
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x0524
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA6189A3 address: 0x00002B6DAA6189A3 ; dladdress:
0x00002B6DA57B4000 ; offset in lib: 0x0000000004E649A3 ;
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA61F5F2 address: 0x00002B6DAA61F5F2 ; dladdress:
0x00002B6DA57B4000 ; offset in lib: 0x0000000004E6B5F2 ;
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA62060F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
0x011f
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAA105697 _ZN8sqeAgent6RunEDUEv + 0x0dd7
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DAD3FCEDA _ZN9sqzEDUObj9EDUDriverEv + 0x010a
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DABCD35A5 sqloEDUEntry + 0x05e5
(/home/regress1/sqllib/lib64/libdb2e.so.1)
0x00002B6DA56A1193 address: 0x00002B6DA56A1193 ; dladdress:
0x00002B6DA569B000 ; offset in lib: 0x0000000000006193 ;
(/lib64/libpthread.so.0)
0x00002B6DB27B50DD __clone + 0x006d
(/lib64/libc.so.6)
</StackTrace>
Workaround: Ensure a 4k pagesize tablespace exist before
attempting to create the event monitor |
