Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 13005

What is buffrpool? Where we use it ?

Tesco,

2 10992

what is Runstats? Whem will u choose to runatats?

Danske,

1 10428

what is REORG? what is the use?

4 11557

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 42820

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 5367

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

1 7439

What is a clustered index?

1 10515

When will you chose to run RUNSTATS?

1 7451

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

IBM,

3 6876

What is meant by a unit of recovery?

1 4538

What is CHECK PENDING ?

5 15847

What is a thread?

3 5338

What is filter factor?

2 8588

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

IBM,

1 7398


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is image copy in db2?

319


Explain how can you do the explain of a dynamic sql statement?

387


Outputs of explain are with matchcols = 0. What does this signify?

399


What is buffer pool?

357


What is dclgen (declaration generator)?

349






What is reorg and runstats in db2?

367


What do you mean by commit and rollback?

330


What is bind and rebind in db2?

337


What is the reason behind not using select * in embedded sql programs?

351


Is schema the same as database?

357


What do you mean by cursor?

331


What is load utility in db2?

358


What is commit in db2?

344


What is an instance in db2?

330


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?

1613