Z/os DB2 Version 7 Index Problem

dbzTHEdinosauer · Posted: Wed Jan 20, 2010 2:16 pm

according to posts in the other site (url from my earlier post),
you should runstat first then reorg.

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

Hi,
Dick Brenholtz

Thanks for your suggestion, but it is opposite of IBM recommendation.

Regards
Manshadi

sushanth bobby · Posted: Wed Jan 20, 2010 2:44 pm

Manshadi,

You can take STATISTICS while doing REORG itself, by doing this you can eliminate your step (3) process.

What version of DB2 you are using ?

Sushanth

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

Hi,
Sushanth

We are using DB2 Version 7.

Yes I can take statistics in Reorg jobs but I am not sure it will solve our problem.

Thanks
Manshadi

GuyC · Posted: Wed Jan 20, 2010 10:22 pm

If a unique index exists, select count(*) probably uses that index rather than the tablespace/parts

a way to force a TS-Scan is adding a where clause on a non-index column where all rows qualify for example datelupd < '3000-01-01'

But all this doesn't answer the question.
DB2 z/OS V7 is OOS more than a year go.

Do you ever check the table or always force it ?

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

Hi,
Guyc

Thanks for your suggestion.