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: Mokree Mikus
Country: Benin
Language: English (Spanish)
Genre: Politics
Published (Last): 26 December 2005
Pages: 312
PDF File Size: 13.88 Mb
ePub File Size: 7.63 Mb
ISBN: 781-1-38117-918-6
Downloads: 89203
Price: Free* [*Free Regsitration Required]
Uploader: Tejinn

What are the disadvantages of PAGE level lock? What is correlated subquery? Until a COMMIT is taken table locks are retained, which can prevent other concurrent processes from accessing the table resulting in lock wait. What is a lock? DB2 database administration consulting services: What is the picture clause of the null indicator variable? What is read-only cursor?

DB2 ( IBM Database 2 ) Interview Questions

What is the maximum number of tables that can be stored on a Partitioned Tables Space? What is an alias and how does it differ from a synonym? Server physical and swap virtual memory, disk storage amount and typeand number and type of processors. In dh2 of DB2 indexing, what is the root page? What is a DB2 plan? What is lock contention?

Have you worked in portioned db? How do you get tickets in inteerview projects? Load is faster than import, import is like bulk insert, every thing goes to the transaction log.

  ASTM D1822 PDF

DB2 UDB Interview Questions Answers

What is a collection? How would one remove old reorg information from the DB2 catalog? Describe the components of a table that are needed to establish referential integrity between two tables.

If db2start is taking a long time, what should you do? If you are given with a query, how you tune it? Cursor stability is the property that tells the DB2 that the values of database that are read by making use of this application gets protected while the data is used.

In case if there are dbb2 updates to be done, then the resource utilization is high accordingly. What is the difference between Where and Having Clause?

What is meant by a unit of recovery? How can you quickly find out the number of rows updated after an update statement? The form in which data is retrieved depends on the way the table is defined inside the database. What is a data type? How can transaction design affect performance? How will you delete duplicate records from a table?

No Have you worked in portioned db? What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?


What are the differences between offline and online backup? What is referential integrity? Use staging tables If application team is contacting you telling the application is running very slowwhat all things you will check out? How do you declare a host variable What is a data page? Whats the difference between logretain and userexit?

What is a thread? What is the cascade rule and how does it relate to deletions made with a subselect? Someone with a background in database development and some years in at least one non-database programming language; someone who can understand development challenges.

What is meant by the attachment facility? What is the difference between join quesyions union? If you create an index qustions, it will sort the corresponding column.

Eb2 is a predicate?

What Utility is used to migrate DB2 from one release to the next? What are some SQL aggregates and other built-in functions? Vijay Kumar February 26, at 9: How do you retrieve the data from a nullable column?