JR29954: SQL30020N RC=124C WHEN SELECTING A CLOB FROM DB2 V7 ON Z/OS

DB2 Version 9.5 Fix Pack 3b 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.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 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

• SQL30020N may occur when performing a SELECT that contains a
  CLOB against DB2 Version 7 on z/OS.
  
  A DB2 trace will show SQL30020N RC=124C which means the DB2 DRDA
  layer encountered a SYNTAX ERROR due to a parsing error,
  although the error code reported by the application may include
  one or more of the following, likely on the call to
  SQLExtendedFetch:
  
  CLI0165E Error in row. SQLSTATE=01S01
  
  CLI0119E Unexpected system failure. SQLSTATE=58004
  
  SQL0902C A system error (reason code = "<reason-code>")
            occurred.  Subsequent SQL statements cannot be
            processed.
  
  SQL30020N Execution failed because of a Distributed Protocol
  Error that will affect the successful execution of subsequent
  commands and SQL statements: Reason Code "". SQLSTATE=58009
  

Local fix

• Set SQL_ROWSET_SIZE=1 using SQLSetStmtAttr() at the CLI layer.
  

Problem summary

• Users Affected:  CLI applications processing more than one row
  for every fetch against a z/DB2 v7 server.
  Problem Description:  SQL30020N when executing a statement
  against z/DB2 v7
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 2
  

Temporary fix

Comments

APAR Information

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

  JR28211

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

Fix information

• Fixed component name

  DB2 CEE WINDOWS

• Fixed component ID

  5765F3001

Applicable component levels

• R950 PSN

     UP