DB2 - Problembeschreibung
Problem IC81580 | Status: Geschlossen |
ALLOW TO FORCE APPLICATION TO UNBLOCK APPLICATIONS IN SQLCCIPCWAITFORRECEIVE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
This APAR will allow user to FORCE interrupt an agent that is waiting in sqlccIPCWaitForReceive code path | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC87828 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.02.2012 05.06.2012 05.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP6 | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |