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



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

Answer / abhishek kumar

SYSIBM.SYSINDEXES

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

Mention some fields that are a part of sqlca.

1 Answers  


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,


How to define the a field which accepts value till 99999.99 in db2

3 Answers  


What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,


What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,


what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,


What do you need to do before you do EXPLAIN ?

1 Answers  


What is ibm db2 used for?

1 Answers  


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1 Answers  


What else is there in the PLAN apart from the access path?

1 Answers  


Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,


Categories