MVSFORUMS.com

[Dragon_Lee]

Hello, how do I know whether the DB2 server is retriving data by 'continuous block fetch' or 'limited block fetch'?

As far as I know, as long as the cursor is defined as 'FOR FETCH ONLY' or 'FOE READ ONLY', then the DB2 server will default to use the block fetch, but how can I know it's useing 'continuous block fetch' or 'limited block fetch'?

Also, by what means I can know the size of a query block in the DB2 server? And how many extra blocks are defined that can be returned for a FETCH?

Appreciate any inputs. Thanks.
_________________
Dragon

[kolusu]

Dragon_Lee,

Check this

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.perf/db2z_continuousblockfetch.htm

Kolusu

[Dragon_Lee]

Thanks Kolusu. As per the doc, 'To enable continuous block fetch for DRDA and to regulate the number of extra rows sent by a DB2 for z/OS server, you must use the OPTIMIZE FOR n ROWS clause on your SELECT statement.'

It looks like the continuous block fetch is default if OPTIMIZE FOR n ROWS clause is used in a FETCH only cursor. Right?
_________________
Dragon