What is Reorg Recovery? when will you run it?
Answers were Sorted based on User's Feedback
Answer / s.v.venkata sivaprasad
reorg is a db2 use to improve the performance and any unused
pages in table space is rearange it perticul order and
release free space
//job1 job....
//step1 exec pgm=IKJEFT01
//sysin dd *
reorg db123.tb123
//
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is catalog database in db2?
What is DCLGEN?
What is the maximum size of varchar data type in db2?
What are the different types of base tables?
What is a bind card?
What is universal database?
How do I delete a table in database?
Mention data types used in db2 ?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
How do you run JCL in cobol program
What is bind plan?
Which is faster delete or truncate?