Interested to Buy Any Domain ? << Click Here >> for more details...
What is Reorg Recovery? when will you run it?
- 2 Answers
- 5361 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 difference between bind and rebind in db2?
explain about index with examples
What is isolation level?
What is bind plan?
Which component is responsible for db2 startup and shutdown?
What is a buffer in memory?
What is dbrm?
how to resolve -818 error. how to see timestamp token in load module and plan
How to find the maximum value in a column in the db2 database?
What is a base table?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Explain the benefits you can get from mainframe connect?
COBOL 
