DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 9943

What is buffrpool? Where we use it ?

Tesco,

2 8751

what is Runstats? Whem will u choose to runatats?

Danske,

1 7991




what is REORG? what is the use?

4 8668

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 35970

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 4014

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

1 5785

What is a clustered index?

1 9074




When will you chose to run RUNSTATS?

1 6051

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

3 4863

What is meant by a unit of recovery?

1 3371

What is CHECK PENDING ?

4 11129

What is a thread?

3 3991

What is filter factor?

2 7369

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

1 6033


Post New DB2 Questions






Un-Answered Questions { DB2 }

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.

487


is it compulsory commitment control in journal?

1299


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

1037


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 ?

725


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

2987






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

4721


How to restart a DB2 program?

605


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 ?

1054


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1046


what is utility for parm lib

984


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?

1123


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?

4856


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

7309


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

5165


what is the responsibility of the construction superintendent

988