Information Management Informix Seeing The Big Picture Informix

Information Management Agenda § Information as a Service § Positioning and Roadmaps § Informix Highlights § V 10 Overview § IBM SWG Interoperability § Call to Action 2

Information Management —Information as a Service— 3

Information Management 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 Strategy Volkswagen AG Result: Procurement productivity increased by 20% 4

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

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

Information Management Expanding the Value For 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 7

Information Management - Number One Market Share Information Delivered on Demand Based on Services Oriented Architecture are nts h n S Clie i § Data Services #1 00+ 4 IDS, DB 2, IMS, Cloudscape, , 0 U 2 0 45 § Content Services e ar ts 4 Content Management Services h S ien 4 Content Integration Services l in #1 0+ C , 00 Services 3 § Information Integration 1 4 4 Federation Services Movement Services Transformation Services n Quality Services… #1 i 0 5, 0 are ts h S en li +C 0 § Information Accelerators No Other Vendor Delivers The Breadth and The Depth of Capabilities 4 4 Master Data Management ce a Entity Analytics Sp s e Data Warehousing Th lient g Industry Data Models din + C a Le 1, 000 8

Information Management Informix Family Update IDS § V 10: Largest Release Since IDS 9 in 1996 § Fastest Ever: 13 -20% Faster than IDS 7. 31 § Strong V 10 Acceptance 4 70+ Clients & Partners in 1 st 60 Days of Availability 4 Over 400 Clients & Partners today § v. Next Priorities 4 Advanced Autonomics 4 Extended Encryption & Auditing Cloudscape § Derby Graduates into the Mainstream U 2 § Point-in-time Recovery § Encryption of Data at Rest 9

Information Management Service Providers Web ID S HTTP/GET HTTP/SOAP IDS Providing Web Services in an SOA environment Web Data. Blade XSLT Data. Blade P HTT P SOA JFoundation Additional SOA Tools & Products XML Generating UDR Web. Sphere MQ C IDS Web Service Provider J 2 EE EGL Applications WORF/DADX Web. Sphere Application Server B JD Web. Sphere Process Server Tables Information Integrator PHP Apache/Tomcat Server IDS provides Web Services data . NET Rational Application Developer for Web. Sphere Windows Internet Information Server IDS consumes Web Services data 10

Information Management —Positioning and Roadmaps— 11

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

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

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

Information Management IBM Informix Product Roadmap IDS v 10. 0 Plan: IDS v. Next+ IDS v. Next C-SDK v 2. 90 C-SDK v. Next Data. Blades C-SDK v. Next+ Continued support with IDS v. Next XPS v 8. 50 XPS v 8. 51 Redbrick v 6. 3 Online v 5. 2 4 GL v 7. 32 Continued Platform and OS support through Fixpacks SE v 7. 25 C-ISAM v 7. 26 EGM RAD v 7. x RAD v 6. x System. Builder v 5. 4 Uni. Data v 7. x Uni. Data v. Next Redback v 4. 3 Uni. Verse v. Next Uni. Verse v 10. 2 2005 2006 2007 2008 2009 IBM Confidential 2010 And beyond 15

Information Management IDS Release Schedule and Roadmap – Major themes ALWAYS ON!!! 2008 S ID g n i g s a r th e ISV v g Revitalization Le ren St Optimized OLTP 1 H 2007 1 H 2006 IDS V 10 2005 • • • IDS Express Runtime Wal-Mart CISCO MQ series support Oracle-to-IDS MTK (YE) • • IPv 6 Microsoft Whidbey Support PHP (Zend) Driver WAS Portal Support (2 H) • • • • RFID Common API Security Enhancement Online Table Re-org Optimistic Concurrency Autonomics SWG Interoperability Spatial/ Time-Series XML Enablement SOA Encrypted Key Management Trusted Context 1 to N HDR Chaining Embeddability Kit ISC/Advisors Solutions Install 16

Information Management —Informix Highlights— 17

Information Management 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 1 H 05 YTY. IDS customers can leverage innovation around IDS with other product offerings such as HDR, Alphablox, Mobility on Demand 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. 18

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

Information Management: The Story 20

Information Management —IDS V 10 Overview— 21

Information Management 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… 22

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

Information Management How to move to IDS v 10. 0 Current Platform Step 1 Step 2 7. 24, 7. 30, 7. 31, 9. 20, 9. 21, 9. 30, 9. 40 10. 0 N/A 9. 1 x 9. 30 10. 0 7. 22, 7. 23 7. 31 10. 0 Online 5. 1 x 7. 31 10. 0 Upgrade in Minutes! § 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 p. Series) 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 24

Information Management Competitive Total Cost of Ownership Expensive Add-Ons? No way! § Everything you need to run IDS is included in one server price. Partitioning 4 Replication, High Availability 4 Web Administration 4 Server Studio JE 4 Informix Connect 4 Rational Application Trial CD 4 Data. Blade Developer’s Kit 4 MQ Data Blade 4 Spatial Data. Blade l a ati Sp Tools 4 g in ion it rt a P 25

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

Information Management 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: 4 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. 4 Easy to install and deploy - the database installs silently within your application, is simple to configure and can be easily managed via your application. 4 Easy to integrate with your application providing faster time to value - comes with Partner. World support structure, and results in faster time to market the combined solution 4 Flexible and provides a choice in programming environments, IDS Express provides deep support of both Java/Eclipse and Microsoft. NET IDEs. 4 Scalable on demand - as business grows, so can the underlying database 4 Extensible - with other IBM Software Group middleware, such as, Lotus ® for collaboration, Tivoli® for management and Web. Sphere ® 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, Corner. Cap Investment Council 27

Information Management Extensive Platform Support HP-UX on PA-RISC and Itanium. Tru 64 on Alpha AIX on p. Series Linux on x. Series, z. Series, p. Series* and i. Series* Solaris on SPARC IRIX Windows 2000, 2003 and XP on x 86 28

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

Information Management —IBM SWG Interoperability— 30

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

Information Management and Informix Dynamic Server Rational EGL for Informix 4 GL § Informix 4 GL to EGL Conversion Utility 4 Opens up Rational to Informix developers 4 Available with Rational Developer V 6. 0 products 4 Key features and benefits § Uniform Conversion - retain the "look and feel" of 4 GL 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 4 Integrated with IBM Software Development Platform 4 Increased productivity of Informix application developers § Visit 4 GL-EGL @ developer. Works 4 http: //www-128. ibm. com/developerworks/rational/products/egl/ 32

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

Information Management DB 2 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 Healthcare DB 2 Everyplace Database § ~250 KB zero admin data store that can be easily synchronized with Informix Dynamic Server v 10. 0 Retail Inventory Management § Multi-platform synchronization server support § Simple to install, manage and deploy § Three editions to choose from depending on business requirements Field Service Sales Force Productivity Shipping & Receiving 34

Information Management Information Integration – Extending Your Reach SQL Mainframe files §IMS §VSAM §Adabas §Sequential §CA-Datacom §CA-IDMS Content Relational databases XML Web services §DB 2 UDB §IDS §Oracle §Sybase §Teradata §Microsoft SQL Server §ODBC Packaged applications §Web. Sphere BI Adaptors §SAP §People. Soft §Siebel Web Other Collaboration Systems §OLE DB §Excel §Flat files §IBM Lotus Extended Search §Web search § LDAP §Custom-built §Lotus Notes §Microsoft Index Server §IBM Lotus Extended Search §Sametime §Quick. Place §Microsoft Exchange Content & Imaging § Omni. Find §DB 2 CM § Data. Stage Family §Domino. doc §Documentum §File. Net §Open Text §Stellent §Interwoven §Hummingbird 35

Information Management —Call to Action— 36

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

Information Management Call to Action § Upgrade to IDS V 10 for: 4 4 4 even better TCO greater industrial strength 7 x 24 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! 38

Information Management 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 39

Information Management —Thank You— 40

Information Management Pick up your free Thinkpad 41

Information Management Who can help? WW Informix Sales Support Danilo Novelli 1 -305 -442 -3604 T/L: 235 -3604 danilo@us. ibm. com WW Informix Technical Enablement Mark Scranton 1 -303 -395 -3622 T/L: 273 -3381 mark. scranton@us. ibm. com IDS Product Manager Christine Normile 1 -877 -252 -5399 T/L: 273 -0981 Christine. normile@us. ibm. com Informix Classics Product Manager Andrea Reid 1 -408 -463 -2293 T/L: 543 -2293 areid@us. ibm. com IDS GTM Strategy Michael N. Cohn 1 -678 -248 -3669 (T/L: 268 -0153) mcohn@us. ibm. com Informix Business Leader Bruce Weed 1 -914 -766 -1717 T/L: 826 -1717 bweed@us. ibm. com Database Technology Awareness Carolyn Woods 602 -357 -4398; TL 273 -0096 cwoods@us. ibm. com IDS Technical Product Manager Fred Ho 1 -650 -926 -8524 hof@us. ibm. com 42

IBM Software Group | Information Management Helpful Links Sales Links & Collateral IDS Version 10 Play Customer Links & Collateral Informix Product pages http: //w 3103. ibm. com/software/xl/portal/viewcontent? type=doc&src. ID=DM&doc. ID=R 206867 Q 86791 T 20 http: //www-306. ibm. com/software/data/informix/ IDS License Compliance IDS Developer and User Forum http: //w 3103. ibm. com/software/xl/portal/!ut/p/_s. 7_0_A/7_0_IP? type=doc&src. ID=DM &doc. ID=L 428191 R 89157 U 94 http: //www 128. ibm. com/developerworks/forums/dw_forum. jsp? forum=548&cat=19 Informix on Xtreme Leverage IDS v 10 on ibm. com http: //w 3103. ibm. com/software/xl/portal/!ut/p/_s. 7_0_A/7_0_LT? nb=ca&ni=dm&ca=in formix&e=informix http: //www-306. ibm. com/software/data/informix/ids 10/ Informix Info. Bahn 2005 Flash media file for IDS V 10 – sales & technical information [Posted on Marcom Central} IDS Express Data Sheet http: //software. leopardem. com/app/assets/Asset. Summary. do? crud. Mode=ge t&data. Manager=ASSET_MGR&id=273027 IDS v 7 to v 10 Telesales kit http: //w 303. ibm. com/software/salesite. nsf/salestools/Tele. Sales+Kits$IDS_Upgr ade_V 10 ftp: //ftp. software. ibm. com/software/data/informix/pubs/datasheets/IDSV 10 -0 -datasheet. pdf IIUG – Informix Users Group (have your customers subscribe to the monthly newsletter) http: //www. iiug. org IDS Enterprise Mobility Flash Demo Watch. IT Informix video programs http: //www-306. ibm. com/software/data/informix/ids/mobility/ http: //www. thesoftwareinstitute. org/new. CAP. cfm– Click on DB 2 Information Management on right navigation panel IDS Express Telesales kit IDS Trial code http: //w 303. ibm. com/software/salesite. nsf/salestools/Tele. Sales+Kits$IDS_Expr ess_V 10 http: //www-306. ibm. com/software/data/informix/downloads. html 43

IBM Software Group | Information Management IDS in an SOA End-to-End Model B 2 B Interactions “Portal” Service Enterprise Service Bus: Transform, Route, Notify, Augment, Side Effect Workflow Business Act. EIS Adapter “Script” POJO Information Mgmt SSB IDS Distinguished Services 44

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

Information Management —Key Focus Areas— 46

Information Management Informix 2006 Key Focus Areas – take out Software Group Compatibility § § Websphere Portal Server 6. x in planning Content Management IDS as a repository for Data. Stage 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 47

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