A fix is available
APAR status
Closed as program error.
Error description
When IOCP is on and used by DB2 at AIX 6.1 TL04, DB2 calls sqloGetMultipleCompletionStatus() which in turn calls AIX's IOCP extension. The IOCP call GetMultipleCompletionStatus() never returns causing I/O to stop when DB2 is in it's page cleaning routines. To see if you have the problem, dump the DB2 stack will show something similar to: 0x090000000CE87364 sqloGetMultipleCompletionStatus + 0x24 0x0900000005803DA4 sqloLioAIOCollect__20SQLO_LIO_HANDLE_DATAFUlP23SQLO_LIO_C OLLECT_STATUSPP11SQLO_IO_REQ13SQLO_LIO_PORT + 0x1074 0x0900000005802310 sqloLioCollectNBlocks + 0xB4 0x09000000057033E4 sqlbClnrCollectSomeAIO__FP12SQLB_CLNR_CBUl + 0x8C 0x0900000005703500 sqlbClnrCollectSomeAIO__FP12SQLB_CLNR_CBUl@glue13A1+ 0x78
Local fix
1. Stay at 6.1 TL03 and below or 2. Do not activate IOCP in DB2.
Problem summary
Application hang in GetMultipleConnectionStatus() or system crash
Problem conclusion
Properly initialize AIO/IOCP requests with iocfd for correct post I/O processing.
Temporary fix
Comments
APAR Information
APAR number
IZ74932
Reported component name
AIX 610 STD EDI
Reported component ID
5765G6200
Reported release
610
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Submitted date
2010-04-21
Closed date
2010-04-21
Last modified date
2013-03-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
AIX 610 STD EDI
Fixed component ID
5765G6200
Applicable component levels
R610 PSY U832117
UP10/09/01 I 1000
PTF to Fileset Mapping
U832117 bos.iocp.rte 6.1.6.0
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSMV87","label":"AIX 6.1 Enterprise Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"610","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMVAX","label":"AIX Express Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"610","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSAUMY","label":"IBM AIX Enterprise Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"610","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG11Q","label":"AIX 6.1 HIPERS, APARs and Fixes"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"610","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
28 March 2013