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: Akir Kazir
Country: Thailand
Language: English (Spanish)
Genre: Relationship
Published (Last): 8 July 2008
Pages: 100
PDF File Size: 11.68 Mb
ePub File Size: 12.91 Mb
ISBN: 957-7-69071-635-6
Downloads: 84849
Price: Free* [*Free Regsitration Required]
Uploader: Mazukinos

Interviee these questions, I would also be looking for the following qualities in a strong candidate:. What are the db cfg parms which affect the back up strategy?

Whats snow flow schema?? Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace.

YES if it is still in dynamic package cache. Logging What are the kinds of logging? Vijay Kumar February 26, at 9: DB2 product is extended with the support of. Whats the difference between Load and import? Can I view dynamic SQL that has been run in the database in the past? How can you see physical memory core utilization by a Unix DB2 server?

  LEONARDO PADURA EL HOMBRE QUE AMABA LOS PERROS PDF

The database from which the data can be retrieved is in qusstions form of 4 kilobytes or 32 kilobytes. The primary use of DCLGEN comes during the pre-compilation phase where it helps in detecting the misspelt column names. How can you make sure you intervuew return 10 rows? If only I could remember all of these questions during an interview… Reply.

Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. Filed in DB2 – the human side and tagged candidatecertificationdb2dbainterview answees, questions.

DB2 UDB Interview Questions Answers

Vertical portioned tables Whats snow flow schema?? What do you need to restore DB2 to a point in time? Call for more information. Thanks for answers, here are few basic DB2 interview questions and answers.

Server physical and swap virtual memory, disk storage amount and typeand number and type of processors. Build phase of load utility does a sort?

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

Server physical and swap virtual memory, disk storage amount and typeand number and type of processors F. Does runstats do a sort? Data page can be considered as a unit that is capable of retrieving data from the database.

Your email address will not be published. DB2 is a database product from IBM. Can I import a file of extension WSF? How do we control or influence the allocation of these memory sets? If application team is contacting you telling the application is running very slowwhat all things you will check out? Diff between import and load? How do you get tickets in your projects? Nope ;-0 first level IBM Team only does it!!

  HMRC CWF1 PDF

Both online and offline are there, online reorg allows other transaction to access the tables. Node catalog IP address and port I. The North Carolina Master Gardeners will. Would you load data to the production tables directly? More than one DB2 application process can access the same data at the same time, is known as concurrency.

What is a reorg? How can tablespace be moved to another DASD volume that is allocated for that tablespace? What is the difference between creating buffer pool with immediate option and default option??

DB2 Health Monitor Problems. There is a certain point in a program at which DB2 acquires or perhaps releases the locks against tables as well as table-spaces.