IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Error in SQL-PLIST3 'Above value truncated after 115 bytes.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 63
Location: hyderabad

PostPosted: Wed Sep 06, 2017 1:34 pm
Reply with quote

Hello Everyone,
While executing one MPP in IMS region(say Pgm A) , it was getting timeout abend 0240.
On analysis, i saw that it had a called module (Pgm B)which fetches data from DB2 .

Code:
EXEC  SQL                                         
   SELECT  transport                                                           
     FROM   XXX                                 
    WHERE  route   = :CP972200.route-number
END-EXEC                                           

Blank values were moved to this field(route-number) .It is defined to be a not null field though.
This query failed and Fault analyser output showed the below.

Code:
 A user abend 0240 occurred in module DFSPCC20 CSECT DFSPCC20 at offset X'1FA6'


Code:
 SQL-PLIST3 = ......Pgm-name..1..l.......Q.........J.XSQLDA 
              NOTE: Above value truncated after 115 bytes.   

Could you please help me in understanding the exact issue which caused the timeout abend?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2432
Location: Hampshire, UK

PostPosted: Wed Sep 06, 2017 2:23 pm
Reply with quote

Find out the how your host variable was populated with blanks - probably your input is in error.
Back to top
View user's profile Send private message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 63
Location: hyderabad

PostPosted: Wed Sep 06, 2017 2:26 pm
Reply with quote

Yes Nic.. Input was erroneous. It should not be blank. But just curious to know about how this resulted in timeout or more detail about the SQL-PLIST3 error.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2508
Location: NY,USA

PostPosted: Wed Sep 06, 2017 3:29 pm
Reply with quote

Talk to DBA, it must have been a table space scan for blank.
Back to top
View user's profile Send private message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 63
Location: hyderabad

PostPosted: Wed Sep 06, 2017 5:21 pm
Reply with quote

Ok. thanks Rohit and Nic. Will check that.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Getting error while xped JCL & VSAM 10
No new posts can someone please help me in finding... IBM Tools 9
No new posts SYNCSORT Error - CONTROL FIELD BEYOND... SYNCSORT 10
No new posts Easytrieve EZABX007 with error code 0... CA Products 7
No new posts SARBCH REPORT DD writing error CA Products 1

Back to Top