• June 16, 2019

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: Munris Tygogrel
Country: Djibouti
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 2 August 2017
Pages: 64
PDF File Size: 20.85 Mb
ePub File Size: 15.65 Mb
ISBN: 825-1-12726-732-1
Downloads: 36299
Price: Free* [*Free Regsitration Required]
Uploader: JoJomuro

What is an alias and how does it differ from a synonym?

What is meant by a unit of recovery? What is a view? DB2 Health Monitor Problems. Declaration Generator is a facility that is used to form SQL statements that describes a table or view.

Describe the components of a table that are needed to establish referential integrity between two tables. If you are given with a query, how you tune it?

What is a clustering index? What questionns the three lock types? Have you worked in portioned db? How to define the data items to receive the fetch items for the SQL?


DB2 UDB Interview Questions Answers

Both online and offline are there, online reorg allows other transaction to access the tables. What is the error code – ? What is a Cartesian product? Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state? What do you need to restore DB2 to a point in time? Interviea you create an indexit will sort the corresponding column.

If db2start is taking a long time, what should you do?

What is a DB2 access path? What are the levels of isolation available with DB2V4? What are column-name qualifier used?

Top 50 DB2 Interview Questions & Answers

Which transaction use a command thread? What is meant by repeatable read? Can I view dynamic SQL that has been run in the database in the past? Based on a work at www. Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. OS kernel configuration; E.

Nope ;-0 first level IBM Team only does it!! Usually, which is more important for DB2 system performance Is there any advantage to denormalizing DB2 tables? How does DB2 determine what lock-size to use? When can an insert of a new primary key value threaten referential integrity? Logging What are the kinds of logging? How would one remove old reorg information from the DB2 catalog? Vertical portioned tables Whats snow flow schema??


More than one DB2 application process can access the same data at the same time, is known as concurrency. What is a correlated sub query? What is the difference between join and union? The physical database is managed by the DB2 component called Data manager.

Will the lock be released after I am done with that page? What is the name of the default DB2 catalog database?

Dva is a module that consists of SQL source statements that get extracted out of the application program.