1.) Define DB2. DB2 is a Database Management System for the MVS Operating System where, DB2 is a subsystem of MVS Operating System. A.6 I had DB2 V on Windows after which I uninstalled it and then. IBM DB2 UDB Interview Questions Answers. Mainframe DB2 UDB Admin Interview Questions, FAQs. What is online reorg/offline?.

Author: Kajik JoJoramar
Country: Georgia
Language: English (Spanish)
Genre: Medical
Published (Last): 28 November 2010
Pages: 154
PDF File Size: 4.84 Mb
ePub File Size: 1.40 Mb
ISBN: 881-9-89628-402-7
Downloads: 81707
Price: Free* [*Free Regsitration Required]
Uploader: Mooguzuru

DB2 ( IBM Database 2 ) Interview Questions

Defines the maximum number of private memory pages to be used for private sorts, or the maximum number of shared memory pages to be used for shared sorts. What is referential integrity?

Buffer ubd can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. Have you worked in portioned db?

Interview Questions: db2 udb dbA Interview Qustions

There is a certain point in a program at which DB2 acquires or perhaps releases the locks against tables as well as table-spaces. Where are plans stored?

Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state? This is the table that contains information on the links that exists between the tables created through referential constraints.


Declaration Generator is a facility that is used to form SQL statements that describes a table or view. DB2 registry db2set -all G. How is it used? What are the Maximum and minimum, number of partitions allowed in questilns partition tablesspace?

When will you use it? What is the error code for Unique Index Violation?

What is an alias and how does it differ from a synonym? What is lock contention? How does DB2 determine what lock-size to use? What is the purpose of the DSNC transaction? Windows Which Windows utilities would you use to do your job?

What are a precompiler? How do you retrieve the data from a nullable column? What is the significance of DB2 free space and what parameters control it?

DB2 UDB Interview Questions Answers

What is correlation names? What is a correlated sub query? If not, then what is the point of using it? Describe the components of a table that are needed to establish referential integrity between two tables.

The buffer manager reduces the quantity of physical input as well as output operations that are actually performed by making use of buffering techniques that are highly sophisticated. What are simple, itnerview and dbq table spaces? How is the status of a utility reset after it has been stopped by DB2? Vijay Kumar February 26, at 9: Describe a correlated subquery. Can I view dynamic SQL that has been run in the database in lnterview past? Explain what a plan? It also permits data to be accessed by other applications who can reference the committed data.


Tell us something about Eb2 memory structure root is Instance shared memory, below that is Database shared memory; within each Database there is Application Group shared memory, then each Agent has private memory. What are the four lockable units for DB2?

What kind of maintenance needs to be done with logs? What is the difference between creating buffer pool with immediate option and default option?? What will the FREE command do to a plan?