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 , administrative task scheduler , ats owner , 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.