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?.
Both online and offline are there, online reorg allows other transaction to access the tables. What is the error code – ? What is a Cartesian product? Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state? What do you need to restore DB2 to a point in time? Interviea you create an indexit will sort the corresponding column.
If db2start is taking a long time, what should you do?
What is a DB2 access path? What are the levels of isolation available with DB2V4? What are column-name qualifier used?
Top 50 DB2 Interview Questions & Answers
Which transaction use a command thread? What is meant by repeatable read? Can I view dynamic SQL that has been run in the database in the past? Based on a work at www. Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. OS kernel configuration; E.
Nope ;-0 first level IBM Team only does it!! Usually, which is more important for DB2 system performance Is there any advantage to denormalizing DB2 tables? How does DB2 determine what lock-size to use? When can an insert of a new primary key value threaten referential integrity? Logging What are the kinds of logging? How would one remove old reorg information from the DB2 catalog? Vertical portioned tables Whats snow flow schema??
More than one DB2 application process can access the same data at the same time, is known as concurrency. What is a correlated sub query? What is the difference between join and union? The physical database is managed by the DB2 component called Data manager.
Will the lock be released after I am done with that page? What is the name of the default DB2 catalog database?
Dva is a module that consists of SQL source statements that get extracted out of the application program.