Way to identify multi-row fetch candidates?

IBM's flagship relational database management system

Way to identify multi-row fetch candidates?

Postby Jonathan Jeuck » Fri Sep 28, 2012 8:56 pm


If you wanted to identify the DB2 programs running in z/OS that would most benefit from implementing multi-row fetch, how would you do it? It seems to me that you'd want to run a report that identifies either the program or the plan, and allows you to sort by "total rows fetched over x days", "fetches per open cursor", and "rows per fetch". How would you go about creating a report that shows this for all jobs/programs over the last 30 days? Would you need a third party performance monitor? Are there some simple ways to run a report with this information within DB2 for z/OS?

Thanks all,
Jonathan Jeuck
Posts: 1
Joined: Thu Sep 20, 2012 12:55 am
Has thanked: 0 time
Been thanked: 0 time

Return to DB2


  • Related topics
    Last post