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

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

Question Posted / s

1 Answers
4196 Views
I also Faced
E-Mail Answers

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

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11618

can we view the access paths created by dbrm ? how ? thx

6979

Explain packages.

1055

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1034

What is the meaning concurrency in the db2 database?

1061

Explain in detail about buffer manager and its functionalities?

996

Are view updateable?

984

What is check constraint. Explain with example.

1047

What is runstats utility in db2?

963

Define db2.

1067

What is meant by explain?

1063

What is the usage of open cursor command?

1040

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 ?...

4215

How to find the number of rows in a db2 table?

1065

How do I add a column to a table in db2?

1051