Job Transition from Oracle to DB2 ? ... Comparisons & Advice please

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