Here are top 34 objective type sample DB2 Interview questions and their answers are given just below to them. These sample questions are framed by experts. db2 udb dbA Interview Qustions. 1st Day . Thanks for answers, here are few basic DB2 interview questions and answers. ReplyDelete. Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to.

Author: Dolkis Fenrizshura
Country: Costa Rica
Language: English (Spanish)
Genre: Environment
Published (Last): 27 October 2004
Pages: 71
PDF File Size: 14.27 Mb
ePub File Size: 18.51 Mb
ISBN: 933-7-63172-300-8
Downloads: 74477
Price: Free* [*Free Regsitration Required]
Uploader: Teshakar

Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state? How can I view the SQL that is still in dynamic package cache? Questions about IBM products find reliable answers from a trusted source.


Db2 Udb Interview Questions And Answers Pdf

Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace. What are the differences between offline and online backup? If not, then what is the point of using it? How can you see physical memory core utilization by a Unix DB2 server?


What kind of maintenance needs to be done with logs? Following a DB2 update statement, what is the quickest way to compute the total number of updated rows? Use our job search engine to find and. However, problems can happen such as, intervies updates access to unrepeatable reads and uncommitted data.

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

More than one DB2 application process can access the same data at the same interbiew, is known as concurrency. Posted by Suresh at 9: Would you load data to the production tables directly?

How to enhance the performance of the application for sorting? Vijay Kumar February 26, at 9: If you create an indexit will sort the corresponding column. DB2 is a database product from IBM. Node catalog IP address and port I.

Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. DB2 product is extended with the support of. DBRMs form inputs that are helpful in the binding process.


DB2 UDB Interview Questions Answers

Based on a work at www. When an application use private sort? If you are given with a query, how you tune it?

The buffer pool is a reserved main storage, which is to satisfy the buffering requirements for one or more table spaces or indexes. Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. DB2 Health Monitor Problems.

DB2 UDB Interview Questions Answers

Describe a correlated subquery. Thanks for answers, here are few basic DB2 interview questions and answers. What database configuration parameter establishes the minimum number of logs? Diff between import and load?

Describe two ways to create a primary key. Which utilities do a sort?

Have you been part of design?