Erika Von Bargen May 2012 What s new in

Agenda § OAT Intro § What’s New? – Install as part of CSDK • New Linux 64 -bit port – Tech Support – Tracking the full command – Memory Manager – Performance History Improvements – Backup – Connection Manager – Time. Series Plug-in – Health Advisor Plug-in May 2012 What’s new in OAT? © 2012 IBM Corporation

OAT Introduction § Open. Admin Tool (OAT) is a web-based console for monitoring and administrating one or more Informix database servers. § Why use OAT? – Graphical user interface – Visual representational of Informix database server information – Remote administration – Administration of multiple instances easily – Requires no changes on the database server – Up-to-date with the newest Informix database server features – Easy to use – Easy to install (comes with CSDK) – Lowers the learning curve for new users – Free – Open Source – Customizable with plug-ins – Interface available in multiple languages May 2012 What’s new in OAT? © 2012 IBM Corporation

Automated Installation § Install OAT as part of CSDK 3. 70 – Open. Admin Tool (OAT) is no longer a separate download. It is now included in the Informix Client SDK installer and Informix bundle installer. – Choose ‘custom’ installation and choose OAT and its plug-ins from the feature tree – Available on: • Linux 32/64 • Windows 32 • Mac. OS 64 § New native 64 -bit port for Linux May 2012 What’s new in OAT? © 2012 IBM Corporation

Tech Support § OAT is now an IBM supported product – Included in CSDK 3. 70 support § Can now call IBM Tech Support for help with OAT § Continued support through IIUG forum: – http: //www. iiug. org/forums/oat/ May 2012 What’s new in OAT? © 2012 IBM Corporation

Tracking the full SQL Admin API command § Menu: Logs > Admin Command § Previously only the high level command executed was tracked. Now, starting with 11. 70. x. C 2, OAT tracks the entire command including arguments. Before: After: May 2012 What’s new in OAT? © 2012 IBM Corporation

Memory Manager § Menu: Server Administration > Memory Manager § View database server and

Performance History § Menu: Performance Analysis > Performance History § Graph performance metrics over time § Recent improvements: – Two new categories of statistics • Memory • Virtual processor – Ability to compare • Multiple database servers • Multiple metrics May 2012 What’s new in OAT? © 2012 IBM Corporation

Performance History § Compare statistics on the same server May 2012 What’s new in

Performance History § Compare statistics across servers May 2012 What’s new in OAT? ©

Ontape Backups § Configure and run both manual and automatic backups § Currently ontape

Ontape Backups § Backup configuration screen May 2012 What’s new in OAT? © 2012

Connection Manager § Part of the Replication Plug-in § Menu: Replication > Connection Manager § Connection Manager page recently redone and centralized in OAT § Use the Connection Manager to – monitor and maintain client connections – direct client connection requests to the appropriate server in a connection unit – load and workload balancing among database servers – manage failover on high-availability clusters § Manage 4 types of connection units – Cluster – Replicate set – Grid – Server set May 2012 What’s new in OAT? © 2012 IBM Corporation

Connection Manager May 2012 What’s new in OAT? © 2012 IBM Corporation

Time. Series Plug-in § Menu: SQL Tool. Box > Time. Series § View and manage Time. Series objects in OAT – Containers, Calendars, Virtual Tables § Similar to Schema Manager, but specific to Time. Series tables and objects May 2012 What’s new in OAT? © 2012 IBM Corporation

Health Advisor Plug-in § Menu: Health Center > Health Advisor § Analyzes the state of the Informix database server § Gathers information about the database server, the databases, and the operating system, and creates a report that contains the results and recommendations. § Approximately 50 different items in 5 different categories are checked – Each alarm can be enabled/disabled – Some have thresholds that can be defined – Some have exceptions that can be defined § Execute the Health Advisor reports manually or automatically on a schedule § Reports can be emailed automatically § Create custom profiles allow the alerts to be tailed to a specific environment May 2012 What’s new in OAT? © 2012 IBM Corporation

Health Advisor Plug-in § Manage alarms May 2012 What’s new in OAT? © 2012

Health Advisor Plug-in § Setup schedule and email May 2012 What’s new in OAT?

Health Advisor Plug-in § Health Advisor Report May 2012 What’s new in OAT? ©

Resources § OAT website: http: //www. openadmintool. org/ – Find download links, release information, demos, and more § OAT in the IBM Informix Info Center: http: //publib. boulder. ibm. com/infocenter/idshelp/v 117/topic/com. ibm. oat. doc/ids_oat. htm § OAT IIUG forum: http: //www. iiug. org/forums/oat/ § OAT You. Tube channel (demos): https: //www. youtube. com/user/Open. Admin. Tool. Channel § Developer. Works article on building plug-ins for OAT: https: //www. ibm. com/developerworks/data/library/techarticle/dm-0808 vonbargen/ § Contact me (Erika Von Bargen) at vonbarg@us. ibm. com May 2012 What’s new in OAT? © 2012 IBM Corporation