home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75092 Status: Closed

SQL5130N WHEN REMOTE CLIENT UPDATE DB CFG using dbheap and lockl ist to
AUTOMATIC AGAINSTSERVER DATABASE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Problem Abstract: SQL5130N when remote client update db cfg 
using dbheap and locklist to 
 
automatic against server database for locklist 
 
 
 
 
On client: 
 
db2 update db cfg using locklist automatic 
SQL5130N  The value specified for the configuration parameter 
"locklist" is 
not in the valid range of "4" to "134217728". 
 
Currently in db cfg, locklist is already set to automatic: 
 
 Max storage for lock list (4KB)              (LOCKLIST) = 
AUTOMATIC(4096) 
 Percent. of lock lists per application       (MAXLOCKS) = 
AUTOMATIC(98) 
 
 
If the same update db cfg runs on server it works fine. 
 
Problem only happens when client and server are not on the same 
db2level.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Please see Problem Description above                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fix Pak 8                             * 
****************************************************************
Local Fix:
Change client machine at the exact same db2level as the server. 
Or update db cfg runs on server will work
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First fixed in Version v9.5 Fix Pak 8
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.03.2011
05.07.2011
05.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList