What is a buffer in memory?
What is a view? Why use it?
what is the process of precompiler?
How to execute stored procedure in db2 command editor?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Name the different types of Table spaces.
How can you compare table column after update and before update?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
Describe major components of db2?
What is ibm db2 database?
Once you create a view, where would information about the view be stored?
What is meant by isolation level?
How to define the data items to receive the fetch items for the SQL?