SAP Knowledge Base Article - Preview

2490338 - DB6: SQL0900N error with ATS after system rename

Symptom

After performed 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 , ats , sql1060n , administrative task scheduler , ats owner , sql0900n , owner of ats , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.