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 Index » WebSphere Message Broker (ACE) Support » Execution Group is getting abended frequently due to DB2

Post new topic  Reply to topic
 Execution Group is getting abended frequently due to DB2 « View previous topic :: View next topic » 
Author Message
muthu121521
PostPosted: Thu Nov 12, 2015 8:04 am    Post subject: Execution Group is getting abended frequently due to DB2 Reply with quote

Apprentice

Joined: 31 Aug 2015
Posts: 36
Hi,
I have a message flow which listens to the MQ queue and inserts that messages into a DB2 Database.We are observing that its getting frequently abended and Execution Group restarts.
I have checked the application logs
We are observing a pattern whenever we find the below error in logs
"Child SQL exception - 22001 - -99999 - [unixODBC][IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001"
It is getting abended some times and EG restarts automatically.
We have 100,000 messages getting processed daily.
If any one has faced similar issues in broker.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Thu Nov 12, 2015 9:38 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
Sounds like some of the data won't fit into the allocated space in the DB2 Table.

Look at the lengths of the data and the size of the columns in the table.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
muthu121521
PostPosted: Thu Nov 12, 2015 10:40 am    Post subject: Reply with quote

Apprentice

Joined: 31 Aug 2015
Posts: 36
but then it should thrown only the error .Not to abend the message flow.Recycle the Execution group.
Back to top
View user's profile Send private message
mgk
PostPosted: Thu Nov 12, 2015 6:53 pm    Post subject: Reply with quote

Padawan

Joined: 31 Jul 2003
Posts: 1642
Quote:
but then it should thrown only the error .Not to abend the message flow.Recycle the Execution group.


I agree, it sounds like you should open a PMR to get this looked at.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Fri Nov 13, 2015 7:31 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
Abends should always result in a PMR.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Execution Group is getting abended frequently due to DB2
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.