1.) Define DB2. DB2 is a Database Management System for the MVS Operating System where, DB2 is a subsystem of MVS Operating System. A.6 I had DB2 V on Windows after which I uninstalled it and then. IBM DB2 UDB Interview Questions Answers. Mainframe DB2 UDB Admin Interview Questions, FAQs. What is online reorg/offline?.

Author: Nahn Samuktilar
Country: Costa Rica
Language: English (Spanish)
Genre: Health and Food
Published (Last): 17 September 2012
Pages: 111
PDF File Size: 11.47 Mb
ePub File Size: 8.62 Mb
ISBN: 838-6-29610-435-6
Downloads: 64071
Price: Free* [*Free Regsitration Required]
Uploader: Zulkigami

Usually, which is more important for DB2 system performance Is there any advantage to denormalizing DB2 tables? What are the various locking levels available? Someone with a background in database development and some years in at least one non-database programming language; someone who can understand development challenges.

How many clustering indexes can be defined for a table?

The form in which data is retrieved depends on the way the table is defined inside the database. When an application use private sort?

DB2 UDB Interview Questions Answers

How to define the data items to receive the fetch items for the SQL? Logging What are the kinds of logging? No Have you worked in portioned db? For each and every row that is qualified, the evaluation of correlated sub-query is a must. What is the name of the default DB2 catalog database? DB2 registry db2set -all G.


How can you quickly find out the number of rows updated after an update statement? If you create an indexit will sort the corresponding column.

What is an inner join, and an outer join?

DB2 ( IBM Database 2 ) Interview Questions

If the base table underlying a view is restructured How is it used? What is a thread? Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. What is the difference between static and dynamic SQL? Interviww can I view the SQL that is still in dynamic package cache?

Can I import a file of extension WSF?

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

How do you retrieve the data from a nullable column? What are the various locks available? What are a precompiler? What are delete-connected tables? Are you a Database Administrator? Load is faster than import, import is like bulk insert, every thing goes to the transaction log.


Whats the difference between Load and import? It can be made up of either 4K or 32K pages.

What is the Manimum number of characters that a tablename can have? Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database? What is the syntax required for the creation of a cursor?

Filed in DB2 – the human side and tagged candidatecertificationdb2dbainterviewquestions. What should queshions specified along with a cursor in order to continue updating process after commit? What does the SQLcode of pertain to? What is a synonym?

Lot of updates have been done on a table due to which indexes have gone haywire. What is correlation names? What is the error code – ?