Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Error in SQL-PLIST3 'Above value truncated after 115 bytes.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Error in SQL-PLIST3 'Above value truncated after 115 bytes.
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: 2409
Location: Hampshire, UK

PostPosted: Wed Sep 06, 2017 2:23 pm    Post subject:
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    Post subject:
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: 2467
Location: NY,USA

PostPosted: Wed Sep 06, 2017 3:29 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Easytrieve EZABX007 with error code 0... Carol Schablow CA Products 7 Thu Sep 24, 2020 3:30 am
No new posts SARBCH REPORT DD writing error kris_madras CA Products 1 Tue Sep 15, 2020 4:22 pm
No new posts EIBRESP =16 & EIBRESP2 = 01 while... Farheen CICS 4 Mon Aug 24, 2020 2:05 pm
This topic is locked: you cannot edit posts or make replies. issue with Syntax error shub2204 SYNCSORT 2 Wed Aug 12, 2020 3:11 pm
No new posts Force a Return Code and print error m... Rick Ryan SYNCSORT 30 Thu Jun 25, 2020 1:18 am

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us