DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 14928

What is buffrpool? Where we use it ?

Tesco,

2 12443

what is Runstats? Whem will u choose to runatats?

Danske,

1 11969

what is REORG? what is the use?

4 13374

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 47961

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 6355

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

1 8490

What is a clustered index?

1 11463

When will you chose to run RUNSTATS?

1 8511

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

IBM,

3 8180

What is meant by a unit of recovery?

1 5475

What is CHECK PENDING ?

5 17891

What is a thread?

3 6624

What is filter factor?

2 9596

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

IBM,

1 8264


Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by commit and rollback?

627


Describe major components of db2?

674


When reorg is used?

707


What is the use of runstats in db2?

609


Explain db2.

646






How do you simulate the explain of an embedded sql statement in spufi/qmf?

670


How to rename a table in DB2 ?

665


define clustering index.

649


Highlight all the advantages that are attached to a package.

659


Define buffer pool.

656


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

713


What is meant by dclgen?

645


What is the use of db2 optimizer?

643


What is coalesce in db2?

713


Why select is not preferred in embedded sql programs?

746