MQSeries.net :: View topic - Errors in binding a DB2 Database for sample message flow app

spidy

Hi All,

I am trying to run a sample message flow application in Websphere Message Broker V5.0. I have installed and configured broker and configuration manager. I have defined message flow. Execution group is created. Everything has been setup. All Queue Managers are running. DB2 has been started. Now for the sample flow I need to create an additional DB2 database (DB2 V8.1). I had the code ready for creating it. But when I ran that script, I was getting an error like this for the following command:

BIND '%DB2TEMPDIR%\bnd\@db2cli.lst' blocking all grant public

LINE MESSAGES FOR db2cli.lst
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0031C File "C:\Temp\%DB2TEMPDIR%\bnd\db2cli.lst" could
not be opened. SQLSTATE=00000
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "3" errors and "0" warnings.

I went ahead and tried to run that message flow. I am able to put message on input queue and I also get it on output queue of the msg flow. But as per the message flow application, the DB2 database created should get the information from the input message and should be updated. But thats not happening. I checked all messages in Event Viewer and tried following those messages. I am doing this for the first time. Has anybody came across this problem anytime? Am I missing anything? Please suggest.

Thanks.