1 Sep Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to. A free inside look at DB2 Database Administrator interview questions and General DB2 LUW DBA questions, if you know DB2LUW you will do fine. 1 Answer. 1.) Define DB2. DB2 is a Database Management System for the MVS Operating System where, DB2 is a subsystem of MVS Operating System. 2.) What is the.

Author: Zulule Mazulkree
Country: Brazil
Language: English (Spanish)
Genre: Technology
Published (Last): 7 January 2013
Pages: 168
PDF File Size: 1.79 Mb
ePub File Size: 3.57 Mb
ISBN: 892-3-27016-966-6
Downloads: 62975
Price: Free* [*Free Regsitration Required]
Uploader: Faudal

What is a root page? Qeustions physical and swap virtual memory, disk storage amount and typeand number and type of processors F. What can the Locate option of the Repair Utility accomplish? What database configuration parameter establishes the minimum number of logs? Lot of updates have been done on a table due to which indexes have gone haywire.

In an SQL table that is embedded, what is the procedure to retrieve rows that are part of a DB2 table? How do nad achieve record level locking in DB2 versions when record level locking is not allowed? What is the difference between creating buffer pool with immediate option and default option?? What is the picture clause of the null indicator variable? Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium.


Can DASD types assigned to storage groups be intermixed? Posted by Suresh at 9: If not, then what is the point of using it? Assigning the OFF value indicates the log archiving method is not to be used. What is a correlated sub query? What is read-only cursor?

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

What is a clustered index? A geek with outside technical interests is ideal. What is the an number of tables that can be stored on a Partitioned Tables Space? Your comment could not be posted. What is the Maximum normber of partitions that can be joined? What is a clustering index? What is a data page?

What is SQLcode – ?

DB2 UDB Interview Questions Answers

Auestions kind of maintenance needs to be done with logs? More than one DB2 application process can access the same data at the same time, is known as concurrency. What are the disadvantages of PAGE level lock? What is the size of a data page? What is a collection?


When first setting up and then later maintaining a database, what would be your main concerns with backup? Describe two ways to create a primary key. What is a common table?

What is the purpose of the DSNC transaction? How can you see physical memory core utilization by a Unix DB2 server?

DB2 Database Administrator Interview Questions

Please enter a valid email address. What is a recovery log? How many clustering indexes can be defined for a table?

Which utilities do a sort? Have you worked in portioned db?

What is meant by the attachment facility? How can tablespace be moved to another DASD volume that is allocated for that tablespace?

How many buffer pools are there in DB2? What is a page?