Job Transition from Oracle to DB2 ? ... Comparisons & Advice please
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jun 2006 18:43:13 +0530
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@xxxxxxxxxxxxx" 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***
Other related posts:
