Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
Answer Posted / 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 |
Post New Answer View All Answers
Define db2.
Explain in detail about buffer manager and its functionalities?
What is buffer pool in the db2 database?
What is host variable?
Define check constraint.
List out the buffer pools in db2
Why select is not preferred in embedded sql programs?
What is null in db2?
Which isolation level provides maximum concurrency?
What is difference between isnull and coalesce?
What is the maximum No of rows per page?
What is bind plan?
What types of tables are there in the db2 database?
What is a dbrm in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...