ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportFirst msg failed to connect to SQL server

Post new topicReply to topic
First msg failed to connect to SQL server View previous topic :: View next topic
Author Message
IIB4VV
PostPosted: Mon Jan 02, 2017 10:54 pm Post subject: First msg failed to connect to SQL server Reply with quote

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
View user's profile Send private message
IIB4VV
PostPosted: Mon Jan 02, 2017 11:38 pm Post subject: Reply with quote

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
View user's profile Send private message
IIB4VV
PostPosted: Tue Jan 03, 2017 10:44 pm Post subject: Reply with quote

Newbie

Joined: 02 Jan 2017
Posts: 7

Any updates or suggestion. Please help.

Thanks,
Back to top
View user's profile Send private message
adubya
PostPosted: Tue Jan 03, 2017 11:58 pm Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
nelson
PostPosted: Sun Jan 08, 2017 6:43 pm Post subject: Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313

What error(s) do you see?
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportFirst msg failed to connect to SQL server
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.