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

ADD RETRY WHEN DB2 RECEIVES WSAEACCESS WHEN BINDING TCP SERVICE PORT IN
WINDOWS.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The db2start might report SQL5043N, and db2diag.log indicates 
the error is caused by WSAEACCESS (10013) on bind() call. 
 
2012-10-12-23.15.30.047000+540 I70203F367         LEVEL: Error 
PID     : 1092                 TID  : 3548        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000 
EDUID   : 3548                 EDUNAME: db2sysc 0 
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr, 
probe:47 
MESSAGE : DIA3202C The TCP/IP call "bind" returned an 
errno="10013". 
 
The following Microsoft page says DB2 can receive WSAEACCESS in 
Windows Server 2003 or later.  If the service port has been used 
by some other process, and it specifies SO_EXCLUSIVEADDRUSE 
socket option on the port. 
 
Using SO_REUSEADDR and SO_EXCLUSIVEADDRUSE 
http://msdn.microsoft.com/en-us/library/windows/desktop/ms740621 
%28v=vs.85%29.aspx 
 
Also, ephemeral port range is started with 49152 in Windows 
Vista or later, and this change increases the chances to 
conflict ephemeral port with default DB2 service port (50000). 
 
DB2 already has a retry logic when bind fail with WSAEADDRINUSE, 
and this APAR will treat WSAEACCESS as same as WSAEADDRINUSE 
when binding service port.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users who use DB2 on Windows platforms.                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.7 FixPack 8 or later.                   * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
This problem was first fixed in DB2 V9.7 FixPack 8.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC91756 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.11.2012
22.04.2013
22.04.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.8 FixList