Interested to Buy Any Domain ? << Click Here >> for more details...
What is Reorg Recovery? when will you run it?
- 2 Answers
- 5373 Views
- I also Faced
- E-Mail Answers
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 the syntax for seeing the columns and data types of a table in the db2 database?
What is RUNSTATS?
What is collection in db2 bind?
what's the best lock size that you could use when you create a tablespace?
Explain the EXPLAIN statement?
What are the prerogatives?
Where are plans stored?
What is the difference between IN subselects and EXISTS subselect?
how to unload different table data into different gdg files/ vsam files.
How do you Load a table ?? and what is Load replace ?
What is a db2 package?
How to insert more than one record using insert?
COBOL 
