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?

12


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

47


What is db2 command?

7


How and when does the db2 enforces the unique key?

34


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?

32


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

44


What is a db2 package?

8


How to compare data between two tables in db2?

11


what is db2 restart?

1109


List out the data types available.

69


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

57


What are concurrency issues?

16


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.

44