If you are given with a query, how you tune it?
Does runstats do a sort?
Explain the steps of Server Installation?
Explain the steps of Disaster Recovery?
What is Increamental /Delta Back up ?
What are the db cfg parms which affect the back up strategy?
Have you worked in partitioned DB ?
How to check no of active conncetions to the DB >> db2 list active databases
The Application team contacts saying DB response is very low what would you do ?
What is a Global Declared Temporary table ? How to use it ?
What is runstats ? how it improves performance ?
What is HADR ? How to load data to a HADR Server ?
SMS table space is full, filesystem is also full , Cannot add SAN what would you do ?
Have you worked in Partitioned DB ?
What are the tables spaces that get created when a DB is initially created,?
What is the use of SYSCAT SPACE ?
What is the use of buffer pools ?
What is buffer pool hit ratio ?
How would you see the buffer pool usage?
How do you find out deadlock transaction ?
What is Reorg check?
Whats are the different Back up types ?
Do you write shell scripts ?
Other than space utilization what is the difference between DMS and SMS ?
How do you find containers that are in error with out looking into diaglog ?
What DB parameter must be set to allow to take incremental back up ?
Showing posts with label DB2 Tutorials. Show all posts
Showing posts with label DB2 Tutorials. Show all posts
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Question:
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).
I'm sorry but the answer is a firm It depends. Depending on various factors most MVS boxes run short on either CPU or I/O. These factors include workload time of day day of the week etc. A capacity planner could give you a better list but these are the things I've seen in the past.For example daytime is usually devoted to getting info into and out of the system using CICS. This usually involves many many short inquiries or updates. Generally in this case the CPU is most important as the many levels of caching can handle these requests.However once users go home the main use switches doing updates to handling those updates. A single update I/O during the day can drive many thousands of I/O's to process that update. As batch processes work with whole filesets cache hit rates go down and I/O becomes more important.If you could provide more specifics perhaps we could come up with a better answer.
Subscribe to:
Posts (Atom)