REORG utility will physically realign/reorganizes the records in a table

What is Reorg Recovery? when will you run it?

Question Posted / srinivas chennareddy

Answer Posted / srinivas chennareddy

REORG utility will physically realign/reorganizes the
records in a table as per the clustered index and release
any free space.

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a buffer in memory?

1066

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1065

What is the maximum size of a char data type in db2?

1013

How to create db2 table in mainframe?

1158

Are view updateable?

1051

What is concurrency?

1241

How can you quickly find out the # of rows updated after an update statement?

1052

How can the duplicate values be eliminated from db2 select?

1108

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1164

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3583

How many databases can be created inside an instance in db2 ?

1042

What are union and union all?

987

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3158

What is a bind in db2?

1050

what are bind concepts in db2 cobol?

1099