|
Problem IC81580
|
Status: Closed |
ALLOW TO FORCE APPLICATION TO UNBLOCK APPLICATIONS IN SQLCCIPCWAITFORRECEIVE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
db2agent could hang waiting for reply from db2fmp that already
exited
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000000250100 semop + 0xC0
0x090000000557CFBC sqloSSemP + 0x214
0x09000000055E386C
sqlccIPCWaitForReceive__FP19sqlcc_ipc_resourcesUi + 0x60
0x0900000007029654 sqlriInvokeInvoker__FP10sqlri_ufob + 0x45C
0x09000000054EA218 sqlricall__FP8sqlrr_cb + 0x69C
0x09000000055863D0 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0xFC
0x0900000006010FEC sqlrr_process_execute_request__FP8sqlrr_cbi +
0x1118
0x0900000005CD28E0 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
+ 0x7F8
0x09000000066E1540
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0x47C
0x0900000006978784
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2U
Cinterface + 0x1EC
0x090000000501D610
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0xDE4
0x090000000501C1D0
@48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x714 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* If for any reason FMP has exited already, db2agent could *
* hung (in sqlccIPCWaitForReceive) waiting for reply from this *
* db2fmp. *
* This could prevent the database from terminating or other *
* agent failing with lock timeout if this db2agent was holding *
* on a lock. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 version v9.7 fixpack 6 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 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 APAR will allow user to FORCE interrupt an agent that is
waiting in sqlccIPCWaitForReceive code path |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87828
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2012
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
