DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 9646

What is buffrpool? Where we use it ?

Tesco,

2 8560

what is Runstats? Whem will u choose to runatats?

Danske,

1 7676




what is REORG? what is the use?

4 8423

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 35374

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 3874

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

1 5617

What is a clustered index?

1 8911




When will you chose to run RUNSTATS?

1 5949

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

3 4690

What is meant by a unit of recovery?

1 3279

What is CHECK PENDING ?

4 10919

What is a thread?

3 3889

What is filter factor?

2 7266

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

1 5944


Post New DB2 Questions






Un-Answered Questions { DB2 }

is it compulsory commitment control in journal?

1269


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

1481


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

791


How to resolve deadlock issue

10287


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

1533






When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

2333


what is the sqlcode -501

7732


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.

1924


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

7177


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1011


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.

491


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?

979


i want to maintain uniqueness on pdf without make lf??????????

959


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1092


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

942