Author Topic: Tuning - Migration to Oracle  (Read 32 times)

jsquizz

  • Global Moderator
  • Sr. Member
  • *****
  • Posts: 417
    • View Profile
Tuning - Migration to Oracle
« on: January 08, 2021, 10:32:01 AM »
We are currently using CMOD 9.5/DB2 11. Our new system we just stood up is CMOD 10.5/Oracle 19C.


1) We are curious about tuning the database, one of the key things we are looking for is SGA size for the database. Are there any other tuning considerations we need to take into account?

2) We are also looking for information regarding - db reorg/runstats. I believe currently we do all of this through arsdb/arsmaint commands. Is that supported with oracle? Is there a specific way to do it.
#AIX #CMOD #DB2 #TSM #XENOS #AFP2PDF #MIGRATION #TROUBLESHOOT

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 1964
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Tuning - Migration to Oracle
« Reply #1 on: January 08, 2021, 11:21:48 AM »
Presumably you made the move to Oracle because you have better internal support for it...  So...  the ultimate authority are the local DBAs.  :)

Otherwise, I don't think there's much that needs tuning outside making sure your database indexes are good.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR