IBM 7.2.1 manual

DB2 Every place V7.2.1 - Mobile and Embedded Database and Synchronizat ion Architecture Joachim Stumpf DB2 T echnical sales support Agenda Introd uction Refere nce scenar ios Comp onents Datab ase funct ions and feat ures Sy nc a rchitectu re Administr ation Applicati on develo pment Inform ation sou rces Page 1-2[...]

Device Company IBM Mobile soluti on s-- technical overvi ew A pplic ation Message Mess age A pplic a t i on Data W ebsphe re MQ Ev er yplace DB2 Everyplace Lotus Domi no Everyplace DB2 PE/W E Satellite functionality A pplicatio n Data Data Browser A pplica tion Data W ebsp here Everyplace Things t o th ink abo ut.... Why a relational datab ase vers[...]

OS/2 a nd AIX platform Low-en d OLT P Multiple platforms Capacity an d performance JDBC UDTs, UDFs, L OBs SMP and M PP parallelism Data Links Ma nager SQLJ Initial OLA P SQL DB2 for Linux DB2 Satel lite Edition Ease of use Ease of application deve lopm ent Performance Inte grated W arehous ing Inte grated OLAP Fed erated datab ases Nativ e O LE DB [...]

Mobile or Occasionally Connected Satellite System Step1 Replication Control Information Corporate Systems Replication data Step3 Help desk queries & comma nds Help Desk DB2 Cont rol Center Others Satell ite Control DB Step2 DB2 Control Server Satellite Administ ration Center DB2 Control Center T est and Model Satellite Sy s tem Administration C[...]

DB 2 Every place _ _ WHY? ? increase emp lo ye e productivity improve business operations with up to date information Field force automatio n, insurance, healthcare, retail, financial s ervices increase customer satisfaction wirel ess lan integrate d cellu lar infrare d or cable to cellphon e seria l c ab le, cradle, or infrared to pc mode m to POT[...]

Business applicatio ns Business to Employe e Pro ductivity Field Force Automation Customer an d product information Barcode a nd p art informatio n from sc anning devices Insuranc e pol icy information Auditing in formation for quality a n d saf e ty appli cations Monitor ing of sy stem in formation Business applicatio ns Industries - Customer Rela[...]

ISVs and partners DB2 E v e ry place and Pervasi ve Computin g effo rts in DM f ollow the overall DM IS V strate gy . Current partners: - Si ebel 7 Sal es Ha ndhel d fo r Pal m OS - RiverRu n creat es integ ra ted PvC solut ions "People Sof t w il l le v erage DB2 Every place as the loca l data sto re for People Sof t’s mobile ap plications.[...]

Healthcare: Asatte Healthcare - Mo bile Patient Record Managem ent Sy s tem used in clinics Patient Info is do wn loa ded each a.m; updat ed and supplemente d each day; uploaded to main datab ase each p.m. benef its of reduced i nput erro rs, saves staff time entering doctor information Information is gener i c (weight, bp, etc) and th en customize[...]

Sales Forc e Automation Appli cation tied in wi th r etail store point of sale and Lawson accounting system DB2E database DB2E syn c ser ver DB2 UDB on W inCE/ on W inN T on AS/40 0 Comp aq IPAQ "seconds" "less t han a m inute" 1. Salesperson t akes order and ver ifies 2. Orde r forwa rde d from PDA; item in stoc k; im mediate f[...]

Sy stem Monitoring/Emb edded: X-Serwis Solution based on DB2 Everypla ce running on embedded x86 hardw are and QNX Neutr i no X-Serwi s created a W eather repo rting s y stem b ased on European Un i on sta ndards. Required robustness and reliability for continous operation in remote locations. Benefit 100% ROI in on e yea r annua l savings of US$1.[...]

The DB2 Every place Solution move to produc tion Mobile App lication Build er DB2 Ev eryplace (Database engine) Develop T est DB2 Ever yplace Sync Server DB2 UDB or JDB C or custom data sources Mobile Devi c e Mid-tier Serv er D ata Sour c e DB2 Every place DB2 Everypl ace Architecture Application Programm ing Interface CLI/ODBC J D BC SQL Compiler[...]

DB2 Everyp lace Characterist ics RDBM S esp ecially made for mobile devices and emb edded syste m s API's DB2 Call Level Interfac e (CLI) / ODBC subset A set of C /C++ function c an be called i n programs to ac cess the database JDBC and J ava applicati on support DBCS (doub le byte ch a ra cter set) and NL V suppo rt Encry ption (communicatio[...]

DB2 Everyp lace Characterist ics CREATE TABLE with following data type s INTEGER | SMAL LINT DECIMAL (B ig) CHARACTER (Sm all int) VARCHAR(S malli nt) BLOB(Smallint) DATE TIME TIMESTAMP an d options PRIMARY KEY wi th more than o ne column referen ti al co nstraints CHECK con straints CREATE T ABLE create t able ORDERS (CUST NO CHAR (6) NOT NULL, EN[...]

DB2 Everyp lace Functions Functions sup ported A VG (expression) SUM (express ion) MIN (expres s ion) MAX (ex pression) COUNT (expression) CONCA T (expr ession,expressi on) MOD (expressi on,expression) LENGTH ( expression) RTRI M (express ion) expression can be a literal like * colum n name , function , special regi s ter Sy nc Server Des ign Overv[...]

Mobile device admini s tration center MDAC is the tool to d efine all these objec t properties DB2 Everypla ce Mobile a pplic ation build er Enables rapid application proto typ in g and deve lo pmen t on Palm OS without writing a single line of code. Includes DB2 Everyplace samp l e applications (source code & project file) Page 2 9-30[...]

Robust Dev elopment environment Program mi ng inter faces supp orted DB2 Cal l Leve l Interfa ce (CLI) / ODBC s ubset Java D ataBase C onn ectivit y (JDB C) driv er for Jav a app lication s Visua l Basi c Interf ace fo r W in 32,W i nCE/Pock etPC a pplic ation deve lopm ent Included D evel oper too ls Databa se Impo rt and Ex port utilitie s Com ma[...]

References/reso urces DB2 Everyplac e webs ite http://ww w.ibm .com /sof tware/da ta/db 2/everyplac e dev eloper f orum http://ww w.devel oper.ib m.c om redbo oks (h ttp://www. redbooks. ibm .com ) SG24-62 17-00 IBM Repli cation Solu tions f or Perva sive C omputing DB2 maga zine http://www.db2m ag.com/db_ area/archive s/2001/q4/ziko poulos.shtm l [...]

Package Components Included Price DB2 Every place Database Edition Database 63 (US) per registered user DB2 Every place Enterprise Edition Database Syn c Server 12,608 per server processor + 94 per registered user DB2 Every place Mobile A pplica tion Builder Mobile Application Builder Fre e D ow nload off t he W eb Packaging & Pricing - 7.2.1 P[...]