WebSphere Application Server -- ORA-03120 error solution

WAS server 6.1.0.27 running on Solaris
Back-end Database: Oracle 9i -9.2.0.4.0

Application running on WAS is writing the XML response to table CLOB field but the following error shows in the SystemOut.log:

 writeClob failed on com.xxxx.xxx.

Checked the application log and found ORA-03120 error (Integer Overflow):

Queried Oracle DBA and DBA did not notice any error on Database side. The application running on Production environment has no this kind of error.

WebSphere Business Monitor 7 - Archive Monitor Module Instance Data

After a long time running, the instance data in a monitor module may reach thousands of records. It will take a lot of Database server disk space and will also downgrade the query performance. The following UNIX shell script shows how to archive the instance data with retention period of 3 month:

IBM provide a jython script in the directory  /IBM/WebSphere/MonServer/scripts.wbm/instances to use for archive the data, refering to the following URL for the script usage:

http://publib.boulder.ibm.com/infocenter/dmndhelp/v7r0mx/topic/com.ibm.btools.help.monitor.ref.doc/ref/instdata_archive_script.html

WebSphere Partner Gateway - Resend a file using script

This post will show how to resend a file using jacl script in IBM WebSphere Partner Gateway (WPG),  WPG is an AS2 file exchange software developed by IBM.  Some times we have to resend a failed file to AS2 partners. This action can be down from hubadmin console but if we know how to resend a file using jacl script, we can schedule the task. the following scripts are working with WPG6.0, not test on other WPG version.

IBM BPM7.5 Advanced Architecture

        The following architecture diagram shown here provides a good introduction to the makeup of BPM Advanced. It highlights the tools and capabilities that originate from earlier version of WebSphere Lombardi Edition and WebSphere Process Server.

IBM BPM7.5.1 database compare with WPS7

The following Database need to be created for IBM BPM7.5.1

1) BPMDB (Process Server DB)
2) CMNDB (Common DB)
3) BPCDB (Business Process Choreographer DB)
4) BSPACEDB (Business Space DB)
5) OBSRVDB (Business Process Observing Reporting DB)
6) PDWDB (Performance Datawarehouse DB)
7) MEDB (Messaging Engine database)
8) CEIDB (Common Event Service DB)

Install IBM BPM Advanced Process Server 7.5.1 on AIX 7 silently

BPM, Business Process Management, is a product released by IBM to replace WebSphere Process Server after IBM purchased the company Lombardi and integrated its distinguished business process solution. In this post, I will show how to install BPM Advanced Server 7.5.1 on AIX7; however, this process does not include install Lombardi business process center.

The steps show how to install IBM BPM 7.5.1 silently with non-root user, for example, wpsuser.

1. PRELIMINARY WORK

1) Create a file system called /IBM or another name with 20G disk space

2) Set the limits for non-root user which is used to install BPM

wpsuser:
        fsize = -1
        core = -1
        cpu = -1
        data = -1
        rss = 65536
        stack = 65536
        nofiles = 20000

3) Install DB2 database 9.5 FP4 or later version (DB2 9.7)

4) Download the following installation files from IBM passport advantage

PS_Adv_V751_AIX_1_of_2.tar.gz

PS_Adv_V751_AIX_2_of_2.tar.gz

Happy New Year - 2012

Hi all:

2012 is coming, wish all you have a wonderful new year. In 2012,  I will keep working on IBM WebSphere technology and  implement new BPM 7.5 upgrade. Also, I will begin to touch Oracle Fusion Middleware, mostly on OAM/OIM. And, if possible, I will study WebSphere Cloud technology in 2012.

Happy New Year !!!