Hi
Environment: DB2 on IBM Mainframe
Need advice of DB2 Gurus / performance Tuning experts
In my Job Transition from Oracle Database to DB2 Database some Queries
please:-
- Can SQL Query Tuning in DB2 have a significant performance
impact on CPU Utilization like Oracle?
- Do init.ora parameters tuning in DB2 have a significant
performance on waits/CPU Utilization impact like Oracle?
- Does partitioning have a significant performance impact on CPU
Utilization in DB2 Database like Oracle?
- Does DB2 have a concept of "waits" like Oracle? If so, what is
the Statspack equivalent report in DB2?
- Does keeping Heavy/Large Object in its corresponding Unique
Tablespace have a significant impact on DB2 waits like Oracle waits?
- Does O.S./Kernel parameter tuning on "IBM Mainframe" O.S. have
a significant performance impact like "Unix" O.S.?
- Does a List similar to "oracle-l_at_freelists.org" exist for DB2
- DBA / Coding?
- Any miscellaneous performance pointers for general
improvement?
- Any Good Docs, pointers, sites, Books on the above subjects?
Thanks
- CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 20 2006 - 08:13:13 CDT