Implementing WebSphere Business Integration Express for Item Synchronization

96 Implementing WebSphere BI Express for Item Synchronization

8.1 Set-up the audit and logging service

The WebSphere Business Integration Express for Item Sync system uses a

database table called audit_log to track events associated with UCCnet

activities.To enable the audit and logging services we need to create the table

required and add some additional configuration information to the InterChange

System configuration.

1. In WordPad open the file audit_log.sql located in the folder

C:\IBM\WebSphereItemSync\collaborations\dependencies\UCCnet\db2.

This file contains SQL statements to create DB2 resources for the auditing

features of WebSphere BI Express.

2. While there are many ways to execute these statements, it is probably easiest

to pass this file to the DB2 command processor. However, this command

processor requires a semi-colon at the end of each command. Edit the

audit_log.sql file to add semi-colons and save it.

3. Open a DB2 command window by selecting Start

→ Programs → IBM DB2

→ Command Line Tools → Command Window.

4. Change to the directory

C:\IBM\WebSphereItemSync\collaborations

\dependencies\UCCnet\db2

.

5. Type the commands in Example 8-1:

Example 8-1 Audit_log connect commands

db2 connect to smb_db user smbadmin using smbP4$$word

db2 -tvf audit_log.sql

db2 connect reset

6. Verify the output to make sure that the DB2 objects were created.

7. In WordPad, open the file InterchangeSystem.UCCnet in the folder

C:\IBM\WebSphereItemSync\samples\UCCnet. You need to edit the values of

four properties in this file:

a. USER_NAME: Change the value attribute from crossworlds to smbadmin.

b. DRIVER: Change the value attribute from com.ibm.crossworlds.jdbc.

sqlserver.SQLServerDriver

to COM.ibm.db2.jdbc.app.DB2Driver.

c. DATA_SOURCE_NAME: Change the value attribute from

jdbc:ibm-crossworlds:sqlserver://HostName:1433;DatabaseName=CWRep

ository

to jdbc:db2:SMB_DB.

d. PASSWORD: Change the value attribute from admin to smbP4$$word.