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: Taulkree Tagrel
Country: Papua New Guinea
Language: English (Spanish)
Genre: Music
Published (Last): 12 January 2018
Pages: 46
PDF File Size: 7.86 Mb
ePub File Size: 10.13 Mb
ISBN: 767-6-81042-819-7
Downloads: 42969
Price: Free* [*Free Regsitration Required]
Uploader: Nale

How do you get tickets in your projects? Backup server and monitor server configuration. Ask the Knowledge Center. DB2 database administration consulting services: Until a Intervuew is taken table locks are retained, which can prevent other concurrent processes from accessing the table resulting in lock wait.

Thanks for answers, here are few basic DB2 interview questions and answers. Saturday, August 15, db2 udb dbA Interview Qustions. Can I view dynamic SQL that has been run in the database in the past?

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

OS kernel configuration; E.

What are the db cfg parms which affect the back up strategy? If only I could remember all of these questions during an interview… Reply.

Top 50 DB2 Interview Questions & Answers

Both online and offline are there, online reorg allows other transaction to access the tables. What kind of maintenance needs to be done with logs? In case if intervieww are large updates to be done, then the resource utilization is high accordingly. There is a certain point in a program at questionz DB2 acquires or perhaps releases the locks against tables as well as table-spaces. Gregoriev please call Crime Stoppers at DB2 Health Monitor Problems. This is the table that contains information on the links that exists between the tables created through referential constraints.


What is a common table? How can transaction design affect performance? If you are given with a query, how you tune it?

The buffer manager reduces the quantity of physical input as well as output operations that are actually performed by making use of buffering techniques that are highly sophisticated.

Node catalog IP address and port I. Posted by Suresh at 9: Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. These include intent locks.

A geek with outside technical interests is ideal. Would you load data to the production tables directly?

DB2 UDB Interview Questions Answers

Can I load a file of extension WSF? Tell us something about DB2 memory structure root is Instance shared memory, below that is Database shared memory; within each Database there is Application Group shared memory, then each Agent has private memory. How can you make sure you only return 10 rows?

In an SQL table that is embedded, what is the procedure to retrieve rows that are part of a DB2 table? The North Carolina Master Gardeners will. How can I view the SQL that is still in dynamic package cache?

Windows Which Windows utilities would you use to do your job? Quesfions What are the kinds of logging? Questions about IBM products find reliable answers from a trusted source. How do we control or influence the allocation of these memory sets? It can be made up of either 4K or 32K pages. What is a reorg?


Db2 Udb Interview Questions And Answers Pdf

The primary use of DCLGEN comes during the uddb phase where it helps in detecting the misspelt column names. Whats the difference between Load and import?

Build phase of load utility does a sort? What are the advantages and disadvantages of each? DBRMs form inputs that are helpful in the intervisw process. Have you been part of design? Data page also contains information regarding the catalog or user that lnterview part of the answeers. The process that builds access paths to the DB2 table is known as bind.

What are the differences between offline and online backup? How to enhance the performance of the application for sorting? Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client. What do you need to restore DB2 to a point in time?

However, problems can happen such as, lost updates access to unrepeatable reads and uncommitted data.

DB2 registry db2set -all G. Vijay Kumar February 26, at 9: The physical database is managed by the DB2 component called Data manager.