MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Database Load - DSNUTILB - REASON=X'00E40002'

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
manojagrawal
Beginner


Joined: 25 Feb 2003
Posts: 124
Topics: 29
PostPosted: Tue Jun 08, 2004 1:59 pm    Post subject: Database Load - DSNUTILB - REASON=X'00E40002' Reply with quote
Hello,

I am trying to a do a database load and I get a Utility Batch Memory execution abend REASON=X'00E40002'.

I checked the following link - http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnmch11/4.17.3?SHELF=&DT=20010718150520&CASE= but am unable to determine what the problem is.

Anyone who has faced it? Any suggestions?
_________________
Thanks & Regards,
Manoj.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose
PostPosted: Tue Jun 08, 2004 3:33 pm    Post subject: Reply with quote
Manoj,


Check this link for explanation of 00E40002

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/4.17.3?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
manojagrawal
Beginner


Joined: 25 Feb 2003
Posts: 124
Topics: 29
PostPosted: Tue Jun 08, 2004 3:41 pm    Post subject: Reply with quote
Hello Kolusu,

I had checked the exact same link as I mentioned above. However I am unable to locate the problem from what is given there. Does this have to do with the system programmers? Any suggestions?
_________________
Thanks & Regards,
Manoj.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose
PostPosted: Tue Jun 08, 2004 4:13 pm    Post subject: Reply with quote
Manoj,

Post your Load JCL.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Balanim
Beginner


Joined: 29 Jan 2004
Posts: 21
Topics: 8
PostPosted: Wed Jun 09, 2004 2:40 am    Post subject: Reply with quote
Hi Kolusu

I am also getting the same error

here is the JCL


Code:
//ACHULCON  JOB 'TSOUSER','UNL CON',NOTIFY=&SYSUID,         
//             MSGCLASS=X,                                 
//             CLASS=Q                                     
//JOBLIB   DD DSN=SYS1.DSNDB2A.SDSNLOAD,                   
//            DISP=SHR                                     
//*                                                         
//ST010   EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT)         
//SYSTSPRT DD SYSOUT=*                                     
//SYSTSIN  DD *                                             
  DELETE 'BALA.UNLCON.SYSREC00'                     
//SYSPRINT DD SYSOUT=*                                     
//SYSUDUMP DD SYSOUT=*                                     
//*                                                         
//**********************************************************
//* UNLOAD table                                 
//**********************************************************
//*                                                         
//ST020   EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(8,LT),TIME=500
//SYSTSPRT DD  SYSOUT=*                                     
//SYSTSIN  DD  *                                           
 DSN SYSTEM(DB2A)                                           
 RUN  PROGRAM(DSNUTILB) PLAN(DSNUTILB)  -                   
       LIB('SYS1.DSNDB2A.SDSNLOAD')                         
//SYSPRINT DD  SYSOUT=*                                     
//SYSUDUMP DD  SYSOUT=*                                     
//SYSREC00 DD  DSN=BALA.UNLCON.SYSREC00,           
//             DISP=(,CATLG,DELETE),                       
//             SPACE=(CYL,(350,250),RLSE)                   
//SYSPUNCH DD  DUMMY                                       
//SYSIN    DD  *                                           
 QCHMIG.QCHTSCON                                           
//*                                   


Thanks
Bala
Back to top
View user's profile Send private message Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose
PostPosted: Wed Jun 09, 2004 5:25 am    Post subject: Reply with quote
Bala,

Remove the JOBLIB statement and rerun the job. Btw you really don't need the first delete step.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Balanim
Beginner


Joined: 29 Jan 2004
Posts: 21
Topics: 8
PostPosted: Wed Jun 09, 2004 6:34 am    Post subject: Reply with quote
Hi Kolusu..

i deleted the JOBLIB but no luck...


Thanks
Bala
Back to top
View user's profile Send private message Yahoo Messenger
manojagrawal
Beginner


Joined: 25 Feb 2003
Posts: 124
Topics: 29
PostPosted: Wed Jun 09, 2004 1:32 pm    Post subject: Reply with quote
Hello Kolusu,

