Calculates statistics on the database to determine if tables or indexes,

What is REORG? When is it used?

Question Posted / vamsikrishnamraju

Answer Posted / vamsikrishnamraju

Calculates statistics on the database to determine if
tables or indexes, or both, need to be reorganized or
cleaned up.

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

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

3010

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

3206

What is the advantage in De-normalizing tables in DB2?

1235

Are view updateable?

1092

How to retrieve rows from a db2 table in embedded sql?

1445

What is a db2 schema?

1297

What is bind plan?

1096

How do I delete a table in database?

1079

How do I add a column to an existing table in db2?

1083

Is ibm db2 open source?

1132

How to check sequence on a table in db2?

1117

What are the various isolation levels possible?

1181

List some fields from sqlca?

1107

Mention the downsides of page level lock.

1217

What kind of database is db2?

1086