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".
Add comment