SAP Knowledge Base Article - Preview

2468117 - Frequent "SQLCA has already been built" and sqlcode: -1060 entries in DB2diag.log

Symptom

  • The DB2diag.log shows many entries for  "SQLCA has already been built" and this entry can be ignored.  
  • The real issue pertains to the SQLCODE - 1060 (SQL1060N -User authorization-ID does not have the CONNECT privilege)
  • You may see examples like those below from the db2diag.log  The important information from the example is AUTHID : ROOT and  sqlcode: -1060

    PID     : XXXXX                    TID : PROC : db2sysc 0
    INSTANCE: db2XXX              NODE : 000            DB   : XXX
    APPHDL  : 0-XXXX                APPID: *LOCAL.db2XXXXXXX
    AUTHID  : ROOT                   HOSTNAME: XXXX
    EDUID   : XXX                      EDUNAME: db2agent XXX
    FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing,
    RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
              "SQLCA has already been built"


    PID     : XXXXX                    TID : PROC : db2sysc 0
    INSTANCE: db2XXX               NODE : 000            DB   : XXX
    APPHDL  : XXXXXX             APPID: *LOCAL.db2XXXXXX
    AUTHID  : ROOT                 HOSTNAME: XXX
    EDUID   : XXX                EDUNAME: db2agent XXXX
    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: ROOT


Read more...

Environment

  • DB2 (LUW) databases for Linux, Unix and Windows
  • Any database version

Product

SAP ERP 6.0

Keywords

 SAP HOST AGENT, Alert, sapdbctrl, SQL1060N, authorization, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-CCM-HAG , Host Agent , 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.