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

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  


When can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 Answers  


where will u check for sqlcode ?

2 Answers   TCS,






What do you need to do before you do EXPLAIN?

1 Answers  


My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


What is nvl in db2?

0 Answers  


What is the logical entity between plan and Package?

5 Answers  


What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,


How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  


How to define the data items to receive the fetch items for the SQL?

2 Answers  


Categories