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: Zulkikazahn Faujora
Country: South Sudan
Language: English (Spanish)
Genre: Photos
Published (Last): 13 December 2004
Pages: 197
PDF File Size: 5.38 Mb
ePub File Size: 16.39 Mb
ISBN: 178-4-71548-656-2
Downloads: 75657
Price: Free* [*Free Regsitration Required]
Uploader: Nabar

How is the status of a utility reset after it has been stopped by DB2? Server physical and swap virtual memory, disk storage amount and typeand number and type of processors F. What is meant by repeatable read? How can tablespace be moved to another DASD volume that is allocated for that tablespace? Load is faster than import, import is like bulk intervied, every thing goes to the transaction log.

fba What is the self-referencing constraint? Post a Comment Your email is never published nor shared. Until a COMMIT is taken table locks are retained, which can prevent other concurrent processes from accessing the table resulting in lock wait. What is a composite index and how does it differ from a multiple index? Which catalog tables stores referential constraints?

DB2 UDB Interview Questions Answers

Besides these questions, I would also be looking for the following qualities in a strong candidate: It can be made up of either 4K or 32K pages. It invokes other system components to perform logging, locking etc.


How does the processing of a correlated subquery differ from a non correlated subquery? Try to get as many as possible. Vijay Kumar February 26, at 9: What is meant by index cardinality?

Would you load data to the production tables directly? Have you installed DB2 udb on a linux server?? What does DML stand for and what are some examples of it? What can the Locate option of the Repair Utility accomplish? What is a data type?

How questiohs you use a Unix utility to streamline or automate your work?

Where could you look if you had a question about whether a column has been defined as an index? What are leaf pages? How can you quickly find out the number of rows updated after interviee update statement? What are the four lockable units for DB2?

Interview Questions: db2 udb dbA Interview Qustions

What are the various locking levels available? What information is used as input to the bind process?

Describe the components of a table that are needed to establish referential integrity between two tables. Whats the difference between Load and import? I ydb CS and update a page.

DB2 ( IBM Database 2 ) Interview Questions

What are the three tyes of page locks that can be held? What is a clustered index? Explain qurstions a plan? Compare a subselect to a join? If you are given with a query, how you tune it? What is a common table? What is an asychronous write?


What is a root page? Table DB snap shop, Application snapshot,sql snap shoptvba utilization using top, check is there any stale connection connections that very old. What are the isolation levals possible? What are the db cfg parms which affect the back up strategy?

How would you move a tablespace to a different DASD volume allocated to that tablespace? The buffer pool is a reserved main storage, which is to satisfy the buffering requirements for one or more table spaces or indexes. What is the significance of DB2 free space and what parameters control it?

When do you specify the isolation level? DB2 database administration consulting services: In which column of which DB2 catalog would you find the length of the rows for all tables?

Can DASD types assigned to storage groups be intermixed? The primary use of DCLGEN comes during the pre-compilation phase where it helps in jnterview the misspelt column udv.