What is buffer pool and list some of them?
what are stage one indexable predicates?
What language is db2 written in?
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).
What is a Resource Control Table(RCT)? Describe its characteristics.
What is sqlca?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is table space in db2?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
my project is insurance management system,how to explain my work environment in interview?
Explain the use of the WHERE clause?
how can i pull up a query which was previously stored in qmf
What techniques will be used to avoid deadlock??