Pocket PC DB2e Synchronization Operation

(Performed on WEA R4.30)

Create DB2e Group and Users
Mobile Devices Administration Center Operations
Connect and Synchronize Pocket PC

The exact behaviour of your installation might vary somewhat from what is described in this page, but in general, it should work.

Note: You can only have one PPC application connected to the PPC DB2 database. If you have the DB2e Command :Line Processor (CLP) running and you try to synchronize your device database, it will probably fail.

Create DB2e Group and Users

Create 2 new groups and a user and add the user to both groups using the following steps.

1) Logon to the wps/portal as "wpsadmin" with password "wpsadmin".

2) Select the "Portal Administration" portlet group, in the left frame under the "Users and Groups" option, and then select "Manage Groups".

3) Create a group called "SyncGroup" (In the "Group Name" field, enter the value "SyncGroup", then click "Create group").

4) Create a group called "DB2eTesting" (In the "Group Name" field, enter the value "DB2eTesting", then click "Create group". Note, you can use any name, but it must be preceded with "DB2e")..

5) Create a user called "db2euser1", and add this user to both groups

            a) In the left frame select the "Manage Users" option, and in the "Manage Users" frame, click "Create new user".
            b) In the "User ID", "Password", "Confirm Password", "First Name", "Last Name" fields enter "db2euser1".
            c) In the "Email" field enter "db2euser1@us.ibm.com", then click "OK".

6) In the left frame under the "Users and Groups" option, select the "Manage Groups" option, and in the "Search for groups" field, enter "*", and click "Get Groups"

7) In the "Manage User Groups" frame, in the "User Groups" section, select "DB2eTesting" and click "Membership".

7) In the "Add users to group" "Name" field, enter "*" and click "Go".

8) In the "Search Results" section, select "db2euser1" and click "Add to group", then click "OK".

9) Back in the "Manage User Groups" panel, in the "User Groups" section, select "Syncgroup" and click "Membership".

10) In the "Add users to group" "Name" field, enter "*" and click "Go".

11) In the "Search Results" section, select "db2euser1" and click "Add to group", then click "OK".

12) At this point you should be able to confirm that DB2e is installed by accessing the URL "http://wea2aix8.raleigh.ibm.com/db2e/db2erdb", where "wea2aix8" should be replaced by your WAS/WEA machine name. Logon using the userid you just created ("db2euser1") (or "wpsadmin"). Information similar to the following should be displayed:

MDSSServlet Information

 MDSSServlet loaded at 04/01/03 16:30:36:134 EST
 DB2 Everyplace SyncServer 8.1.2 WEA20030326
 The current time is 04/02/03 09:46:20:798 EST
 
 
 
 

Mobile Devices Administration Center Operations

DB2 Subscription and Subscription Set Configuration

On Windows

From the MS "Start", "Programs", "IBM Everyplace Synchronization Server", click on "Launch MDAC". The MDAC GUI will appear. Go to step 4 below.
 

On AIX

1) From the machine you have installed DB2e on (i.e. "wea2aix3"), from the command line execute the command "xhost  +".

2) Switch users to you DB2 instance administrator user (i.e. if your instance administratore is "wasinst", "su - wasinst" password = "wasinst", OR, "su - db2inst1", password = "ibmdb2" if appropriate),  and execute the command "unset JAVA_HOME". You must then export your display to the machine you wish to display the Mobile Device Administration Console (MDAC) GUI on. To export your display to allow the (MDAC) to run on this machine type the command "export DISPLAY=wea2aix3.raleigh.ibm.com:0.0" (where your display machine is "wea2aix3").

3) Change directories to "/home/wasinst/db2everyplace81/Server/bin" (or "/home/db2inst1" if appropriate), and execute the command "./dsyadmin.sh".

4) The DB2 GUI will appear as well as the DB2e MDAC GUI. A pop-up for the DB2 GUI ("Attach - LOOPBACK") might appear, if so logon using the ID/Password "wasinst" (or "db2inst1"/"ibmdb2"  if appropriate) and press "OK". Afterwards, a "WPS LDAP Logon" dialog box will appear, and in the "User ID" and "Password" fields enter "wpsadmin" (might already be filled in), and in the "Sync group" field enter "SyncGroup" (might already be filled in), then press "OK" (at this point you should be able to click on "Groups" and "Users", and see the group and user you added to the Portal server in the Create DB2e Group and Users section above.)

5) In the MDAC, select "Subscriptions", right mouse click and select "Create", "Table subscription", and select "JDBC subscription". A "Create JDBC Subscription" dialog box will appear.

6) In the "Identification" tab, in the "Name" field, enter "Nursing", in the "Description" field enter "Nursing the VNURSE DB", and in the "Adapter" field, accept the default "DSYJDBC - Default DB2 Everyplace JDBC adapter".

