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 16624

What is buffrpool? Where we use it ?

Tesco,

2 14002

what is Runstats? Whem will u choose to runatats?

Danske,

1 13183

what is REORG? what is the use?

4 15702

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51308

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 7608

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

1 9274

What is a clustered index?

1 12449

When will you chose to run RUNSTATS?

1 9394

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

IBM,

3 9683

What is meant by a unit of recovery?

1 6512

What is CHECK PENDING ?

5 19927

What is a thread?

3 8134

What is filter factor?

2 10660

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

IBM,

1 9300

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1241

Where do you specify them?

1283

Define data page.

1072

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

1082

Explain about rct.

1090

What is package in db2 mainframe?

989

Explain the function of data manager.

1046

How do I add a column to a table in db2?

1104

When reorg is used?

1130

What do you mean by commit and rollback?

1047

What is the result of open cursor statement?

1083

What is sqlca?

1079

What are concurrency issues?

1098

Is schema the same as database?

1060

What does a deadlock mean in DB2?

1169

For More Un-Answered { DB2 } Questions Click Here