|
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: 2454
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: 3109
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 |
|
|
|
|
