Symptom
After performing the system rename from <ABC> to <XYZ>, ATS (Administrative Task Scheduler) has SQL0900N error in db2diag.log file.
db2diag.log file:
2017-04-11-14.30.00.200650+480 I57376801A859 LEVEL: Error
PID : 19524 TID : 197 PROC : db2sysc 0
INSTANCE: db2xyz NODE : 000 DB : <XYZ>
APPHDL : 0-27347 APPID: *LOCAL.db2tas.170411063018
AUTHID : DB2<ABC> HOSTNAME: pearl
EDUID : 197 EDUNAME: db2agent (XYZ) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_init, probe:480
DATA
1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1060 sqlerrml: 8
sqlerrmc: DB2<ABC>
sqlerrp : SQLRR003
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFE2A (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2017-04-11-14.30.00.201190+480 E57377661A520 LEVEL: Error
PID : 19529 TID : 16414 PROC : db2acd 0
INSTANCE: db2<xyz> NODE : 000 DB : <XYZ>
APPID : *LOCAL.db2tas.170411063018
HOSTNAME: pearl
EDUID : 16414 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::executeTask, probe:600
MESSAGE : ZRC=0xFFFE7961=-99999
DATA
1 : <preformatted>
[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
2017-04-11-14.30.00.201662+480 I57378182A439 LEVEL: Error
PID : 19529 TID : 16414 PROC : db2acd 0
INSTANCE: db2<xyz> NODE : 000 DB : <XYZ>
APPID : *LOCAL.db2tas.170411063018
HOSTNAME: pearl
EDUID : 16414 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, probe:1100
MESSAGE : ECF=0xFFFFFBDC=-1060
2017-04-11-14.30.00.202031+480 E57378622A697 LEVEL: Error
PID : 19529 TID : 16414 PROC : db2acd 0
INSTANCE: db2<xyz> NODE : 000 DB : <XYZ>
APPID : *LOCAL.db2tas.170411063018
HOSTNAME: pearl
EDUID : 16414 EDUNAME: db2acd 0
FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::updateStatusRecordAndCommit, probe:1700
MESSAGE : ZRC=0xFFFFFC7C=-900
SQL0900N The application state is in error. A database connection does not exist.
DATA
1 : <preformatted>
[IBM][CLI Driver][DB2/HPUX-IA64] SQL0900N The application state is in error. A database connection does not exist. SQLSTATE=08003
Read more...
Environment
SAP on IBM DB2 for Linux, UNIX, and Windows
Keywords
SQL0900N, ATS (Administrative Task Scheduler), ECF=0xFFFFFBDC=-1060, owner, systools.admintasks, wrong owner , KBA , owner of ats , sql0900n , sql1060n , ats , ats owner , administrative task scheduler , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-CCM , CCMS/Database Monitors , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview