Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums 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: 62
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: 1922
Location: 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: 62
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

Senior Member


Joined: 21 Sep 2010
Posts: 1817
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: 62
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 -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm

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