Transcript IBM blue-and-white template

®
IBM Software Group
OpenAdmin Tool for IDS
What’s New?
KC IIUG Tech Day – January 22, 2009
Erika Von Bargen
[email protected]
IBM Software Group | IBM Informix Information Management Software
Agenda
 What is OpenAdmin Tool for IDS?
 Overview of OAT Features
 What’s New?
 OAT on MacOS
 Newly Enhanced SQL Explorer
 Plug-in Manager
 Enterprise Replication
 What’s Coming Next?
 How to get OAT
IBM Software Group | IBM Informix Information Management Software
What is OpenAdmin Tool for IDS?




OAT is a web-based administration tool for
the IBM Informix Database Server V11,
V11.5, and moving forward
OAT is open source
A single OAT installation can administer
one or more data servers
No additional software is needed on the
data server
Web Server
OAT
IDS
Servers
IBM Software Group | IBM Informix Information Management Software
Web Server
The OAT Stack

Components which are required
to run OpenAdmin Tool for IDS

100% Free

Two install options
 Automated Installer which
includes all the components
(available on Windows, Linux,
MacOS)
 Manual Install in which you
install/configure the individual
pieces to suit your own
environment
OAT
OpenAdmin Tool
Informix Connect
(or Client SDK)
PDO
Informix
sqlite
PDO
PHP 5
Web Server
IBM Software Group | IBM Informix Information Management Software
OAT Data Server Interaction

OAT accesses the data server using only standard SQL
statements
 Uses the existing sysmaster database to retrieve performance and
monitoring data
 Utilizes the SQL Admin API to make configuration changes to the data
server
SQL Statement
Returned Data
IBM Software Group | IBM Informix Information Management Software
Overview of OAT Features
Google Map view of
IDS servers,
Health Center,
DBSpace Explorer, …
IBM Software Group | IBM Informix Information Management Software
Overview of OAT Features
… Query Drill Down, System Reports,
Session Explorer, SQL Toolbox…
IBM Software Group | IBM Informix Information Management Software
Overview of OAT Features
… MACH Explorer,
Automated Update
Statistics, Performance
History Graphs …
IBM Software Group | IBM Informix Information Management Software
Recent Improvements in OpenAdmin

Auto Update Statistics

Dynamic Reconfiguration

Memory Statistics

Redesigned UI

New and Improved SQL Explorer

Onconfig analyzer and recommendation

Simple Automated installer

Historical Data Graphs

MACH 11 connection manager wizard

Task Scheduler improvements

MACH 11 start/stop server

Virtual Processor Administration

ER Monitoring Support

ER Admin Support

Privileges Manager

Plug-in Manager

Integrity Checks

Read only access

Env variable support

Improved documentation and FAQ
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
OAT on MacOS
 IDS now available on MacOS
 Automated installer for OAT now available for
MacOS
 Demo of IDS & OAT on MacOS
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Enhanced SQL
Explorer
 Redesigned SQL Explorer in OAT version 2.23
 With New Features:
 Search strings and filters on SQL Trace info
 Set tracing at either global (entire server) or user (specific
databases and user sessions) level
 Suspend and resume SQL tracing
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Enhanced SQL Explorer
 Same popular Query Drill Down functionality…
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Enhanced SQL Explorer
 with added search fields & filters
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Enhanced SQL Explorer
 And more granularity in SQL Trace settings
Set tracing:
ON, OFF,
or SUSPENDED
Set
Global
or User
level
tracing
Set databases
to trace
Set users
to trace
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Plug-in Manager
 Plug-in Manager introduced in OAT verison 2.21 (last June)
 Allows you to install, enable, and disable plug-ins in OAT
 More importantly, it provides a platform to
develop custom modules for OAT
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Plug-in Manager
 Located in the Admin section of OAT
 Install, Upgrade, Enable, or Disable Plug-ins
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Plug-in Manager
 What are the benefits?
Standard interface for developers to build
custom modules for OAT
Standard interface for developers to share their
plug-ins with other OAT users
Plug-ins preserved during upgrades of OAT
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Plug-in Manager
 Building Plug-ins
 Create your new functionality in separate source files
 Create a plugin.xml file
•
Tells OAT abut the
plug-in
• Tells OAT what menu
links to create
 Bundle the plug-in as a
zip file
 DeveloperWorks article on building OAT plugins
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
Enterprise
Replication Plug-in
 Monitor your ER domain through OAT
 ‘World view’ topology with alerts
 Drill down for node details
• capture, send queue, apply, network, disk, configuration,
errors, ATS/RIS info
 Replicate Explorer
 Easy-to-use, graphical interface for ER
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
ER Plug-in
 Set thresholds to monitor your domain
 OAT will alert you if any of your nodes exceed the thresholds
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
ER Plug-in
Monitor your ER Domain Graphically
 OAT uses ‘cdr view profile’ to monitor all nodes in the domain
 And alert you if thresholds have been exceeded
Click on any
node to view
summary stats
Graphical view
of ER topology
Alerts when
server exceeds
threshold
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
ER Plug-in
Drill Down from topology world view to get node details
 capture, send queue, apply, network, disk, configuration, errors, ATS/RIS info
IBM Software Group | IBM Informix Information Management Software
What’s New in OAT?
ER Plug-in
Replicate Explorer:
 Monitor Replicates and Replicate Sets
IBM Software Group | IBM Informix Information Management Software
What’s Coming Next in OAT?
Coming with 11.50.xC4:
 ER Administration
 Setup and administer ER graphically in OAT
•
•
•
•
Define ER servers
Define replicates and replicate sets
Start/stop/suspend/resume replicates and replicate
sets
Check replicates and replicate sets
IBM Software Group | IBM Informix Information Management Software
What’s Coming Next in OAT?
Coming with 11.50.xC4:
 Compression
 OAT will provide
a graphical
interface to use
this new IDS
11.50xC4 feature
IBM Software Group | IBM Informix Information Management Software
What’s Coming Next in OAT?
Coming with 11.50.xC4:
 More enhancements to SQL Explorer:
 Ability to save SQL Trace history
 And use SQL Explorer to view historical trace data
 Ability to apply External Directive for query optimization
 Sign-up for 11.50xC4 beta program to try all of
these features (plus IDS’s new features) early!
 Contact Madhuri Ahuja: [email protected]
IBM Software Group | IBM Informix Information Management Software
How to get OAT
 The latest release of OAT is available at:
 IBM’s Informix Free Product Download page
 https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=e
n_US&source=swg-informixfpd
 OAT Information at www.openadmintool.org
 Demos, screenshots, feature information, etc.
 Support through the OAT forum on IIUG website
 www.iiug.org/forums/oat
IBM Software Group | IBM Informix Information Management Software
Questions?
Thank you!!
Download OAT or visit
www.openadmintool.org today!