| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| First msg failed to connect to SQL server |
« View previous topic :: View next topic » |
| Author |
Message
|
| IIB4VV |
 Posted: Mon Jan 02, 2017 10:54 pm Post subject: First msg failed to connect to SQL server |
 |
|
Newbie
Joined: 02 Jan 2017
Posts: 7
|
Hi Everyone,
we have a service that will connect to SQL server (Remote DB), where the number of transactions will be very low.
When ever the service is triggered, it is failing for few times and once its start working it will work for few hours.
Not sure whether it is failing due to no transaction for long time.
Please help with your suggestions.
We are using IIB9 running in AIX, SQL server is running in Windows server.
IS there any way we can set the connection reset after sometime in case of no transactions for certain time.
Thanks in advance. Please help.
Regards,
Vishnu |
|
| Back to top |
|
 |
| IIB4VV |
| Posted: Mon Jan 02, 2017 11:38 pm Post subject: |
|
|
Newbie
Joined: 02 Jan 2017
Posts: 7
|
The mqsireport properties reported the below
DatabaseContext
threadNumber='11053'
ODBC_Version_3
envHandle='4588901376'
DataSource
name='ITHDB'
timeoutEnabled='false'
coordinated='false'
state='2'
ManagedStatement
text='{ CALL dbo.SP_CT ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) }'
createTime='1481185785.369725562'
lastExecuteTime='1483095290.097298281' |
|
| Back to top |
|
|
| IIB4VV |
| Posted: Tue Jan 03, 2017 10:44 pm Post subject: |
|
|
Newbie
Joined: 02 Jan 2017
Posts: 7
|
Any updates or suggestion. Please help.
Thanks, |
|
| Back to top |
|
|
| adubya |
| Posted: Tue Jan 03, 2017 11:58 pm Post subject: |
|
|
Partisan
Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK
|
Do you have any firewall infrastructure between your IIB server and your DB ?
_________________
Independent Middleware Consultant
andy@knownentity.com |
|
| Back to top |
|
|
| nelson |
| Posted: Sun Jan 08, 2017 6:43 pm Post subject: |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
| What error(s) do you see? |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
