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 IT05753 Status: Geschlossen

APPLICATION HUNG DOING INSERT/SELECT ON TABLE WITH XML COLUMNS AND COMPRESS
YES

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
An application running inserts/updates and selects on a 
table with XML columns and compression might hang and not able 
to be forced off. 
 
The scenario is : 
 
open transaction 
  insert .. 
  select.. 
 
 
db2pd -latches will show a deadlatch on 
SQLO_LT_SQLB_BPD__bpdLatch_SX S (i.e a two threads waiting on 
each other) 
 
Database Member 0 -- Active -- Up 0 days 00:06:43 -- Date 
2014-11-21-12.16.25.721195 
 
Latches: 
Address            Holder     Waiter     Filename 
LOC        LatchType            HoldCount 
0x0780000001588440 1029       0 
../include/sqle_workload_disp.h 1389 
SQLO_LT_sqeWLDispatcher__m_tunerLatch 1 
0x0700000047C2F468 13391      0 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000053E99768 13391      0 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      13134 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      13648 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      14162 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      14419 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      14676 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      14933 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      15190 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
>>>>>>>>>> 
0x0700000047D5BC28 13391      15447 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
<<<<<<<<<< 
0x0700000047D5BC28 13391      15704 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      15961 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      16218 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      16475 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047D5BC28 13391      16732 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047C50A28 15447      0 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
0x0700000047E8D9A8 15447      0 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
>>>>>>>>>> 
0x0700000047D35DE8 15447      13391 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
<<<<<<<<<< 
0x0700000047D35DE8 15447      13905 
/view/db2_v105fp3_aix64_n140813/vbs/engn/sqb/inc/sqlbslat.h 649 
SQLO_LT_SQLB_BPD__bpdLatch_SX S 
 
Stacks for the threads will show the wait is on XML code. 
 
31 (1)   SQLO_SLATCH_CAS64::getConflictComplex 
32 (2)   SQLO_SLATCH_CAS64::getConflict 
33 (3)   sqlbfix 
34 (4)   sqldcsl_fetchDirect 
35 (5)   sqldcsl_fetchRow 
36 (6)   xmls_FetchRegion 
37 (7)   XmlrnNodeMgr::fetchNode 
38 (8)   XmlrnTreeWalker::resolveContinuationNode 
39 (9)   XmlrnSerializer::serialize 
40 (10)          XmlrnSerializer::serialize 
41 (11)          XmlrnSerializer::serialize 
42 (12)          sqlriMaterializeXml 
43 (13)          sqlribnoLobCbDrda 
44 (14)          sqlribno_work 
45 (15)          sqlribno_work 
46 (16)          sqlribno 
47 (17)          sqlriSectInvoke 
48 (18)          sqlrr_process_fetch_request 
49 (19)          sqlrr_fetch 
50 (20)          sqljsParseRdbAccessed 
51 (21)          sqljsSqlam 
52 (22)          sqljsSqlam 
53 (23)          sqljsSqlam 
54 (24)          sqljsDriveRequests 
55 (25)          sqljsDrdaAsInnerDriver 
56 (26)          sqeAgent::RunEDU 
57 (27)          sqeAgent::RunEDU 
58 (28)          sqzEDUObj::EDUDriver 
59 (29)          sqloEDUEntry
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 and Fix Pack 7                   * 
****************************************************************
Local-Fix:
Do not use compression on Tables with XML columns or 
when insert - update XML tables , place a commit before doing a 
select on the table on the same transaction: 
 
open transaction 
  insert .. 
  commit 
 open transaciton. 
  select.. 
 
intead of : 
open transaction 
  insert .. 
  select...
Lösung
Problem was first fixed in DB2 Version 10.5 and Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.11.2014
19.01.2016
27.04.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList