Skip to Content
avatar image
Martin Mikala

DB6 11.1.1 and hostagent 721 return error SQL1060N for root

May 03, 2017 at 10:13 AM | 249 Views | Last edit May 03, 2017 at 10:23 AM 4 rev.

Hi,

I've updated DB2 LUW from 10.5FP7 to 11.1FP1 on RHEL6 and in diaglog is every 15 minutes severe error SQL1060N. This do sap hostagent 721 pl21 or last 25 too), he is trying connect to DB as root, but it is in 11.1 not allowed or ... Is necessary adjust something in hostagent profile or set something in DB2? I did not find anything in upgrade guide or related notes.

B.R.

Martin Mikala

http://www-01.ibm.com/support/docview.wss?uid=swg21289255

db2diag

2017-05-03-12.57.42.329297+180 I2216877E959          LEVEL: Error
PID     : 96105                TID : 140730873931520 PROC : db2sysc 0
INSTANCE: db2psb               NODE : 000            DB   : PSB
APPHDL  : 0-30720              APPID: *LOCAL.db2psb.170503095742
AUTHID  : ROOT                 HOSTNAME: fisnsap009
EDUID   : 260                  EDUNAME: db2agent (PSB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_init, probe:480
MESSAGE : ZRC=0x801A006D=-2145779603=SQLZ_CA_BUILT
          "SQLCA has already been built"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1060   sqlerrml: 8
 sqlerrmc: ROOT
 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-05-03-12.57.42.333019+180 I2217837E867          LEVEL: Error
PID     : 96105                TID : 140730873931520 PROC : db2sysc 0
INSTANCE: db2psb               NODE : 000            DB   : PSB
APPHDL  : 0-30720              APPID: *LOCAL.db2psb.170503095742
AUTHID  : ROOT                 HOSTNAME: fisnsap009
EDUID   : 260                  EDUNAME: db2agent (PSB) 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: ROOT
 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-05-03-12.57.42.336801+180 I2218705E547          LEVEL: Severe
PID     : 96105                TID : 140730873931520 PROC : db2sysc 0
INSTANCE: db2psb               NODE : 000            DB   : PSB
APPHDL  : 0-30720              APPID: *LOCAL.db2psb.170503095742
AUTHID  : ROOT                 HOSTNAME: fisnsap009
EDUID   : 260                  EDUNAME: db2agent (PSB) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:140
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
          "SQLCA has already been built"

dev_sapdbctrl

Wed May  3 12:57:42 2017
[PID 19638] *** ERROR => HANDLE_SQLCA exception occured! SQLCODE: -1060 [dbdb6ctrl.cpp 4593]
[PID 19638] *** ERROR => Exception catched
ErrorMessage: HANDLE_SQLCA exception occured! SQLCODE: -1060
ErrorInfo: HANDLE_SQLCA exception occured! SQLCODE: -1060
ErrorCode: 99 [dbdb6ctrl.cpp 4604]
[PID 19638] [PID 19638] ErrorMessage: HANDLE_SQLCA exception occured! SQLCODE: -1060
ErrorInfo: HANDLE_SQLCA exception occured! SQLCODE: -1060
ErrorCode: 99 [dbdb6ctrl.cpp 4604]
[PID 19638] [PID 19638] ErrorInfo: HANDLE_SQLCA exception occured! SQLCODE: -1060
ErrorCode: 99 [dbdb6ctrl.cpp 4604]
[PID 19638] [PID 19638] ErrorCode: 99 [dbdb6ctrl.cpp 4604]
[PID 19638] *** ERROR => Passive Connect SQLCODE: -1060 [dbdb6ctrl.cpp 4607]
[PID 19638] *** ERROR => Exception catched
ErrorMessage: Passive Connect SQLCODE: -1060
ErrorInfo: Passive Connect SQLCODE: -1060
ErrorCode: 12 [dbdb6ctrl.cpp 2192]
[PID 19638] [PID 19638] ErrorMessage: Passive Connect SQLCODE: -1060
ErrorInfo: Passive Connect SQLCODE: -1060
ErrorCode: 12 [dbdb6ctrl.cpp 2192]
[PID 19638] [PID 19638] ErrorInfo: Passive Connect SQLCODE: -1060
ErrorCode: 12 [dbdb6ctrl.cpp 2192]
[PID 19638] [PID 19638] ErrorCode: 12 [dbdb6ctrl.cpp 2192]
[PID 19763]

db2level

db2level
DB21085I  This instance or install (instance name, where applicable: "db2psb")
uses "64" bits and DB2 code release "SQL11011" with level identifier
"0202010F".
Informational tokens are "DB2 v11.1.1.1", "special_36154",
"DYN1612051900AMD64_36154", and Fix Pack "1".
Product is installed at "/db2/PSB/db2psb_home/db2_v11.1.1".
IBM Db2 for Linux, UNIX, and Windows
saphostagent | sql1060n
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Alexander Bertram
    May 04, 2017 at 09:05 AM

    Hello,

    SAP was fast. They just confirmed the solution.

    You have to grant connect to root as the sap host agent has connection problems.

    as <db2sid>

    GRANT CONNECT ON DATABASE TO USER root

    Verify:
    SELECT SUBSTR(grantee,1,15) AS grantee, granteetype, connectauth AS CONNECT FROM syscat.dbauth

    GRANTEEGRANTEETYPE CONNECT

    --------------- ----------- -------

    ROOTUY


    SAP support also pointed me to this IBM document:

    http://www-01.ibm.com/support/docview.wss?uid=swg21289255


    Regards,
    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2017 at 11:13 AM

    Hallo Martin,

    how did you start hostagent? Could you please also show a ps -ef for the running process.

    Regards

    Olaf

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Alexander Bertram
    May 04, 2017 at 07:49 AM

    Hello Martin,

    i found a solution to this problem and at the moment i have a incident open with SAP to verify this.

    If i get a positive reply i can write it here.

    Shouldn´t take too long.

    Regards,

    Alex

    Add comment
    10|10000 characters needed characters exceeded