IBM Support

JR31182: ODBC WRAPPER ERROR : PROTOCOL ERROR CAUSING DEALLOCATION OF CONV ERSATION - DISCONNECT EXCEPTION - DB DAMAGED SQL1034N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During the Rollback an SQL1034 indicating the DB is damaged is
    encountered as per the following diag.log entry.
    2007-06-01-12.44.50.462978-240 I47866233C428 LEVEL: Severe
    PID : 1142930 TID : 1 PROC :
    db2agent
    (PWSII) 0
    INSTANCE: db2icb NODE : 000 DB : PWSII
    APPHDL : 0-893 APPID: P9275B89.P04E.070530210002
    FUNCTION: DB2 UDB, relation data serv,
    sqlrr_rds_common_post,
    probe:
    DATA #1 : Hexdump, 4 bytes
    0x2FF14FC4 : 801A 006D ...m
    2007-06-01-12.44.50.463129-240 I47866662C376 LEVEL: Severe
    PID : 1142930 TID : 1 PROC :
    db2agent
    (PWSII) 0
    INSTANCE: db2icb NODE : 000 DB : PWSII
    APPHDL : 0-893 APPID: P9275B89.P04E.070530210002
    MESSAGE : UCstate:
    DATA #1 : Hexdump, 4 bytes
    0x20039AE0 : 0400 0142 ...B
    2007-06-01-12.44.50.463278-240 I47867039C687 LEVEL: Severe
    PID : 1142930 TID : 1 PROC :
    db2agent
    (PWSII) 0
    INSTANCE: db2icb NODE : 000 DB : PWSII
    APPHDL : 0-893 APPID: P9275B89.P04E.070530210002
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1034 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLRR09E
    sqlerrd : (1) 0x801A006D (2) 0x00000000 (3)
    0x00000000
    (4) 0x00000000 (5) 0xFFFFFFE2 (6)
    0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:
    

Local fix

  • Customer worked around disconnect issue bgy pointing the LD temp
    
    to disk instead of hyperspace on Classic Federation (z/OS) side.
    
    (Not sure if this is relevant)
    

Problem summary

  • Users affected:
       Users of the ODBC wrapper in InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5, FixPak 4 (s090429). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR31182

  • Reported component name

    ODBC WRAPPER

  • Reported component ID

    5724N9707

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-11-20

  • Closed date

    2009-05-30

  • Last modified date

    2009-05-30

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

    JR31181

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

Fix information

  • Fixed component name

    ODBC WRAPPER

  • Fixed component ID

    5724N9707

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPM","label":"Data Sources and Wrappers - ODBC"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
30 May 2009