2032 IBM Informix in the Cloud Nicholas Geib

2032 IBM Informix in the Cloud Nicholas Geib Monday 24 October 2016

Please note IBM’s statements regarding its plans, directions, and intent are subject to change or withdrawal without notice and at IBM’s sole discretion. Information regarding potential future products is intended to outline our general product direction and it should not be relied on in making a purchasing decision. The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information about potential future products may not be incorporated into any contract. The development, release, and timing of any future features or functionality described for our products remains at our sole discretion. Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multiprogramming in the user’s job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here. 2 World of Watson 2016 3/4/2021

IBM Informix –The ideal enterprise class database for the Internet of Things Please join us at this exclusive luncheon event where we will provide insight into the Informix database why it is the only enterprise class DBMS suitable for real world Internet of Things use cases. Meet the Informix product leadership team – for deeper insight into the product roadmap and the future of Informix. Exclusive luncheon Tuesday, October 25 th Location – Theater Room, Ri Ra Irish Pub, Mandalay Shops 12: 00 PM – 2: 00 PM Register to Attend at this link: Tuesday Informix Luncheon Or just google “Informix Luncheon Las Vegas” …. . google should return the registration link at the top of the response list For more information: Steve Shoaf: shoafs@us. ibm. com Rajesh Govindan rajesh. govindan@in. ibm. com

Technology Preview: Monitoring IBM Informix How do you monitor Informix? Are you quickly and easily alerted when something goes wrong? Can you flexibly configure what to monitor? Do you visual monitored data to gain further insight? What tools do you use? The Informix team has been working on a prototype and want your feedback. Where: Smarter Support area When: Monday 8: 00 -7: 30 Tuesday 1: 00 -7: 00 Wednesday 8: 00 -11: 00, 3: 00 -5: 00 What: 15 minutes of hands-on exercises using the prototype

Agenda Market Trends Business Requirements Why consider IBM Informix on Cloud What is IBM Informix on Cloud Using IBM Informix on Cloud

Cloud is the future IBM Ranked #1 in Hybrid Cloud > 80% of enterprise IT orgs will commit to hybrid cloud by 2017 (IDC) 70% of IT decision makers say they will always have a blend of Traditional IT and Cloud (IBM Center for Applied Insights Survey, 2016) Hybrid Cloud now makes up ~65% of the total Cloud Opportunity and is growing at 33% CAGR through 2018 In January 2016, IBM was ranked #1 in Hybrid and positioned as a leader Hybrid Cloud Management Solutions (Synergy Group Research and Forrester, respectively)

Cloud Agility Accelerates Innovation Outthink The Economics More Productivity Risk Mitigation Better Economics Greater Flexibility Public Cloud Hosted Private Cloud Hybrid Cloud Development Infrastructure Dedicated Environment End Game for Most Enterprises Continuous Innovation • Simplified development process • Portable and collaborative • Reimagine your business • Application development for apps with mission critical data • Business process automation, secured • Business process applications stay intact • Managed / new applications on the cloud • Ubiquitous data management software

Business Requirement How can I reduce my ongoing business cost? How can I analyze the data in Io. T and in the edge? How do I reduce time to market? • IT infrastructure platform cost is the biggest recurring cost for enterprises • On-prem RDBMs represents one of the most expensive recurring expenses for enterprise IT organizations. • It is necessary to innovate and to be able to innovate you look at different deployment options ie cloud Desired outcome §Informix on Cloud is aimed for enterprise who are wanting to innovate to save costs by choosing a cloud deployment for their workloads but do not want to compromise on enterprise level security and performance, and need a robust and proven technology choice.

How IBM Informix on Cloud can help • • IBM Informix on cloud offers the rich enterprise performance available in the cloud (without the cost, complexity and risk of managing your own infrastructure) Informix on Cloud brings Infrastructure as a service economics to data infrastructure, while preserving control, performance, security, and availability expectations needed to run enterprise businesses

Why consider IBM Informix on Cloud § As a CTO, I need to be able to quickly and inexpensively additional development and test instances of Informix to support our product development and release goals. § As a software engineer, I need another large instance of an Informix database for stress testing our new application. None of our current test environments are large enough to effectively test this application. § As a manager, I want my team to try the latest version of Informix without impacting any of my current systems and without going through a long budget approval process. § As a developer, I want to try out new features in Informix like No. SQL and the REST API, but I currently don’t have access to a version with these features. § As a DBA, I want to experiment with Informix’s clustering, replication, and sharding technologies to see how they might help my business.

What is IBM Informix on Cloud The latest Informix server on a machine in a Soft. Layer data center, fulfilled quickly, billed monthly, accessible on the Internet, dedicated to you, entirely in your control.

Sizes § Price/month: $1, 250 $2, 200 $4, 000 $8, 000

Decisions & Responsibilities • • What decisions do I need to make? • the size • the Data. Center, e. g Dallas, London, Sydney • how many machines • requested delivery date You don’t get a choice about the version of Informix, OS, etc. • What is IBM responsible for? Fulfilling the order. IBM provides you with an account on Bluemix if necessary, obtains the machine from Soft. Layer, installs and configures Informix, and makes the machine accessible to you. • What am I, IBM’s customer, responsible for? • Any and all administration of the OS, network, database, etc. • Installing, configuring, and/or running applications, creating a schema, etc. • You have complete control over and flexibility to use the system to serve your business.

Upon receiving the machine: access documentation on Bluemix

Upon receiving the machine: Log in for the first time $ ssh root@1. 2. 3. 456's password: You are required to change your password immediately (root enforced) Changing password for root. (current) UNIX password: New password: Retype new password: [root@myinformixhost ~]# When logging into the machine for the first time, you will immediately be required to change your password.

Ongoing use of the machine: administration • You have full power and responsibility to administer the machine. • Administer the machine just like you do machines in your current data center/office. This includes: Applying patches to the OS Backing up the machine and the Informix server Installing and/or updating any software Configuring the firewall Managing OS accounts Upgrading Informix Transferring data to/from the system Configuring clients to connect to Informix Changing ONCONFIG settings, adding db/sbspaces, etc. • • •

Initial Configuration of Machine • We’ve made some decisions about the initial configuration of the OS, Informix, etc. This is your machine, so change whatever you like to fit the needs of your business. • Informix version: 12. 10. FC 7 W 2 AEE We plan to fulfill orders using the latest available Informix release. So at some point new orders will be fulfilled using 12. 10. FC 8. • OS: Cent. OS 7 (currently 7. 2. 1511) • File system: • / for os • /data for dbspaces, logs, etc. • OS accounts: • root, only customer knows password • informix, initially configured without a password

Initial Configuration of Machine • • Product locations • $INFORMIXDIR • WL • IWA /home/Informix/server /opt/ibm/wire_listener /opt/ibm/iwa Only. tar; not configured Firewall à la iptables allows traffic: • SSH (22) • SQLI over SSL (9089) • DRDA over SSL (9091) • Mongo over SSL (27018) • REST over SSL aka HTTPS (443) Informix and Wire Listener configured with a self-signed certificate Informix also listens for non-SSL traffic: • SQLI (9088) • DRDA (9090) • Mongo (27017) • REST, aka HTTP (80)

Configuring Remote Client Connectivity • All traffic goes over the internet • Highly recommend that all traffic be encrypted • Documentation for using SSL with SQLI, DRDA, Mongo, and REST at Bluemix

All the Good Stuff We Love About Informix • SQL-processing speed machine • Low administration • Full spectrum of replication solutions • Cluster with three secondary types • Enterprise Replication • Time. Series for efficient storage and querying • Accelerate queries with in-memory, columnar IWA • REST API • • No. SQL functionality that developers love • JSON data • Mongo. DB client compatibility Embeddable, even on ARM and Intel/Quark

Getting help View documentation on Bluemix https: //console. ng. bluemix. net/docs/services/Informix. On. Cloud. html Use the forums – Stack Overflow – tags “informixoncloud” and “bluemix” http: //stackoverflow. com/search? q=informixoncloud+bluemix – IBM developer. Works d. W Answers – tags “informixoncloud” and “bluemix” https: //developer. ibm. com/answers/smartspace/bluemix/ Open a Bluemix ticket

Getting help • Have a problem with Informix (e. g. AF)? Have a problem with physical infrastructure (e. g. disk, memory, network)? Open a Bluemix ticket • Different than opening a PMR, if you are familiar with that process • SLAs http: //www-03. ibm. com/software/sladb. nsf/sla/bm-6605 -08

Why consider IBM Informix on Cloud continued § As a CTO, I need to deploy our solution in a distant geography we’ve never done business in before. § As a project manager, I need to have an Informix database environment that both my developers and individual beta customers can easily access. My developers are creating a Proof of Concept and my customer will access it. § As a DBA, I need to have an offsite copy of our Informix database for the purpose of disaster recovery. § As an architect, I want to prototype Informix Warehouse Accelerator with my application as my customers are asking for performance improvements on various queries in our application. With our Workgroup Edition, I don’t have access to IWA.

Want something more? Something different? Do you want something else from this IBM offering? Please give us your feedback! For example: • Can I order a multi-machine cluster? • Can IBM help me transfer data to and from the machine using e. g. Aspera? • I’d like IBM to be responsible for backing up the Informix server. • I wish this would integrate with technology xyz. • I’d like faster fulfillment.

Learn more • Documentation in the Bluemix catalog https: //console. ng. bluemix. net/docs/services/Informix. On. Cloud/Informix. O n. Cloud. html • Videos https: //developer. ibm. com/clouddataservices/docs/informix/ General Questions? § Karen Qualley kqualley@us. ibm. com Order today § Through Bluemix @ www. bluemix. net § Contact your Americas Call Centers (800 -426 -2255), local IBM representative, or your IBM Business Partner. To identify your representative or partner call 800 -426 -7968.

Notices and disclaimers continued Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products in connection with this publication and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. IBM does not warrant the quality of any third-party products, or the ability of any such thirdparty products to interoperate with IBM ’s products. IBM EXPRESSLY DISCLAIMS ALL WARRANTIES, EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. The provision of the information contained herein is not intended to, and does not, grant any right or license under any IBM patents, copyrights, trademarks or other intellectual property right. IBM, the IBM logo, ibm. com, Aspera®, Bluemix, Blueworks Live, CICS, Clearcase, Cognos®, DOORS®, Emptoris®, Enterprise Document Management System™, FASP®, File. Net®, Global Business Services ®, Global Technology Services ®, IBM Experience. One™, IBM Smart. Cloud®, IBM Social Business®, Information on Demand, ILOG, Maximo®, MQIntegrator®, MQSeries®, Netcool®, OMEGAMON, Open. Power, Pure. Analytics™, Pure. Application®, pure. Cluster™, Pure. Coverage®, Pure. Data®, Pure. Experience®, Pure. Flex®, pure. Query®, pure. Scale®, Pure. Systems®, QRadar®, Rational®, Rhapsody®, Smarter Commerce®, So. DA, SPSS, Sterling Commerce®, Stored. IQ, Tealeaf®, Tivoli®, Trusteer®, Unica®, urban{code}®, Watson, Web. Sphere®, Worklight®, X-Force® and System z® Z/OS, are trademarks of International Business Machines Corporation, registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at: www. ibm. com/legal/copytrade. shtml. 31 World of Watson 2016 3/4/2021

Thank You