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 db2 optimizer?
What is isolation level in db2?
how to resolve -805. give clear explination for that
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Explain the use of the WHERE clause?
Explain about dbrm.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the difference between using bind () and rebind () methods of naming class?
What is the purpose of the DSNC transaction ?
How to connect to db2 database from windows command line?
what needs to be done if a table is in copy pending / check pending status?
How does DB2 store NULL physically?