Interested to Buy Any Domain ? << Click Here >> for more details...
What is Reorg Recovery? when will you run it?
- 2 Answers
- 5183 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 |
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Can you tell me how can you find out the # of rows updated after an update statement?
How can we retrieve the total number of records in RPG & CLLE?
Mention the definition of cobol in varchar field.
What is syscat in db2?
What is blu acceleration in db2?
How do I create a view in db2?
What information is held in SYSIBM.SYSCOPY?
List out the buffer pools in db2
How many buffer pools are there in DB2?
what is check point and restart Logic ? why do we go for that ??
COBOL 
