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
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 ?
How do I add a column in db2?
Define declaration generator (dclgen).
Explain about cursor stability?
Can you use max on a char column?
Explain what are the various isolation levels possible?
How do I optimize a query in db2?
What is reorg?
What is query_cache_limit?
What is the purpose of using commit?
How can record locking be achieved in those DB2 versions which do not support it?
What is the meaning concurrency in the db2 database?
Give a brief description of db2 isolation levels?
What is check constraint in db2?
What is the role of schema in the db2 database?