Interested to Buy Any Domain ? << Click Here >> for more details...
What is Reorg Recovery? when will you run it?
- 2 Answers
- 5238 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 |
How to know the primary key of a table without defining the primary key in the table?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
Explain various types of locks in db2?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
Is schema the same as database?
What is a clustered index?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
How to create a table using embedded sql?
List out the three types of page locks that can be held.
What are the contents of dclgen?
Can any one tell me about Restart logic in DB2.
What are foreign keys in db2?
COBOL 
