DB2 - Problem description
Problem IT02018 | Status: Closed |
Create event monitor fails with -901 if no 4K pagesize tablespace exist | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users running DB2 10.1 before fix pack 4 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.1 Fix Pack 4 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.05.2014 30.07.2015 30.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |