IBM 7.2.1 - Manuals - manualsarea.com

Page 2 - IBM Mobile solutions-- technical overview; Message; W ebsphere MQ Everyplace; Browser; W ebsphere Everyplace; Why a relational database versus a flat file; easier application development

Device Company IBM Mobile solutions-- technical overview Application Message Message Application Data W ebsphere MQ Everyplace DB2 EveryplaceLotus Domino EveryplaceDB2 PE/W E Satellite functionality Application Data Data Browser Application Data W ebsphere Everyplace Things to think about.... Why a ...

Page 3 - Sa

OS/2 and AIX platformLow-end OLTP Multiple platform sCapacity and performanceJDBCUDTs, UDFs, LOBs SMP and MPP parallelismData Links ManagerSQLJInitial OLAP SQL DB2 for LinuxDB2 Satellite EditionEase of useEase of application developmentPerformance Integrated W arehousingIntegrated OLAPFederated data...

Page 4 - DB2 Satellite scenario; The natural extension of; IBM Pervasive Computing Vision; Any; Services

Mobile orOccasionallyConnectedSatellite System Step1 ReplicationControlInformation CorporateSystems Replicationdata Step3 Help deskqueries &commands HelpDesk DB2 ControlCenterOthers SatelliteControlDB Step2 DB2ControlServer SatelliteAdministrationCenter DB2ControlCenter Test andModelSatelliteSys...

Page 5 - Internet; DB2 Everyplace Sync connection options

DB2 Everyplace __ WHY?? increase employee productivity improve business operations with up to date information Field force automation, insurance, healthcare, retail,financial services increase customer satisfaction wireless lan integrated cellular infrared or cable to cellphone serial cable, cradle,...

Page 7 - ISVs and partners; - Siebel 7 Sales Handheld for Palm OS; Integrated with their Tivoli management environment; Field Force Automation: Gas de France

ISVs and partners DB2 Everyplace and Pervasive Computing efforts in DM followthe overall DM ISV strategy.Current partners: - Siebel 7 Sales Handheld for Palm OS - RiverRun creates integrated PvC solutions "PeopleSoft will leverage DB2 Everyplace as the local data store forPeopleSoft’s mobile app...

Page 8 - Asset Tracking: Essential Systems; Information reconciled with corporate

Healthcare: Asatte Healthcare - Mobile Patient Record Management System used inclinics Patient Info is downloaded each a.m; updated and supplementedeach day; uploaded to main database each p.m. benefits of reduced input errors, saves staff time entering doctorinformation Information is generic (weig...

Page 10 - Benefit; Component Name; DB2 Everyplace

System Monitoring/Embedded: X-Serwis Solution based on DB2 Everyplace running on embedded x86hardware and QNX Neutrino X-Serwis created a W eather reporting system based onEuropean Union standards. Required robustness and reliability for continous operation inremote locations. Benefit 100% ROI in on...

Page 11 - The DB2 Everyplace Solution; move to; DB2 Everyplace Architecture

The DB2 Everyplace Solution move to production Mobile Application Builder DB2Everyplace (Database engine) Develop Test DB2 Everyplace Sync Server DB2 UDB or JDBC or custom data sources MobileDevice Mid-tier Server Data Source DB2 Everyplace DB2 Everyplace Architecture Application Programming Interfa...

Page 12 - DB2 Everyplace Characteristics; IBM Microdrive and Compact Flash Memory support; DB2 Everyplace SQL; Supports a subset of SQL

DB2 Everyplace Characteristics RDBMS especially made for mobile devices and embedded systemsAPI's DB2 Call Level Interface (CLI) / ODBC subsetA set of C/C++ function can be called in programs to access the databaseJDBC and Java application support DBCS (double byte character set) and NLV supportEncr...

Page 13 - CREATE TABLE; create table ORDERS; ENTRY TIMESTAMP NOT NULL DEFAULT Current Timestamp,

DB2 Everyplace Characteristics CREATE TABLE with following datatypes INTEGER | SMALLINTDECIMAL (Big) CHARACTER(Smallint)VARCHAR(Smallint)BLOB(Smallint) DATETIMETIMESTAMP and options PRIMARY KEY with more than one columnreferential constraintsCHECK constraints CREATE TABLE create table ORDERS (CUSTNO...

Page 14 - DB2 Everyplace Functions; Functions supported; Sync Server Design Overview; Devices

DB2 Everyplace Functions Functions supported AVG(expression)SUM(expression)MIN(expression)MAX (expression)COUNT(expression)CONCAT(expression,expression)MOD(expression,expression)LENGTH(expression)RTRIM(expression) expression can be a literal like *column name , function , special register Sync Serve...

Page 15 - Mobile device administration center; MDAC is the tool to define all these object properties

Mobile device administration center MDAC is the tool to define all these object properties DB2 Everyplace Mobile applicationbuilder Enables rapid application prototyping and development on Palm OS withoutwriting a single line of code.Includes DB2 Everyplace sample applications (source code & pro...

Page 17 - IBM Replication Solutions for Pervasive Computing; Documentation; The End

References/resources DB2 Everyplace website http://www.ibm.com/software/data/db2/everyplace developer forum http://www.developer.ibm.com redbooks (http://www.redbooks.ibm.com) SG24-6217-00 IBM Replication Solutions for Pervasive Computing DB2 magazine http://www.db2mag.com/db_area/archives/2001/q4/z...

Page 18 - Database Edition; Database; Enterprise Edition

Package ComponentsIncluded Price DB2 Everyplace Database Edition Database 63 (US) per registered user DB2 Everyplace Enterprise Edition DatabaseSync Server 12,608 per server processor+ 94 per registereduser DB2 Everyplace Mobile ApplicationBuilder Mobile ApplicationBuilder Free Download off theW eb ...