7) In the "Source" tab, for the "Database URL", click on the "..." icon.

8) In the "Select Local DB2 Source Database", select "VNURSE", then click "OK".

9) In the Source "User ID" field, enter "wasinst" (or "db2inst1" if appropriate), in the "Password" and "Verify password" fields enter "wasinst" (or "ibmdb2"  if appropriate) (the "Driver" should be "IBM DB2 UDB local").

10) Click the "Test connection" button to confirm connectivity to the database, and click "Close" in the resulting pop-up stating your connection was successful (assuming it was!).

11) In the "Mirror" tab, for the "Database URL", click on the "..." icon.

12) In the "Select Local DB2 Mirror Database", select "M_VNURSE", then click "OK".

13) In the Mirror "User ID" field, enter "wasinst" (or "db2inst1" if appropriate), in the "Password" and "Verify password" fields enter "wasinst" (or "ibmdb2"  if appropriate) (the "Driver" should be "IBM DB2 UDB local").

14) Click the "Test connection" button to confirm connectivity to the database, and click "Close" in the resulting pop-up stating your connection was successful (assuming it was!).

15) Select the "Identification" tab, and then select the "Define subscription" button on that panel.

 16) In the "Define Replication Subscription" dialog box, click "Add" (then wait several seconds).

17) In the "Add Table" dialog box, select "DSYSAMPLE.VNCONTACT", and click "Add".

18) Perform the above step for the "DSYSAMPLE.VNMEDICALRECORD", the "DSYSAMPLE.VNPERSON", "DSYSAMPLE.VNSCHEDULE", and "DSYSAMPLE.VNSIGNATURE" tables, then click "Close".

19) Back in the "Define Replication Subscription", click the "Timing" button.

20) In the "Subscription Timing" dialog box, in the "Batch window" field, enter "60" seconds, then click "OK".

21) Click "OK" to close the "Define Replication Subscription" dialog box.

22) Click "OK" in the "Create JDBC Subscription" dialog box (then wait several seconds).

23) Back in the MDAC console, select "Subscription sets", right click and select "Create".

24) In the "Create Subscription Set" dialog box, select the "Identification" tab.

25) In the "Name" field enter "NurseSet", and in the "Description" field, enter "The Nurses Subscription Set".

26) Select the "Subscriptions" tab, and in the "Available subscriptions" area, select "Nursing" and click the ">" button to add it to the "Selected Subscriptions" area, then click "OK".

27) In the MDAC, select "Groups", and in the right panel, select the DB2e group you had previously created in the Portal server ("DB2eTesting"), right click and select "Edit".

28) In the "Change Group - DB2eTesting" dialog box, select the "Subscription sets" tab, and in the "Available subscription sets" section, select "NurseSet" and click the ">" button to move to the "Selected subscription sets" section, then click "OK" in the "Change Group - DB2eTesting" dialog box.
 
 
 

Connect and Synchronize Pocket PC

This section assumes you have Hard Reset Pocket PC, performed a Microsoft Activesync Software Installation and Pocket PC Client Software Installation and are using a Bluetooth connection to the LAN (see "Pocket PC Operation" for details of these operations)
 

Synchronize your device

First Time Synchronizing
 
 

WEA 4.30 Clean PPC Install

1) Perform a "soft reset" by pressing the button on the right bottom edge with the wand (make sure you PPC is not connected to your PC via the USB cable).

2) Assure your Bluetooth connection to the LAN is functional (browse some web site)

3) From the Pocket PC, tap the Windows icon in the upper left corner and select "Everyplace Client"

4) In the "Welcome" page, tap the keyboard icon in the lower right corner, and for the "User name" and "Password" fields, enter your id/pw (i.e. "db2euser1"), and tap the "Log in" button.

5) In the "Everyplace Synchronization Server" field, enter the machine name of your Everyplace Synchronization Server is on (i.e. "wea2aix1.raleigh.ibm.com"), then click the check icon in the upper right corner of the browser.

6) In the upper left section of the web page, in the selection box, select "My settings".

7) In the resulting page, tap "Organize categories".

8) In the resulting list, for a DB2e sync, you need only select the "Database sync" option, then tap the check mark in the upper right corner of your web page.

9) In the upper left section of the web page, in the selection box, select "My settings"

10) Scroll down and tap the "Network profiles" option.

11) For the "DB2 Everyplace server", enter the machine name for your server (i.e. "wea2aix1.raleigh.ibm.com") then tap the check mark in the upper right corner of your web page.

12) In the upper left section of the web page, in the selection box, select "My tools"

13) Tap the "Database sync" option.

14) In the "iSync" window, tap the "Synchronize" button. (you might need to "Reset" the user in the MDAC)

At this point you can use the DB2e client
 

WEA 4.30 Clean DMS Client Install

This section assumes you have previously installed the DB2e Client software using DMS.

