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

How to execute stored procedures?

718


Mention the definition of cobol in varchar field.

776


How to get the ddl of a table in db2?

759


What is runstats db2?

666


How many types of page locks can be held in db2?

689






What is db2 command?

669


What is null in db2?

653


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11171


What is sqlca’s maximum length?

792


How do I import a csv file into db2?

650


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3208


What are the prerogatives?

701


What are the full forms of spufi and dclgen and why are they used?

734


Mention some fields that are a part of sqlca.

680


What is the difference between cursor and select statement?

714