Following errors may appear in db2diag.log even when ATS task
tables does not exist
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 |
****************************************************************
* USERS AFFECTED: *
* Users of ATS *
****************************************************************
* PROBLEM DESCRIPTION: *
* Following errors may come in db2diag.log even when ats task *
* *
* tables doesnot exist *
* *
* *
* *
* *
* *
* 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 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V98 FP3 *
**************************************************************** |
