Transcript Informix 11.7 - garyproctorsblog

Increase Your Revenue with IBM Informix 11.7
Informix BP WebCast 3/14/2012
© 2012 IBM Corporation
Topics
 Introduction - Sapna Muralikrishnan (5 mins)
 2012 Channel Sales Initiatives - Gary Proctor (15 mins)
 Informix Analytics - Go To Market Tips and Update from the lab Dennis Allen (15 mins)
 Informix Genero - Go To Market Tips and Update from the lab Douglas Dailey (15 mins)
 Marketing Collateral Update - Sapna Muralikrishnan (10 mins)
 Q&A
1
© 2012 IBM Corporation
2012 Channel Sales Initiatives
Gary Proctor
Business Development, Informix Channels
© 2012 IBM Corporation
Informix 11.7 – The Beginning of the Next Decade of IBM Informix
 Informix Cluster expands the industry's most comprehensive set of high
availability options on heterogeneous, low cost hw (competitive differentiator!)
 Informix Analytics speed analytical queries and lower costs
by up to 100 times (competitive differentiator!)
 Time Series Analysis respond to high volumes of time related data in
dramatically less storage and much faster query performance (competitive
differentiator!)
 Genero – 4GL Application Modernization increase developer efficiency; expand
applications to cloud and mobility environments
 Embedded and Autonomic enhancements respond to changes without
intervention; deploy with little or NO on going DBA support.
 Performance enhancements mean faster work flow processing, quicker
decisions, less servers, and fewer resources
 Low Total Cost of Ownership make Informix cost at least 31% less than
Microsoft SQL Server*
3
© 2012 IBM Corporation
Informix 11.7
Creating Growth Opportunities for ISVs
Free editions to drive adoption and new solutions
Informix Developer Edition
Informix Growth Edition
• Full functionality, limited scalability
• Ideal for small to medium size business
• Rich HA options
• Shared disk clustering/grid
• 4 sockets, 16 cores, 16GB memory
• All platforms
• 1 core, 1GB memory, 20 connections, 8GB dbspace
• Free to download, develop, test
• All platforms
Informix Innovator-C Edition
• Ideal for small applications, includes HA
• Free to download and deploy in production
• Redistribution requires separate license
• 1 socket, 4 cores, 2GB memory
• All platforms
4
Greater value editions for-purchase
Informix Ultimate Edition
• Full enterprise class functions for all businesses
• Unlimited grid/scalability
• Optional compression feature
• All platforms
Highly competitive Windows/Mac edition
for purchase
Highly Warehouse editions
for purchase
Informix Choice Edition for Windows and
Mac OSX
Informix Warehouse Editions for Growth
and Ultimate Editions
• Ideal for small to medium size business
• Limited replication, 2 node grid
• 2 sockets, 8 cores, 8GB memory
• Windows and Mac OSX
Ideal for small to medium size business
• Accelerator for near real time Analytics
• Growth 48 GB Memory limit, Ultimate is unlimited
• All Platforms
© 2012 IBM Corporation
Informix for Availability and Scalability
"The new flexible grid in Informix 11.7 lets us manage 100+ geographically
dispersed nodes from a single location, reducing our administration costs up to
80%. It also gives us the flexibility to have different hardware and operating
systems in different clusters which helps keep costs low. The flexible grid
technology promises measurable IT cost savings for any size business." ~
Romana Opletalova, General Manager, d-Prog Ltd.
• Scale globally
• Manage easily
• Balance workloads
• Rolling Upgrades
• Heterogeneous
• Avoid platform lock-in
• Ideal for the Cloud
© 2012 IBM Corporation
Informix Cluster is a Game Changer
 What is a grid?
Grids are a form of distributed computing whereby a “super virtual computer” is composed of
many networked loosely coupled computers acting together to perform very large tasks.
 What is unique about Informix Flexible Grid?
