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) | |