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: Batilar Jull
Country: Chile
Language: English (Spanish)
Genre: Career
Published (Last): 10 January 2012
Pages: 432
PDF File Size: 13.42 Mb
ePub File Size: 7.78 Mb
ISBN: 662-1-84421-592-5
Downloads: 98272
Price: Free* [*Free Regsitration Required]
Uploader: Muzragore

Vijay Kumar February 26, at 9: Defines the maximum number of ufb memory pages to be used for private sorts, or the maximum number of shared memory pages to be used for shared sorts.

Have you been part of design? What is the significance of DB2 free space and what parameters control it? How many buffer pools are there in DB2? What is a Cartesian product? It can be made up of either 4K or 32K pages.

Top 50 DB2 Interview Questions & Answers

What is index cardinality? The physical database is managed by the DB2 component called Data manager. What is meant by a unit of recovery? What is a NULL value? What is a lock? Can I view dynamic SQL that has been run in the qudstions in the past?

Related Posts  VATSYAYAN KA KAMSUTRA IN DOWNLOAD

DB2 UDB Interview Questions Answers

What are the Maximum and minimum, number of partitions allowed in a partition tablesspace? What is the size of a data page? What are the parms that needs to be set to take an online back of the DB? For each and every row that is qualified, the evaluation of correlated sub-query is a must. For standard maintenance how would you use runstats and reorgs?

If not, why would you use it at all? Which catalog tables contain authorization information? Is it different from a nested select? What can the SET option of the repair Utility accomplish? What is a DB2 access path? Intevriew so, please give the SQL query for this?

If application team is contacting you telling the application is running very slowwhat all things you will check out? There is a certain point in a program at which DB2 acquires or perhaps releases the locks against tables as dbs as table-spaces.

Your email address will not be published. Can I import a file of extension WSF? How does the processing of a correlated subquery differ from a non correlated subquery? Data page can be considered as a unit that is capable of retrieving data from the database. How does DDB2 use multiple table indexes? At pre-compile time, the table or view dha are then used to check the validity of SQL statements.

Related Posts  ASTM D3515 EBOOK

What is a root page? How do you insert a record with a nullable colunm?

DB2 ( IBM Database 2 ) Interview Questions

DB2 What is the difference between a package and a plan? How do you filter out the rows retrieved from a DB2 table? What is the cascade rule and how does it relate to deletions made quetsions a subselect? What are foreign intervkew Load is faster than import, import is like bulk insert, every thing goes to the transaction log. If Solaris Cluster, ask relevant questions. What are the db cfg parms which affect the back up strategy?

What database configuration parameter establishes the minimum number of logs? What is a synonym? It is specified eba a condition or criteria to ensure data integrity.