View previous topic :: View next topic
|
Author |
Message |
rikdeb
New User
Joined: 19 Jan 2009 Posts: 63 Location: hyderabad
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Find out the how your host variable was populated with blanks - probably your input is in error. |
|
Back to top |
|
|
rikdeb
New User
Joined: 19 Jan 2009 Posts: 63 Location: hyderabad
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
Talk to DBA, it must have been a table space scan for blank. |
|
Back to top |
|
|
rikdeb
New User
Joined: 19 Jan 2009 Posts: 63 Location: hyderabad
|
|
|
|
Ok. thanks Rohit and Nic. Will check that. |
|
Back to top |
|
|
|