|
Problem IT00763
|
Status: Closed |
INCORRECT WARNING SQL1363W RAISED WHEN UPDATING A DB CFG PARAMETER ON INACTIVE DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
If there are more than 1 database in the instance, then an
incorrect warning SQL1363W may be raised if the current
database is inactive, but one or more other databases have been
explicitly activated e.g.
db2 create database P1
db2 create database P2
db2 activate database P1
db2 update db cfg for P2 using LOGSECOND 10
DB20000I The UPDATE DATABASE CONFIGURATION command completed
successfully.
SQL1363W One or more of the parameters submitted for immediate
modification
were not changed dynamically. For these configuration
parameters, the database
must be shutdown and reactivated before the configuration
parameter changes
become effective.
as P2 is not active, it should not return SQL1363W
This problem is cosmetic in nature, the update is processed and
no further action is needed. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade the database server to V10.1 Fix Pack 4 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
This problem has first been fixed in V10.1 Fix Pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.04.2014
26.06.2014
26.06.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.4
|
 |
