DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 15158

What is buffrpool? Where we use it ?

Tesco,

2 12678

what is Runstats? Whem will u choose to runatats?

Danske,

1 12150

what is REORG? what is the use?

4 13719

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 48512

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 6524

How do you filter out the rows retrieved from a Db2 table ?

1 8627

What is a clustered index?

1 11598

When will you chose to run RUNSTATS?

1 8649

What does DML stand for and what are some examples of it?

IBM,

3 8406

What is meant by a unit of recovery?

1 5640

What is CHECK PENDING ?

5 18215

What is a thread?

3 6888

What is filter factor?

2 9789

What's the maximum number of volumes that can be added to a STOGROUP?

IBM,

1 8410


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is load utility in db2?

766


What are bind parameters in db2?

704


What is dpf in db2?

763


What is sqlca’s maximum length?

804


What is ibm db2 used for?

706






Mention a credible reason why select* is never given preference in an sql program that has been embedded.

831


How to check sequence on a table in db2?

701


What is the difference between plan and package in db2?

694


Who uses db2?

662


What is db2 and what is the use of db2 optimizer?

727


Define data page.

723


what is the sqlcode -501

11726


What is meant by union and union all?

677


What is query_cache_limit?

634


How can you quickly find out the # of rows updated after an update statement?

712