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: Mokasa Malagrel
Country: Niger
Language: English (Spanish)
Genre: Finance
Published (Last): 6 October 2016
Pages: 296
PDF File Size: 11.42 Mb
ePub File Size: 2.51 Mb
ISBN: 988-1-97362-553-9
Downloads: 14845
Price: Free* [*Free Regsitration Required]
Uploader: Kigamuro

If not, then what is the point of using it?

Db2 Udb Interview Questions And Answers Pdf

Data page can be considered as a unit that is capable of retrieving data from the database. This chapter describes history of DB2, its versions, editions and their respective features. DB2 Health Monitor Problems. Questions about IBM products find reliable answers from a trusted source.

DB2 UDB Interview Questions Answers

However, problems can happen such as, questionss updates access to unrepeatable reads and uncommitted data. Interview questions answers pdf June 13, at 2: Can I view dynamic SQL that has been run in the database in the past? This is a module that consists of SQL source statements that get extracted out of the application program. The buffer pool is a reserved main storage, which is to satisfy the buffering requirements for one or more table spaces or indexes.


More than one DB2 application process can access the same data at the answegs time, is known as concurrency.

Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. If you create an indexit will sort the corresponding column. When an application anwers private sort?

DBRMs form inputs that are helpful in the binding process.

Top 50 DB2 Interview Questions & Answers

No Have you worked in portioned db? Try to get as many as possible. How interiew you see physical memory core utilization by a Unix DB2 server?

If application team is contacting you telling the application is running very slowwhat all things you will questione out? Gregoriev please call Crime Stoppers at How do you get tickets in your projects?

Describe the components of a table that are needed to establish referential integrity between two tables. The primary use of DCLGEN comes during the nad phase where it helps in detecting the misspelt column names. What do you want to know? Declaration Generator is a facility that is used to form SQL statements that describes a table or view.


What database configuration parameter establishes the minimum number of logs? DB2 product is extended with the support of.

DB2 UDB Interview Questions Answers

How to enhance the performance of the application for sorting? Your email address will not be published.

What are the differences between offline and online backup? Both online and offline are there, online reorg allows other transaction to access the tables.

DB2 is designed to store, analyze and retrieve the data efficiently. Nope ;-0 first level IBM Team only does it!! If you are given with a query, ubd you tune it? What are the db cfg parms which affect the back up strategy?

Early examples include the Oracle. Server physical and swap virtual memory, disk storage amount and typeand number and type of processors F.

Author: admin