(Performed on WEA R4.30)
Create
DB2e Group and Users
DB2
Subscription and Subscription Set Configuration
Hard
Reset Pocket PC
Microsoft
Activesync Software Installation
Pocket
PC Client Software Installation
Connect
and Synchronize Pocket PC
Pocket
PC DB2 SQL Operation
Logging
DB2e Operations
Operating
the Pocket PC
The exact behaviour of your installation might
vary somewhat from what is described in this page, but in general, it should
work.
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
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). 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.
Note: To turn on Pocket PC 2002 (PPC), press the button on the front top right.
1) First assure no one has anything useful on the device, then perform a hard reset (the hard reset is performed differently on different PPC's, for example, for the Compaq iPAQ Pocket PC, remove the device from the cradle and battery pack, hold down two bottom buttons on front of the device next to the edge while pressing the recessed button on bottom edge with wand. The display will go off. Then press the recessed button on the bottom edge with the wand. OR, when you press these three buttons, the display will not go completely off and a reset will occur)
2) As instructed, tap screen to set up Pocket PC. You will be instructed to tap it on 5 places, then to perform a "cut and paste" operation, then select the time zone ("Eastern").
3) In the "Complete" and "Expand" windows, tap the screen to continue.
(Note: these devices are not incredibly stable. You might perform the
following and it work. You might need to do a "soft reset" occasionally
and things magically start working. Soft reset is done by using the wand
to press the small recessed button on the bottom right edge using the wand.)
Microsoft Activesync Software Installation
1) From "zeitouni.raleigh.ibm.com", in the directory "PPCutilities", doubleclick the "msasync.exe" icon/file.
2) In the "Microsoft Activesync" Setup window, click "Next".
3) In the "Select Installation Folder, click "Next".
4) Connect the Pocket PC to your computer via the USB cable (DO NOT connect your Pocket PC with anything BUT the USB cable. Connecting with the serial port will cause you to come talk to Steve), then in the "Get Connected" panel, click "Next .
5) Your computer should then recognize the Pocket PC and load the appropriate driver, this will be reflected in a dialog box.
6) You might need to disconnect your Pocket PC from the dock, or even reset it (press the button on the bottom right edge), then replace in dock.
7) In the "New Partnership" "Set Up a Partnership" panel, select "Guest Partnership", then click "Next". (note, from now on, when you connect the Pocket PC to your PC this same procedure will occur).
8) After several seconds the "Microsoft Activesync" window should reflect
"Connected". Minimize this window.
Pocket PC Client Software Installation
1) From CD 7, change directories to the CD directory "\client\PPC2002", and double-click the "setup.exe" program.
2) In the "Choose Setup Language" panel, click "English" (or the language of your choice), then click "OK".
3) In the "Everyplace Client for Pocket PC" dialog box, "Welcome" panel, click "Next".
4) In the "License Agreement" panel, click "Yes".
5) In the "Choose Destination Location" panel, accept the default and click "Next".
6) In the "Select Components" panel, accept the selected defaults but also include "Lotus Mobile Notes", "DB2 Everyplace Sample Applications", and "WebSphere Micro Enviroment (Preview)" (WEAR4.21), "Sametime Connect" (WEA430), "Service Oriented Runtime (Preview)" (WEA430), and "Server Initiated Action (only Phone Edition)" (WEA430), (then click "Next".
7) In the "Start Copying Files" panel, the Components selected should include "Lotus Mobile Notes", "PIM and Email Synchronization", "DB2 Everyplace", "Offline Portal Browsing", "IBM Device Agent", "Offline Portal Forms', and "WebSphere Micro Enviroment (Preview)" (WEAR4.21), "Service Oriented Runtime (Preview)" (WEA430), and "Server Initiated Action (only Phone Edition)" (WEA430), then click "Next".
8) You will be queried by a "Installing Applications" popup if you wish to "Install "Sync Client" and other pending installations using the default application install directory", click "Yes".
9) After several seconds an "Application Downloading Complete" popup appears, reflecting you should "Please check your mobile device screen to see if additional steps are necessary to complete this installation". At the Pocket PC, the "Sync Client" should be running, requesting:
(WEA4.21) your e-mail information. Enter your Name and Email address in the appropriate fields. (i.e. "Steve Hayden", and "shayden@us.ibm.com"), then tap "OK" in the upper right corner of your Pocket PC,
OR
(WEA4.30) in the "User ID", "Password", and "Confirm Password" fields enter your Portal information (i.e. "db2euser1", from step 5 of the section above Create DB2e Group and Users), then tap the "Enter" key on the PPC keyboard. The PPC should reflect that downloading is occurring. In the next panel on the PPC, enter your name and email address (i.e. "Steve Hayden", and "shayden@us.ibm.com"), then tap the "Enter" key on the PPC keyboard. (the preceding operations might be reversed).
10) Click "OK" on the "Application Downloading Complete" pop-up on your PC.
11) In the "Everyplace Client for Pocket PC" dialog box, "InstallShield Wizard Complete" panel, click "Finish".
12) Disconnect the USB or seriral port cable from your Pocket PC to
your PC.(note: you should hear an descending tone on both devices when
disconnection occurs).
Connect and Synchronize Pocket PC
Perform one of the following ("Using Bluetooth Connection" or "Using LAN Connection") to enable connectivity to the network
Using Bluetooth Connection
The following was performed on a Pocket PC 2002. You might need to tap somewhere on the screen to continue.
1) Tap the icon in the lower right corner, and in the resulting expansion, select "Turn Radio On".
2) Tap the icon in the lower right corner, and in the resulting expansion, select "Bluetooth Manager".
(Note, the following 4 steps should only need to be executed once for the device unless it is reset or powered off)
3) In the "Bluetooth Manager" question to search for devices, tap "Yes".
4) When the search is complete, select "PicoBlueLab1", and tap "Save".
5) In the "Save the devices to following groups", select all options ("Home" and "Work") and tap "OK".
6) In the upper right corner, tap "OK", then in the "Bluetooth Manager" panel, tap the "X" in the upper right corner.
7) In the lower right corner, tap the icon and select "Bluetooth Manager".
8) Select "PicoBlueLab1", and in the lower left corner tap "Actions" and tap "Connect to LAN access using PPP".
9) A "Connecting" popup will appear and eventually hide.
10) In the upper right corner, tap "OK".
11) In the upper right corner, tap the "X" to exit Bluetooth Manager.
12) In the upper left corner, tap the Window icon and select "Internet Explorer".
13) In the lower left corner, tap "View" and select "Address Bar"
14) Click on the keyboard icon in the lower right corner and fill in a URL to test connectivity to internet, then click the green circular arrow in the upper right corner of IE. If your URL downloads successfully, you have successfully connected to Bluetooth and to Al Gore's internet.
b) Using LAN Connection
Steve, fill in this blank!
Synchronize your device
First Time Synchronizing
WEA 4.30
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) 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 your Everyplace Synchronization Server is on (i.e. "wea2aix7.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. "wea2aix7.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 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.
1) On the Pocket PC, tap "Start", "Programs", and then tap the "Db2 Everyplace Sample" icon.
2) In the "DB2 Everyplace Sample" panel, tap the "Db2eclp" icon.
3) In the top entry field of the "DB2 Everyplace CLP" panel, enter sql statements, then tap "Execute" to perform the SQL statement (i.e "list tables", "select * from vmcontact"), etc.).
4) To drop a table, simply type "drop table yourtablename" (where "thetablename" is the name of the table you wish to drop) and tap the "Execute" button.
5) To list contents of a table, simply type "select
* from thetablename" (where "thetablename" is the name of the table you
wish to view), and tap the "Execute" button.
To insert a row (an example)
1) From the "DB2 Everyplace CLP" panel, "INSERT INTO VNCONTACT (PATIENTID, CONTACTID, RELATIONSHIP) VALUES ('909090909', '999900000', 'BUBBA'). and tap "Execute".
2) Syncronize again, go to your AIX machine, and from the command prompt log in as your DB2 instance user.
3) Connect to your nurse database (i.e. "db2 connect to vnurse").
4) From the DB2 command prompt type "db2" to enter the DB2 command mode.
5) At the DB2 command prompt type "select * from dsysample.vncontact", which will list all the rows in this database. Your newly added row should appear at the end. Congrats on syncing.
1) Switch users to the "db2inst1" user (i.e. "su - db2inst1", password = "ibmdb2").
2) Change directories to "/home/db2inst1/db2everyplace81/Server/bin" and execute the command "dsytrace.sh 1" to turn on DB2e logging (or "dsytrace.sh 0" to turn it off"). Trace logging goes to "/home/db2inst1/db2everyplace81/Server/logs", filename(s) "dsys.*.trace", where "*" = 1-9.
3) Stop the "DB2 Everyplace Application Server" in the WAS console, then restart it.
4) From the MDAC, reset the user, then attempt
synchronization.
Using the File Explorer
1) Tap the "Start" button in the upper right corner of the display.
2) Tap "Programs", and in the Programs panel tap "File Explorer".
3) Tapping any file will attempt to execute it.
4) Touching and holding will bring up a pull down
menu with "Cut", "Copy", "Rename", "Delete", "Send via E-mail", and "Beam
File..." function.