Transcript IDS Mobility on Demand - Washington Area Informix User Group

Informix User Forum 2005
Moving Forward With Informix
Mobilizing Informix Dynamic
Server Enterprise Data
Christine Normile
IDS Product Manager/IBM
Anita Chung
DB2 Everyplace Product Manager/IBM
Atlanta, Georgia
December 8-9, 2005
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
At the right time
(any time)
IDS
Delivered to the right
source
The Right
Information
Using the
appropriate
technology
At the right place
(every place)
IBM Software Group | DB2 Data Management Software
DB2 Everyplace Overview
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
“
Benefits
• Increase
Employee
Productivity
• Improve
Profitability
• Reduce
Costs
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
IBM Software Group | DB2 information management software
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..
Financial Services..
on-line financial services
wealth management
customer loyalty
insurance claims
physician practice
management
pharmaceutical sales force
automation
electronic clinical trials
hospital information systems
Utilities..
Brokerage Services..
CRM
alerts, news feeds
field worker access to information
customer account access
supply chain anywhere
machine-to-machine
June 2005
IBM Software Group | DB2 information management software
Considerations When Exploiting Enterprise Mobility
 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?
June 2005
IBM Software Group | DB2 Data Management Software
DB2 Everyplace Mobilizes Your IDS Applications
DB2 Everyplace
Database
Sales Force Productivity
Healthcare
Retail Inventory Management
IBM Software Group | DB2 Data Management Software
DB2 Everyplace Solution
IBM Software Group | DB2 Data Management Software
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/OEM—Database Edition, Express Edition, Enterprise Edition
• Free trial download available at:
– http://www14.software.ibm.com/webapp/download/product.jsp?s=p&id=JPE
N-4HNW2H
– http://www-306.ibm.com/software/data/db2/everyplace/index.html
IBM Software Group | DB2 Data Management Software
Application Development Freedom
•
•
•
•
•
•
•
•
•
•
C/C++
JDBC
.net languages
Web Services
AppForge
Metrowerks
Eclipse
WSAD
WSDD
Platform Flexibility
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
Key Autonomics Features Addressing Customer
Pain Points
Self Configuring
 Zero admin database with selfreclaiming unused space
 Guarantee data delivery to the
source database
 Automated management of DB2
functions on sync
 Intelligent defaults (out of the box)
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 Healing
 Automatic "resume" if canceled/failed
 optimized recovery of messages
 Automatic retry upon network errors
during sync
Self Protecting
 Table level encryption fordata on device
 End-to-end encryption
 Password protection with encryption
 Removable memory card support
IBM Software Group | DB2 Data Management Software
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 US$600,000 per year
IBM Software Group | DB2 Data Management Software
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 httpbased synchronization protocol.
Sync Server
Mobile user management and synchronization of enterprise
data with mobile and embedded devices
DB2 Everyplace is a small footprint relational database and
synchronization server for mobile computing and embedded devices.
IBM Software Group | DB2 information management software
Mobile and Embedded Client Platform Support
DB2 Everyplace 8.2
Oracle Lite 10g
Sybase Anywhere 9.0.2
 Palm OS
 Palm OS
 Palm OS (UltraLite only)
 Windows CE
 Windows CE
 Windows CE
 Symbian
 QNX Neutrino
 Embedded Linux
 (Blackberry/MIDP)
Sept 2005
IBM Software Group | DB2 information management software
Supported Source Databases
DB2 Everyplace 8.2
•
All DB2 UDB
•
Oracle Lite 10g
•
Sybase Anywhere 9.0.2
•
DB2 UDB (LUW only)
Informix
•
Oracle DB
•
Oracle DB
•
Microsoft SQL Server
•
Microsoft SQL Server
•
Sybase Adaptive Server
•
Sybase Adaptive Server
Oracle DB
Supported Client Databases
DB2 Everyplace 8.2
•
DB2 Everyplace
•
Cloudscape
Oracle Lite 10g
•
Oracle DB Lite
Sybase Anywhere 9.0.2
•
Sybase UltraLite, ASA
Sept 2005
IBM Software Group | DB2 Data Management Software
Enterprise Mobility Solution for IDS
Mobile Device
Sync Server
Data Source
HTTP/HTTPS
DataPropagator/JDBC
Synchronize
Replicate
 Database Engine
DB2 Everyplace
CloudScape
 Sync Client API
 Mobile Application
 DB2 Everyplace Sync Server
 Control DB
 Mirror DB
 Sync Server Servlet
 WAS/Embedded WAS
 Mobile Device
Administration Console
 Informix Dynamic Server
IBM Software Group | DB2 Data Management Software
Synchronization Objects
Group
(filter)
N
M
Subscription set
subscription
User
(filter)
Device
User
(Filter)
subscription
Adaptor:
JDBC
File
DPropR
Custom
Devices are defined when they first synchronize
IBM Software Group | DB2 Data Management Software
Single Server Architecture
Sync
DB2
Everyplace Client
WebSphere
Application
Server
Mobile Devices
Administration
Center
Informix
Dynamic
Server
Sync
Server
Administration
Data Mirroring
Clients
Mid-Tier Server
Content
Sources
IBM Software Group | DB2 Data Management Software
DB2 Everyplace Sync Connection Options
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
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.
 .
IBM Software Group | DB2 Data Management Software
JDBC subscriptions
 Database deltas are synchronized between the clients and mirror
database.
 Deltas between the mirror and source are only transferred after
replication.
IBM Software Group | DB2 Data Management Software
Upload subscriptions
 Database deltas are uploaded directly from the clients to the source
database.
IBM Software Group | DB2 Data Management Software
File subscriptions
 Files are downloaded to the clients directly from the file system.
IBM Software Group | DB2 Data Management Software
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.
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
JDBC Replication
 Source Application Data Changes
IBM Software Group | DB2 Data Management Software
JDBC Replication
 Client Application Data Changes
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
Installation – Step 1

DB2 Everyplace Installation

Installation Wizard – copies the program files to the system and
updates system registry on Windows.
IBM Software Group | DB2 Data Management Software
Installation – Step 2

DB2 Everyplace Configuration

Configuration Wizard / Command Line Utility – creates internal
control databases, updates properties files, installs and configures
embedded application server
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
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)
IBM Software Group | DB2 Data Management Software
Why DB2 Everyplace?
Immediate
Availability of Data
Minimized Cost
Increased
Productivity
Improved
Responsiveness
Increased
Effectiveness
IBM Software Group | DB2 Data Management Software
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 library:
http://www-306.ibm.com/software/data/db2/everyplace/library.html
 DB2 Everyplace forum:
http://server6.kepnet.com/cgi-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 User’s Guide
IBM Software Group | DB2 Data Management Software
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
IBM Software Group | DB2 Data Management Software
http://www.ibm.com/software/data/db2/everyplace/
Informix User Forum 2005
Moving Forward With Informix
Mobilizing Informix Dynamic
Server Enterprise Data
Christine Normile, [email protected]
Anita Chung, [email protected]
Atlanta, Georgia
December 8-9, 2005