|
Problem IT40523
|
Status: Closed |
FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - 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: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.8.0 *
**************************************************************** |
| Local Fix: |
Change LOG_DDL_STMTS to NO when running flush bufferpool on
standby. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.8.0 *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.04.2022
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) |
