JR29176: SQL ERROR -4700 WHEN USING JCC DRIVER 3.X TO CONNECT TO DB2 Z/OS V8 IN COMPATIBILITY MODE

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2  for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 9  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.1 Fix Pack 10  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.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  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

• You may receive following error when using Universal JDBC driver
  version 3.x while connecting to DB2/zOS V8 in Compatibility
  Mode:
  
  SQLCODE: -4700, SQLSTATE: 56038, SQLERRMC: null
  
  The JCC driver v3.x incorrectly sets additional cursor attribute
  "WITH ROWSET POSITIONING", which is causing the SQL-4700 error.
  

Local fix

• Use the Universal JDBC driver version 2.x or set the
  Universal JDBC driver property useRowsetCursor=false
  for the JCC driver v3.x.
  

Problem summary

• SQL ERROR -4700 WHEN USING JCC DRIVER 3.X TO CONNECT TO
  DB2 Z/OS V8 IN COMPATIBILITY MODE
  

Problem conclusion

• The JCC driver v3.x incorrectly sets additional cursor attribute
  "WITH ROWSET POSITIONING", which is causing the SQL-4700 error.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  DB2 CUE ISERIES

• Fixed component ID

  5724M1501

Applicable component levels

• R910 PSY

     UP