when to reorg a tablespace

ravideep · #1 (**permalink**) 03-08-11, 01:49

hi
i want to know when to reorg a tablespace without running runstats

sathyaram_s · #2 (**permalink**) 03-08-11, 05:27

if you see a overflows in you table snapshot ...

That is only one of the reasons you may want to do a reorg. otherthan that, cannot think of anything else ..

But, why don't you want to do runstats ?

nvk@vhv · #3 (**permalink**) 03-08-11, 05:53

See:
http://public.dhe.ibm.com/software/d...ages_0508I.pdf
Pages 7 ff.

IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

Up to date Statistics are essential. On the other hand you could run reorgchk with "current statistics".

przytula_guy · #4 (**permalink**) 03-08-11, 07:44

clusterratio too low ..
too many pages used.... (many delete done)

sathyaram_s · #5 (**permalink**) 03-08-11, 08:30

I read my post now and see I have not been clear ..

Overflows in table snapshot may point to the requirement of reorg.

As far as I can think of , this is the only metric that you can use to identify reorg requirement without doing runstats

Internet Services

Web Development

Digital Marketing

Consumer Tech