IBM Software Group Information Management Informix Integration with

IBM Software Group / Information Management Informix Integration with Web. Sphere and Tivoli Jeanette Horan, Vice President World Wide Data Management Development, General Manager Silicon Valley Lab Gary Proctor, Sr. Development Manager - IDS "Chat With The Labs" © 2004 IBM Corporation

IBM Software Group / Information Management Presentation Overview § Informix – Key New Messages § On Demand Business Vision § Informix and Web. Sphere § Informix and Tivoli § Upgrading from SE or Online 5 to IDS 9. 4 § Summary 2 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Message to Informix Clients and Partners Your existing Informix database investments will be protected and you will be able to take advantage of evolving technology § IBM continues to enhance and support Informix Dynamic Server 9. x. There are no end of life plans for IDS 9. x. 7. 31 EOS will be extended for 5 addition years past April 2006. § IDS is IBM’s strategic database for enterprise level embedded solutions § IBM will ensure the ability to leverage your existing investment through integrated, cost effective and competitively based offerings with other IBM Software Group products § Existing 4 GL skills can be leveraged in a modern application development environment by using EGL and Web. Sphere Studio going forward § For current Informix customers who are considering a move, move only when the result is better for you and consider DB 2 for overall value advantage. 3 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Product Satisfaction Is High § The majority of Informix clients and partners are satisfied with the capabilities of the product. – Source: end 2003 Summary of worldwide market research done periodically by IBM since IBM acquisition in 2001, 644 respondents in total. § Informix Products have benefited from IBM’s development process, quality standards and technology sharing Strong Performance Tailored to Size Stable Fast 4 "Chat With The Labs" High Volume Capacity Easy to Use 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Defining the next computing era “An enterprise whose business processes -- integrated end-to-end across the company and with key partners, suppliers and customers – can respond with speed to any customer demand, market opportunity or external threat” — Sam Palmisano, IBM Chairman and CEO 5 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IBM Web. Sphere Software Platform Web. Sphere Portal A single point of personalized interaction with applications, content, processes and people Web. Sphere Commerce Powerful sell- and buy-side solutions to handle the challenges encountered in customer and trading partner environments Web. Sphere Everyplace Software for extending ebusiness applications to mobile devices Web. Sphere Voice Software for enabling natural voice interactions with applications and data Web. Sphere Studio An open comprehensive development environment for building dynamic e-business applications 6 "Chat With The Labs" Optimize Operations Web. Sphere Business Integration Software that delivers end-to-end integration through five proven capabilities: model, integrate, Web. Sphere MQ connect, monitor and manage Software to connect internal and external applications to exchange information reliably and securely Web. Sphere Application Server Web. Sphere Host Integration A high-performance and extremely scalable transaction engine for dynamic e-business applications Software to leverage and extend legacy assets for new e-business solutions 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IBM Web. Sphere Application Server Family A high-performance and extremely scalable transaction engine for dynamic e-business applications A J 2 EE certified A next generation application server that simplifies build-to-integrate tasks, accelerates application development and enables real-time adaptable capabilities configuration optimized to the unique qualities of service provided by z/OS Web. Sphere Application Server Enterprise Web. Sphere The mainstream Web Application services J 2 EE certified application Server for server enabling z/OS industry leading Web. Sphere Application Server qualities of service and flexible deployment options Web. Sphere Application Server - Express An easily approachable “on-ramp” to e-business, providing fast and productive development, deployment of dynamic web applications 7 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Web. Sphere Studio Family Enterprise Developer Application Developer Integration Edition Application Developer Site Developer • Professional Web, Java, XML, and Web services developers • SCM interface to connect to vendor software of your choice • Embedded Web. Sphere Application Server Express • J 2 EE developers • Relational DB tools • CCLT • Embedded Web. Sphere Application Server • Advanced J 2 EE developers • Serviceoriented architecture • Enterprise development organizations • Web services based enterprise modernization • Reuse of enterprise • Flow assets composition (COBOL, Pl/1) • Embedded Web. Sphere Application Server Enterprise Workbench IBM’s commercially supported version of the Eclipse Workbench 8 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Web. Sphere Portal: Example of Collaboration 9 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management MQ Series Scenario. Z/OS MQInformix Database Module HP UX IBM AIX 5. x Informix Dynamic Server MQ Datablade Websphere MQ Q 1… DB 2 on Z/OS Q 2… Direct IDS to MQ interaction MQ-DB 2 database module 10 "Chat With The Labs" App-1 App-2 2/10/2022 © 2003 IBM Corporation

