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

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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