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: Faukree Kinos
Country: Estonia
Language: English (Spanish)
Genre: Video
Published (Last): 22 August 2009
Pages: 498
PDF File Size: 15.25 Mb
ePub File Size: 4.30 Mb
ISBN: 815-8-75448-796-8
Downloads: 37475
Price: Free* [*Free Regsitration Required]
Uploader: Faenos

What are the four lockable units for DB2? How does the processing of a correlated subquery differ from a non correlated subquery? How do you achieve record level locking in DB2 versions when record level locking is not allowed? What should qudstions specified along with a cursor in order to continue updating process after commit? What is meant by concurrency?

DB2 UDB Interview Questions Answers

It also permits data to be accessed by other applications who can reference the committed data. What is a correlated sub query? How many sub queries can you combine together? Server physical and swap virtual memory, disk storage amount and typeand number and type of processors.

For standard maintenance how would you use runstats and reorgs? DB2 can implement a join in three ways using a merge join Which utilities do a sort? What will the DB2 optimizer do?


Top 50 DB2 Interview Questions & Answers

Usb DB2 Catalog column tell you when an index needs table reorganized? What else is there in the PLAN apart from the access path?

For each and every row that is qualified, the evaluation of correlated sub-query is a must. What is a page? What are the db cfg parms which affect the back up strategy? How does one remove entires from the SCT02 table? What is the picture clause of the null indicator variable?

questilns What is the difference between group by and order by? If so, please give the SQL query for this? What are the three tyes of quesions locks that can be held? Whats the difference between Load and import? How could one combine a set of incremental image copies into a single copy? Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state?

Have you been part of design? Have you done server installation? If you create an indexit will sort the corresponding column If you are given with a query, how you tune it?

Describe two ways to create a primary key. When can you be sure quextions a quary will return onlyl one row? What is a view?

What are the various locks available? What are the three lock types?


What is isolation level? What is lock escalation? What are some characteristics of columns that benefit from indexes?

What is the difference between creating buffer pool with immediate option and default option?? What questionz a DB2 access path? Backup server and monitor server configuration. The process that builds access paths to the DB2 table is known as bind.

What is a common table? Suppose I have a program which uses a dynamic SQL and it has been performing What does it mean if the null indicator has -1, 0, -2?? Server physical and swap virtual memory, disk storage amount and typeand number and type of processors F.

How can you make sure you only return dn2 rows? How many clustering indexes can be defined for a table? When an application use private sort? How is the status of a utility reset after it has been stopped by DB2?

What is a clustering index? If Solaris Cluster, ask relevant questions. If I have a view which is a join of two or more tables, can this view be updatable? What is an alias?