Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
Answer / s
I/O is expensive as most the the CPU time is wasted doing
I/O's
| Is This Answer Correct ? | 2 Yes | 1 No |
List out the buffer pools in db2
What are leaf pages?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What do you mean by NOT NULL? When will you use it?
Are views updateable?
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. TIA
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
Define sqlca.
Can any one tell me about Restart logic in DB2.
Give the name of some fields form sqlca.
What is the difference between cursor stability and repeatable read isolation levels?
What is an asychronous write?