Site Loader

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: Malagal Kajisar
Country: Martinique
Language: English (Spanish)
Genre: Relationship
Published (Last): 7 May 2015
Pages: 223
PDF File Size: 14.65 Mb
ePub File Size: 4.50 Mb
ISBN: 447-6-64432-523-1
Downloads: 93303
Price: Free* [*Free Regsitration Required]
Uploader: Vozuru

What can the SET option of the repair Utility accomplish? What are the disadvantages of PAGE level lock? Which utilities do a sort?

Are you a Database Administrator? What are delete-connected tables? What are some SQL aggregates and udv built-in functions?

How do you insert a record with a nullable colunm?

No Have you worked in portioned db? How many buffer pools are there in DB2? Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

When will you use it? For each and every row that is qualified, the evaluation of correlated sub-query is a must.

What is SQLcode – ? Can I load a file of sb2 WSF?

Logging What are the kinds of logging? What information is used as input to the bind process? How might you use a Unix utility to streamline or automate your work? How can tablespace be moved to another DASD volume that is allocated for that tablespace?


What is meant by intdrview level?

What inteerview meant by a unit of recovery? What is an asychronous write? What is the significance of DB2 free space and what parameters control it?

Interview Questions: db2 udb dbA Interview Qustions

What is a cursor and what is its function? Try to get as many as possible. What is lock contention? Backup server and monitor server configuration. What is a DB2 bind?

What are the three tyes of page locks that can be held? I use CS and update a page. How many sub queries can you combine together? What is an alias and how does it differ from a synonym? DB2 database administration consulting services: How to enhance the performance of the application for sorting?

DB2 UDB Interview Questions Answers

What is a collection? How could one combine a set of incremental image copies into a single copy? Cursor stability is the property that tells the DB2 that the values of database that are read by making use of this application gets protected while the data is used. The primary use of DCLGEN comes during the pre-compilation phase where it helps in detecting the misspelt column names.

What is the purpose of the DSNC transaction? When do you specify the isolation level? In case if there are large updates to be done, then the resource utilization is high accordingly. What are the four lockable units for DB2? Have you installed DB2 udb on a linux server?? What is a clustered index? If application team is contacting you telling the application is running very slowwhat all things you will check out?


What is a thread? What else is there in the Questionx apart from the access path? What will the FREE command do to a plan?

What is the error code – ? This is a module that consists of SQL source statements that get extracted out of the application program. Your email address will not be published. What is an intent lock? What DB2 Catalog column tell you when an index needs table reorganized? Where could you look if you had a question about whether a column has been defined as an index? When can an insert of a new primary key value threaten referential integrity?

What is read-only cursor? How can you see physical memory core utilization by a Unix DB2 server?