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 14715

What is buffrpool? Where we use it ?

Tesco,

2 12269

what is Runstats? Whem will u choose to runatats?

Danske,

1 11781

what is REORG? what is the use?

4 13149

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 47406

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 6216

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

1 8377

What is a clustered index?

1 11338

When will you chose to run RUNSTATS?

1 8410

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

IBM,

3 8011

What is meant by a unit of recovery?

1 5372

What is CHECK PENDING ?

5 17662

What is a thread?

3 6466

What is filter factor?

2 9473

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

IBM,

1 8156

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to get the ddl of a table in db2?

667

What is ibm db2 database?

524

What is buffer pool and list some of them?

619

How to find schema of a table in db2?

562

What are host variables in db2?

611

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

6226

How to execute stored procedure in db2 command editor?

522

What is the purpose of using commit?

606

Is schema the same as database?

621

What is netezza database?

561

What is the difference between plan and package in db2?

564

What is dbrm? What it contains? When it will be created?

587

What is the result of open cursor statement?

627

If I have a view which is a join of two or more tables, can this view be updateable?

683

What is consistency token in db2?

626

For More Un-Answered { DB2 } Questions Click Here