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: JoJokora Mezitilar
Country: Norway
Language: English (Spanish)
Genre: Environment
Published (Last): 9 February 2008
Pages: 459
PDF File Size: 3.80 Mb
ePub File Size: 17.81 Mb
ISBN: 229-7-31250-278-7
Downloads: 93650
Price: Free* [*Free Regsitration Required]
Uploader: Mazuzuru

What should be ddb2 along with a cursor in order to continue updating process after commit? What is a reorg? Load is faster than import, import is like bulk insert, every thing goes to the transaction log. Suppose I have a program which uses a dynamic SQL and it has been performing What is a synonym? What is the name of the default DB2 catalog database? What is isolation level?

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

Jnterview staging tables If application team is contacting you telling the application is running very slowwhat all things you will check out? What is a common table? The buffer pool is a reserved main storage, which is to satisfy the buffering requirements for one or more table spaces or indexes.

Whats snow flow schema?? It invokes other system components to perform logging, locking etc. If not, then what is the point of using it? Since DCLGEN is just a tool, it will only generate variable definitions for the host and reduces the chances of errors.


Windows Which Windows utilities would you use to do your job? What is the error code – ? Both online and offline are there, online reorg allows other transaction to access the tables.

What is meant by concurrency? What are the disadvantages of PAGE level lock?

Why might full image copies be faster to queztions than an incremental image copy? How can you see physical memory core utilization by a Unix DB2 server? Lot of updates have been done on a table due to which indexes have gone haywire.

DB2 UDB Interview Questions Answers

When an application use private sort? When does the SQL statement gets executed when you use cursor in the application programming?

What is meant by a unit of recovery? What are the three lock types? In case if there are large updates to be done, then the resource utilization is high accordingly. What are the differences between offline and online backup? Usually, which is more important for DB2 system performance Is there any advantage to denormalizing DB2 tables? When is the access path determined for dynamic SQL?


Cursor stability is niterview property that tells the DB2 that the values of database that are read by making use of this application gets dg2 while the data is used. Table DB snap shop, Application snapshot,sql snap shoptcpu utilization using top, check is there any stale connection connections that very old.

What are column-name qualifier used? Is it different from a nested select? What does it mean if the null indicator has -1, 0, -2??

DB2 UDB Interview Questions Answers

DBRMs form inputs that are helpful in the binding process. What is a data page? How many clustering indexes can be defined for a table?

What will the FREE command do to a plan? DB2 Health Monitor Problems. Your email address will not be published. What information is used as input to the bind process? What are the levels of isolation available with DB2V4? How does DB2 determine what lock-size to use?

What technique is used to retrieve data from more than one table in a single SQL statement?