DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 14704

What is buffrpool? Where we use it ?

Tesco,

2 12261

what is Runstats? Whem will u choose to runatats?

Danske,

1 11775

what is REORG? what is the use?

4 13134

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 47364

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 6207

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

1 8365

What is a clustered index?

1 11331

When will you chose to run RUNSTATS?

1 8405

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

IBM,

3 8006

What is meant by a unit of recovery?

1 5368

What is CHECK PENDING ?

5 17656

What is a thread?

3 6446

What is filter factor?

2 9457

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

IBM,

1 8148


Post New DB2 Questions

Un-Answered Questions { DB2 }

What does db2 stand for?

587


What is the syntax for seeing the columns and data types of a table in the db2 database?

569


What is the usage of open cursor command?

590


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

573


How to create db2 table in mainframe?

617






What do you mean by cursor?

575


How to execute stored procedure in db2 command editor?

520


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6773


What is the use of with ur in db2?

600


What is data manager?

592


What is ibm db2 database?

524


Is db2 a programming language?

594


What is bind in db2?

593


What is a db2 collection?

595


What do you mean by rollback?

560