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: Shaktizuru Sajar
Country: Turks & Caicos Islands
Language: English (Spanish)
Genre: Politics
Published (Last): 20 August 2018
Pages: 411
PDF File Size: 12.51 Mb
ePub File Size: 20.9 Mb
ISBN: 502-9-44188-429-4
Downloads: 18785
Price: Free* [*Free Regsitration Required]
Uploader: Vudokinos

Can I view dynamic SQL that has been run in the database in the past? Whats the difference between logretain and userexit?

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

Based on a work at www. Post a Comment Your email is never published nor shared. Node catalog IP address and port I. Someone with a background in database development and some years intervkew at least one non-database programming language; someone who can understand development challenges.

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


How to easily assign an incremented an unique value to a column? The primary use of DCLGEN comes during the pre-compilation phase where it helps in detecting the misspelt column names. The physical database is managed by the DB2 component called Data manager. Vertical portioned tables Whats snow flow schema?? Questions about IBM products find reliable answers questiona a trusted source Dr.

The process that builds access paths to the DB2 table is known as innterview. Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client.

Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace. Qkestions class will address the topics of child sexual abuse prevention, recognition and response.

Have you done server installation? For standard maintenance how would you use runstats and reorgs?

How do we control or znd the allocation of these memory sets? What do you need to restore DB2 to a point in time? Thanks for answers, here are few basic DB2 interview questions and answers.


DB2 database administration consulting services: When first setting up and then later maintaining a database, what would be your main concerns with backup?

DBRMs form inputs that are helpful in the binding process.

It is specified as a condition or criteria to ensure data integrity. What are the advantages and disadvantages of each? Vijay Kumar February 26, at 9: Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state?

Build phase of load utility does a sort? Posted by Suresh at 9: It invokes other system components to perform logging, locking etc.

DB2 UDB Interview Questions Answers

The database from which the data can be retrieved is in the form of 4 kilobytes or 32 kilobytes. In case if there are large updates to be done, then the resource utilization is high accordingly.

How do you document your work? OS kernel configuration; E.