IC84150: DB2CFIMP <FILENAME> UPDATES DBM CFG PARAMETERS INCORRECTLY WHEN VALUES SET TO AUTOMATIC; CLIENT CONNECTIONS WILL HANG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If original db2 get dbm cfg shows
    
    MAX_CONNECTIONS = 100 AUTOMATIC
    MAX_COORDAGENTS = 200 AUTOMATIC
    NUM_POOLAGENTS = 200 AUTOMATIC
    
    when you export the configuration using
    
    db2cfexp filename backup
    the filename will contain:
    
    MAX_CONNECTIONS=AUTOMATIC
    MAX_COORDAGENTS=AUTOMATIC
    NUM_POOLAGENTS=AUTOMATIC
    
    When this file is then used with
    db2cfimp filename
    
    The result in the dbm cfg shows:
    MAX_CONNECTIONS = 0 AUTOMATIC
    MAX_COORDAGENTS = 0 AUTOMATIC
    NUM_POOLAGENTS = 1 AUTOMATIC
    
    Any connections to the database will hang waiting for an agent.
    

Local fix

  • Manually update the dbm cfg parameters back to the original
    values by running
    db2 update dbm cfg using num_poolagents -1 max_coordagents -1
    max_connections -1
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * db2cfimp <filename> updates dbm cfg parameters incorrectly   *
    * when original values set to AUTOMATIC; client connections    *
    * will hang                                                    *
    * If original db2 get dbm cfg shows                            *
    *                                                              *
    * MAX_CONNECTIONS = 100 AUTOMATIC                              *
    * MAX_COORDAGENTS = 200 AUTOMATIC                              *
    * NUM_POOLAGENTS = 200 AUTOMATIC                               *
    *                                                              *
    * when you export the configuration using                      *
    *                                                              *
    * db2cfexp filename backup                                     *
    * the filename will contain:                                   *
    *                                                              *
    * MAX_CONNECTIONS=AUTOMATIC                                    *
    * MAX_COORDAGENTS=AUTOMATIC                                    *
    * NUM_POOLAGENTS=AUTOMATIC                                     *
    *                                                              *
    * When this file is then used with                             *
    * db2cfimp filename                                            *
    *                                                              *
    * The result in the dbm cfg shows:                             *
    * MAX_CONNECTIONS = 0 AUTOMATIC                                *
    * MAX_COORDAGENTS = 0 AUTOMATIC                                *
    * NUM_POOLAGENTS = 1 AUTOMATIC                                 *
    *                                                              *
    * Any connections to the database will hang waiting for an     *
    * agent.                                                       *
    *                                                              *
    * Problem Description: (describe the problem including         *
    * external symptoms as seen by the customer)                   *
    * Problem wa                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB Version 10 Fix Pack 1.                    *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 10 Fix Pack 1
    

Temporary fix

  • Update the MAX_CONNECTIONS, MAX_COORDAGENTS and NUM_POOLAGENTS
    manually via the update dbm cfg command
    

Comments

APAR Information

  • APAR number

    IC84150

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-12

  • Closed date

    2012-12-10

  • Last modified date

    2012-12-10

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

    IC76615

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

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RA10 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC84150

Modified date:

2012-12-10

Translate my page

Machine Translation

Content navigation