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 15459

What is buffrpool? Where we use it ?

Tesco,

2 12960

what is Runstats? Whem will u choose to runatats?

Danske,

1 12358

what is REORG? what is the use?

4 14170

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 49201

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 6759

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

1 8766

What is a clustered index?

1 11767

When will you chose to run RUNSTATS?

1 8768

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

IBM,

3 8680

What is meant by a unit of recovery?

1 5781

What is CHECK PENDING ?

5 18582

What is a thread?

3 7142

What is filter factor?

2 10000

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

IBM,

1 8597

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you stop a db2 database in linux?

731

How to run db2 command in windows?

856

How do I import a csv file into db2?

732

What is database alias db2?

810

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

949

What is the difference between cursor and select statement?

816

What does db2 plan contain?

738

What is universal database?

813

What is the maximum size of varchar data type in db2?

824

Define data page.

800

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

837

What is the connection string to connect to the DB2 Database ?

823

Are views updateable?

825

B37 abend during spufi?

1194

Mention the location where the output received from explain statement is stored.

828

For More Un-Answered { DB2 } Questions Click Here