Usually, which is more important for DB2 system performance - CPU processing or I/O access?
I/O operations are usually most critical for DB2 performance (or any other database for that matter).
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the difference between view and materialized view ? 22.09.08
Normal Views are for Access purpose ie One need to give access the end user to specific data. Materialized Views are to optimize the performance . WHen mater...What is Control Interval, Control Area ? 12.08.08
Control Interval is analogous to a physical block for QSAM files. It is the unit of I/O. Must be between 512 bytes to 32 k. Usually either 2K or 4K. A larger c...Describe Database Connection pooling relative to MTS ? 16.04.07
This allows MTS to reuse database connections. Database connections are put to ?sleep? as opposed to being created and destroyed and are activated upon request....What are the events we use in dialog programming and explain them? 26.03.07
There are two events in Dialog Programming i.e. screen: 1. PBO (Process Before Output) – Before the screen is displayed, the PBO event is processed. 2. PAI...What is performance testing? 12.07.06
Performance testing verifies loads, volumes and response times, as defined by requirements. Although performance testing is a part of system testing, it can be...DBMS V/s File Processing System 30.06.06
DBMS Ø Redundancy is controlled. Ø Unauthorised access is restricted. Ø Providing multiple user interfaces. Ø Enforcing integrity constraints. Ø Provi...What is ITS? What are the merits of ITS? 12.03.06
ITS is a Internet Transaction Server. ITS forms an interface between HTTP server and R/3 system, which converts screen provided data by the R/3 system into HTML...What is enterprise information system resource 11.03.06
An entity that provides enterprise information system-specific functionality to its clients. Examples are a record or set of records in a database system, a bus...What is System R? What are its two major subsystems? 08.03.06
System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is po...Disadvantage in File Processing System? 08.03.06
Data redundancy & inconsistency. Difficult in accessing data. Data isolation. Data integrity. Concurrent access is not possible. Security Problem...