IY97524: JCC CLIENT GETS SQLCODE -964 DURING A NON-ATOMIC MULTI-ROW INPUT REQUEST. IT EXPECTS AN SQLCA FOR EACH ROW, BUT GETS ONLY ONE.

DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  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

APAR status

• Closed as program error.

Error description

• JCC client gets sqlcode -964 (transaction log full) when
  issuing a non-atomic multi-row input request. It expects an
  SQLCA for each row, but gets only one.
  If the APAR fix is not applied, an exception in the JCC
  application may occur.
  The sypmtoms of the exception are similar to the following:
  03-08-2007 14:55:30.507: ExecExceptionIgnore.eventPerformed(0)
  (Chained) Ignoring SQL error: Error Code: -964, SQLState: 57011
  03-08-2007 14:55:30.507: ExecExceptionIgnore.eventPerformed(0)
  Message: Error for batch element #1: DB2 SQL error: SQLCODE:
  -964, SQLSTATE: 57011, SQLERRMC: null
  03-08-2007 14:55:30.507: ExecExceptionIgnore.eventPerformed(0)
  JCC SQLCA:
  SQLCA Information
  sqlcode : -964
  sqlerrmc: null
  sqlerrp : SQLRI039
  sqlerrd : (1) -2062548983 (2) 9 (3) 0
  (4) 0 (5) -1039 (6) 1
  sqlwarn : (1) (2) (3) (4) (5) (6)
  (7) (8) (9) (10) (11)
  sqlstate: 57011
  

Local fix

Problem summary

• JCC CLIENT GETS SQLCODE -964 DURING A NON-ATOMIC MULTI-ROW INPUT
   REQUEST. IT EXPECTS AN SQLCA FOR EACH ROW, BUT GETS ONLY ONE.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.1, FixPak 4.
  

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

• Fixed component ID

  5724N7600

Applicable component levels

• R910 PSY

     UP