Informix: Seeing The Big Picture Informix User Forum 2005 - Atlanta P aul Rivot – Director Information Management Decem

1. Informix: Seeing The Big PictureInformix User Forum 2005 - AtlantaPaul Rivot – Director Information ManagementDecember 8, 2005

2. Agenda • Information as a Service • Positioning and Roadmaps • Informix Highlights • V10 Overview • IBM SWG Interoperability • Call to Action

3. —Information as a Service—

4. Volkswagen “Today, 70% of the time of our people is spent searching information and only 30% by making intelligent decisions. We want to flip the ratio 70/30, by providing 70% of intelligent and analytical time decision making and only 30% of administrative work.”— Dr. Martin Hofmann Exec. Director, Group Supply StrategyVolkswagen AG Result: Procurement productivity increased by 20%

5. Insightful Relationships BusinessContext Data & Content Information as a Service Information as a ServiceMoving From a Project-Based to a Flexible Architecture Tools & Applications Dashboards Insight In-line, Real-time Real Time : e.g., On Line Help, Synchronized Master Data… Extracted: e.g. Basel II, Business Optimization… Standards based: e.g., XQuery, JSR170, JDBC, Web Services... Heterogeneous Applications & Information and more… IBM Content Manager DB2 IDS xyz… Oracle

6. Information Intensive Problem Domains Healthcare Finance Insurance Retail Mfg. Government • Account Opening • Credit Card Risk Mgmt. • Anti-money Laundering • No-touch Claims Processing • New Product Introduction • New Customer Introduction • Vendor Fraud Analysis • RFID • RFID • Integrated Supply Chain • Product & Parts Management • Dealer Collaboration • Early Warning Systems • Police Force Effectiveness • Intelligence Gathering • Anti-Terrorism • Integrated Case Management • Patient Safety • Disease Management • Predictive Medicine • Call Center Relationship Management • Cross Selling…Customer Service…Priority Service • Human Resources • Relationship Analysis…Information Privacy…Skills Discovery Cross Industry • Finance & Accounting • Risk & Compliance…Business Performance Management…ePayments Procurement Information as a Service

7. Expanding the ValueFor Clients and our Business Partners Information as a Service Entity Analytics Master Data Mgmt. Integration Content Data * Source: IBM Analysis of Various Industry Estimates, 2005

8. Information Management - Number One Market Share #1 in Share 450,000+ Clients Information Delivered on Demand Based on Services Oriented Architecture • Data Services • IDS, DB2, IMS, Cloudscape, U2 • Content Services • Content Management Services • Content Integration Services • Information Integration Services • Federation Services • Movement Services • Transformation Services • Quality Services… • Information Accelerators • Master Data Management • Entity Analytics • Data Warehousing • Industry Data Models #1 in Share 13,000+ Clients #1 in Share 5,000+ Clients No Other Vendor Delivers The Breadth and The Depth of Capabilities Leading The Space 1,000+ Clients

9. Informix Family Update IDS • V10: Largest Release Since IDS 9 in 1996 • Fastest Ever: 13-20% Faster than IDS 7.31 • Strong V10 Acceptance • 70+ Clients & Partners in 1st 60 Days of Availability • Over 400 Clients & Partners today • vNext Priorities • Advanced Autonomics • Extended Encryption & Auditing Cloudscape • Derby Graduates into the Mainstream U2 • Point-in-time Recovery • Encryption of Data at Rest

10. J2EE Applications Tables JFoundation Web DataBlade XSLT DataBlade XML Generating UDR EGL Applications WORF/DADX ServiceProviders Web IDS Providing Web Services in an SOA environment IDS HTTP/GET HTTP SOAP HTTP/SOAP Additional SOA Tools & Products WebSphere MQ WebSphere Process Server Information Integrator Rational Application Developer for WebSphere JDBC IDS Web Service Provider PHP .NET Apache/Tomcat Server Windows Internet Information Server WebSphere Application Server IDS provides Web Services data IDS consumes Web Services data

11. —Positioning and Roadmaps—

12. “The reports of my death are greatly exaggerated” “The reports of my death are greatly exaggerated” Mark Twain quotation after hearing that his obituary had been published in the New York Journal.

13. #1 Leader – “Database World Wide Market Share”- Gartner IBM Is #1 in World Wide Database Market Share • IBM strategy is to be the leader in all database segmentswith the right products • Informix Family (IDS) • DB2 Family (DB2 UDB) • UniVerse/UniData Family (U2) • IMS • Capitalize on market strengths of Informix Dynamic Server (IDS) Online Transaction Processing IDS v10.0 is IBM’s newest database for pure OLTP computing. The latest version has new features which greatly increase the performance of IDS. • Key Industries • IDS has significant market presence within key industries including Telco, Government, Retail & Banking Embedded Solutions IDS is optimized for industrial-strength embedded solutions due to its ability to integrate within an application. Small & Medium Businesses New Express & Workgroup editions of V.10 appeal to the market. Low DBA requirements are a strong selling point.

14. IBM Database Portfolio Infrastructure OLTP Products Total Solution Value: • Application • DBMS • Server • Storage • Services • SW & HW Mtc • IT Staff DB2 zOS Target: applications built for zOS V A L U E DB2 & IDS Enterprise Target: the most challenging database problems, on any size system OEM/Embedded Products DB2 & IDS Workgroup Target: 2-4 way mid level systems, requiring advanced high availability Target: Industrial Strength Transactional, Java Application + Middleware Solutions Express Runtime $ Target: Entry level 2 ways systems, requiring base database capability DB2 & IDS Express Target: industrial strength transactional, embedded applications IDS MultiValue { Any Size Mid-Level Entry Target: MultiValue embedded vertical applications for SMB U2 Product Flexibility: Increasing Capability, Performance, Scalability, & Control Lite { Target: Lite Embedded Data Driven Applications for Eclipse / Java Developers Cloudscape Micro { Target: Micro databases, mobile devices DB2 Everyplace Product Flexibility: Increasing Footprint, Increasing Capability, Performance, Scalability, & Control

15. IBM Informix Product Roadmap Plan:IDSvNext+ IDSv10.0 IDSvNext C-SDK v2.90 C-SDK vNext C-SDK vNext+ Continued support with IDS vNext DataBlades XPSv8.50 XPSv8.51 Redbrickv6.3 Online v5.2 4GL v7.32 Continued Platform and OS support through Fixpacks SE v7.25 EGM C-ISAM v7.26 RAD v7.x RAD v6.x SystemBuilder v5.4 UniData vNext Redback v4.3 UniVerse vNext UniData v7.x IBM Confidential UniVerse v10.2 And beyond 2005 2009 2006 2007 2008 2010

16. IDS Release Schedule and Roadmap – Major themes • ALWAYS ON!!! 2008 Leveraging IDS Strengths • XML Enablement • SOA • Encrypted Key Management • Trusted Context • 1 to N HDR Chaining • Embeddability Kit • ISC/Advisors • Solutions Install • Optimized OLTP 1H2007 ISV Revitalization • RFID • Common API • Security Enhancement • Online Table Re-org • Optimistic Concurrency • Autonomics • SWG Interoperability • Spatial/ Time-Series 1H2006 • IDS V10 • IPv6 • Microsoft Whidbey Support • PHP (Zend) Driver • WAS Portal Support(2H) 2005 • IDS Express • Express Runtime • Wal-Mart • CISCO • MQ series support • Oracle-to-IDS MTK (YE)

17. —Informix Highlights—

18. Success with Informix Dynamic Server • New Releases!! This year IBM launched IDS V.10, IDS Express and IDS Runtime will come this fall. We are investing in new offerings in response to customer demand for this powerful database which is optimized for OLTP & embedded scenarios. • Strong Revenue Growth!! IDS has seen double digit growth in 1H05 YTY. IDS customers can leverage innovation around IDS with other product offerings such as HDR, Alphablox, Mobility on Demand and Websphere MQ. • ISV Adoption!! Over 1,000 independent software vendor (ISV) applications have been produced and enabled to IDS. New OEM contracts and ISV recruitment efforts are driving renewed commitment from Partners to drive IDS revenue • IDS Is Winning!! IBM is winning major deals in the market against Oracle and Microsoft.

19. Informix On The Move • Informix Use • 8 of the top 10 U.S. retailers • 20 out of the top 25 supermarkets in the U.S. • Technology Partners • like Ericsson and Cisco • 70% of all telephone switches/routers run on embedded Informix • Wide use in Public sector • multiple countries • Civic administration, Judicial Applications, Military Applications, Law Enforcement Education, National Security, Tax Administration, Customs • QA improvements since the IBM acquisition

20. Information Management: The Story

21. —IDS V10 Overview—

22. Informix Dynamic Server Performance. Reliability. Scalability. Today you can find IBM’s Informix software in nearly everything you touch Do you know how Informix technology touched YOU today? Protected your country… Facilitated social harmony and sustainable development… Made a hotel reservation… Tracked the design of your next Porsche… Enabled emergency response systems… Helped you pay for petrol… Made it easier to pay taxes, to make a phone call, to get directions, to insure your home, to pay a bill online, to surf the web, to go to the doctor, and more…

23. Available Now! The Largest IDS Release Since IDS 9 in 1996 IDS v10.0: Technical Enhancements • Rolling Application Upgrades – Schema Evolution • Online Index Rebuild Reduces Downtime • Backup and Restore Flexibly Across Platforms Reliability • Enterprise Edition • Handles the most demanding requirements! • Workgroup Edition • Suitable for Medium Businesses or departmental applications • Express Edition • Affordably priced with the flexibility to grow as your business grows! • Fastest IDS Release Ever • 5% Faster than 9.4. 13-20% Faster than IDS 7.31 • Exploits capabilities of the Linux 2.6 Kernel Performance • Supports Configurable Page Sizes and related buffer pools • Available for Intel, Mid-Range and Mainframe Scalability • Column level encryption helps business meet regulatory compliance issues Security Unix, Windows, Linux, zLinux, pLinux, iLinux • Install time is drastically reduced with new installer • New single user mode for administration • Enhanced disk management, backup and restore • Improved trouble-shooting capabilities Manageability Development • Informix 4GL to EGL Conversion Utility • Available with Rational Developer V6

24. How to move to IDS v10.0 • Recompilation of applications is recommended and may be required • If customers are changing operating systems (say HP-UX to Linux) or hardware (say SUN SPARC to IBM pSeries) they must use dbexport/dbimport • Customers upgrading from Standard Engine must use dbexport/dbimport • Customers who wish to migrate from XPS to IDS will also need to use dbexport/dbimport and some schema changes may be required Upgrade in Minutes!

25. Competitive Total Cost of Ownership Expensive Add-Ons? No way! • Everything you need to run IDS is included in one server price. • Partitioning • Replication, High Availability • Web Administration • Server Studio JE • Informix Connect • Rational Application Trial CD • DataBlade Developer’s Kit • MQ Data Blade • Spatial DataBlade Spatial Tools Partitioning

26. Version 9.4 Workgroup Edition 2 CPU’s Windows, Linux and Unix 32-bit and 64-bit Workgroup OEM Edition 4 CPU’s Windows, Linux and Unix 32-bit and 64-bit Enterprise Edition Version 10 Express Edition 2 CPU’s Linux and Unix 32-bit Workgroup Edition 4 CPU’s Windows, Linux and Unix 32-bit and 64-bit HDR Add-on Option for WE Enterprise Edition IBM Informix® Dynamic Server Packaging

27. Announcing IDS Express Designed with the mid-market in mind, IDS Express combines a self-managing database engine that provides power, function, and reliability with simplicity in packaging, installation and deployment. • IDS Express provides a robust relational database with low administrative overhead that is: • Simpler and less complex than the competition. Easily embeddable into your application, such that our common end customer can concentrate on your solution, not database management. • Easy to install and deploy - the database installs silently within your application, is simple to configure and can be easily managed via your application. • Easy to integrate with your application providing faster time to value - comes with PartnerWorld support structure, and results in faster time to market the combined solution • Flexible andprovides a choice in programming environments, IDS Express provides deep support of both Java/Eclipse and Microsoft .NET IDEs. • Scalable on demand - as business grows, so can the underlying database • Extensible - with other IBM Software Group middleware, such as, Lotus® for collaboration, Tivoli® for management and WebSphere® for dynamic e-business • Supported Platforms: Windows, Linux “ IDS needs no army of DBAs. IBM Informix products run efficiently, without a lot of money and without a lot of interference. I can’t say that about Oracle. —Sean Durity, IT Manager, CornerCap Investment Council ”

28. Extensive Platform Support HP-UX on PA-RISC and Itanium. Tru64 on Alpha Solaris on SPARC IRIX Windows 2000, 2003 and XP on x86 AIX on pSeries Linux on xSeries, zSeries, pSeries* and iSeries*

29. IBM Informix Dynamic Server v10.0 To sum it all up, IDS 10.0 is a DBA’s dream come true. Gary Ben-Israel CIO National Institute for Testing and Evaluation Jerusalem, Israel Performance. Reliability. Scalability.

30. —IBM SWG Interoperability—

31. Business Integration • WebSphere Information Integrator • WebSphere Application Server • Embedded • Express • Enterprise • Network Deployment • WebSphere Portal Server • Enabled, Express, Extended • WebSphere Process Server • WebSphere MQ Series • WebSphere Ascential DataStage Collaboration Application Development • Lotus Enterprise Integrator • Rational Application Developer (RAD) • Rational Web Developer • Rational Data Architect System Management • Tivoli Storage Management for Databases • Tivoli Monitoring for Databases Information Management • Informix Tools & DataBlades • DB2 Alphablox • DB2 Everyplace • DB2 Web Query • DB2 Table Editor • DB2 Office Connect IDS Server Interoperates with Multitude of IBM Products Informix IDS Extending Values to Applications, Development, Management, Technology More Integration Planned

32. and Informix Dynamic Server Rational EGL for Informix 4GL • Informix 4GL to EGL Conversion Utility • Opens up Rational to Informix developers • Available with Rational Developer V6.0 products • Key features and benefits • Uniform Conversion - retain the "look and feel" of 4GL program with the equivalent EGL program • Graphical Conversion Wizard - step-by-step conversion process • Command Line Conversion - scripted or automated usage • Announcement of enhanced tooling • Integrated with IBM Software Development Platform • Increased productivity of Informix application developers • Visit 4GL-EGL @ developerWorks • http://www-128.ibm.com/developerworks/rational/products/egl/

33. Alphablox • Customers who have these problems…… • Branch or Store Profitability Analysis • KPIs / Dashboards via the web • Financial Planning and Analysis • And have tried these products already and are frustrated…. • Excel, Analyzer, ProClarity, arcplan, or any multidimensional AdHoc query tool • Have implemented Alphablox solutions and seen dramatic improvements to business processes. Flash Demo (Retail BPM)http://www-306.ibm.com/software/data/db2/alphablox/flashdemo/demo.swf

34. DB2 Everyplace Database Healthcare Retail Inventory Management Sales Force Productivity Shipping & Receiving DB2 Everyplace Mobilizes Your IDS Applications • mobile database and synchronization solution that easily integrates into existing IT environments • Powerful bi-directional synchronization solution • Reliable and secure access to enterprise information for mobile workforce—anywhere, anytime • ~250KB zero admin data store that can be easily synchronized with Informix Dynamic Server v10.0 • Multi-platform synchronization server support • Simple to install, manage and deploy • Three editions to choose from depending on business requirements Field Service

35. Information Integration – Extending Your Reach SQL SQL Content Mainframe files Relational databases XML Web services Packaged applications Web Other Collaboration Systems Content & Imaging • OmniFind • DataStage • IMS • Adabas • CA-Datacom • CA-IDMS • VSAM • Sequential • DB2 UDB • IDS • Oracle • Sybase • Teradata • Microsoft SQL Server • ODBC • WebSphere BI Adaptors • SAP • PeopleSoft • Siebel • OLE DB • Excel • Flat files • IBM Lotus Extended Search • Web search • LDAP • Custom-built • DB2 CM • Family • Domino.doc • Documentum • FileNet • Open Text • Stellent • Interwoven • Hummingbird • Lotus Notes • Microsoft Index Server • IBM Lotus Extended Search • Sametime • QuickPlace • Microsoft Exchange

36. —Call to Action—

37. Ways to Connect WatchIT video series at www.watchit.com/informix or www.thesoftwareinstitute.org • IBM Informix Software: Portfolio Update and Future Directions • IBM Informix Software: Database Technology in Everything You Touch • IBM Informix Software: A Step into the Future, IDS Version 10 (4Q2005) “Chat with the Labs” • http://www-1test.ibm.com/partnerworld/pwhome.nsf/weblook/eac_index_bizinformix_09mar.html • July 13: Upgrading from IDS v7.x to v10, over 150 in attendance, 95% of the audience gave the call a rating of either Excellent or Good Conferences and Roadshows • Infobahns • TechCon in Orlando Sept. 19-22, 2005 • IDUG/IIUG NA in Tampa May 7-11, 2006 International Informix Users Group at www.iiug.org • Worldwide network of Informix users

38. Call to Action • Upgrade to IDS V10 for: • even better TCO • greater industrial strength 7x24 up time • increased speed • better storage utilization & security • enhanced integration with other SWG products • Keep up your Informix maintenance contract for best of breed support and access to the latest technology • Modernize your application tools via Websphere Studio (EGL) • Connect with IBM and other Informix Users • IIUG members should disseminate the good word around the IDS/Informix revitalization • Remember as an IBM customer you have access to the best products, solutions, services and support!

39. Advice from Mark Twain • "Get your facts first, and then you can distort them as much as you please." • Informix is Alive and Well! • Integral component of the SWG strategy through • integration with the SWG stack • Great for OLTP and Embedded solutions • Here to stay! Roadmaps and plans are in place • ensuring a strong future • Superior technology and value than Oracle and • Microsoft • The right choice for our customers • The right choice for our partners

40. —Thank You—

41. Pick up your free Thinkpad

42. Who can help?

43. Helpful Links

44. IDS in an SOA End-to-End Model B2B Interactions “Portal” Service Enterprise Service Bus: Transform, Route, Notify, Augment, Side Effect Workflow Business Act. Distinguished Services “Script”POJO SSB EIS Adapter Information MgmtIDS

45. IDS v10.0: Benefiting your Business • Keeps you operating even when disaster strikes! • Eliminates unscheduled outages! • Reduces scheduled maintenance! Superior Reliability • Get more performance with less hardware! • Keep pace with ever-increasing requirements SuperiorPerformance • Efficiently handles departmental applications or enterprise applications • Grows as your business needs grow! SuperiorScalability • Addresses emerging requirements for privacy and regulatory compliance • Sarbanes-Oxley, Basel II, HIPAA and other regulations • Protects your data without requiring application changes SuperiorSecurity • Provides the lowest Total Cost of Ownership • Lets you manage your business instead of your database • Lets DBAs focus on strategic business priorities SuperiorManageability • Develop using the tools of your choice: • Supports .Net and Microsoft Integrated Development Environment • Supports latest Java levels • Supports Rapid Application Development • Supports your Business Logic NATIVELY for exceptional performance SuperiorDevelopment

46. —Key Focus Areas—

47. Informix 2006 Key Focus Areas – take out • Software Group Compatibility • Websphere Portal Server 6.x in planning • Content Management • IDS as a repository for DataStage • Etc. • IDS Development • RFID • Spatial • Autonomics • Security & Regulatory Compliance • Customer/BP Requirements • ISV Revitalization • Targeted list of ISVs • VAR/VAD focus • Continued and increased market awareness • Additional BP and customer events • Increased BP co-marketing • More focus on BP and customer success stories

48. and Informix Dynamic Server Rational Web Developer Rational Application Developer Rational Software Architect • Fully integrated with IDS v10.0 • Provides pure Java development environment • Enterprise Generation Language • Based on Informix 4GL constructs • 4GL to EGL conversion tool • Proven Business Logic in 4GL Apps • Leverage 4GL Skills • Based on ECLIPSE Drag and drop JSF components Visual layout and design Quick Edit View for scripting Point-and-click data connectivity Rapid Application DevelopmentMaking Java development faster