LI70909: TRUNCATION OF RESULT SET RETURNED FROM STORED PROCEDURE

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• This APAR addresses a problem related to the truncation of
  result sets from stored procedures.  The problem occurs when
  connection concentrator is enabled and there is a mix of DB2 UDB
  Version 8 and DB2 UDB Version 7 clients.
  

Local fix

• A work-around is to turn concentrator off.  The connection
  concentrator is enabled when the value of the database manager
  configuration (dbm cfg) parameter max_connections is greater
  than the value of (dbm cfg) parameter max_coordagents.
  

Problem summary

• USERS AFFECTED: Users running stored procedures in an
  environment where connection concentrator is enabled and there
  is a combination of DB2 UDB Version 7 and Version 8 clients.
  PROBLEM DESCRIPTION:
  If this APAR is not applied, the result sets returned by your
  stored procedure may be truncated (and thus incorrect).
  PROBLEM SUMMARY: See Error Description.
  

Problem conclusion

• Problem was first fixed in Version 8.1 FixPak 11 (s060120).
  

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 LINUX39

• Fixed component ID

  5724B6205

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP