Prefetch not availabe during NPI INDEX REORG

Charles Tsao

Prefetch not availabe during NPI INDEX REORG
Hello everyone,

I encountered a situation and wonder if someone can help me out.

Background - Running REORG INDEX SHRLEVEL CHANGE on a NPI 6pieces * 2GB
ZOS/DB2 7. During the UNLOAD phase of the REORG utility. I can only see
SYNC I/O no PREFETCH thru OMON. I checked the bufferpool for prefetch
failure due to the normal thresholds, no problem. I try another NPI that is
assigned to the same bufferpool and it works fine - mostly prefetch and few
sync.

Seems that the sync IO only occur with this particular NPI. Can someone
tell me under what condition can this occur?

Many thanks

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim Ruddy

Re: Prefetch not availabe during NPI INDEX REORG
(in response to Charles Tsao)
Has the sequential threshold been hit for the bufferpool defined for the index?

Jim Ruddy
DB2 for z/OS Development

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm