IZ46731: BLOCKFORNROWS DB2CLI.INI KEYWORD SHOULD WORK WITH STORED PROCEDU RE RESULT SETS

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

• The db2cli.ini keyword BlockForNRows is used to ensure that a
  cursor/result set is blocked for an "N" number of rows up to
  a maximum of the RQRIOBLK setting (for remote clients) or
  the ASLHEAPSZ (for local clients).
  .
  This keyword does not currently work with stored procedure
  result sets, and with this APAR that will be fixed.
  .
  Also, DB2 for z/OS allows cursors to be defined with the ROWSET
  POSITIONING clause.  By default this will prevent a cursor from
  being blocked.   The db2cli.ini keyword BLOCKFORNROWS can now
  force the cursor to be blocked even with these kinds of cursors.
  

Local fix

Problem summary

• Users Affected:  CLI application users
  Problem Description:  The BLOCKFORNROWS db2cli.ini keyword will
   now be extended to work with stored procedure result sets.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, Fixpak 5
  

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

• Fixed component ID

  5765F3000

Applicable component levels

• R950 PSN

     UP