– ZERO downtime for maintenance and upgrades made EASY!
• Rolling Upgrades make users much happier
• No temporary hardware required
• No database or application cloning required
–
–
–
–
–
–
Up and running in minutes
Automatically propagate database objects throughout the grid
Scale capacity when and where needed with Informix Flexible Grid
Utilize heterogeneous HW and operating systems within the grid!
Enable web-based services and cloud computing
Easily manage all of this from a single location
"The new flexible grid capability in Informix V 11.7 lets us re-use old equipment and combine it with the use
of new equipment to scale out across a grid that uses different types of hardware and operating systems.
This is a real innovation that lowers our operating costs with less investment in hardware, and lets us
leverage existing investments and resources.“
Hector De Santiago Ramirez, IT Infrastructure Manager, DHL
6
© 2012 IBM Corporation
Smarter Transportation and Shipping
What’s smart?
• Enhanced customer service with user
insight into 500,000 shipment
checkpoints
• Improved staff efficiencies with 12X
faster system backups/administration
• Reduced IT costs through
compatibility with multiple platforms
Smarter Business Outcomes
• Reclaimed staff productivity enables
new customer services and
applications
• Rapid growth is matched by
performance and ease of scale-out
“By using the Flexible Grid feature of Informix 11.7, our IT department has saved administrative
time that can now be used to create new functionality and applications for our customers.”
~ Felipe Villegas, CIO, DHL Express Mexico
© 2012 IBM Corporation
Informix for your Private Cloud
Why Informix?
Only database that can be utilized and provisioned in a cloud model
on heterogeneous, commodity hardware
Competitors’ offering is “more capital investment intensive” in
hardware
Easily manage the entire environment from a single console using a
comprehensive set of administration commands.
Modern development environment for cloud and mobile technology
deployments
Provide around-the-clock services with virtually NO downtime, even
for routine maintenance and upgrades
Manage workload utilization cost effectively for both OLTP and
Decision Support applications
© 2012 IBM Corporation
ERP as a Service
SUPPLY CHAIN
Database
INVENTORY
database
INVENTORY
database
ORDER database
Informix Cloud
Console
SaaS
providers want their
infrastructure on a cloud
Application Cloud Services by service provider
Service provider builds and manages the infrastructure
Support multi-tenancy models, manage database provisioning and utilization
© 2012 IBM Corporation
Informix for Smart Metering
 Smart Meters Solves Real Problems
– Real time information on energy usage
 Benefits for people
– Gain control over personal energy usage
– Modify electrical consumption
•
•
•
•
California study – reductions 5.7% to 8.7%
Norwegian study - reductions of 9%
UK study reduction of 12%
Oncor Texas, reductions of 5%-10%
 Benefits for power companies
– Develop new innovative rate plans
– Avoid building new plants
– Avoid buyer power from other sources
– Meet “green” standards
– Reliable power restored quicker after outages
10
02/11/2011
EDF 1 IBM Confidential
© 2012 IBM Corporation
100 Million Smart Meter Benchmark: Summary
AMT SYBEX/ IBM TimeSeries
 100 Million meters with 30 minute data intervals
 Single 16 core Power 750 using 3.7 TB of storage for 31 days of data
 Daily readings loaded in less than 8 hours while processing billing calculations
Cumulative Load Rate for One Day
24M meters processed
every 30 minutes
Minutes
Meters - millions
Meters - millions
VEE Processing Rate for One Day
16.7M meters loaded
every 30 minutes
Minutes
© 2012 IBM Corporation
Informix TimeSeries vs Relational Database Systems
Comparison of Published Benchmarks for Meter Data Management
Meters
Daily
Reads
Total
Cores
Total
RAM
DB
cores
App
cores
DB
RAM
App
RAM
100M
4.9B
16
500
16
shared
500
shared
5.5M
1.06B
456
3668
96
360
768
2900
Informix TimeSeries
The Competition *
Daily Readings (meters * registers * intervals)
Informix TimeSeries
The Competition
Database Resources (CPU cores)
4,900,000,000
1,061,500,000
5 times the performance
Informix TimeSeries
16
The Competition
96
< 1/5 the resources
… with significantly simpler management using a single node system
* Based on published Oracle benchmark
12
http://www.oracle.com/us/industries/utilities/utilities-meter-data-exadata-wp-486477.pdf
© 2012 IBM Corporation
Informix 11.7 – Autonomics
 Informix is easy! It just works!
– Continued focus on autonomics and ease of administration
– Nearly 25% of the Informix 11.7 features simplify or reduce work for DBAs
Automatic light scans on tables
Automatically route connections across the Informix Grid
Database extensions are automatically registered
Automatically add CPU virtual processors
"Informix 11.7 will save up to 80% of DBA's time thanks to automated storage and memory management,
automated task scheduler, and automated installation. The new Flexible Grid lets us use one command from a
single location to create new nodes and propagate the DDL across the grid to all the necessary locations."
~ Victor Vatyutov, Lead DBA , State Traffic Safety Inspection of Russian Interior Ministry
13
© 2012 IBM Corporation
Informix Autonomics Delivers…
Self Healing
Self Configuring
 Internally handle errors and retry when possible
 Deployment Assistant / Utility
 Automated DB Scheduler tasks added
 Automatically timeout idle users
 Automatic table storage optimization
(compression) based on user defined parameters
 Automatically allocate CPU VPs to match
hardware/licensing when IDS starts
Self Maintenance
 Build a package containing
 (Optional) pre-built database(s)
 Compresses the package
 Deploy, decompress, and install the
package on multiple systems
 Can be used for media distribution such
as CDs
 Automated storage allocation
 Allow existing chunks to be extended automatically
 Add chunks automatically when space is low
 Threshold used to determine when to add space
14
© 2012 IBM Corporation
Informix Analytics
Go To Market Tips and Update from the lab
Dennis Allen,
WW Sales Leader, Informix Warehouse
© 2012 IBM Corporation
200 Times Faster
© 2012 IBM Corporation
IWA = Extreme Value
 Informix Extreme
– Reliability: e911 has run on Informix for more than 15 years and never had a
down system
– Availability: Customers average 1 DBA per 3000 instances. Hundreds of
thousands of installs that require no administration
 Warehouse Extreme
– Columnar, In Memory: Terabytes of data per server, cluster across servers
– Concurrency: Supports thousands of concurrent connections, using standard
SQL
 Accelerator Extreme
– Query Performance: Individual queries >1500 Times Faster
– Average customer query acceleration > 100 times faster
– Transparency: No Admin, No Tuning, No Aggregation
Extreme Value means Winning Performance
© 2012 IBM Corporation
Informix Warehouse Accelerator
What is it?
How is it different?
The Informix Warehouse Accelerator (IWA) is
 Performance.
an In-Memory Columnar database that
provides responses to queries in seconds
that normally take hours or days. IWA is
workload optimized, appliance-like, and
enables the integration of business insights
into operational processes
 Concurrency:
Unprecedented response
times to enable 'train of thought' analysis
often blocked by poor query performance.
Supports thousands of
user connections to enable Smart
Corporate Dashboards, and Real Time
Applications
 Integration. Connects to IDS, with no
Application updates required.
 Transparency. applications connected to
IDS, are entirely unaware of IUWE
 Simplified administration. appliance-like
to drive winning strategies.
hands-free operations, eliminating
database tuning tasks
Analytics at the Speed of Thought!
© 2012 IBM Corporation
What BI Used to Look Like
Client Apps
BI Queries
Data Warehouse Server
Data Warehouses
Are great at storing enterprise data
BI Tool
Are expensive to implement and maintain
Support a few long running queries
© 2012 IBM Corporation
What BI Looks Like Now with IWA
Client Apps
Data Warehouse Server
BI Queries
IWA Server
IWA retains some or all of the DW data in memory
IWA accelerates complex queries, up to 1500X
BI Tool
IWA provides all of the capabilities of Informix,
including supporting a large number of
concurrent users
IWA requires no Admin
© 2012 IBM Corporation
64-bit processor
RAM in TB
Number of
Occurrences
Informix Warehouse Accelerator
Frequency
Partitioning
Rare
values
Common
Values
…
…
11111
0
01001
0
…
…
& 1111
0
==
0
1110
Compressed Predicate Evaluation
A1 D1 G1
A2 D2 G2
A3 D3 G3
A4 D4 G4
SIMD
© 2012 IBM Corporation
Simplicity, Flexibility, Choice
IBM Data Warehouse & Analytics Solutions
IBM
Netezza
IBM
Smart Analytics System
IBM
InfoSphere Warehouse
IBM Informix Warehouse
True Appliance
Flexible Integrated System
Custom Solution
Warehouse Accelerators
Information Management Portfolio
(Information Server, MDM, Streams, etc)
Simplicity
The right mix of simplicity and flexibility
Flexibility
© 2012 IBM Corporation
IWA Product Summary for 2011
Milestones:
Key Product Characteristics:
-Initial Product Launch of IUWE
at end of Q1 2011
-Only IBM Information Management
offering for in-memory columnar
database designed for warehousing
and analytics
-Added IGWE at end of Q3 2011
-Exceeded an aggressive sales
target in its 1st year
-Deploys on commodity Linux-Intel
hardware with IDS running mixedworkloads
-Transparency of queries from BI tools
-Customers in 4 different
continents across multiple
industries
-Extreme speed (e.g. 100x) with no
administration and tuning, e.g.
indexes, partitioning, summary
tables, cubes, etc.
-Competitive pricing, especially for SMB
customers
© Copyright IBM Corporation, 2008
© 2012 IBM Corporation
IWA Customer Summary for 2011
Customer Profile:
• Customers in Europe, Latin America, U.S. and Africa
• Spans different industries such as Retail, Insurance,
Transportation/Logistics, and Public Sector
• Strong partner participation resulting in 70% of deals
• Partner solutions based on IWA
• Customers with existing warehouse deployment and new
deployments
• Existing IDS customers and new customers
• Beating competition in performance and much lower cost of
ownership including Teradata, SQL Server, Greenplum and
Vectorwise
© Copyright IBM Corporation, 2008
© 2012 IBM Corporation
Informix Warehouse Offerings
Ultimate Warehouse Edition
(IUWE)
Growth Warehouse Edition
(IGWE)
*High-End
*Mid-Range
Fully Featured
Includes IWA & Storage
Optimization/Compression
Includes IWA
Unlimited scalability
Informix: 16 cores, 16GB RAM max
IWA: 16 cores, 48GB RAM max
4 64-bit Platforms;
IWA runs on Linux-Intel 64
Informix: 4 64-bit Platforms;
IWA runs on Linux-Intel 64
© 2012 IBM Corporation
IWA Accelerating
Feature Improvements Released:
 Workload Analyzer – Designs your Mart based on your Queries
 Locales Support – WW language support
 Data Currency – Keep IWA running, while loading data
---------------------------------------------------------------------------------------------More in 2012:
 Clustering – Spread Data over Multiple Nodes, for Speed and Scale
 Incremental Partition Refreshes – Only Refresh the Deltas
 Support FlexGrid configurations – Run IWA from a Secondary
 Further Integration with Cognos and other BI tools
© 2012 IBM Corporation
Informix Genero
Go To Market Tips and Update from the lab
Doug Dailey,
Informix Genero Product Management
© 2012 IBM Corporation
From Character-based to Experience-based ….
Desktop Clients
Web Browser
Linux
Mobile Devices
Cloud
28
© 2012 IBM Corporation
Latest News for Informix Genero
 Informix Genero v2.40 was announced on March 6th
 90-day evaluation software available for download
 Developer Certification Exam is now available
 Education & Training orderable via ibm.com in the United States
 Delivering enablement sessions:
 Paris, France
 Malaysia
 Mexico City, Mexico
 Bogota, Colombia
 Miami, FL
© 2012 IBM Corporation
Business Partners are Selling Informix Genero
 Differentiate through main value statements
Single code stream, one binary, many platforms and different deployments
No license manager, IBM portfolio, open database interface, no re-writes!
 Deals and deal sizes – IBM expects a much larger footprint in 2012
 Where is the product selling?
 What types of opportunities are there?
• Feedback from partners is good in that there are a lot of opportunities to work Genero into IBM deals
• Services opportunities are there for migrations & consulting services (IBM needs your help)
• Net new development (cost of development compared to Java and .NET)
• CRM applications abound in 4GL; great opportunities to migrate
• OTM campaigns should generate some leads; contact Gary Proctor for these
• The Cloud. There is a lot of emphasis on virtualized appliances and private and public clouds
 Some Keys to selling
 Demonstrating the value
 Proof of Concepts – 1 to 2 screens and a report. Keep it short & sweet!
 Sizing - Typically 1:1. Web is best suited for PVU or Socket
 Finding the right metrics – Socket pricing on Growth is the best $value
 Skills – Work to schedule an enablement session and grow skills
© 2012 IBM Corporation
What’s New in Informix Genero?
 Language enhancements
 Improved Web Performance & Rendering via HTML5
 Improved Studio ergonomics
–Genero Web client support
–Business Application Modeller
–Application Generator
–Database Manager
–Workspaces
 Report Writer
 Business Application Modeller enhancements
 Database Manager, Project Manager, Source Code
Manager, etc.
© 2012 IBM Corporation
Language Enhancements
• SQL – END SQL blocks
• SQL type LVARCHAR in DDL
• IIF and NVL SQL operators
• IF NOT EXISTS and IF EXISTS
• CASE expressions
• Select SKIP, FIRST, MIDDLE, LIMIT
• Savepoints and Rollback to Savepoints
• DISPLAY ARRAY list modification triggers
• Built-in find in DISPLAY ARRAY and INPUT ARRAY
• Built-in seek in DISPLAY ARRAY
• Aggregate fields for table summary line
• Short-circuit evaluation option
© 2012 IBM Corporation
Web Performance and Capabilities
Genero Web Performance
 Less memory consumed for GWC rendering
 Less data traffic for tables and windows
 Better stack management in threads
Genero Web Capabilities
 MS Silverlight “full” theme support and HTML5
 Support for cookies
 Support for SOAP 1.2 and SOAP fault
 Support for WS-Addressing 1.0
 Support for “stateful” services
 API and settings improvements for encryption, network
and security
© 2012 IBM Corporation
MS Silverlight Improvements and HTML5 Introduction
 GDC features supported
 Tables & frozen columns
settings
 Decoration styles
 RichText
 Download window
 Type-ahead support
 Basic 4GL feature set
 Desktop Client look/feel
 Type-ahead
 Ability to work disconnected
 iPad® & iPhone ®
© 2012 IBM Corporation
Genero Report Writer
 New output formats for 2007/2010 Excel and Word (.xlsx and .rtf)
 Datamatrix bar codes
– encode text and binary
– encode up to 1558 code words
 Support for hyperlinks (mailto, external and local sources)
 New gzip compression of data works with the Desktop Client
 Now encodes .jpg images in PDF files
 Preview & printing of all diagram types
(sequence, component, dependency, etc.)
© 2012 IBM Corporation
Business Application Modeling
Create applications from a model not from scratch!
1. Model driven approach to
generate business logic,
instead of writing from
scratch!
2. Design database, forms,
BAM diagrams to define the
workflow of your application
3. Generate code for reports
and base templates
4. Generic demo included
5. Great for CRUD apps and
Experts with customized
needs
6. Great tool for prototyping
Apps for customers
© 2012 IBM Corporation
What are Your Next Steps
 Download Informix Genero v2.40 evaluation software
https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=sw
g-in-genero&S_PKG=dl&lang=en_US&cp=UTF-8
 Attend the IIUG Conference in San Diego, CA (April 22-25)
Genero Track with 14 sessions
 Sign-up for the Genero Boot Camp at the IBM La Jolla Facility (April 26th)
http://ibm-informix.eventbrite.com/
 Ask your IBM representative about scheduling an Enablement Session
 Keep your eyes open for an upcoming PoT on Informix Genero
Similar to what is now available for IWA including a demo platform for sellers
© 2012 IBM Corporation
Informix Genero Links
 Informix Genero – What’s New info in each User Guide
http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.pr
ognode.doc%2Fgenero.htm
 Download Informix Genero Evaluation Software
https://www14.software.ibm.com/webapp/iwm/web/reg/download.do?source=swg-ingenero&S_PKG=dl&lang=en_US&cp=UTF-8
 Informix Genero Developer Certification Exam
http://www-03.ibm.com/certify/tests/edu559.shtml
 Informix Genero Education & Training
http://www304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_search&s
ortBy=5&searchType=1&sortDirection=9&includeNotScheduled=15&rowStart=0&row
sToReturn=20&maxSearchResults=200&language=en&country=us&searchString=Ge
nero
 Informix Genero System Requirements
http://www-01.ibm.com/support/docview.wss?uid=swg27020985
 Informix Genero YouTube Channel
http://www.youtube.com/user/IBMInformixGenero
© 2012 IBM Corporation
Marketing Collateral Update
Sapna Muralikrishnan
Informix Channel Marketing
© 2012 IBM Corporation
3% - 20% Incremental
Payout Opportunity
Up To Double SVI Competitive Incentive
for Approved Competitive
for Information Management Software
Displacement Deals!
Sell Only
Identify and Sell
Enterprise End User
With Customer Reference
5% standard SVI fee
10% standard SVI fee
5% incremental competitive incentive
10% incremental competitive incentive
10% SVI Fees Total
20% SVI Fees Total
General Business End User
10% standard SVI fee
20% standard SVI fee
10% incremental competitive incentive
20% incremental competitive incentive
20% SVI fees Total
40% SVI Fees Total
Enterprise End User
Without Customer Reference
5% standard SVI fee
10% standard SVI fee
3% incremental competitive incentive
6% incremental competitive incentive
8% SVI Fees Total
Total 16% SVI Fees
General Business End User
10% standard SVI fee
20% standard SVI fee
6% incremental competitive incentive
12% incremental competitive incentive
16% SVI fees Total
32% SVI Fees
© 2012 IBM Corporation
Blue / Blue
Element 1: “Sell It – Get It”
Build loyalty with System X BPs by leveraging SW
SWG
New incentive for selling IBM HW and SW on a single client order
High
Volume
High End
BladeCe
nter
Stora
ge
x3650 - 2
socket
X3850 X5 4
socket
HS22
DS35
00
X3550 - 2
socket
X3690 X5 2
socket
HS22V
V700
0
Open
Authorized
All
Brand Selected
Target Partners
X3630 - 2
socket
HX5
WebSphere, DB2
Cognos
VAD
HW BPs as primary target
No changes to product authorization requirements
BP must resell both HW and SW fulfillment on a client order
BP
HW+SW
Incentive: Rebate
Incentive:
5% of HW, 15% of SW – VAD/BP Split: 25%/75%
Minimum order:
$50K USD
Maximum size:
None
Order content ratio requirement: 30% minimum HW or SW contribution per order
Client
e.g.: $100K client deal - HW or SW content cannot be less than 30K individually
If less, payment capped at 30% ratio rule
Customer set: All customer sets, (IA: still under review), no ELA accounts
41
IBM Confidential
© 2012 IBM Corporation
Blue / Blue
Sell It – Get It
Open Products: All
Authorized Products:
Runtime
DB2
Informix
InfoSphere Warehouse
Solution Bundle
Solution
Bundles
SWG Brands have other eligible
products and solution bundles
Ser
ver
x or
Life Cycle Management p
x or
Information Integration p
Data Warehousing & x or
Analytics p
x or
Big Data Analytics p
42
Stora
ge
SWG
Multiple Optim Products
Multiple InfoSphere Products
Multiple Warehousing Products
InfoSphere War
Multiple Big Data Products
IBM Confidential
© 2012 IBM Corporation
Discover Informix Event-in-a-Box
A complete kit for business partners to run their own Informix
event
 New graphics
 New invitations
 New presentations focusing
on key plays
 Updated offers
 Updated videos
https://www-304.ibm.com/partnerworld/wps/servlet/mem/ContentHandler/D192626G32869F18
© 2012 IBM Corporation
Informix Business Partner Portal
One-stop-clicking to Informix resources
http://tinyurl.com/Informix-BP-Enablement-Site
© 2012 IBM Corporation
Information Management Industry Templates
Create effective industry collateral at low cost
What is available?
• 4 page Industry Solution Briefs that provide:
– IBM consistent industry messaging
– IBM Smarter Planet look and feel
– Easy to insert the business benefits of the IBM Products
integrated in partner solutions
– Partner logos, description of the partner solution and partner
contact information
– Create a solution brief in under an hour from start to finish at
no-cost
– $4,000 savings compared to development of a custom 4 page
solution brief using an external marketing agency
• Industry Business Partner and IBM Event Invitations
– Create HTML event invitations at no-cost for your joint IBM
events
– $700 savings compared to the standard development charges
from an external marketing agency
https://www.ibm.com/partnerworld/mem/session.jsp?vendor=ibm_pw_pitney_bowes
© 2012 IBM Corporation
Information Management Solution Portal
An interactive web site designed to showcase business partners’
solutions
 Each business partner receives their own web page which can span across industries,
products, and programs.
 The web page contains the company contact information and logo, solution
information, a resources section (whitepapers, downloads, etc), a news and press
release section, as well as quotes from the partner and their customers.
 The site is completely partner driven. Partners are given their own login account so
that they can edit their pages at any time!
http://www.ibm.com/developerworks/wikis/display/im/Solution+Portal
© 2012 IBM Corporation
Information Management Learner Portal
Self-paced online access to Bootcamp content
Access is available to registered IBM business partners only.
To view access code required for user ID registration on the IM Learner Portal, visit:
https://www-304.ibm.com/jct01005c/partnerworld/mem/pat/pat_sw_im_learnerportal_access.html
(Viewable for registered IBM PartnerWorld member only)
Register for a user ID on the IM Learner Portal at: http://eb90.elearn.ihost.com/wps/portal/ibm
Login to the IM Learner Portal using the newly registered user ID.
All bootcamp presentations and labs are hosted in a modular, indexed format so that users can
directly access the product features and associated contents that interest them.
For questions on IM bootcamps content available on
the IM Learner Portal, please contact
[email protected]
■
47
© 2012 IBM Corporation
The New Discover Informix Sales Kit
https://www-304.ibm.com/partnerworld/wps/servlet/mem/ContentHandler/D414681T43504D26
48
© 2012 IBM Corporation
Free Classroom and e-Learning Training!
■
Invite Clients to register for an upcoming bootcamp by visiting the IM
Bootcamp Wiki: http://www.ibm.com/developerworks/data/bootcamps
(CONFIRMED bootcamps will have online registration link available)
■
If a required bootcamp isn't available in your region, and there is
enough demand to organize an event, email [email protected] to
request for a bootcamp
–
■
Use the IM Learner Portal for self-paced online access to the bootcamp
materials (available to IBM PartnerWorld members only)
–

49
Provide details such as: Name of Workshop, Time range of the event
https://www304.ibm.com/jct01005c/partnerworld/mem/pat/pat_sw_im_learnerportal_access.html
For any Informix questions send an email to [email protected]
© 2012 IBM Corporation
Just over 4 weeks until the IIUG Informix Conference!
Soon airline ticket prices will start to rise and the hotel will
sell out. Get registered now!
Don’t miss the premier Informix event of the year with 100+ technical sessions, including two
new tracks this year! There will be an IBM Business track to learn about other IBM products.
And, a track on Genero – the future of 4GL.
Check out the entire conference, including the sessions, keynotes, tutorials, and more at
http://www.iiug.org/conf. Or, go to https://www.iiug.org/conf/2012/iiug/register.php to register. Act
before midnight April 15, 2012 (Eastern USA time) and receive a special discount. Use the Registration
code “SAPNA” and you will save $100 off the conference registration price!
See you in San Diego!
Business Partner Online Collaboration Forum at IIUG
Collaborate with other business partners in a private forum
Email
[email protected] to sign up
© 2012 IBM Corporation
Informix Marketing Resources for Business Partners
 UPDATED! Informix Quick Reference Tool
http://tinyurl.com/Informix-BP-Enablement-Site
 Informix 11.7 Partner Playbook
https://www.ibm.com/partnerworld/wps/servlet/ContentHandler/D414681T43504D26
 Informix Seminar-In-A-Box
https://www.ibm.com/partnerworld/wps/servlet/ContentHandler/D414681T43504D26
 Just-Push-Go Informix 11.7 Campaign
http://www.ibm.com/partnerworld/wps/servlet/ContentHandler/justpushgo
 IBM Co-Marketing Center
https://www.ibm.com/partnerworld/mem/session.jsp?vendor=ibm_pw_pitney_bowes
 Data Management for Business Analytics MSV Blueprint
http://public.dhe.ibm.com/partnerworld/pub/smb/blueprints/data_management_for_business_analytics_blueprint.pdf
 Information Management Industry Templates
https://www.ibm.com/partnerworld/mem/session.jsp?vendor=ibm_pw_pitney_bowes
 Information Management Solution Portal
http://www.ibm.com/developerworks/wikis/display/im/Solution+Portal
 Informix Bootcamps
http://www.ibm.com/developerworks/data/bootcamps
 Discover Informix Sales Kit
