1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

 2 14719

What is buffrpool? Where we use it ?

Tesco,

2 12275

what is Runstats? Whem will u choose to runatats?

Danske,

1 11788

what is REORG? what is the use?

 4 13161

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 47428

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 6221

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

 1 8389

What is a clustered index?

 1 11344

When will you chose to run RUNSTATS?

 1 8411

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

IBM,

3 8019

What is meant by a unit of recovery?

 1 5377

What is CHECK PENDING ?

 5 17669

What is a thread?

 3 6472

What is filter factor?

 2 9479

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

IBM,

1 8159

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is buffer pool and list some of them?

619

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1616

Explain about rct.

639

What are foreign keys in db2?

607

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2316




How and when does the db2 enforces the unique key?

609

What does db2 plan contain?

567

What is the maximum No of rows per page?

620

How to find the maximum value in a column in the db2 database?

597

What is catalog database in db2?

634

What types of tables are there in the db2 database?

543

How do you select a row using indexes in db2?

634

What is the difference between oracle and db2?

578

What is deadlock in db2?

572

What is database alias db2?

591

For More Un-Answered { DB2 } Questions Click Here