I am using it on AIX not mainframe but a good resource is
http://www.idugdb2-l.org/archives/db2-l.html
and
http://www.redbooks.ibm.com - very good resource
Also IBMs own website is good for FAQs etc.
Hope this helps
Regards
Lee
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA
Sent: 20 June 2006 14:13
To: oracle-l_at_freelists.org
Subject: 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***
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 20 2006 - 08:40:15 CDT