DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 10716

What is buffrpool? Where we use it ?

Tesco,

2 9355

what is Runstats? Whem will u choose to runatats?

Danske,

1 8586




what is REORG? what is the use?

4 9314

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 37339

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 4325

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

1 6234

What is a clustered index?

1 9395




When will you chose to run RUNSTATS?

1 6358

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

IBM,

3 5301

What is meant by a unit of recovery?

1 3637

What is CHECK PENDING ?

5 11797

What is a thread?

3 4261

What is filter factor?

2 7674

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

IBM,

1 6352


Post New DB2 Questions






Un-Answered Questions { DB2 }

Is it possible to create an Instance in DB2 using DB2 Control Center ?

36


what is a corelated subquerry?

45


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

35


Explain db2.

24


Explain about cursor stability?

38






How do you pull up a query which was previously saved in qmf?

26


define clustering index.

38


What is check constraint in db2?

20


Explain what are the various isolation levels possible?

18


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

43


Which are the db2 tools to protect integrity of the database?

43


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

20


What is concurrency?

47


What does a deadlock mean in DB2?

31


What are the full forms of spufi and dclgen and why are they used?

21