Interested to Buy Any Domain ? << Click Here >> for more details...
How are write I/Os from the buffer pool executed?
- 1 Answers
- 4222 Views
- I also Faced
- E-Mail Answers
Answer / s
Writes are queued until a commit, checkpoint happens. Also
when write thresholds are exceeded, stop database, stop db2.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a page?
How many clustering indexes can be defined for a table?
What is the maximum length of sqlca?
Mention and explain the contention situations caused by locks?
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).
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is the error code -803 ?
What is a Database Request Module(DBRM)?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is an alias?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
COBOL 
