1 Sep Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to. 15 Aug db2 udb dbA Interview Qustions. 1st Day Thanks for answers, here are few basic DB2 interview questions and answers. ReplyDelete. 29 Sep You’ll likely be asked difficult questions during the interview. Top 20 db2 interview questions and answers If you need top 7 free ebooks below for Tell me about yourself? .. online training for IBM DB2 LUW UDB DBA.

Author: Mami Jura
Country: Japan
Language: English (Spanish)
Genre: Sex
Published (Last): 5 August 2009
Pages: 381
PDF File Size: 8.60 Mb
ePub File Size: 17.83 Mb
ISBN: 843-8-77151-311-9
Downloads: 38836
Price: Free* [*Free Regsitration Required]
Uploader: Tujinn

How do you insert a record with a nullable colunm? In terms of DB2 indexing, what is the root page?

Your comment has been saved. Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. The reason for the same is that the pre-compiler never refers to the catalogue tables of DB2.

Node catalog IP address and port I. How do you achieve record level locking db2 udb dba interview questions and answers DB2 versions when record level locking is not allowed?

IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linux, UNIX and Windows – United States

Besides these questions, I would also be looking for the following qualities in a strong candidate:. Can DASD types assigned to storage groups be intermixed?

Having trouble reading this image? When do you specify the isolation level? What are leaf pages? How can I view the SQL that is still in dynamic package cache?

What are the db cfg parms which affect the back up strategy? What is the best lock size that you could use when you create a tablespace? Posted by Jack Vamvas at 3: What is the self-referencing constraint?

What is a root page? What does the SQLcode of pertain to?

DB2 UDB Interview Questions Answers

db2 udb dba interview questions and answers How can you see physical memory core utilization by a Unix DB2 server? What is the difference between join and union? If I have a view which is a join of two or more tables, can this view be updatable? To perform an operation against a different instance — which variable value do you change? What are some characteristics of wuestions that benefit from indexes?

What is meant by repeatable read? Defines the maximum number of memory pages used for private sorts or the maximum number of shared memory pages to be used for shared ports. Where are plans stored? What is a db2 udb dba interview questions and answers pool? I use CS and update a page. What are foreign keys? Can I load a file of extension WSF?

The parameter assists in managing the load on the system during high concurrent application requests. Cursor stability is the property db2 udb dba interview questions and answers tells the DB2 that the values of database that are read by making use of this application gets protected while the data is used.

What is a view? At pre-compile time, the table or view descriptions are then used to check the validity of SQL statements.

It invokes other system components to perform logging, locking etc.