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: Vukora Migul
Country: France
Language: English (Spanish)
Genre: Politics
Published (Last): 9 April 2012
Pages: 424
PDF File Size: 6.57 Mb
ePub File Size: 11.77 Mb
ISBN: 618-8-58754-282-3
Downloads: 73620
Price: Free* [*Free Regsitration Required]
Uploader: Maurr

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

What are the various locks available? How do you retrieve the data from a nullable column? What is isolation level?

What is a LIKE table and how is it created? What is a DB2 bind? Logging What are the kinds of logging? Questionx many buffer pools are there in DB2?

How can you see physical memory core utilization by a Unix DB2 server?

When can you be sure that a quary will intervies onlyl one row? If not, then what is the point of using it? A geek with outside technical interests is ideal. What is a NULL value? What do you need to restore DB2 to a point in time?


When is the skeleton cursor table created?

The reason for the same is that the pre-compiler never refers to the catalogue tables of DB2. When does the SQL statement gets executed when you use cursor in the application programming? What is the self-referencing constraint? Would you load data to the production tables directly? What are the four lockable units questins DB2?

DB2 UDB Interview Questions Answers

Whats the difference between Load and import? How is it used? What are the parms that needs to be set to take an online back of the DB? If only I could remember all of these questions during an interview… Reply. Table DB snap shop, Application snapshot,sql snap shoptcpu utilization using top, check is there any stale connection connections that very old. What kdb normalization and what are the five normal forms?

OS kernel configuration; E. How do you declare a host variable How to define the data items to receive the fetch items for the SQL?


What are a precompiler? Can I view dynamic SQL that has been run in the database in the past?

DB2 UDB Interview Questions Answers

What is a result table? Which catalog tables contain authorization information? Use staging tables If application team is contacting you telling the application is running very slowwhat all things you will check out? DB2 can implement a join in three ways using a merge join Try to get as many as wuestions. What is the name of the default DB2 catalog database?

YES if it is still in dynamic package cache. If you are given with a query, how you tune it?

Describe the components of a table that are needed to establish referential integrity between two tables. What is an inner join, and an outer join? Posted by Suresh at 9: