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 10840

What is buffrpool? Where we use it ?

Tesco,

2 9436

what is Runstats? Whem will u choose to runatats?

Danske,

1 8697

what is REORG? what is the use?

4 9417

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 37593

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 4375

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

1 6306

What is a clustered index?

1 9453

When will you chose to run RUNSTATS?

1 6401

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

IBM,

3 5366

What is meant by a unit of recovery?

1 3678

What is CHECK PENDING ?

5 11912

What is a thread?

3 4303

What is filter factor?

2 7720

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

IBM,

1 6401

Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by between and in? Is between inclusive of specified range values?

Where can you declare a cursor in a cobol-db2 program?

What is db2 command?

How and when does the db2 enforces the unique key?

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

4907

What action db2 takes when a program aborts in the middle of a transaction?

What are the two types of logging in the db2 database? Explain them.

What is a db2 package?

How to compare data between two tables in db2?

what is db2 restart?

1109

List out the data types available.

What parameters are used to control the free space in DB2?

What are concurrency issues?

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1214

Explain db2.

For More Un-Answered { DB2 } Questions Click Here