1 / 20

What’s new in OpenAdmin Tool for Informix?

Erika Von Bargen May 2012. What’s new in OpenAdmin Tool for Informix?. 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 TimeSeries Plug-in

more
Download Presentation

What’s new in OpenAdmin Tool for Informix?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Erika Von Bargen May 2012 What’s new in OpenAdmin Tool for Informix?

  2. 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 • TimeSeries Plug-in • Health Advisor Plug-in What’s new in OAT?

  3. OAT Introduction • OpenAdmin 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 What’s new in OAT?

  4. Automated Installation • Install OAT as part of CSDK 3.70 • OpenAdmin 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 • MacOS 64 • New native 64-bit port for Linux What’s new in OAT?

  5. 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/ What’s new in OAT?

  6. 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.xC2, OAT tracks the entire command including arguments. Before: After: What’s new in OAT?

  7. Memory Manager • Menu: Server Administration > Memory Manager • View database server and OS memory usage • Configure automatic low memory management What’s new in OAT?

  8. 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 What’s new in OAT?

  9. Performance History • Compare statistics on the same server What’s new in OAT?

  10. Performance History • Compare statistics across servers What’s new in OAT?

  11. Ontape Backups • Configure and run both manual and automatic backups • Currently only ontape backups are supported in OAT What’s new in OAT?

  12. Ontape Backups • Backup configuration screen What’s new in OAT?

  13. 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 What’s new in OAT?

  14. Connection Manager What’s new in OAT?

  15. TimeSeries Plug-in • Menu: SQL ToolBox > TimeSeries • View and manage TimeSeries objects in OAT • Containers, Calendars, Virtual Tables • Similar to Schema Manager, but specific to TimeSeries tables and objects What’s new in OAT?

  16. 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 What’s new in OAT?

  17. Health Advisor Plug-in • Manage alarms What’s new in OAT?

  18. Health Advisor Plug-in • Setup schedule and email What’s new in OAT?

  19. Health Advisor Plug-in • Health Advisor Report What’s new in OAT?

  20. 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/v117/topic/com.ibm.oat.doc/ids_oat.htm • OAT IIUG forum: http://www.iiug.org/forums/oat/ • OAT YouTube channel (demos): https://www.youtube.com/user/OpenAdminToolChannel • DeveloperWorks article on building plug-ins for OAT: https://www.ibm.com/developerworks/data/library/techarticle/dm-0808vonbargen/ • Contact me (Erika Von Bargen) at vonbarg@us.ibm.com What’s new in OAT?

More Related