suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT37863 Status: Closed

HADR GRACEFUL TAKEOVER CAN TIMEOUT DUE TO SUSPENDED DB2AGENT PROCESSES

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
When agents were trapped, they may be suspended. These suspended
agents would prevent the completion of graceful takeover. User
applications are not forced off during graceful takeover.

One way to identify the suspended agents is checking the stack
files during takeover.

$ grep db2agent *stack.txt | grep HADRDB | uniq
26217.2371.000.stack.txt:EDU name   : db2agent (HADRDB) 0 [-]
...
26217.7975.000.stack.txt:EDU name   : db2agent (HADRDB) 0
(suspended) 0 [-]
26217.7991.000.stack.txt:EDU name   : db2agent (HADRDB) 0
(suspended) 0 [-]

We can also identify the suspended agents from the output of
"db2pd -edus"
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to v11.5.7                                           *
****************************************************************
Local Fix:
When takeover timeout due to the suspended db2agent processes,
we can issue forced takeover.
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to v11.5.7                                           *
****************************************************************
Comment
Upgrade to v11.5.7
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.08.2021
29.11.2021
29.11.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)