Interested to Buy Any Domain ? << Click Here >> for more details...
What is Reorg Recovery? when will you run it?
- 2 Answers
- 5475 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 |
Give some example of statistics collected during RUNSTATS?
Give the COBOL definition of a VARCHAR field.
What is the use of DELGEN in DB2? Can we Write the program with out using it?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Which components manage deadlocks in db2?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is image copy in db2?
What does sqlcabc has?
How would you print the output of an SQL statement from SPUFI?
What information is used as input to the bind process?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is the format (internal layout) of ?TIMESTAMP??
COBOL 
