Author |
Message
|
ucbus1 |
Posted: Fri Apr 26, 2002 8:03 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002 Posts: 560
|
I am having workflow on a AIX machine and connecting to database which is located in another mAIX box remotely. Now a days I am getting the following error
"[IBM][CLI Driver] CLI0108E Communication link failure. SQLSTATE=40003"
The logs on DB2 are not much of help as I do not see any errors logged at the time when I was getting communication failure error.
Please let me know if you have any idea
Thanks |
|
Back to top |
|
 |
vedbhat |
Posted: Sun Apr 28, 2002 5:49 pm Post subject: |
|
|
 Disciple
Joined: 19 Mar 2002 Posts: 186 Location: Singapore
|
Hi,
1) Do you have DB2 client installed on the Workflow Server Machine to connect to the DB2 Server.
2) Is the userid and password specified in .odbc.ini correct.
These are the things that I can remember as of now.
Regards
Ved
_________________ IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
Back to top |
|
 |
ucbus1 |
Posted: Mon Apr 29, 2002 5:05 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002 Posts: 560
|
Yes, I have tested the connection with user ID password. Its working fine. The problem is occuring at random
Thanks |
|
Back to top |
|
 |
vedbhat |
Posted: Mon Apr 29, 2002 6:01 pm Post subject: |
|
|
 Disciple
Joined: 19 Mar 2002 Posts: 186 Location: Singapore
|
Hi,
If you can tell when exactly you get the error, we can try to findout and give you any suggestions to solve your problem.
Cheers and Have a nice day.
Ved
_________________ IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
Back to top |
|
 |
ucbus1 |
Posted: Tue Apr 30, 2002 5:47 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002 Posts: 560
|
Sure...
I am having UPES, message handler which executes different service classes based on the message received. When a particular message is received, the service class executes a stored procedure which cleans up the database by deleting the record. Here, to call stored procedure I am using pool managers to manage the connection to database . My service class runs on AIX box and on this box we have database instance defined as remote. The actula database is situated on another AIX box.
Please let me know if you want me to provide any specifics
Thanks |
|
Back to top |
|
 |
ucbus1 |
Posted: Tue Apr 30, 2002 5:49 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002 Posts: 560
|
To continue...
I am getting the error at random some times when I am trying to establish a connection |
|
Back to top |
|
 |
vedbhat |
Posted: Wed May 01, 2002 6:19 pm Post subject: |
|
|
 Disciple
Joined: 19 Mar 2002 Posts: 186 Location: Singapore
|
Hi,
Instead of retrieving the connection from the Pool, Try hardcoding Userid and Password to connect to the database.
Did you find any details in the DB2 information Center about the Error code 0108. I couldnt find any error messages with respect to this code.
Cheers
Ved
_________________ IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
Back to top |
|
 |
ucbus1 |
Posted: Thu May 02, 2002 10:14 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002 Posts: 560
|
Thanks
I wish I could Hard code. But I can not because of the security reasons. I have similar set up in TEST environment where DATABASE and WORKFLOW co-exist and I am not facing any problem on TEST machine. I guess it has to do something with the way the database is defined remote.
Let me know if you hav any solution |
|
Back to top |
|
 |
vedbhat |
Posted: Thu May 02, 2002 9:43 pm Post subject: |
|
|
 Disciple
Joined: 19 Mar 2002 Posts: 186 Location: Singapore
|
Hi,
I havent done this before in Unix but the chapter "Configuring Client-to-Server Communications Using the Command Line Processor" in the manual -> "DB2 Connect Quick Beginnings for UNIX**" tells you how to configure client.
I hope this will help you solve your problem.
Cheers
Ved
_________________ IBM Certified Solutions Expert - MQSeries Workflow
IBM Certified Specialist - MQSeries |
|
Back to top |
|
 |
|