SAP Knowledge Base Article - Preview

2490338 - DB6: SQL0900N error with ATS after system rename

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.