What DB2 Catalog column tell you when an index needs table
reorganized ?

Answer Posted / abhishek kumar

SYSIBM.SYSINDEXES

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1703


How do I add a column in db2?

583


Define declaration generator (dclgen).

658


Explain about cursor stability?

614


Can you use max on a char column?

632






Explain what are the various isolation levels possible?

603


How do I optimize a query in db2?

604


What is reorg?

610


What is query_cache_limit?

541


What is the purpose of using commit?

609


How can record locking be achieved in those DB2 versions which do not support it?

614


What is the meaning concurrency in the db2 database?

628


Give a brief description of db2 isolation levels?

593


What is check constraint in db2?

597


What is the role of schema in the db2 database?

642