home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC66533 Status: Closed

ATS THROW ADM15503E WHEN TASK TABLES DOESN'T EXIST

product:
DB2 FOR LUW / DB2FORLUW / 970 - 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:                                              * 
* 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:
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
V9.5 Fp6 and V9.7 FP3 contains the fix
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.02.2010
25.05.2010
25.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6,
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList