DB2 - Problembeschreibung
Problem IC66533 | Status: Geschlossen |
ATS THROW ADM15503E WHEN TASK TABLES DOESN'T EXIST | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
I met a couple of errors about AtsDbInfo component during SAP install test with s090819 build on SUN platform. In SAP insall, we didn't manually create task tables. But ADM15503E is thrown in db2diag when task tables doesn't exsit. It is not a correct behavior. 2009-08-26-01.41.39.782650-240 I48084A572 LEVEL: Error PID : 29542 TID : 204 PROC : db2sysc 0 INSTANCE: db2hia NODE : 000 DB : HIA APPHDL : 0-65 APPID: *LOCAL.db2hia.090826054142 AUTHID : DB2HIA EDUID : 204 EDUNAME: db2agent (HIA) 0 FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, probe:40 RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED" DIA8003C The interrupt has been received. DATA #1 : Hex integer, 4 bytes 0x0000000B 2009-08-26-01.41.39.788129-240 E48657A593 LEVEL: Error PID : 29546 TID : 7 PROC : db2acd 0 INSTANCE: db2hia NODE : 000 EDUID : 7 EDUNAME: db2acd 0 FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsDbInfo::validateBaseTables, probe:300 MESSAGE : ZRC=0xFFFFFB38=-1224 DATA #1 : <preformatted> [IBM][CLI Driver] SQL1224N The database manager is not able to accept new requests, has term inated all requests in progress, or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032 2009-08-26-01.41.39.789859-240 E49251A1007 LEVEL: Error PID : 29546 TID : 7 PROC : db2acd 0 INSTANCE: db2hia NODE : 000 EDUID : 7 EDUNAME: db2acd 0 FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsDbInfo::validateBaseTables, probe:400 MESSAGE : ADM15503E The administrative task scheduler detected a security error on database "HIA ". No scheduled tasks will be executed on this database. To resume task execution, drop the SYSTOOLS.ADMINTASKS and SYSTOOLS.ADMINTASKSTATUS table, and recreate all the scheduled tasks on this database using the SYSPROC.ADMIN_TASK_ADD stored procedure. DATA #1 : String with size, 15650 of 4294967295 bytes Object not dumped: Address: 0xFFFFFFFF712FB11C Size: 4294967295 Reason: Address is NULL DATA #2 : String with size, 15508 of 4294967295 bytes Object not dumped: Address: 0xFFFFFFFF712FB098 Size: 4294967295 Reason: Address is NULL 2009-08-26-01.41.39.795076-240 E50259A952 LEVEL: Error PID : 29546 TID : 7 PROC : db2acd 0 INSTANCE: db2hia NODE : 000 EDUID : 7 EDUNAME: db2acd 0 FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsConnection::commit, probe:900 MESSAGE : ECF=0x82BA00E1=-2101739295 DATA #1 : String, 64 bytes [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 CALLSTCK: [0] 0xFFFFFFFF7448CF80 __1cNAtsConnectionHendTran6MkI_i_ + 0x310 [1] 0xFFFFFFFF74490334 __1cJAtsDbInfoSvalidateBaseTables6M_i_ + 0x444 [2] 0xFFFFFFFF74492948 db2HmonAtsPollDatabase + 0x320 [3] 0xFFFFFFFF7450156C callFunction + 0x69C [4] 0xFFFFFFFF744C65DC __1cRhmonThreadWrapper6Fpv_0_ + 0x2C4 [5] 0xFFFFFFFF7BE17C9C _resume_ret + 0x2DC [6] 0x0000000000000000 ?unknown + 0x0 [7] 0x0000000000000000 ?unknown + 0x0 [8] 0x0000000000000000 ?unknown + 0x0 [9] 0x0000000000000000 ?unknown + 0x0 2009-08-26-01.41.39.796976-240 E51212A433 LEVEL: Error PID : 29546 TID : 7 PROC : db2acd 0 INSTANCE: db2hia NODE : 000 EDUID : 7 EDUNAME: db2acd 0 FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsDbInfo::validateBaseTables, probe:600 MESSAGE : ZRC=0xFFFE7961=-99999 DATA #1 : <preformatted> [IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of Admin task scheduler * **************************************************************** * PROBLEM DESCRIPTION: * * ADM15503E will be written to diag.log even when task tables * * does not exist * **************************************************************** * RECOMMENDATION: * * Upgrade to product V9.7 FP3 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
V9.5 Fp6 and V9.7 FP3 contains the fix | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.02.2010 25.05.2010 25.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6, 9.7.FP3 | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |