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 16620

What is buffrpool? Where we use it ?

Tesco,

2 13997

what is Runstats? Whem will u choose to runatats?

Danske,

1 13180

what is REORG? what is the use?

4 15685

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51300

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 7599

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

1 9267

What is a clustered index?

1 12448

When will you chose to run RUNSTATS?

1 9390

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

IBM,

3 9668

What is meant by a unit of recovery?

1 6500

What is CHECK PENDING ?

5 19918

What is a thread?

3 8124

What is filter factor?

2 10652

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

IBM,

1 9294

Post New DB2 Questions

Un-Answered Questions { DB2 }

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2936

What is package in db2 mainframe?

987

Is db2 relational database?

979

Why cursor is used in db2?

1036

What is database alias db2?

1125

Define data page.

1065

Are views updateable?

1153

What is ibm db2 connect?

995

Which isolation level provides highest data integrity?

1116

What is phantom read in db2?

1156

Can you tell me how can you find out the # of rows updated after an update statement?

1099

what is the responsibility of the construction superintendent

2142

What is the cobol picture clause of the db2 data types date, time, timestamp?

1066

What is sqlca?

1072

What is image copy in db2?

1015

For More Un-Answered { DB2 } Questions Click Here