View previous topic :: View next topic
|
Author |
Message |
sunnybunny
New User
Joined: 29 Nov 2005 Posts: 49
|
|
|
|
Hello Friends,
I am getting U3042 abend in a IMS/DB2 program. The first sql statement itself fails without giving any sql error. Actually I am invoking IMS-DB2 program thru IMS transaction. When control comes to first statement of SQL in xpeditor it is abending with U3042.
Please help me on this.
Regards,
Sunny. |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
We need more information. Please check Abend assist. |
|
Back to top |
|
|
mahapatrasoumya
New User
Joined: 13 Apr 2006 Posts: 7
|
|
|
|
Please check your jcl and make sure that , you are using the corrct RESLIB library . If you use wrong RESLIB library it might give this error.
Example for production you have to use PROD.RESLIB , for test you have to use TEST.RESLIB. |
|
Back to top |
|
|
sbalajibe
New User
Joined: 15 Aug 2005 Posts: 62
|
|
|
|
I Am also facing same problem as Sunny. Can please suggest me the solution
Sunny: Did u find out the solution....? plese share
Regards
Balaji |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Looks like you need the system programmer to determine which IMS module causes the abend. He should check register 15 according to the manual:
Quote: |
Code 3042
3042
Explanation:
Module DFSESPR0 issues this abend after detecting error. DFSESPR0 also issues this abend due to errors detected in lower level modules. The module detecting the error sets the abend code for DFSESPR0 to issue.
System action:
The TCB in the dependent region, under which these modules run, is terminated.
Programmer response:
Bytes 1 and 2 of Register 15 contain a hexadecimal value representing the module name that detected the nonzero return code. To determine the module name, refer to the categories describing the various conditions detected by IMS modules in Return Codes and Function Codes. Bytes 3 and 4 of Register 15 contain the hexadecimal return code passed back by the external subsystem exit or the lower level module.
System Operator Response:
Notify the system programmer.
Problem determination:
4, 5, 6, 7
Related topics:
IMS Abend Codes 3000 - 4095
|
The manual may be found here. Also check if all libraries are concatenated in your JCL. |
|
Back to top |
|
|
sbalajibe
New User
Joined: 15 Aug 2005 Posts: 62
|
|
|
|
U have to add the dd statement
//DFSESL DD DSN=&LIB6..RESLIB,
// DISP=SHR
// DD DISP=SHR,
// DSN=SYS4.DB2.DB3T.SDSNLOAD
// DD DISP=SHR,
//DSN=SYS4.DB2.DB3T.SDSNEXIT
ADD u r reslib and DB2 libraries
regards
Balaji |
|
Back to top |
|
|
upadhya_k Warnings : 1 New User
Joined: 15 Jun 2007 Posts: 6 Location: bangalore
|
|
|
|
Hi,
I am geting the same abend and I have checked with the JCls also.. I have included the proper RESLIB statements... Could anybodu please help me out in this regard...
[/img] |
|
Back to top |
|
|
wendybarnett
New User
Joined: 14 Jun 2009 Posts: 2 Location: South Africa
|
|
|
|
The RTT module must be in a PDS not PDS/E.
Once they re-linked it into IMS's reslib versus DB2's sdsnload, the U3042 went away.
The difference seems to be PDS versus PDSE, and furthermore, the RTT seems to be
searched for each and every tran even though there is a match of PSB <-
DB2 plan. The steplib of their startup proc only has the ims pds reslib
and their DFSESL DD has both the DB2 SDSNLOAD, SDSNEXIT, and IMS RESLIB.
PDSE is allowed for DB2 loadlib in the DFSESL DD statement. PQ82493 and PQ84553 describes it .
Let me know if the above helps. If not , please send the requested dump + logrec information. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello Wendy and welcome to the forum,
We have been looking for one such as you
Don't be concerned if there are not so many replies to this topic as it has been inactive for about a year and a half.
I expect there are others more current you may find interesting.
Thanks for joining,
d |
|
Back to top |
|
|
wendybarnett
New User
Joined: 14 Jun 2009 Posts: 2 Location: South Africa
|
|
|
|
Thank you.
We in Africa are alittle behind
We only going to DB2 v 8 now.
For a quick workaround to get our system up we found that moving the RTT module from the DB2 LOADLIB to the IMS RESLIB solved the problem, it seems IMS not partial to PDS/E. |
|
Back to top |
|
|
anilbidave
New User
Joined: 12 Nov 2006 Posts: 1 Location: pune
|
|
|
|
Thanks All for your Valuable support...Its working |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
I'm biting. What is working? |
|
Back to top |
|
|
|