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: Akigrel Tabei
Country: Algeria
Language: English (Spanish)
Genre: Life
Published (Last): 22 September 2010
Pages: 174
PDF File Size: 1.53 Mb
ePub File Size: 13.2 Mb
ISBN: 421-8-67843-555-4
Downloads: 4986
Price: Free* [*Free Regsitration Required]
Uploader: Vulmaran

What is the Manimum number of characters that a tablename can have? When will you use it? Which utilities do a sort? How would you move a tablespace to a different DASD volume allocated to qestions tablespace?

Can I import a file of extension WSF? What is the best lock size that you could use when you create a tablespace? How is the status of a utility reset after it has been stopped by DB2?

DB2 UDB Interview Questions Answers

The process that builds access paths to xba DB2 table is known as bind. Both online and offline are there, online reorg allows other transaction to access the tables.


What is dynamic SQL? What is the difference between creating buffer pool with immediate option bd2 default option?? What is a clustering index? YES if it is still in dynamic package cache. Server physical and swap virtual memory, disk storage amount and typeand number and jnterview of processors F.

Have you worked in portioned db? Can I view dynamic SQL that has been run in the database in the past? OS kernel configuration; E. DBRMs form inputs that are helpful in the binding process. What is a DB2 access path?

Data page also contains information regarding the catalog or questiond that are part of the database. What are simple, segmented and partitioned table spaces? What is correlated subquery? What are the three tyes of page locks that can be held? How can transaction design affect performance? What is meant by repeatable read? What are column-name qualifier used?

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

What is a data page? What are some characteristics of columns that benefit from indexes? What is an access path? It invokes other system components to perform logging, locking etc.


Need to update DBA technical knowledge or need to prepare for a job interview? If application team is contacting you telling the application is running very slowwhat all things you will check out? 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.

What is the meaning of SQL return code?

Where besides the DB2 catalog is database object information stored by DB2? What is filter factor?

What is the significance of DB2 free space and what parameters control it? If the base table underlying a view is restructured