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 |
Which catalog table stores referential constraints?
what are stage one indexable predicates?
How do I start db2 in windows?
Mention data types used in db2 ?
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 declare cursor?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
can all users have the privilage to use the sql statement select * (dml)?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is an alias and how does it differ from a synonym?
What is cursor in dbms?
Can I use LOCK TABLE on a view?