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


Please Help Members By Posting Answers For Below Questions

What is phantom read in db2?

640


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.

2324


what is the responsibility of the construction superintendent

1664


What is db2 optimizer?

771


Is schema the same as database?

631






What is syscat in db2?

580


What is the max length of sqlca?

768


What is a dbrm in db2?

576


What is a system catalog table in db2?

589


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630


What do you mean by storage group (stogroup)?

583


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6860


What is the difference between oracle and db2?

587


What is difference between isnull and coalesce?

620


What db2 400?

679