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: Goltijinn Dukora
Country: Belize
Language: English (Spanish)
Genre: Career
Published (Last): 17 June 2016
Pages: 70
PDF File Size: 8.49 Mb
ePub File Size: 13.35 Mb
ISBN: 719-9-40676-424-8
Downloads: 42503
Price: Free* [*Free Regsitration Required]
Uploader: Digis

If the base table underlying a view is restructured How many sub queries can you combine together? Whats the difference questtions logretain and userexit? The reason for the same is that the pre-compiler never refers to the catalogue tables of DB2.

How can I view the SQL that is still in dynamic package cache? What is index cardinality? What is a lock? What will the DB2 optimizer do?

DB2 UDB Interview Questions Answers

What Utility is used to migrate DB2 from one release to the next? What is the difference between Where and Having Clause? Questoons do you insert a record with a nullable colunm?


Vertical portioned tables Whats snow flow schema?? What is correlated subquery? What does DML stand for and what are some examples of it? Windows Which Windows utilities would you use to do your job?

How is it used? What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

What is a thread? What does the SQLcode of pertain to? Would you load data to the production tables directly?

What are some characteristics of columns that benefit from indexes? When can an insert of a new primary key value threaten referential integrity? What is lock contention? Name the different types of Table spaces?

Interview Questions: db2 udb dbA Interview Qustions

If application team is contacting you telling the application is running very slowwhat all things you will check out? When can you be sure that a quary will return onlyl one row? What is the FREE command? Have you worked in portioned db? What is a clustering index? What is the cascade rule and how does it relate to deletions made with a subselect?

What is lock escalation? How can tablespace be moved to another DASD volume that is allocated for that tablespace? If I have a view which is a join of two or more tables, can this view be updatable?


What is a base table? How can you quickly find out the number of rows updated after an update statement? DBRMs form inputs that are helpful in the binding process. It is specified as a ud or criteria to ensure data integrity. What is cursor stability? What are leaf pages?

Vijay Kumar February 26, at 9: How can transaction design affect performance? What is the maximum number of tables that can be stored on a Partitioned Tables Space? What is a data type? How many buffer pools are there questiins DB2? Which DB2 command is used to retireve environmental information?

Author: admin