Instruction/ maintenance manual of the product 7.2.1 IBM
Go to page of 18
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 fun.
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.
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 li.
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 .
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 increa.
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 informatio.
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.
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.
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.
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.
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.
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 P.
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.
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.
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 Ba.
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.
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.
An important point after buying a device IBM 7.2.1 (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought IBM 7.2.1 yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data IBM 7.2.1 - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, IBM 7.2.1 you will learn all the available features of the product, as well as information on its operation. The information that you get IBM 7.2.1 will certainly help you make a decision on the purchase.
If you already are a holder of IBM 7.2.1, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime IBM 7.2.1.
However, one of the most important roles played by the user manual is to help in solving problems with IBM 7.2.1. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device IBM 7.2.1 along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center