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: | Yozshubei Shazuru |
| Country: | Bahamas |
| Language: | English (Spanish) |
| Genre: | Business |
| Published (Last): | 27 December 2012 |
| Pages: | 34 |
| PDF File Size: | 9.73 Mb |
| ePub File Size: | 20.21 Mb |
| ISBN: | 799-2-35338-746-6 |
| Downloads: | 11330 |
| Price: | Free* [*Free Regsitration Required] |
| Uploader: | JoJozragore |
DB2 registry db2set -all G.
DB2 UDB Interview Questions Answers
What are the 4 environments which can access DB2? What is the difference between creating buffer pool with immediate option qeustions default option?? What is a result table? If you are given with a query, how you tune it?
DB2 UDB Interview Questions Answers
Whats the difference between logretain and userexit? What is the difference between static and dynamic SQL? How would one remove old reorg information from the DB2 catalog? YES if it is still in dynamic package cache.
What is the difference between join and union?
What technique is used to retrieve data from more than one table in a single SQL statement? The reason for the same is that the pre-compiler never refers to the catalogue tables of DB2. What is meant by repeatable read? What is the Manimum number of characters that a tablename can have? What is the difference between group by and order uudb
What are the parms that needs to be set to take an online back of the DB? Until a Questinos is taken table locks are retained, which can prevent other concurrent processes from accessing the table resulting in lock wait. How do we control or influence the allocation of these memory sets? Why use it Explain an outer join? What are simple, segmented and partitioned table spaces? What is index cardinality?
IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linux, UNIX and Windows – United States
What is a DB2 access path? Describe two ways to create a primary key. How does DB2 determine what lock-size to use? What are the three DB2 date and time data types and their associated functions? What kind of maintenance needs to be done with logs? What are the disadvantages of PAGE level lock?
What is the Maximum normber of partitions that can be joined? Can I load a file of extension Intetview Explain what a plan? How is the status of a utility reset after it has been stopped by DB2?
If db2start is taking a long time, what should you do?
What is a clustering index? How do you document your work? Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client.
What is the error code – ? Suestions is the syntax required for the creation of a cursor? Filed in DB2 – the human side and tagged candidatecertificationdb2dbainterviewquestions.
What is a cursor and what is its function? What is the easiest way to find out which programs are affected by change in a table’s structure?? How does one remove entires from the SCT02 table? What is the difference between CS and RR isolation levels?
What are some characteristics of columns that benefit from indexes? What are the isolation levals possible? What is the name of the default DB2 catalog database? Where could you look if you had a question about whether a column has been defined as an index?