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

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

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