13401152.
doc 1
Creation of IBM WPS (Websphere Process Server) custom server profile with capabilities
• Custom Database* configuration for CEI event
• Upgrade / Augment WPS server profile to IBM WBM (Websphere Business Monitor). WBM is the product
for BAM (aka Business Activity Monitoring) of enterprise application.
• Custom Database* configuration for WBM server (i,e for BAM) so that the Application Monitor data may
be used for reporting using third party products like Actuate [Link].
* In this case, IBM DB2 v 9.1 used as the custom database. It may be replaced with any other database products
like Oracle, Informix, Microsoft SQL server etc.
Software Requirement
1. IBM Websphere Integration Developer(WID) v6.1.2
2. IBM Websphere Process Server(WPS) v 6.1.2
3. IBM Websphere Business Monitor(WBM) v 6.1.2
4. IBM DB2 v9.1 (may install any other database as per your requirement)
Target Audience
• IBM WID-WPS developer, IBM WBM developer
• Application Designer and Architects.
• Software Installation Group
• Server Admin
Table of Content
[Link] IBM WPS (Websphere Process Server).....................................................................................2
[Link] IBM WBM (Websphere Business Monitor)..............................................................................2
[Link] new IBM WPS custom server profile (& Configure DB2 database for CEI events)................3
[Link] into the CEI database..............................................................................................................22
[Link] WPS profile with WBM capabilities (& configure DB2 database for Monitor model).....23
[Link] into the Monitor database.......................................................................................................34
[Link] Application test on the server.................................................................................................35
[Link] the applications.....................................................................................................................35
[Link] the correct server and deploy the modules..........................................................................35
[Link] sample test cases and check the monitor data..........................................................................37
[Link] the data in database and extract report..................................................................................38
Change Log
Date Document Change Summery Author Remark
Version
19th Jan 2009 0.1 (Draft) Initial Document Satya Sidhartha
[Link] 2
1. About IBM WPS (Websphere Process Server)
IBM® WebSphere® Process Server is a high-performance business engine to help form processes that meet
your business goals Built on open standards; it deploys and executes processes that orchestrate services
(people, information, systems, and trading partners) within your service-oriented architecture (SOA) or non-SOA
infrastructure.
• Extends the value of core applications and databases by centralizing business processes and sharing them
across the enterprise, enabling businesses to maximize resources and increase ROI
• Ensures compliance with regulations and internal requirements by that business operations run precisely as
documented
• Ensures process integrity to accommodate transaction intensive processes, while providing the scalability,
reliability and flexibility needed for future business needs
• Strong support for human workflow and enables rapid process changes, providing business agility and
enabling you to leverage resources efficiently.
More about product at [Link]
Help and documentation at
[Link]
html
2. About IBM WBM (Websphere Business Monitor)
IBM WebSphere® Business Monitor is business activity monitoring (BAM) software that allows you to measure
business process performance, monitor in-flight and completed processes, and report on business operations.
• Provides business users access to near real-time business process information and KPIs through Web 2.0
dashboards, desktop and mobile devices.
• Empowers business users to create new dashboards, KPIs and subscribe to business alerts without involving
IT
• Provides a comprehensive realtime view of operational processes through a high performance business
activity monitoring solution for processes and applications running in disparate environments
• Accelerates continuous process improvement and business innovation through a tight integration with other
IBM BPM products
• Enables business users to manage staff workload for better resource planning.
• Offers multidimensional analyses for trend analysis and problem identification
More about the product at [Link]
Help and documentation at
[Link]
[Link]
[Link] 3
3. Create new IBM WPS custom server profile (& Configure DB2 database for CEI
events)
To create a new server profile, you must have installed the WPS server on your machine. When you install IBM
WID, the process server gets installed by default.
Note-: By default, WPS servers use internal Derby database for CEI Event logging, Monitoring (if any) and other
process related data.
To create a new server profile, go to the C:\IBM\WID61\pf\wps\firststeps folder and double click on the file
[Link]. Assuming C:\IBM\WID61 as the installation directory for WID.
[Link] 4
[Link] 5
[Link] 6
[Link] 7
[Link] 8
[Link] 9
[Link] 10
[Link] 11
[Link] 12
[Link] 13
[Link] 14
[Link] 15
[Link] 16
[Link] 17
[Link] 18
[Link] 19
[Link] 20
[Link] 21
[Link] 22
After successful profile creation, it will display message like this.
3.1. Look into the CEI database
Now you may have a look into the CEI database created by new WPS profile on DB2 database.
Use these connection properties to connect to the event database.
Driver class name------: [Link].DB2Driver
User name----------------: db2admin (or username you have provided)
Password------------------: Welcome1 (or password you have provided)
Connection URL---------: j[Link]//localhost:50000/EVENT (replace localhost with IP of the DB2 server and port
as well)
Here you can see around 33 tables being created. Among which the CEI_T_CBE_MAP table contains a listing of
all of the CBE (Common Base Events or simply events) properties and what tables they can be found in. The
CEI_T_EVENT (here it’s CEI_T_EVENT00) table contains all of the simple or top-level property data of a CBE.
Note-: CEI_T_EVENT00 table gets populated with CBE (i.e. events) only when you deploy application emitting
event onto this server profile.
[Link] 23
4. Augment WPS profile with WBM capabilities (& configure DB2 database for Monitor
model)
The profile created in the above step is a Websphere Process Server(WPS) profile. In order to deploy business
monitoring application you must have Websphere Business Monitoring(WBM) capabilities.
So you must Augment the WPS server to WBM profile as well. After successful augmentation, the profile would be
capable to deploy both process server module as well as the BAM enabled monitor models modules.
For that you have to install the Websphere Business Monitor (WBM, here v6.1.2) and integrate it with the WID
installation. After successful installation, the server view of WID will look like this.
To create a new server profile, go to the C:\IBM\WID61\pf\wps\firststeps folder and double click on the file
[Link]. Assuming C:\IBM\WID61 as the installation directory for WID.
(Picture# -: )
[Link] 24
[Link] 25
[Link] 26
[Link] 27
[Link] 28
[Link] 29
[Link] 30
[Link] 31
[Link] 32
[Link] 33
[Link] 34
4.1. Look into the Monitor database
Now you may have a look into the CEI database created by new WPS profile on DB2 database.
Use these connection properties to connect to the event database.
Driver class name------: [Link].DB2Driver
User name----------------: db2admin (or username you have provided)
Password------------------: Welcome1 (or password you have provided)
Connection URL---------: j[Link]//localhost:50000/MONITOR (replace localhost with IP of the DB2 server and
port as well)
[Link] 35
5. Sample Application test on the server
[Link] the applications
You may now create IBM WPS and WBM compliant applications and deploy them onto the newly
created server. Note the WPS application should emit CBE or simply events (Which are stored into the
EVENT database on DB2 as per this configuration). The events should be consumed by WBM server
(using Triggers and Matrics) so that they will be persisted in MONITOR database (Here configured to
DB2).
[Link] the correct server and deploy the modules
Now choose the server which we have created with custom database configuration.
[Link] 36
Now we can deploy both process server modules and Business Monitor modules on this server. Right click on
“WebSphere Business Monitor Server v6.1 on WebSphere Process Server” and click on “Add and Remove
Projects”. Select deploy both the modules.
[Link] 37
5.3. Run sample test cases and check the monitor data.
If you test run the module, the module will emit CBE events and those events get stored into EVENT
database tables. As we have also enabled BAM using the IBM WBM, those events also goes to MONITOR
database. (The database structure is diff for both and the later one is more suitable for reporting purpose while the
former one is more suitable for event logging purpose).
To test, open assembly diagram of the Clawback_Process_Merge, select the Clawback_Eligibility
component, right click on that and choose the “Test Component” option.
[Link] 38
You may run couple of test cases similar to this so that the database could be populated with more data.
5.4. Check the data in database and extract report
Now check the MONITOR database for the process monitoring data.
[Link] 39
