|
Problem IC97478
|
Status: Closed |
INCORRECT WARNING SQL1363W RAISED WHEN UPDATING A DB CFG PARAMETER ON INACTIVE DATABASE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 DB2 server to v9.7 Fix Pack 10 or above. *
**************************************************************** |
| Local Fix: |
|
| Solution |
This problem was first fixed in v9.7 Fix Pack 10 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.11.2013
15.12.2014
15.12.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
