invispix 10x10
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 IT39175 Status: Closed

FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
Flush bufferpool is not supported on standby with
LOG_DDL_STMTS=YES.

On Db2 11.5, default value of LOG_DDL_STMTS is NO.

On standby,

$ db2 "flush bufferpool all"
DB20000I The SQL command completed successfully.

$ db2 update db cfg for hadrdb using LOG_DDL_STMTS YES

$ db2 "flush bufferpool all"
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL1773N The statement or command failed because it requires
functionality
that is not supported on a read-enabled HADR standby database.
Reason code =
"5".
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* HADR                                                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade Db2 to latest version.                               *
****************************************************************
Local Fix:
Change LOG_DDL_STMTS to NO when running flush bufferpool on
standby.
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* HADR                                                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade Db2 to latest version.                               *
****************************************************************
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.11.2021
06.04.2022
06.04.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
invispix 10x10
invispix 10x10
Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

invispix 10x10