Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do?
Answer Posted / s
Reorg Index or Rebuild Index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What kind of database is db2?
How does db2 sample database connect?
How to fetch the last row from the table in SQL (db2)?
What is dbrm? When it will be created?
What is precompiler in db2?
What are concurrency issues?
What is phantom read in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Can you tell me how can you find out the # of rows updated after an update statement?
Define buffer pool.
How does coalesce work?
What is netezza database?
Where do you specify them?
What is the use of reorg in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?