DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 10953

What is buffrpool? Where we use it ?

Tesco,

2 9531

what is Runstats? Whem will u choose to runatats?

Danske,

1 8779




what is REORG? what is the use?

4 9537

What is the difference between a package and a plan?

Mphasis, L&T, Infosys,

6 37890

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 4417

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

1 6370

What is a clustered index?

1 9505




When will you chose to run RUNSTATS?

1 6426

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

IBM,

3 5453

What is meant by a unit of recovery?

1 3725

What is CHECK PENDING ?

5 12032

What is a thread?

3 4349

What is filter factor?

2 7773

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

IBM,

1 6448


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is the physical storage length of date data type?

61


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

7771


What is the cobol picture clause of the db2 data types date, time, timestamp?

57


How do I delete a table in database?

29


can all users have the privilage to use the sql statement select * (dml)?

82






Define data page.

83


What is the difference between bind and rebind in db2?

25


What is the use of reorg in db2?

28


What is netezza database?

22


How do I optimize a query in db2?

23


What is the difference between db2 and oracle?

28


What is dpf in db2?

34


What is phantom read in db2?

20


What is the role of the data page in the db2 database?

58


What does a deadlock mean in DB2?

66