What does the REORG Utility do?

Question Posted / guest

2 Answers
13972 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What does the REORG Utility do?..

Answer / guest

REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.

Is This Answer Correct ?

23 Yes

5 No

What does the REORG Utility do?..

Answer / 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

More DB2 Interview Questions

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers

How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.

7 Answers TCS,

What information is held in SYSIBM.SYSCOPY?

1 Answers

How to define the data items to receive the fetch items for the SQL?

2 Answers

How will you delete duplicate records from a table?

7 Answers Google,

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers Infosys,

What is a synonym ?