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 IC68681 Status: Closed

SETTING TCP_SENDSPACE AND TCP_RECVSPACE ONLY APPLICABLE ON AIX PLATFORM

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
APAR IZ33284 introduced setting the tcp_sendspace/tcp_recvspace 
to minimum 64K. 
 
Customers on Linux platform have come across this message which 
should only apply to AIX platforms. Linux does not have kernel 
parameters by these names. In Linux, the corresponding 
parameters to tune are rmem_max/wmem_max and tcp_rmem/tcp_wmem. 
 
It turns out that in Linux kernel 2.6 and later there is auto 
tuning of these parameters, so we do not need to set them in 
DB2 code. We are going to apply the above APAR to AIX only and 
allow the Linux kernel to auto tune these parameters.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Non-AIX platforms                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SETTING TCP_SENDSPACE AND TCP_RECVSPACE ONLY APPLICABLE      * 
* ONAIXPLATFORM                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fix Pack 2                    * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 9.7 Fix Pack 2
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.05.2010
31.05.2010
31.05.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP2
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList