IBM Support

IC97478: INCORRECT WARNING SQL1363W RAISED WHEN UPDATING A DB CFG PARAMETER ON INACTIVE DATABASE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the DB2 server to v9.7 Fix Pack 10 or above.         *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in v9.7 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC97478

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-07

  • Closed date

    2014-12-15

  • Last modified date

    2014-12-15

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IT00763 IT00764

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC97478

Modified date: 15 December 2014