IBM Software Group Open Admin Tool for

® IBM Software Group Open. Admin Tool for IDS What’s New? KC IIUG Tech Day – January 22, 2009 Erika Von Bargen vonbarg@us. ibm. com

IBM Software Group | IBM Informix Information Management Software Agenda § What is Open. Admin Tool for IDS? § Overview of OAT Features § What’s New? 4 OAT on Mac. OS 4 Newly Enhanced SQL Explorer 4 Plug-in Manager 4 Enterprise Replication § What’s Coming Next? § How to get OAT

IBM Software Group | IBM Informix Information Management Software What is Open. Admin Tool for IDS? § § OAT is a web-based administration tool for the IBM Informix Database Server V 11, V 11. 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 Open. Admin Tool for IDS § 100% Free § OAT Two install options 4 Automated Installer which includes all the components (available on Windows, Linux, Mac. OS) 4 Manual Install in which you install/configure the individual pieces to suit your own environment Open. Admin 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 4 Uses the existing sysmaster database to retrieve performance and monitoring data 4 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 Open. Admin § Auto Update Statistics § Dynamic Reconfiguration § Memory Statistics § Redesigned UI § New and Improved SQL Explorer § Simple Automated installer § Onconfig analyzer and recommendation § 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 § Plug-in Manager § Privileges 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 Mac. OS § IDS now available on Mac. OS § Automated installer for OAT now available for Mac. OS § Demo of IDS & OAT on Mac. OS

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: 4 Search strings and filters on SQL Trace info 4 Set tracing at either global (entire server) or user (specific databases and user sessions) level 4 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? 4 Standard interface for developers to build custom modules for OAT 4 Standard interface for developers to share their plug-ins with other OAT users 4 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 4 Create your new functionality in separate source files 4 Create a plugin. xml file • Tells OAT abut the plug-in • Tells OAT what menu links to create 4 Bundle the plug-in as a zip file § Developer. Works 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 4 ‘World view’ topology with alerts 4 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. x. C 4: § ER Administration 4 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. x. C 4: § Compression 4 OAT will provide a graphical interface to use this new IDS 11. 50 x. C 4 feature

IBM Software Group | IBM Informix Information Management Software What’s Coming Next in OAT? Coming with 11. 50. x. C 4: § More enhancements to SQL Explorer: 4 Ability to save SQL Trace history 4 And use SQL Explorer to view historical trace data 4 Ability to apply External Directive for query optimization § Sign-up for 11. 50 x. C 4 beta program to try all of these features (plus IDS’s new features) early! 4 Contact Madhuri Ahuja: ahujam@us. ibm. com

IBM Software Group | IBM Informix Information Management Software How to get OAT § The latest release of OAT is available at: 4 IBM’s Informix Free Product Download page 4 https: //www 14. software. ibm. com/webapp/iwm/web/pre. Login. do? lang=e n_US&source=swg-informixfpd § OAT Information at www. openadmintool. org 4 Demos, screenshots, feature information, etc. § Support through the OAT forum on IIUG website 4 www. iiug. org/forums/oat

IBM Software Group | IBM Informix Information Management Software Questions? Thank you!! Download OAT or visit www. openadmintool. org today!