DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 8036

What is buffrpool? Where we use it ?

Tesco,

2 7263

what is Runstats? Whem will u choose to runatats?

Danske,

1 6118




what is REORG? what is the use?

4 7141

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 32367

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 3182

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

1 4635

What is a clustered index?

1 8003




When will you chose to run RUNSTATS?

1 5257

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

3 3869

What is meant by a unit of recovery?

1 2668

What is CHECK PENDING ?

4 9743

What is a thread?

3 3258

What is filter factor?

2 6689

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

1 5306


Post New DB2 Questions








Un-Answered Questions { DB2 }

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

2677


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.

337


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?

4424


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

778


How do we specify index to include or not during bind process.

842






If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

642


How to test SQL -911 error while developing COB-DB2 program

4724


I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.

287


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.

1717


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 ?

499


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

1330


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

605


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

1081


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

2160


assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

397