Reorg is done when 1) clustratio <80% ( for IBM stranded) 2) when a

What does the REORG Utility do?

Question Posted / harsha

2 Answers
13872 Views
I also Faced
E-Mail Answers

Answer Posted / harsha

Reorg is done when

1) clustratio <80% ( for IBM stranded)
2) when altering the Cluster object
3) when dropping the cluster object
4) when bulk updates and inserts are done
5) space reclamation
6) when a table is changed from compression to decompression
mode

Is This Answer Correct ?

6 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the benefits of using the db2 database?

1150

How does coalesce work?

956

Which component is responsible for db2 startup and shutdown?

979

What is explain in db2?

958

what is diffrence b/w file-aid tool and file-aid utility???

4808

How to execute stored procedures?

1055

What is load utility in db2?

1125

How do I import data from excel to db2?

1000

What does runstats do in db2?

1020

What is a Foreign Key?

1034

What is an instance in db2?

981

What is syscat in db2?

949

What is the difference between spufi and qmf?

1050

Define db2 and its databases?

996

What is collection in db2 bind?

956