DB2 - Problembeschreibung
Problem IT25963 | Status: Geschlossen |
WHEN THERE ARE MANY CONNECTIONS TO THE PRIMARY DATABASE, HADR TAKEOVER COULD RETURN SQL1770N RC7. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Databases using HADR feature * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v11.1.4.4 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : Nachfolger : IT25993 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.08.2018 16.03.2020 16.03.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |