|
Problem IT25993
|
Status: Closed |
WHEN THERE ARE MANY CONNECTIONS TO THE PRIMARY DATABASE, HADR TAKEOVER COULD RETURN SQL1770N RC7.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
When there are many current and incoming connections to the HADR
primary database, the takeover hadr command could sometime
return SQL1770N rc7.
During hadr takeover, the primary database has to force off
current connections and block incoming connections from
entering. When there are too
many connections the process might take too long and eventually
timeout, causing takeover to fail on the standby database.
The following diagnostic message can be found in db2diag.log on
standby:
2018-08-13-15.25.14.245149-240 I4622014E613 LEVEL:
Error
PID : 15112 TID : 139723221755648 KTID :
27920
PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
TESTDB
HOSTNAME: DB2INST1
EDUID : 409 EDUNAME: db2hadrs.0.0 (TESTDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery,
hdrEduAcceptEvent, probe:20240
DATA #1 :
Standby has not received data from primary for 601 seconds.
Check the status of the primary. Aborting TAKEOVER.
hdrCurrentTime 1534188314 hdrLastLogRecvTime 1534187713
hdrGracefulTkTimeout 600 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : IT25963
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.08.2018
27.11.2018
27.11.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
