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


Please Help Members By Posting Answers For Below Questions

Define check constraint.

639


Mention the various locks that are available in db2.

612


Is db2 relational database?

567


Explain the contents that are a part of dclgen.

651


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

696






What is role in db2?

612


what are bind concepts in db2 cobol?

643


What is query_cache_limit?

541


What is declare cursor?

608


How can deadlocks be resolved?

534


What is the use of value function?

619


What is the difference between bind and rebind in db2?

846


Define sqlca.

645


What is an instance database?

595


What is bind plan?

604