Sorry for the delay. The Load JCL is as follows:
Code:
//ZZDBREST JOB ('XXXXXXX,0000,XXXX01,BINXXX'),'DATABASE RELOAD',   
// MSGCLASS=H,MSGLEVEL=(1,1),COND=(4,LT),REGION=0M,                   
// USER=ABCDEF1,GROUP=ABCDE3,NOTIFY=ABCDEF1                           
//*MAIN CLASS=DD1HDB2                /***DB2 CLASS XXXXM***/         
//* ---------------------------------------------------------         
//RELOAD   EXEC PGM=DSNUTILB,                                         
//             REGION=4096K,                                         
//             PARM='DD1H,TESTID'                                       
//STEPLIB   DD DSN=DB2.DD1H.DB2.RUNLIB.LOAD,DISP=SHR                 
//          DD DSN=DB2.DD1H.DB2.SDSNLOAD,DISP=SHR                     
//          DD DSN=DB2.DD1H.QMF.SDSQLOAD,DISP=SHR                     
//SYSUT1    DD SPACE=(23738,(128,64),RLSE,,ROUND),UNIT=SYSDA         
//SORTWK01  DD SPACE=(23738,(128,64),RLSE,,ROUND),UNIT=SYSDA         
//SORTWK02  DD SPACE=(23738,(128,64),RLSE,,ROUND),UNIT=SYSDA         
//SORTWK03  DD SPACE=(23738,(128,64),RLSE,,ROUND),UNIT=SYSDA         
//SORTWK04  DD SPACE=(23738,(128,64),RLSE,,ROUND),UNIT=SYSDA         
//SORTOUT   DD SPACE=(23738,(128,64),RLSE,,ROUND),UNIT=SYSDA         
//SYSDISC   DD SPACE=(23738,(32,16),RLSE,,ROUND),UNIT=SYSDA           
//SYSERR    DD SPACE=(23738,(32,16),RLSE,,ROUND),UNIT=SYSDA           
//SYSMAP    DD SPACE=(23738,(32,16),RLSE,,ROUND),UNIT=SYSDA         
//RCBLOAD   DD DSN=XYZ.MANOJ.DATABASE.MANOJ,DISP=SHR           
//SYSIN     DD DSN=XYZ.MANOJ.MODULES(DBLOAD1),DISP=SHR         
//          DD DSN=XYZ.MANOJ.MODULES(DBSTRUC1),DISP=SHR       
//UTPRINT   DD SYSOUT=*                                             
//SYSPRINT  DD SYSOUT=*                                             
//SYSUDUMP  DD SYSOUT=*

XYZ.MANOJ.DATABASE.MANOJ - Contains the data to be loaded
XYZ.MANOJ.MODULES(DBLOAD1)
Code:
 LOAD                 
   DATA               
   INDDN RCBLOAD       
   REPLACE             
   LOG YES             
 INTO TABLE 

XYZ.MANOJ.MODULES(DBSTRUC1) - Contains the structure of the DB2 table I am loading into.
_________________
Thanks & Regards,
Manoj.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose
PostPosted: Wed Jun 09, 2004 3:15 pm    Post subject: Reply with quote
Manoj,

Did you try running the job by removing the steplib?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
manojagrawal
Beginner


Joined: 25 Feb 2003
Posts: 124
Topics: 29
PostPosted: Wed Jun 09, 2004 3:24 pm    Post subject: Reply with quote
Hello Kolusu,

On removing the STEPLIB, I get the abend saying that the requested module, i.e., DSNUTILB not found.

However, On including only DSN=DB2.DD1H.DB2.SDSNLOAD in the steplib, the job ran perfectly, RC=0. Thanks a ton!!!

Now a question. Why did this happen? How would the concatenation of the other DSN's effect the run?
_________________
Thanks & Regards,
Manoj.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose
PostPosted: Thu Jun 10, 2004 8:42 am    Post subject: Reply with quote
Manoj,

Long time back , I remember reading a document that coding steplib, or Joblib for DB2 utilities will cause unpredicted results. Even though they explained the reasons in that document , I cannot recollect them as well as I cannot find that document. If I find it then I will update this topic

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group