DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

what is the process of precompiler?

2 16624

What is buffrpool? Where we use it ?

Tesco,

2 14000

what is Runstats? Whem will u choose to runatats?

Danske,

1 13182

what is REORG? what is the use?

4 15697

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51307

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 7605

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

1 9271

What is a clustered index?

1 12448

When will you chose to run RUNSTATS?

1 9394

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

IBM,

3 9679

What is meant by a unit of recovery?

1 6510

What is CHECK PENDING ?

5 19924

What is a thread?

3 8130

What is filter factor?

2 10655

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

IBM,

1 9299

Post New DB2 Questions

Un-Answered Questions { DB2 }

Why do we need reorg in db2?

988

How is deadlock resolved?

1147

Explain db2.

1037

How many databases can be created inside an instance in db2 ?

1035

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2066

What is the difference between dbm cfg and db cfg file in db2 ?

1536

What is rct?

1235

What is dclgen (declaration generator)?

1059

What do you mean by cursor?

988

What is a collection in db2?

1036

List out the data types available.

1153

Mention the downsides of page level lock.

1161

What is consistency token in db2?

1144

Explain the function of data manager.

1044

When reorg is used?

1129

For More Un-Answered { DB2 } Questions Click Here