IBM Support

Database configuration parameter (DB CFG) update is not immediate for configurable online parameters

Troubleshooting


Problem

The database configuration parameter, for example LOGARCHMETH1, is not updated immediately when using the UPDATE DATABASE CONFIGURATION command.

Symptom

The DB2 information center indicates that LOGARCHMETH1 is a parameter that is configurable online. However, when checked with the "db2 get db cfg show detail" output, the update is reflected only in the "delayed" column.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21572059