DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 9334

What is buffrpool? Where we use it ?

Tesco,

2 8307

what is Runstats? Whem will u choose to runatats?

Danske,

1 7342




what is REORG? what is the use?

4 8108

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 34727

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 3693

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

1 5411

What is a clustered index?

1 8721




When will you chose to run RUNSTATS?

1 5796

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

3 4479

What is meant by a unit of recovery?

1 3136

What is CHECK PENDING ?

4 10613

What is a thread?

3 3718

What is filter factor?

2 7131

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

1 5788


Post New DB2 Questions






Un-Answered Questions { DB2 }

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

448


can we view the access paths created by dbrm ? how ? thx

4587


How to restart a DB2 program?

507


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?

4836


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

1481






How to fetch the uncommited data from table ?

524


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4663


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

7037


what is utility for parm lib

897


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.

1523


what is the sqlcode -501

7496


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

618


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

1870


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?

941


what is diffrence b/w file-aid tool and file-aid utility???

2905