Interested to Buy Any Domain ? << Click Here >> for more details...
How would one remove old reorg information from the DB2
catalog?
- 2 Answers
- 6460 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mehdee
The online REORG INDEX or REORG Table Space utility
reorganizes an index space or Table Space to improve access
performance and reclaim fragmented space.
RUNSTATS utility will collect inline statistics and update
DB2 catalog.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the disadvantages of PAGE level lock?
How is the value function used?
What is buffer pool?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What are the abend codes occour in ur latest PROJECT in DB2
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What is the difference between dbm cfg and db cfg file in db2 ?
Is db2 a database?
what is dynamic cursor?gives syntax for this?
Define sqlca.
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
COBOL 
