How are write I/Os from the buffer pool executed?
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 |
Define declaration generator (dclgen).
why we go for SPUFI for creating tables or for sql queries?
What is the STOSPACE Utility used for?
How to check table size in db2 sap?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is null indicator in db2?
What is sqlcode -922 ?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What techniques will be used to avoid deadlock??
How can you split a table in to exactly half?
Name the different types of Table spaces.
wht are the restrictions for union ?