DB2 - Problem description
Problem IC66529 | Status: Closed |
ATS THROW ADM15503E WHEN TASK TABLES DOESN'T EXIST | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * ATS throw ADM15503E when task tables doesn't exist * * indb2diag.log * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 v9.5 fp6 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Solution | |
Problem is first fixed at DB2 v9.5 fp6 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC66533 IC66534 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.02.2010 31.05.2010 31.05.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP6 | |
Problem solved according to the fixlist(s) of the following version(s) |