OpenAdmin Tool for Informix (OAT) October 2012

(1)

OpenAdmin Tool for Informix (OAT)

(2)

What is OpenAdmin Tool for Informix?

OAT is a web-based administration tool for the IBM Informix database server

A single OAT installation can administer one or more database servers

No additional software is needed on the database server

The latest release of OAT works with all Informix server versions V11 and higher

Web Server

OAT

Informix

Servers

11.70 11.50 11.70 11.10

(3)

What are the benefits of OAT?

Free GUI tool for monitoring and administering Informix Lowers the learning curve for Informix

Visual representational of Informix data

Makes administration of multiple instances easy Requires no changes to the database server Open Source

Customizable with plug-ins

First tool to support new Informix database server features Included as part of the Informix Client SDK

(4)

The OAT Stack

Web Server

PDO

PHP

sqlite

Informix

PDO

Informix Connect or Client SDK

OpenAdmin Tool

Web Server OAT

Components which are required to run OpenAdmin Tool for Informix

100% Free

Installation options

Install as part of Informix Client SDK - Automated installation and setup that includes all

components needed to run OAT (Apache, PHP, etc.)

Or just download the OAT zip file and install into your own web server and PHP installation.

(5)

How OAT Works

OAT is unique in that it accesses the database server using only SQL

OAT utilizes three key aspects of the Informix database server

1.

1. System catalog tables in the sysmaster database to retrieve performance and System catalog tables

monitoring data

2.

2. SQL Admin API to make configuration changes to the data serverSQL Admin API 3.

3. Database Scheduler in theDatabase Scheduler sysadminsysadmindatabase to run tasks and gather data database

through sensors

SQL Statement

(6)

Current OAT Features

Graphically monitor, analyze, and administer your Informix database server instances

SQL Explorer Performance History Health Center Space Administration Configuration Task Scheduler Session Explorer System Reports Schema Manager Automated Update Statistics Clusters Enterprise Replication Informix Flexible Grid Plug-in Manager And more…

(7)

SQL Explorer

(8)

Performance History Graphs

Graph performance metrics over time

(9)

Storage Management

Monitor space usage

(10)

Space Optimization

Compress, repack, shrink, defragment tables

Setup schedule to have the database server automatically compress, repack, shrink, and defragment tables based on policies

(11)

Configuration Management

(12)

Automated Update Statistics (AUS)

Simplify statistics maintenance

Automate the collection of statistical and

(13)

System Reports

Example

:

Waiting Session Report Shows sessions waiting on locked tables/rows, buffers, and logical logs

Drill down for

detailed session and lock information

(14)

Backups

(15)

Clusters

Monitor, manage, and administer Informix clusters, including dynamically adding SDS secondaries

(16)

OAT Plug-ins

Plug-ins provide the ability to seamlessly add custom functionality to OAT

Currently IBM releases 4 plug-ins included with OAT – Replication

• Graphical interface for setting up, monitoring, and administering Enterprise Replication, Grid, and the Connection Manager

– Schema Manager

• Manage your database schema – TimeSeries

• Manage Informix TimeSeries data and objects – Health Advisor

• Analyze the state of your Informix database server. • Schedule health checks to run at regular intervals a

(17)

Replication Plug-in

Monitor your Replication Domain Graphically

(18)

Replication Plug-in

Drill Down details about each server

(19)

Replication Plug-in

Informix Flexible Grid

(20)

Replication Plug-in

Informix Flexible Grid

Easy setup and administration using wizards

(21)

Replication Plug-in

Informix Flexible Grid

Monitor the status of grid commands. Rerun failures.

(22)

Schema Manager Plug-in

(23)

Health Advisor Plug-in

(24)

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_o at.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: