Mobilizing Informix Dynamic Server Enterprise Data

1
Mobilizing Informix Dynamic Server Enterprise
Data
Informix User Forum 2005 Moving Forward
With Informix

• Christine Normile
• IDS Product Manager/IBM
• Anita Chung
• DB2 Everyplace Product Manager/IBM

Atlanta, Georgia
December 8-9,
2005
2
Enterprise Mobility Delivers ROI Now
Increase Productivity Same personnel, more
requests completed

• In 2004 . . .
• 625M WW Cell phone shipments
• 11.7M PDAs will be sold
• 30M total hotspot users
• 50 business laptops will have WiFi

Customer Loyalty Retention Less customer churn
with value-added services
Generate Additional Revenue More time with
customers
Increase Profitability New business models,
higher margins
3
Delivered to the right source
At the right time (any time)
IDS
The Right Information
At the right place (every place)
Using the appropriate technology
4
DB2 Everyplace Overview

• Benefits
• Increase Employee Productivity
• Improve Profitability
• Reduce Costs

Mobile database and synchronization solution that
easily integrates into existing IT environments

• Reliable and secure access to enterprise
  information anywhere, any time for mobile
  workforce
• A 250KB zero admin data store that can be easily
  synchronized with DB2, IDS and other JDBC
  compliant enterprise data sources
• Multi-platform synchronization server Support
• A scalable solution that readily integrates with
  a portfolio of wireless offerings from IBM and
  your existing IT investments
• Robust, high performance and on demand
  information management capability to mobile
  environment
• Best of breed mobile client support
• Three flexible licensing options to choose from

Outlet Explorer, powered by DB2 Everyplace,
improves the efficiency of field-based sales
representatives by at least 50 percent. But the
real benefit is the quality and reliability of
the information that is now easily accessible,
which can lead to increased profits. Wolfram
Ernst, Managing Director and Co-founder, LEAD

5
Typical Applications in Mobile Computing

• Retail..
• mobile shopping
• personal shopper
• merchandising
• retail content delivered to wireless devices
• in store employee applications

• Transportation..
• flight confirmations, rapid check-in, etc.
• airline / airport operations
• route track and trace
• rail car management

• Healthcare..
• physician practice management
• pharmaceutical sales force automation
• electronic clinical trials
• hospital information systems

• Financial Services..
• on-line financial services
• wealth management
• customer loyalty
• insurance claims
• Brokerage Services..
• CRM
• alerts, news feeds

• Utilities..
• field worker access to information
• customer account access
• supply chain anywhere
• machine-to-machine

6
Considerations When Exploiting Enterprise Mobility
Depth of analysis on characteristics can
determine level of business value capture

• Who needs Access?
• Which devices?
• Is there connectivity available?
• What application/information is needed on-site?
• How do I manage these devices?
• What level of security is required?
• How do I connect across different network
  protocols?

7
DB2 Everyplace Mobilizes Your IDS Applications
DB2 Everyplace Database
Sales Force Productivity
Healthcare

Shipping Receiving
Retail Inventory Management
Field Service
8
DB2 Everyplace Solution
9
DB2 Everyplace V8.2

• Lay the foundation for enterprise mobility on
  demand
• Complete mobile relational database and
  synchronization solution
• Best of breed mobile platform support
• Reliable and secure enterprise data access right
  from your palm
• Complements a wide range of IBM wireless and
  information management software
• Offer rapid return of investment
• Integrated, open and scalable mobile application
  development made easy Zero administration, ultra
  small footprint mobile data base
• Ship in three editions to meet the needs of
  enterprises of all sizes and ISV/OEMDatabase
  Edition, Express Edition, Enterprise Edition
• Free trial download available at
• http//www14.software.ibm.com/webapp/download/prod
  uct.jsp?spidJPEN-4HNW2H
• http//www-306.ibm.com/software/data/db2/everyplac
  e/index.html

10
Application Development Freedom

• C/C
• JDBC
• .net languages
• Web Services
• AppForge
• Metrowerks
• Eclipse
• WSAD
• WSDD
• Platform Flexibility

11
Scalable On Demand

• As business grows, so can the underlying mobile
  database and synchronization infrastructure
• Start with DB2 Everyplace Express
• Upgrade transparently to DB2 Everyplace
  Enterprise Edition
• With a Simple license key change

12
Key Autonomics Features Addressing Customer Pain
Points

• Self Configuring
• Zero admin database with self-reclaiming unused
  space
• Guarantee data delivery to the source database
• Automated management of DB2 functions on sync
• Intelligent defaults (out of the box)

• Self Healing
• Automatic "resume" if canceled/failed
• optimized recovery of messages
• Automatic retry upon network errors during sync

• Self Optimizing
• Auto-increment in Identity Column for table
  creation
• Configuration Advisor Wizard
• Automatic database REORG after synchronization
• Automatic removal of server traces, logs and
  outdated data

• Self Protecting
• Table level encryption fordata on device
• End-to-end encryption
• Password protection with encryption
• Removable memory card support

13
Reference CEMIG

• Where they started
• Legacy driven processes
• Expensive dedicated satellite link
• Technicians returning to operational bases for
  new orders

• How they changed
• Implemented DB2 Everyplace to connect field
  technicians to IDS database with service request
  data
• Dispatch service orders to 500 mobile users who
  are with equipped with handheld devices

• What they are achieving
• Improve responsiveness to service outages
• Improve customer satisfaction
• Achieve measurable ROI of US600,000 per year

14
DB2 Everyplace Components

Component
Description
Database Engine
High performance data store for managing and
using data on mobile and embedded devices
Sync Client
Sync client to communicate with the server using
an http-based synchronization protocol.
Mobile user management and synchronization of
enterprise data with mobile and embedded devices
Sync Server
DB2 Everyplace is a small footprint relational
database and synchronization server for mobile
computing and embedded devices.
15
Mobile and Embedded Client Platform Support

16
Supported Source Databases
Supported Client Databases
17
Enterprise Mobility Solution for IDS

• Database Engine
• DB2 Everyplace
• CloudScape
• Sync Client API
• Mobile Application

• Informix Dynamic Server

• DB2 Everyplace Sync Server
• Control DB
• Mirror DB
• Sync Server Servlet
• WAS/Embedded WAS
• Mobile DeviceAdministration Console

18
Synchronization Objects
N
M

• Adaptor
• JDBC
• File
• DPropR
• Custom

Devices are defined when they first synchronize
19
Single Server Architecture
Clients
Content Sources
Mid-Tier Server
20
DB2 Everyplace Sync Connection Options
21
Sync Server and Client Overview

• Centralized administration
• Mobile Devices Administration Center GUI (MDAC)
• Zero administration on devices
• Manage table definitions, constraints, and
  indexes
• Vertical and horizontal partitioning of data
• Control distribution of data, files, and
  applications
• Grouping of subscriptions
• Access control for device users based on
  privileges

22
Sync Server and Client Overview

• Message protocol utilizes WAP binary XML for
  compression
• Automatic upgrade distribution of database and
  sync client engine software without user
  intervention
• Security
• Authentication
• MD5 authentication for standalone
• LDAP authentication with WEA
• Communication data encryption
• 56-bit and 128-bit DES for standalone
• SSL with WEA
• Local data encryption on devices setup through
  central administration

23
DB2 Everyplace Subscriptions for IDS

• A replication subscription provides
  specifications for how the information in a
  source system (an enterprise server) is to be
  synchronized with a target system (the mobile
  device).
• JDBC subscriptions provide users with access to
  data in source tables on a data source with a
  JDBC interface, including Oracle, DB2, Microsoft
  SQL Server, Informix, Sybase, and Lotus Domino.
• Upload subscriptions only allows the user to
  directly insert rows into a table on a source
  database. Related tables on the mobile devices
  are not refreshed during synchronization.
• File subscriptions allow replication of any type
  of file stored at the source server and are not
  bi-directional.
• .

24
JDBC subscriptions

• Database deltas are synchronized between the
  clients and mirror database.
• Deltas between the mirror and source are only
  transferred after replication.

25
Upload subscriptions

• Database deltas are uploaded directly from the
  clients to the source database.

26
File subscriptions

• Files are downloaded to the clients directly from
  the file system.

27
Database Server

• DB2 Everyplace uses several metadata tables to
  maintain information about its internal
  structure.
• The performance of relational databases will
  typically decline as tables grow unless they are
  periodically reorganized.
• Customer data should reside in backend servers on
  separate systems from the DB2 Everyplace system
  for maximum performance.

28
Database Server (continued)

• Database servers are required for core
  functionality
• DSYCTLDB control database
• DSYMSGDB message store database
• DSYCSTAT client statistics
• MIRROR mirror databases
• SOURCE source databases

29
JDBC Replication

• Source Application Data Changes

30
JDBC Replication

• Client Application Data Changes

31
Custom Logic

• Allows application to customize behavior of
  synchronization and replication.
• Custom Logic provides a mechanism for
• Real-time synchronization and replication
• Primary key substitution
• Customize conflict resolution
• Callbacks available for
• start/end of database replication
• start/end of table replication or synchronization
  
• changed row of table during replication or
  synchronizationJavadocs
• API documentation available in
• DSYINSTDIR/doc/lang/javadoc/CustomLogic

32
Installation

• DB2 Everyplace Setup Launchpad Starting point
  for end users.
• View Install Notes
• View Release Notes
• Install Product
• Exit Launchpad
• Installation is a two step process install and
  configure

33
Installation Step 1

• DB2 Everyplace Installation
• Installation Wizard copies the program files to
  the system and updates system registry on Windows.

34
Installation Step 2

• DB2 Everyplace Configuration
• Configuration Wizard / Command Line Utility
  creates internal control databases, updates
  properties files, installs and configures
  embedded application server

35
Best Practice

• DB2e
• Create indices for the most common queries
• Minimize the number of records needed on the
  client (filter)
• Synchronize often when you make client changes
• Subscriptions
• Subscriptions with different replication needs
  should go to different mirrors
• Include as many tables as possible in a
  subscription
• Use long replication cycle
• Use upload subscriptions if possible for
  performance
• Inserts directly on the source
• Minimize the use of complex filters

36
Best Practice (continue)

• Design solution with no or minimum conflicts
• Try to separate static and dynamic data in your
  design
• Client communication
• Adjust the timeout value for the client (default
  30 sec)
• Increase HTTP I/O timeout on WAS and HTTP
  Server(default 5 sec, use 30-60 sec)

37
Why DB2 Everyplace?
Immediate Availability of Data
Minimized Cost
Improved Responsiveness
Increased Productivity
Increased Effectiveness
38
References

• IDS Mobility on Demand
• http//www-306.ibm.com/software/data/informix/ids/
  mobility/
• DB2 Everyplace external website
  http//www.ibm.com/software/data/db2/everyplace
• DB2 Everyplace libraryhttp//www-306.ibm.com/sof
  tware/data/db2/everyplace/library.html
• DB2 Everyplace forumhttp//server6.kepnet.com/cg
  i-bin/db2www/db2everyplaceforum.mac/main
• DB2 Everyplace documentation
• IBM DB2 Everyplace Sync Server Administration
  Guide
• IBM DB2 Everyplace Sync Server Administration
  Guide
• IBM DB2 Everyplace Installation and Users Guide

39
Get mobilized now

• Leverage your existing Informix Dynamic Server
  based applications to mobilize your workforce
• Purchase Informix Dynamic Server v10.0 or Upgrade
  to IDS v10.0
• Contact your local IBM Sales Representative or
  Business Partner for the latest offers
• Or log on to www.ibm.com/informix/ids/mobility
  for more information

40
http//www.ibm.com/software/data/db2/everyplace/
41
Mobilizing Informix Dynamic Server Enterprise
Data
Informix User Forum 2005 Moving Forward
With Informix

• Christine Normile, Christine.Normile_at_us.ibm.com
• Anita Chung, AChung_at_us.ibm.com

Atlanta, Georgia
December 8-9,
2005