What`s new in OpenAdmin Tool for Informix?
Download
Report
Transcript What`s new in OpenAdmin Tool for Informix?
Erika Von Bargen
May 2012
What’s new in OpenAdmin Tool for
Informix?
© 2012 IBM Corporation
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
May 2012
What’s new in OAT?
© 2012 IBM Corporation
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
May 2012
What’s new in OAT?
© 2012 IBM Corporation
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
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.xC2, 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 OS memory usage
Configure automatic low memory management
May 2012
What’s new in OAT?
© 2012 IBM Corporation
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 OAT?
© 2012 IBM Corporation
Performance History
Compare statistics across servers
May 2012
What’s new in OAT?
© 2012 IBM Corporation
Ontape Backups
Configure and run both manual and automatic backups
Currently only ontape backups are supported in OAT
May 2012
What’s new in OAT?
© 2012 IBM Corporation
Ontape Backups
Backup configuration screen
May 2012
What’s new in OAT?
© 2012 IBM Corporation
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
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
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 IBM Corporation
Health Advisor Plug-in
Setup schedule and email
May 2012
What’s new in OAT?
© 2012 IBM Corporation
Health Advisor Plug-in
Health Advisor Report
May 2012
What’s new in OAT?
© 2012 IBM Corporation
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 [email protected]
May 2012
What’s new in OAT?
© 2012 IBM Corporation