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 null indicator in cobol db2?
how can i pull up a query which was previously stored in qmf
WHAT IS MEANT BY COMMIT COMMAND?
What is a DBRM, PLAN ?
What is a cursor and what is its function?
what is the sqlcode -501
Explain what a plan is?
How do you retrieve the data from a nullable column?
Why use RUNSTAT Utility?
What are the various data types available in db2?
What does DML stand for and what are some examples of it?
how to u check the query is executing or not ?where will u check for sqlcode ?