1) Perform a "soft reset" by pressing the button on the right bottom edge with the wand (make sure you PPC is not connected to your PC via the USB cable).

2) Assure your Bluetooth connection to the LAN is functional (browse some web site)

3) From the Pocket PC, tap the Windows icon in the upper left corner and select "Everyplace Client"

4) In the "Welcome" page, tap the keyboard icon in the lower right corner, and for the "User name" and "Password" fields, enter your id/pw (i.e. "dmsabuser"), and tap the "Log in" button.

5) In the upper left section of the web page, in the "My Tools" selection box, select "My settings".

6) In the resulting page, tap "Organize categories".

7) In the resulting list, for a DB2e sync, you need only select the "Database sync" option, then tap the check mark in the upper right corner of your web page.

8) In the upper left section of the web page, in the selection box, select "My settings"

9) Scroll down and tap the "Network profiles" option.

10) For the "DB2 Everyplace server", enter the machine name for your server (i.e. "wea2aix1.raleigh.ibm.com") then tap the check mark in the upper right corner of your web page.

11) In the upper left section of the web page, in the selection box, select "My tools"

12) Tap the "Database sync" option.

13) In the "iSync" panel, tap the "File" option and select the "Settings" option.

14) In the "Settings" panel, enter your DB2e userid and password (i.e. "db2euser1"), check the "Save Password" option, then tap "OK".

15) In the "iSync" window, tap the "Synchronize" button. (you might need to "Reset" the user in the MDAC). The Nursing sample database tables should now be downloaded to your device. When this is done, tap the "X" in the upper right corner of your web page, then the "X", and then the "OK".

At this point you can use the DB2e client
 
 

(WEA 421)

(perform this section once after installing sync software, if it is your first time, otherwise perform Create a New Pocket PC Profile)

1) Perform a "soft reset" by pressing the button on the right bottom edge with the wand (make sure you PPC is not connected to your PC via the USB cable).

2) (If necessary) Perform steps 7-11 in the above section "Using Bluetooth Connection".

3) From the Pocket PC, tap the Windows icon in the upper left corner and select "Everyplace Client"

4) On the PPC tap "Getting started", for the "User ID", "Password", and "Confirm Password" fields, enter a userid you previously (or will be) created in the Portal server and added to the SyncGroup and DB2eTesting groups (i.e. "db2euser1"), select to "Save password", then tap "OK" in the upper right corner  (press the keyboard icon in the lower left to invoke the keyboard, tap it again to make it go away) (Steve check this).

5) In the "Getting Started" panel "Name your new profile" field, enter a name for your profile (i.e. "Syncer"), then tap "Next".

6) In the "Getting Started: Syncer" panel "What is your WebSphere Everyplace Access Server Hostname" field, enter the hostname for your WAS/WEA machine (i.e. "wea2aix8.raleigh.ibm.com"), and tap "Next".

7) In the "Getting Started: Syncer" panel "Choose the information to refresh when using this profile", select "Database sync", and tap "Next".

8) In the "Getting Started: Syncer" panel "How do you connect to your database sync server", for the "Server Hostname", enter the hostname for your WAS/WEA machine (i.e. "wea2aix8.raleigh.ibm.com"), and for the "Target Directory", enter "\", then tap "Next".

9) In the "Getting Started: Syncer" panel "Connection Timeout", accept the defaults and tap "Next".

10) In the "Getting Started: Syncer" panel "Setup is complete...", tap "Done".

11) In the "Everyplace Client" panel tap the "Refresh now" icon, and synchronization should occur.

12) To confirm synchronization, tap "Start", "Everyplace Client", "Tools", "View log" and "Database sync" to view sync log

(Might need to "Reset" user in MDAC)

(OR)
 

Create a New Pocket PC Profile
 
 

WEA 4.21

1) On the Pocket PC 2002, tap the "Start" button, and select "Everyplace Client".

2) In the "Everyplace Client" panel, tap "Create a new profile".

3) In the "Name your new profile" field, enter a name for your profile (i.e. "Syncer"), then tap "Next".

4) In the "What is your WebSphere Everyplace Access Server Hostname" field, enter the name of your Portal Server (i.e. "wea2aix8.raleigh.ibm.com"), and tap "Next".

5) In the "Choose the information to refresh when using this profile" field, select (at least) "Database sync", then tap "Next".

6) In the "How do you connect to your database sync server" panel, the "Server Hostname" should be the same as your Portal Server, and the "Target directory" should be "\", tap "Next".

7) In the "Connection timeout" panel, accept the defaults and click "Next". You will be returned to the Everyplace Client main screen.

8) Tap "Refresh now" to begin synchronization.

9) Confirm your synchronization has succeeded by viewing the data you just downloaded. Refer to "Pocket PC Operation" for details on using PPC tools to confirm and/or change your database.