What is performance tuning db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


What is ibm db2 used for?

0 Answers  


Mention and explain the contention situations caused by locks?

1 Answers  


List out the three types of page locks that can be held.

0 Answers  






If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  


What is db2 catalog database?

0 Answers  


What is subquery ?

6 Answers  


can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,


How is deadlock resolved?

0 Answers  


can we drop column from a table

7 Answers   INDUS,


Categories