home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC63689 Status: Geschlossen

DB2RBIND HUNG

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
db2rbind command hung and 
we can find holding / waiting latches on 
SQLO_LT_sqlra_sql_context_mcb__pdirptr_latch 
 
The call stack looks like: 
11       sqlra_get_section 
12       sqlrr_sql_request_pre 
13       sqlrr_prepare 
14       CLI_sqlPrepare 
15       SQLPrepare2 
16       SQLPrepare 
17       sqlexc_xcomp1 
18       sqloInvokeFnArgs 
19       sqlriInvokerTrusted 
20       sqlriInvokeInvoker 
21       sqlricall 
22       sqlriExecThread 
23       sqlriSectInvoke 
24       sqlra_internal_sql 
25       sqlnp_handle_procedural 
26       sqlnp_main 
27       sqlnn_cmpl 
28       sqlnn_cmpl 
29       sqlrr_cmpl 
30       sqlra_recreate_pkg 
31       sqlra_rebind_pkg 
32       sqlrr_rebind
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 systems on all Linux, Unix and Windows platforms at  * 
* DB2 Version 9.7 GA with DB2_COMPATIBILITY_VECTOR set.        * 
* Also, user must have purchased license on EDB THIRD PARTY    * 
* CODE SUPPORT                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2rbind command hung and                                    * 
* we can find holding / waiting latches on                     * 
* SQLO_LT_sqlra_sql_context_mcb__pdirptr_latch                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 for LUW version 9.7 fixpack 1                 * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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

Lösung
fix is in DB2 for LUW version 9.7 fixpack 1 and all subsequent 
fix packs
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.10.2009
21.12.2009
21.12.2009
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList