DB2 FOR LUW / DB2FORLUW / 970 - DB2

An attempt to update the database configuration parameters 
DBHEAP or LOCKLIST to AUTOMATIC from a remote client will fail 
with SQL5130N if the Client and Server are not at the same DB2 
level 
 
For example, this command executed at the remote client: 
  db2 update db cfg using locklist automatic 
fails with 
  SQL5130N  The value specified for the configuration parameter 
  "locklist" is not in the valid range of "4" to "134217728". 
 
Problem only happens when client and server are not on the same 
db2level.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 LUW users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Remote client updates database config parameters, dbheap and * 
* locklist to automatic, returns SQL5130N.                     * 
* The same update database config command works fine on        * 
* server.                                                      * 
*                                                              * 
* The problem only happens on client where db2level is not the * 
* same as server.                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the Server to v9.7 FP5                               * 
****************************************************************

Change the client machine to the same DB2 level as the server, 
or issue the command locally from the Server.

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 5

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC75092 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.03.2011
18.01.2012
18.01.2012

9.7.FP5