Usually, which is more important for DB2 system performance

Usually, which is more important for DB2 system
performance - CPU processing or I/O access?

Question Posted / guest

Usually, which is more important for DB2 system performance - CPU processing or I/O access?..

I/O is expensive as most the the CPU time is wasted doing
I/O's

Is This Answer Correct ?

2 Yes

1 No

More DB2 Interview Questions

How Plan is created while executing the query using SPUFI?

What is table space in db2?

What is the syntax required for the creation of a cursor?

What is PRIME TABLE and what are the uses of it

What is catalog database in db2?

Write a query to retrive partial string.

Define predicate?

How to find primary key of a table in db2?

Name the different types of Table spaces.

What is tablespace?

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

What are the isolation levels possible ?

For more DB2 Interview Questions Click Here