IBM Support

JR29310: SQL1096N WHEN MODIFYING DBM CFG VALUE VIA CONFIGURATION ASSISTANT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SYMPTOM:
    DB2 Configuration Assistant will generate an SQL1096N when
    attempting to change a value for a dbm cfg parameter.
    
    For example, the symptom is created when attempting to change
    DIAGLEVEL=4 from the configuration assistant like so:
    
    START
       Config.Assisstant
          [configure]
             "DBM Configuration"
                 DIAGLEVEL [...] 4
                    OK
    
    SQL1096N The command is not valid for this node type.
    

Local fix

  • A workaround is to uncheck the [Dynamic] check box from the
    parameter change window before clicking the [OK] button.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:
    *               All DB2 v9.5 Configuration Assistant users
    *               performing an update to the database manager
    *               configuration file.
    ****************************************************************
    * PROBLEM DESCRIPTION:
    *               This is caused by missing code in the DB2
    *               Configuration Assistant.
    ****************************************************************
    * RECOMMENDATION:
    *               Use the workaround listed above in the Local
    *               Fix area or manually update the DBM CFG
    *               parameter directly for the instance.
    *
    *               Upgrade to DB2 Version 9.5 fix pack 5 or higher.
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 Version 9.5 fix pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR29310

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-05-16

  • Closed date

    2009-12-22

  • Last modified date

    2009-12-24

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

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 December 2009