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) |