|
Problem IC83899
|
Status: Closed |
INSERTING BLOBS OF SIZE 32756 BYTES DOES NOT COMPLETE WHEN EXECUTED IN A TRANSACTION. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
inserting blobs of size 32756 bytes causes an application hang
while serer is waiting to read more information from the socket.
Problem reproduces on both Informix and DB2 servers
The problem appears to be with the EXTDTA OBJDSS and the
corresponding
NEXT DSS LOGICAL RECORD
EXTDTA OBJDSS (ASCII)
(EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF
0123456789ABCDEF
0000 FFFFD00300027FF9 146C005858585858 .........l.XXXXX
..}..."9.%......
0010 585858056A8AAF35 71945D25376213FA XXX.j..5q.]%7b..
....|....m).....
0020 3508312068382405 CBC4A8CB7AA56921 5.1 h8$.....z.i!
.........Dy.:v..
0030 CEFFC6D845002678 618CF5AC6A4B7F62 ....E.&xa...jK.b
..FQ..../.5.|.".
0040 81BC4FB8006C537D 0A493AA6E1E4BACC ..O..lS}.I:.....
a.!..%.'...w.U..
0050 2A3C56379B3BB534 E1B9BFDB43779B80 *<V7.;.4....Cw..
................
0060 454549BE55B12161 AC48CEFCC680967C EEI.U.!a.H.....|
......./....F.o@
0070 D228812EF447C745 071AD646AD783A92 .(...G.E...F.x:.
K.a.4.G...O....k
0080 AEB9619C9BFC7679 1BF48B526DB86E61 ..a...vy...Rm.na
../....`.4.._.>/
0090 2343091AF56D8BFD 7E04B73BDADAB434 #C...m.....;...4
....5_..=.......
00A0 0E3B4E0C1EF9E1D5 B20812FFBC74D84E .;N..........t.N
..+..9.N......Q+
00B0 AC75236A6F209C41 2E641E96453A9E41 .u#jo .A.d..E:.A
...|?......o....
00C0 405644316A614329 613367ED5A8C4109 @VD1jaC)a3g.Z.A.
...|/../...]...
00D0 2B688F65B74AC5EE 9E0DDEBADB4A9077 +h.e.J.......J.w
.....[E......[..
00E0 69D1BF6530A7E34B 32F9083BB8AFE6A2 i..e0..K2..;....
.J...xT..9....Ws
00F0 22146BDCAB3989F5 9156935D82884D17 ".k..9...V.]..M.
..,...i5j.l)bh(.
...
...
...
...
7F30 127B4FA6625E707F 3ADFCA0532F73762 .{O.b^p.:...2.7b
.#!w.;.".....7..
7F40 3CBC8E7925328F51 BD5506F20F45FCA2 <..y%2.Q.U...E..
...`.......2...s
7F50 ECE5D93699B01B5C D98560AC926AFA2C ...6...\..`..j.,
.VR.r..*Re-.k|..
7F60 B103801D874AAAE0 ECFEE80D587E70F4 .....J......X.p.
....g[.\..Y..=.4
7F70 E328194D1D01C98B A132A0A0D2E3BE53 .(.M.....2.....S
T..(..I.....KT..
7F80 5ADA410BC5DF1AA1 3AF94A9BC70E045B Z.A.....:.J....[
]...E....9[.G..$
7F90 146BC86A50AD0EAF 3AF47B55AA0A0D08 .k.jP...:.{U....
.,H|&....4#.....
7FA0 3F95B27D3D642F04 0D781224B72DC493 ?..}=d/..x.$.-..
.n.'..........Dl
7FB0 2E448C661A5402AD CC91D1D163C5F630 .D.f.T......c..0
.........jJJ.E6.
7FC0 EB415B325C861EAF 3CC45CD89AEAF80C .A[2\...<.\.....
..$.*f...D*Q..8.
7FD0 2FE827657EA7EDEA 9204B1AB935DA147 /.'e.........].G
.Y..=x..k...l)..
7FE0 81E23875D19236A7 26DC2956F82A13E2 ..8u..6.&.)V.*..
aS..Jk.x....8..S
7FF0 99C4A17A9E90B258 58585858585858 ...z...XXXXXXXX
rD.:...........
NEXT DSS LOGICAL RECORD (ASCII)
(EBCDIC)
0 1 2 3 4 5 6 7 8 9 A B C D E F 0123456789ABCDEF
0123456789ABCDEF
0000 0002 .. ..
The Server appears to be waiting for more information to read
from the socket: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Client users that insert large blobs *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 9.7 FP 7 or greater *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
Problem first fixed in DB2 Version 9.7 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC88597
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.06.2012
24.10.2012
24.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
