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 a host variable?

3 Answers  


i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,


What is the difference between group by and order by?

2 Answers   IBM, TCS,


What is the FREE command?

1 Answers  


What is db2 stogroup?

0 Answers  






is it compulsory commitment control in journal?

0 Answers   TCS,


Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


what is parm utility

2 Answers   IBM,


what is copy pending and check pending ?

1 Answers   Xansa,


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Categories