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: Aradal Mazshura
Country: Dominica
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 11 September 2015
Pages: 395
PDF File Size: 6.84 Mb
ePub File Size: 1.11 Mb
ISBN: 530-1-61755-507-4
Downloads: 94082
Price: Free* [*Free Regsitration Required]
Uploader: Kasar

DB2 UDB Interview Questions Answers

What is the function of buffer manager? Can I load a file of extension WSF? Server physical and swap virtual memory, disk storage amount and typeand number and type of processors F. Have you done server installation?

What is the function of the Data Manager? 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. Interviw Kumar February 26, at 9: Nope ;-0 first level IBM Team only does it!!

What is a DB2 bind? DB2 Health Monitor Problems. What is the picture clause of the null indicator variable? What is a collection? There is a certain point in a program at which DB2 acquires or perhaps releases the locks against tables as well as table-spaces.


When can an insert of a new primary key value threaten referential integrity? When do you specify the isolation level? When is the skeleton cursor table created?

How to define the data items to receive the fetch items qeustions the SQL? Besides these questions, I would also be looking for the following qualities in a strong candidate:.

How many sub queries can you combine together? What are some SQL aggregates and other built-in functions?

This is a module that consists of SQL source statements that get extracted out of the application program. If the base table underlying a view is restructured What d2 correlation names?

What is an access path? What can the SET option of the repair Utility accomplish? What are the db cfg parms which affect the back up strategy? Following intervview DB2 update statement, what is the quickest way to compute the total number of updated rows? Clustering index is a type of index, which locates the table rows and determines how to group questionz rows together in the tablespace. What is referential integrity? What is index cardinality? What is the syntax required for the creation of a cursor?

What are the parms that needs to be set to take an online back of the DB? What are simple, segmented and partitioned table spaces? What are the levels of isolation available with DB2V4?


DB2 UDB Interview Questions Answers

How is the status of a utility reset after it has been stopped by DB2? Saturday, August 15, db2 udb dbA Interview Qustions. Besides these questions, I would also questiond looking for the following qualities in a strong candidate: Will the lock be released after I am done with that page?

How do you get tickets in your projects? If I have a view which is a join of two or more tables, can this view be interrview Explain transactions, commits and rollbacks in DB2?

It can be made up of either 4K or 32K pages. In an SQL table that is embedded, what is the procedure to retrieve rows that are part of a DB2 table? Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client. What is the database descriptor? What are the three tyes of page locks that can be held? What is a lock?