What is the purpose of the QUIESE Utility?
Answer / s
QUIESE establishes a consistency point for a tablespace by
writing all pending updates to DASD and writing the log RBA
to SYSIBM.SYCOPY
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a Database Request Module(DBRM)?
How do we specify index to include or not during bind process.
pls tell me abt the normalization five types....
Is db2 a programming language?
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 are union and union all?
What do you mean by between and in? Is between inclusive of specified range values?
Why might full image copies be faster to implement than an incremental image copy?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is bind in db2?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
how do u update the faltfile into db2 table ?