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: Mooguzshura Arashihn
Country: Seychelles
Language: English (Spanish)
Genre: Travel
Published (Last): 11 April 2009
Pages: 59
PDF File Size: 3.49 Mb
ePub File Size: 17.70 Mb
ISBN: 119-3-15628-917-4
Downloads: 40715
Price: Free* [*Free Regsitration Required]
Uploader: Nekree

What is a cursor? What is cursor stability? What is a LIKE table and how is it created?

It is specified as a condition or criteria to ensure data integrity. How is the status of a utility reset after it has been stopped by DB2? What DB2 Catalog column tell you when an index needs table reorganized? Are you a Database Administrator?

What will the FREE command do to a plan? What is meant by concurrency?

DB2 LUW DBA HowTo / DB2 LUW DBA Candidate Interview Question Sampler

If so, please give the SQL query for this? What is meant by isolation level? How does the processing of a correlated subquery differ from a non correlated subquery? It can be made up of either 4K or 32K pages. OS kernel configuration; E.

DB2 UDB Interview Questions Answers

DB2 database administration consulting services: What is the error code – ? If not, then what is the point of using it? How many buffer pools are there in DB2?


The reason for the same is that the pre-compiler never refers to the catalogue tables of DB2. If Solaris Cluster, ask relevant questions. Vijay Kumar February 26, at 9: DB2 can implement a join in three ways using a merge join What is the easiest way to find out which programs are affected by change in a table’s structure?? Which catalog tables contain authorization information? Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem.

How to easily assign an incremented an unique value to a column? What are simple, segmented and partitioned table spaces? Posted by Suresh at 9: What is the FREE command?

What is the function of buffer manager? What are the various locking levels available? In terms of DB2 indexing, what is the root page? What is a correlated sub query? This is the table that contains information on the links that exists between the tables created through referential constraints.

Will the lock be released after I questuons done with that page? Where could you look if you had a question about whether a column has been defined as an index?

Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium.


DB2 Health Monitor Problems. Based on a work at www. What is the Manimum number of characters that a tablename can have? What is the best lock size that you could use when you create a tablespace? Your email address will not be published.

IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linux, UNIX and Windows – United States

How do you declare a host variable Filed in DB2 – the human side and tagged candidatecertificationdb2dbainterviewquestions. What is a root page? DB2 registry db2set -all G. Vertical portioned tables Whats snow flow schema?? What is meant by index cardinality?

Node catalog IP address and port I. Interview questions answers pdf June 13, at 2: What is a thread? Someone with a background in database development and some years in at least one non-database programming language; someone who can understand development challenges.

In which column of which DB2 catalog would you find the length of the rows for all tables? What is referential integrity?