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 SupportLinux DB2 ODBC select statement Random failure

Post new topicReply to topic
Linux DB2 ODBC select statement Random failure View previous topic :: View next topic
Author Message
Muhammad Haider
PostPosted: Fri Jun 30, 2017 2:58 am Post subject: Linux DB2 ODBC select statement Random failure Reply with quote

Apprentice

Joined: 14 Mar 2011
Posts: 32

I have my flow on IIB 10 accessing data from IBM DB2 v 11.

Flow is doing a select statement on DB2 table and working fine on windows. I am using ODBC.

I have made a new installation of IIB 10 and DB2 v11 on a single linux system RHEL v6.

Same flow is now deployed in linux, but is randomly failing when selecting data from DB2 table. I am using ODBC. I am trying to debug from my IIB toolkit on windows and whenever this failure case occurs, it terminates my debugger at the database select statement. Any hints what may be the issue on DB2/IIB on linux.
Back to top
View user's profile Send private message
Muhammad Haider
PostPosted: Fri Jun 30, 2017 10:22 pm Post subject: Reply with quote

Apprentice

Joined: 14 Mar 2011
Posts: 32

Its basically crashing the integration server. Any guess why ?
Back to top
View user's profile Send private message
timber
PostPosted: Sat Jul 01, 2017 2:01 am Post subject: Reply with quote

Yatiri

Joined: 25 Aug 2015
Posts: 654

Disconnect the debugger and switch on user trace on the integration server. You will get a *much* better error message, along with a lot of information about what IIB was doing at the time of the crash.
Back to top
View user's profile Send private message
Armageddon123
PostPosted: Mon Jul 03, 2017 10:00 am Post subject: Reply with quote

Acolyte

Joined: 11 Feb 2014
Posts: 54

any EG crash should give abend files . Any IIB abend should go to PMR because broker didnot handle something which you did(which may be allowed or not which you can confirm via PMR).
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 SupportLinux DB2 ODBC select statement Random failure
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.