| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT37555 | Status: Closed |
AUTOMATIC MAINTENANCE (DB2ACD) PROCESS GENERATES "HMONSQLCONNECT, PROBE:600 SQLCODE-1060" DB2DIAG.LOG ERRORS ON STANDBY DATABASE | |
| product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
| Problem description: | |
Starting in Version 11.5.6.0, when database Automatic
Maintenance settings are enabled, the db2acd process (which
manages automatic maintenance activities) may generate
db2diag.log error messages on the Standby database approximately
every 5mins, indicating hmonSQLConnect, probe:600, with message
"SQLConnect error sqlRC=[-1] sqlcode=[-1060]", like so:
2021-07-06-16.37.29.629562-240 I278575E874 LEVEL:
Error
PID : 24965 TID : 140648660555520 PROC :
db2acd
INSTANCE: NODE : 000
HOSTNAME:
FUNCTION: DB2 UDB, Health Monitor, hmonSQLConnect, probe:600
DATA #1 : String, 43 bytes
SQLConnect error sqlRC=[-1] sqlcode=[-1060]
DATA #2 : SQL Return Code, PD_CLI_TYPE_SQLRETURN, 2 bytes
SQL_ERROR
Hex:
FFFF ..
DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1060 sqlerrml: 7
sqlerrmc: DB2HMON
sqlerrp : SQLELOST
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 08004 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * HADR * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
| Local Fix: | |
These db2diag.log errors are benign and can be ignored. | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * HADR * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
| Comment | |
Upgrade to 11.5 FP7 or later | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.07.2021 21.11.2021 21.11.2021 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