IDS Datablades IBM Software Group / Information Management Informix Dynamic Server SQL Parser Spatial XSLT MQSeries Time. Series NAG WEB 11 "Chat With The Labs" DATABLADE API Geodetic Optimizer Parallel Query Manager Fragment Manager Transaction Services SQL Parser Access Methods Data Access Interface 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IDS and Web. Sphere MQ § MQSeries Transactional Support – Supports the coordination of IDS 7 & 9 servers from MQSeries in an XA environment – MQSeries acts as an XA transaction manager and IDS as an XA resource manager – Limited platform availability: for IDS initially AIX § IBM Informix MQSeries Data. Blade – New MQ API for IDS 9, modelled after an existing DB 2 MQ API – Allows an Informix application to easily interact with an MQ based infrastructure – Additional Virtual Table Interface (VTI) support for simple SQL-/Tablebased access to MQ queues! – Initial version now available via IBM Alphaworks 12 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IDS and Web. Sphere Installations § Install IDS and Java Environment – Include the bin directory of J 2 SE in the PATH environment variable ie: Export CLASSPATH=/home/JDBC/lib/ifxjdbc. jar: /home/JDBC/lib/ifxjdbcx. jar TIP: Set the CLASSPATH environment variable in every user profile that will connect to IDS using JDBC. – Verify that your environment variables are properly set. Ie: INFORMIXSERVER, INFORMIXDIR, ONCONFIG, PATH, CLASSPATH § Install WAS (Web. Sphere App Server) to work with IDS – Install JDBC driver on the development server and separate App Server machine if using three tier architecture – Install Web. Sphere Studio App Server with WORF for IDS, on separate server, if using three tier architecture. Run Setup from temp directory. § Install WSAD (Web. Sphere Studio Application Developer) on Windows Client(s) – Run Setup, opens Installation Launcher window, follow instructions to point to Wep. Sphere app server and IDS RDBMS server. 13 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IDS and Web. Sphere Installations Machine C (Optional) Web. Sphere App Server 14 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management The First IBM Informix Redbook! § Covers all IDS / Web. Sphere Topics § Lots of step-by-step examples (example code downloadable) § Based on Linux and Windows platforms § Available Now! § Download at: http: //www. ibm. com/redbooks § Redbook ID: SG 24 -6948 15 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IBM Informix and Web. Sphere Bundles §Enterprise Bundle - IDS 9. 4 Enterprise Edition Unlimited - Web. Sphere Application 5. 1 - Web. Sphere Studio Application Developer 5. 1 §Enterprise Trade-up - Includes IDS 9. 4 EE Unlimited Trade-up From 7 §Workgroup Bundle - IDS 9. 4 Workgroup Edition - Web. Sphere Application Server Express 5. 1 16 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Informix and Tivoli - What Value Does Tivoli Deliver? § Intelligent Systems Management – Monitor your IT resources – Automate & correlate problems – Optimize Business Systems with IT § Intelligent identity management – Integrate identity management and access control providing single sign-on – Protect IT against security threats – Maintain privacy commitments § Intelligent Storage Management – Optimize storage resources and server consolidation – Automate backup and recovery – Simplify storage capacity planning 17 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Tivoli addresses these IT business areas! Availability Helps ensure the health and appropriate functioning of IT Helps ensure information assets, confidentiality and data integrity are protected Security § 27 -32% savings triage time § 35 -40% reduced admin time § 25 -35% higher first call close rates Optimization Orchestration Helps ensure the most productive utilization of IT § 35 -40% reduced access time Provisioning Makes available right resources to right processes and people § 20 -25% greater utilization § 15 -35% reduced capital outlay § 40 -50% fewer batch restarts § 25 -30% reduced staff req’ts Senses, triggers , responds according to business goals. § Increase resource utilization from 20% avg. to as high as 50% § 30 -40% reduced admin time Virtualization BSM Manage using business priority, manage service levels § 40 -50% savings in SLA reporting § 15 -30% savings on time for root cause determination, downtime Provides a single, consolidated, logical view of and easy access to all available resources in a network § 10 -25% saving in physical consolidation § Increased storage utilization up to 3 X 18 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Informix and Tivoli Architecture Tivoli Mgmt. Solution Business Systems Mgmt. Performance & Availability Configuration & Operations Monitoring Centralized Control Analysis Central Console Reporting Storage Security Storage Management Access Management Service Delivery Storage Area Network Mgmt. Identity Management Web Management Data Protection Pervasive Management. Disaster Recovery Risk Management Auditing Common Infrastructure / Services IDS 19 "Chat With The Labs" Web. Sphere App Server DB 2 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Intelligent Management Software – Why Tivoli? § Ability to move customers from reactive to proactive management Intelligent Management Software § Ability to help customers map IT assets into business processes § Ability to “do more with less” with autonomic and correlation engines Integrated for efficiency Automate d for productivit y § Ability to incorporate “best practices” Optimized for business value § Ability to help customers move to the on demand world “Tivoli’s autonomic approach to systems management goes well beyond integration to the truly intelligent, responsive and proactive capabilities that will enable IBM to actually deliver e-business on demand. ” —Carol Baroudi 20 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Tivoli Partnering with DB 2 / IDS Enabling application and data availability § What is it? – Monitors DB 2 / IDS databases 1. – Automatically backs up IBM DB 2 / IDS databases 2. – Provides historic and trending analytics 3. § Value to customer: 4. – Ensure data available automatically Key Plays IBM Tivoli Storage Manager IBM Storage Manager for Databases IBM Tivoli Access Manager IBM Tivoli Monitoring for Databases – Plan storage capacity to avoid availability issues – Free resources to focus on business critical tasks § Key competitive features: – Shared storage and data repositories help keep data securely backed up and available Tight integration helps keep applications and data available. 21 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IDS and Tivoli Installations § Install IDS and Java Environment – Include the bin directory of J 2 SE in the PATH environment variable ie: Export CLASSPATH=/home/JDBC/lib/ifxjdbc. jar: /home/JDBC/lib/ifxjdbcx. jar TIP: Set the CLASSPATH environment variable in every user profile that will connect to IDS using JDBC. – Verify that your environment variables are properly set. Ie: INFORMIXSERVER, INFORMIXDIR, ONCONFIG, PATH, CLASSPATH § Install Tivoli Monitoring for DBs to work with IDS – Can be installed from Desktop or Command Line – From Desktop -> Install Product (Select correct Product for IDS agent) – Run DMLink. JRE; from Desktop -> Navigator -> DMLink. JRE; specify end points, click Execute § Set up different “administrators” for different DBs and/or different roles (optional) 22 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management IDS SE and ONLINE 5 Migrations to IDS 9. 40 § SE Migrations to IDS 9. 40 – Requires an Unload from SE and a Load of Data into IDS – SPL Migration – Data. Type Differences – SQL Syntax Differences § ONLINE 5 to IDS 9. 40 – Requires an Unload from Online and a Load of Data into IDS – SPL Migration – Data. Type Differences – SQL Syntax Differences 23 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Questions and Answers YOUR TURN! http: //www. ibm. com/software/data/informix Thanks for participating. 24 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Additional Resources Informix Product Page http: //www. ibm. com/informix/ DM Today http: //www. ibm. com/software/data/ db 2 infonews/ IBM Information Management http: //www. ibm. com/software/data/ Product Managers: Jerry Zhu (IDS) Omkar Nimbalkar (Clients, Blades) 1 -913 -599 -7207 jerryzhu@us. ibm. com 1 -605 -926 -1976 omkarn@us. ibm. com Worldwide Database Server Sales Support: 25 Technical Enablement Sales Christine Normile Jacques Roy Scott Pavlot +1 -877 -252 -5399 +1 -303 -932 -7363 cnormile@us. ibm. com jacquesr@us. ibm. com +1 -724 -934 -3022 spavlot@us. ibm. com "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation

IBM Software Group / Information Management Informix and U 2 Integration Days Come learn the latest Informix and U 2 product strategy and how you can leverage your Informix and U 2 investment across IBM Software. Thursday, August 26 – Bethesda, MD 6710 Rockledge Drive, 4 th Floor, B Wing, Room 24 B 235 Tuesday, August 31 – Atlanta, GA 4111 Northside Drive, Ground Floor (3 rd), Room 03 F 23 Continental breakfast served at 8: 30 a. m. Customers 9: 00 a. m. - 1: 00 p. m. , includes Lunch Business Partners 9: 00 a. m. – 3: 00 p. m. Please RSVP by calling 248 -552 -4272 or via e-mail ascsfd@us. ibm. com 26 "Chat With The Labs" 2/10/2022 © 2003 IBM Corporation