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

AFTER ENABLING DB2_USE_IOCP, DB2 MAY ENCOUNTER EALREADY (56)
"OPERATION ALREADY IN PROCESS" ERROR

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When DB2_USE_IOCP is enabled, the instance may crash with the 
following error reported in the db2diag.log 
 
2009-06-19-16.41.51.883506-240 E137264801A556     LEVEL: Error 
(OS) 
PID     : 1204650              TID  : 7290        PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000 
EDUID   : 7290                 EDUNAME: db2pclnr (SAMPLE) 0 
FUNCTION: DB2 UDB, oper system services, 
sqloLioAssociateFHwithPort, probe:100 
MESSAGE : ZRC=0x83000038=-2097151944 
CALLED  : OS, -, CreateIoCompletionPort 
OSERR   : EALREADY (56) "Operation already in progress" 
DATA #1 : signed integer, 4 bytes 
1874 
DATA #2 : I/O Completion Port, PD_TYPE_IO_PORT, 4 bytes 
0x0000011C 
 
To avoid this problem set registry variable DB2_USE_IOCP=NO
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* AIX                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When DB2_USE_IOCP is enabled, the instance may crash with    * 
* the                                                          * 
* following error reported in the db2diag.log                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2009-06-19-16.41.51.883506-240 E137264801A556     LEVEL:     * 
* Error                                                        * 
* (OS)                                                         * 
*                                                              * 
* PID     : 1204650              TID  : 7290        PROC :     * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: db2inst1              NODE : 000                   * 
*                                                              * 
* EDUID   : 7290                 EDUNAME: db2pclnr (SAMPLE) 0  * 
*                                                              * 
* FUNCTION: DB2 UDB, oper system services,                     * 
*                                                              * 
* sqloLioAssociateFHwithPort, probe:100                        * 
*                                                              * 
* MESSAGE : ZRC=0x83000038=-2097151944                         * 
*                                                              * 
* CALLED  : OS, -, CreateIoCompletionPort                      * 
*                                                              * 
* OSERR   : EALREADY (56) "Operation already in progress"      * 
*                                                              * 
* DATA #1 : signed integer, 4 bytes                            * 
*                                                              * 
* 1874                                                         * 
*                                                              * 
* DATA #2 : I/O Completion Port, PD_TYPE_IO_PORT, 4 bytes      * 
*                                                              * 
* 0x0000011C                                                   * 
*                                                              * 
*                                                              * 
*                                                              * 
* To avoid this problem set registry variable DB2_USE_IOCP=NO  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to Db2 V9.7 FP1                                       * 
****************************************************************
Local Fix:
To avoid this problem set registry variable DB2_USE_IOCP=NO
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Solution
DB2 V9.7 FP1 will contain the fix.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC66396 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.07.2009
17.02.2010
17.02.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP1
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList