IC88597: INSERTING BLOBS OF SIZE 32756 BYTES DOES NOT COMPLETE WHEN EXECUTED IN A TRANSACTION.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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:
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 10.1 Fix Pack 2                       *
    ****************************************************************
    

Problem conclusion

  • First Fixed in Version 10.1 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC88597

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-27

  • Closed date

    2013-01-14

  • Last modified date

    2013-01-14

  • APAR is sysrouted FROM one or more of the following:

    IC83899

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC88597

Modified date:

2013-01-14

Translate my page

Machine Translation

Content navigation