https://www-304.ibm.com/partnerworld/wps/servlet/mem/ContentHandler/D414681T43504D26
52
© 2012 IBM Corporation
53
© 2012 IBM Corporation
APPENDIX
© 2012 IBM Corporation
Informix Smarter Case Studies
© 2012 IBM Corporation
Smarter Gaming
Game Show Network meets growing user demand and enhances revenue
with around-the-clock game availability
What’s smart?
• High performance for tens of thousands of
players per day enjoying 750,000 games
per day with a single DBA
• Projected 50-percent increase in analytics
to match players based on similar skilllevels and to prevent fraud
Smarter Business Outcomes
• No unplanned downtime for past two
years; avoidance of planned downtime
• Avoidance of $100,000 expenditure for
new server capacity
“The Flexible Grid feature of Informix enables us to perform rolling upgrades without any outages,
so players can go on playing with no interruption and no impact on our revenue. That’s worth its
weight in gold.”
~ Susan Marciano, Vice President of Technical Operations, Game Show Network
© 2012 IBM Corporation
Finance – Banking with Informix
Banking
Business Challenge
Banking solution consists of personal banking, ATM, investment
banking and mortgage applications
Additionally looking to grow banking locations and make
data available locally , local offices have different h/w
Central Data
Today apps running currently at both branches and regional
centers run against a centralized database at a central location
Want to add failover. Failover has to be smooth and
transparent
Solution
Regional Centers
Regional centers additionally have investment banking and
mortgage applications
Informix
connection
Manager
Primary SDS 1 SDS 2
Currently experiencing high traffic at the central location.
Utilize Connection Manager to distribute peak loads
to regional instances within grid
Node 2
Node 1
Shared
Disk
Shared
Disk
Central Informix DB
Deploy a 3-node Informix Flexible Grid cluster at center
with HDR failover
Deploy regional instances as SDS cluster with HDR
on current hardware.
Deploy center, regional and branch as Flex Grid nodes
HDR
Regional Informix DB
HDR
Node 3
Local Bank
Informix DB
© 2012 IBM Corporation
Insurance with Informix
Insurance Field Offices
Business Challenge
Customized databases that provide their specific insurance claim
processing and financial data and no more, replicated to call support
centers for central coordination
When product attributes change or a new table is added,
changes have to be rolled out easily to all field offices and call
support centers (CSC)
CSCs need to operate 24x7, for millions of mobile phone
users, wanting immediate response
Call Support Centers
Decentralized databases that are located geographically close to
mobile user customers and providing high performance accident
claims entry and claim query look up services, replicated to insurance
field support office and corporate office for centralized coordination
When upgrades are done, operations that are 24x7
should not be disrupted
Solution
Distribution Centers
Merchandise to stores arrive from DCs. Goods come from local
suppliers as well as overseas
Deploy Informix HA with CSCs
Corporate Office
Detailed and Summarized Claims Processing database for centralized
control.
Mobile Customers
Deploy Field Office and Call Support Centers as Informix
Flexible Grid nodes. Use Grid DDL replication to automatically
propagate changes to agents and mobile customers
Use Informix Rolling Upgrade capability to perform
upgrades without disruption
Providence A, B, C, etc …
Flexible
Grid
Rolling
Upgrade
Agent Field Offices
Informix
Informix
DB
DB
Informix
Informix
DB
DB
HDR
Call Support Centers
Corporate Office
© 2012 IBM Corporation
Government with Informix
Tax Services for Citizens
Business Challenge
Tax services consist of tax registration, payments and tax
information search
Providing multiple points of service locations seamlessly
disseminating and consolidating information from
regional offices. Regional offices have different h/w
Providing Quality of Service to tax payers
Certain applications such as tax payments and search
are taking too long
Want to ensure 99.999% High Availability; every
downtime event costs $500K
Regional offices and Points of Service
As part of the infrastructure Govt has negotiated PoS with
businesses in each county besides 3 regional offices for state
Consolidated Data Infrastructure
Solution
Tax information is consolidated centrally for audit and tracking
purposes
Tax
Payments
Search
New/update
Registration;
registrant lookups
Deploy Informix Flexible Grid cluster at center with SDS &
HDR failover, add failover to regional office database
Configure primary for payments, SDS/HDR node for
search
Distribute county data out to databases at regional
offices to allow local updates, lookups, consolidate
data back from regional offices
Primary SDS 1
Central
Informix DB
Distribute data to regions
Shared
Disk
Consolidate changes to
central database
Regional office
Informix DB
HDR
HDR
© 2012 IBM Corporation