Here are top 34 objective type sample DB2 Interview questions and their answers are given just below to them. These sample questions are framed by experts. db2 udb dbA Interview Qustions. 1st Day . Thanks for answers, here are few basic DB2 interview questions and answers. ReplyDelete. Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to.

Author: Malagal Jull
Country: France
Language: English (Spanish)
Genre: Spiritual
Published (Last): 12 July 2015
Pages: 186
PDF File Size: 10.42 Mb
ePub File Size: 6.25 Mb
ISBN: 765-7-64554-936-5
Downloads: 63902
Price: Free* [*Free Regsitration Required]
Uploader: Jukus

What are the db cfg parms which affect the back up strategy? Have you done server installation? How might you use a Unix utility to streamline or automate your work? Use our job search engine to find and What do you want to know?

Build phase of load utility does a sort? What are the differences between offline and online backup? If application team is contacting you telling the application is running very slowwhat all intervkew you will check out?

OS kernel configuration; E. 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 buffer manager reduces the quantity of physical input as well as output operations that are actually performed by making use of buffering techniques that are highly sophisticated. Describe two ways to create a primary key. Would you load data to the production tables directly? DBRMs form inputs that are helpful in the binding process. How can transaction design affect performance? No Have you worked in portioned db? The process that builds access paths to the DB2 table is known as bind.


Diff between import and load?

Since DCLGEN is just a tool, it will only generate variable definitions for the host and reduces the chances of errors.

Can I load a file of extension WSF? It invokes other system components to perform logging, locking etc. Questionx the difference between logretain and userexit?

DB2 UDB Interview Questions Answers

Saturday, August 15, db2 udb dbA Interview Qustions. How can you see physical memory core utilization by a Unix DB2 server? Have you worked in portioned db?

If you create an indexit will sort the corresponding column. Can I import a file of extension WSF? How do you get tickets in your projects? Windows Which Windows utilities would you use to do your job?

DB2 LUW DBA HowTo / DB2 LUW DBA Candidate Interview Question Sampler

The physical database is managed by the DB2 component called Data manager. Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace. Besides these questions, I would also be looking for the following qualities in a strong candidate: Describe the components of a table that are needed to establish referential integrity between two tables. Post navigation Bank Careers In Uae. Besides these questions, I would also be looking for the following qualities in a strong candidate:.


DB2 is a database product from IBM. For standard maintenance how would you use runstats and reorgs? Both online and offline are there, online reorg allows other transaction to access the tables. What kind of maintenance needs to be done with logs? Whats snow flow schema?? Gregoriev please call Crime Stoppers at Posted by Suresh at 9: Describe a correlated subquery. For each and every row that is qualified, the evaluation of correlated sub-query is a must.

Can I view dynamic SQL that has been run in the database in the past?

Db2 Udb Interview Questions And Answers Pdf

How can I view the SQL that is still in quetions package cache? Review and pay your bill, sign-up to pay your bill automatically, and see the latest upgrade offers and deals.

In an SQL table that is embedded, what is the procedure to retrieve rows that are part of a DB2 table? The reason for the same is that the anv never refers to the catalogue tables of DB2. Based on a work at www. Questions about IBM products find reliable answers from a trusted source Dr. Vijay Kumar February 26, at 9: How do you document your work?