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: Shaktishura Zulugul
Country: Reunion
Language: English (Spanish)
Genre: Science
Published (Last): 21 March 2010
Pages: 375
PDF File Size: 18.50 Mb
ePub File Size: 15.20 Mb
ISBN: 834-2-80171-273-3
Downloads: 41726
Price: Free* [*Free Regsitration Required]
Uploader: Tejind

Have you worked in portioned db? How is it used? If you are given with a query, how you tune it? If Solaris Cluster, ask relevant questions. What is the maximum number of tables that can be stored on a Partitioned Tables Space?

DB2 ( IBM Database 2 ) Interview Questions

Whats the difference between Load and import? What do you need to restore DB2 to a point in time? What is the function of the Data Manager? Vijay Kumar February 26, at 9: What is a DB2 bind?

What are column-name qualifier used? What are a precompiler? What is an inner join, and questinos outer join?

What are the three tyes of page locks that can be held? What is a buffer pool? Describe the components of a table that are needed to establish referential integrity between two tables. What is a root page?


What is meant by index cardinality?

How do you declare a host variable What is referential integrity? Lot of updates have been done on a table due to which indexes have gone haywire. It can be made up of either 4K or 32K pages. DB2 registry db2set -all G.

What happens to a tablespace when its recovery information has been removed and a full recovery is no longer possible? What is the difference between CS and RR isolation levels? How would one remove old reorg information from the DB2 catalog? How many clustering indexes can be defined for a table? What is an asychronous write? Have you been part of design? How can you make sure you only return 10 rows?

When will you use it? Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium.

What are leaf pages? What is a predicate? How can you see physical memory core utilization by a Unix DB2 server? Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. What do you do? How can you see all the connected processes running against the database? How can one determine the status of a tablespace?


What is the difference between group by and order by? What information is used as input to the bind process?

What is index cardinality? Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace. If not, then what is the point of using it?

How do you filter out the rows retrieved from a DB2 table? Data page also contains information regarding the catalog or user that are part of the database.

DB2 UDB Interview Questions Answers

Describe a correlated subquery. Build phase of load utility does a sort? This should also be matched with plan ID.

How is a typical DB2 batch program executed?