Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

ERROR WHILE SUBMITTING LOAD JOB

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ANURADHA NEELAKANTAN

New User


Joined: 23 Aug 2016
Posts: 5
Location: INDIA

PostPosted: Thu Aug 25, 2016 11:50 am    Post subject: ERROR WHILE SUBMITTING LOAD JOB
Reply with quote

Hi,

I am unable to submit a load job in my TEST region(DSN7). I am getting the below error even the subsystem is active.
"DSNU006I DSNUTILB - DB2 SYSTEM DSN7 HAS NOT BEEN STARTED
DSNU012I DSNUTILB - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8"

Can you please help me in detailing why I am getting this error?
My load jcl:
//IFU0093L JOB (2,68932,MFG),IFU0093,REGION=4M,NOTIFY=IFU0093
//LOAD EXEC DSNUPROC,PARM='DSN7,IFU0093'
//STEPLIB DD DSN=SYSDB2.DSN7.MOVEDB2.ISPLLIB,DISP=SHR
// DD DSN=SYSDB2.DSN7.SSPGM,DISP=SHR
// DD DSN=SYSDB2.DSN7.EXIT.LOAD,DISP=SHR
//DSNTRACE DD SYSOUT=*
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SORTWK01 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SORTWK02 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SORTWK03 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SORTWK04 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SORTOUT DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSREC00 DD DSN=MMT1.IFU0093U.DB27.SYSREC00,
// DISP=SHR
//SYSUT1 DD UNIT=SYSDA,SPACE=(4000,(20,20),,,ROUND)
//SYSIN DD DSN=MMT1.IFU0093U.DB27.SYSPUNCH,DISP=SHR
Back to top
View user's profile Send private message

Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Thu Aug 25, 2016 12:18 pm    Post subject:
Reply with quote

Hello,

The DB2 Messages manual is fairly clear about the message: DSNU006I -

Quote:

DSNU006I

csect-name DB2 SYSTEM system-name HAS NOT BEEN STARTED

Explanation
Utility startup processing has been unable to connect to the indicated DB2® subsystem, because a -START DB2 command has not been issued for that subsystem.

System action

Utility processing is terminated without invoking the requested utility or utilities.


Operator response

Contact the system programmer to determine if a -START DB2 command should be issued for the indicated subsystem.

System programmer response

Have the operator issue a -START DB2 command for the indicated subsystem.

User response

Correct your JCL to specify the correct subsystem-name on the EXEC statement, and resubmit the job. Otherwise, contact the system programmer to determine when the subsystem will be available for processing.

Problem determination

DB2 must be started in order to execute DB2 utilities.
Severity

8 (error)
Back to top
View user's profile Send private message
ANURADHA NEELAKANTAN

New User


Joined: 23 Aug 2016
Posts: 5
Location: INDIA

PostPosted: Thu Aug 25, 2016 12:50 pm    Post subject:
Reply with quote

Yes . i referred all those manuals.
I tried starting it, it displayed its already active.
I can load via online option using DB2 file manager. But I am unable to load it in Batch process using this jcl.
It shows DSN7 is not active. Don't know why. I am able to perform all other query activities in that region,unload,load via online option.
Back to top
View user's profile Send private message
mistah kurtz

Active User


Joined: 28 Jan 2012
Posts: 268
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Thu Aug 25, 2016 3:08 pm    Post subject:
Reply with quote

Check with your site support. I guess you need to define //*MAIN parameter in the job, just after the job card something like below:
Code:
//*MAIN    CLASS=
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Thu Aug 25, 2016 4:01 pm    Post subject:
Reply with quote

//*MAIN is a JES3 statement. If the TS is at a site running JES2, the statement will not help.

Anuradha, the system is telling you what it sees is the problem. Your first issue is that you need to accept what the system is telling you. Once you do that, what you realize is that the batch job cannot be running on the same system your online commands are. This means it is an issue specific to your site and you MUST contact your site support group for assistance.
Back to top
View user's profile Send private message
ANURADHA NEELAKANTAN

New User


Joined: 23 Aug 2016
Posts: 5
Location: INDIA

PostPosted: Thu Aug 25, 2016 4:28 pm    Post subject:
Reply with quote

I posted my query to the site support as suggested. Will update you once i get what is the reason behind this problem.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Thu Aug 25, 2016 10:43 pm    Post subject:
Reply with quote

Welcome!Please make a use of code tags.
I suspect, your Job Card is not right hence talk to someone at your site and correct the job card for the region that you want DB2 load to be processed.
Hint could be CLASS or SCHENV may go wrong for the correct environment.
Back to top
View user's profile Send private message
ANURADHA NEELAKANTAN

New User


Joined: 23 Aug 2016
Posts: 5
Location: INDIA

PostPosted: Fri Aug 26, 2016 5:17 pm    Post subject:
Reply with quote

My site support also suggested //*MAIN clause, Now tried with the below Main card
//*MAIN CLASS=DSN7BTCH,FAILURE=CANCEL,LINES=(9999,W)

Now i am getting i don't have load authority.

But these many days i tried loaded into database using DB file manager tool. How did that happen if my ID has not authority for loading .. icon_sad.gif

Ironic to deal!
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Sun Aug 28, 2016 1:15 am    Post subject:
Reply with quote

Again, Anuradha-chan, we need to see the JCL and control cards used, and the actual messages received.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Sun Aug 28, 2016 4:03 pm    Post subject:
Reply with quote

There can be differences between online and batch authorities. Check with your security group.
Back to top
View user's profile Send private message
ANURADHA NEELAKANTAN

New User


Joined: 23 Aug 2016
Posts: 5
Location: INDIA

PostPosted: Fri Sep 23, 2016 2:24 pm    Post subject: Reply to: ERROR WHILE SUBMITTING LOAD JOB
Reply with quote

Hi Guys,

After a month gap, I came up with few progress.
I checked with my DB and he gave solution that load authority should be raised for the particular region. I did and now it is loading as expected by giving MAIN as //*MAIN CLASS=DSN7BTCH,FAILURE=CANCEL,LINES=(9999,W)

Here DSN7 is the region I want to load and DB27 is the region I want to unload.

I have designed the Jcl in such a way that first I will unload and the I will reformat the SYSPUNCH to change the table owner according to the loading region and as a third step I will load.

Here I am facing a problem like, unable to unload(prod region) and load (dev region) using this single MAIN statement. Is there any way can I do it both in one jcl?
Back to top
View user's profile Send private message
jerryte

Active User


Joined: 29 Oct 2010
Posts: 183
Location: Toronto, ON, Canada

PostPosted: Wed Oct 05, 2016 1:58 am    Post subject:
Reply with quote

Check which LPAR the job actually executes on. You can see this in SDSF held output. Then ask your DBA if the 'DSN7' db2 subsystem is active on that lpar.
If not then you can put a parm on the JOB card SYSAFF=lpar to force the job to execute on the correct lpar.
You can also try SCHENV=DSN7 but not sure if this works
Back to top
View user's profile Send private message
jasorn

Active User


Joined: 12 Jul 2006
Posts: 153
Location: USA

PostPosted: Mon Nov 21, 2016 3:04 am    Post subject: Re: Reply to: ERROR WHILE SUBMITTING LOAD JOB
Reply with quote

We have to do this in two jobs in my shop. In my experience the setup for this varies from shop to shop. It seems to me your team should know these answers or you should meet with your support staff to get an understanding of how things are set up there.

ANURADHA NEELAKANTAN wrote:

Here I am facing a problem like, unable to unload(prod region) and load (dev region) using this single MAIN statement. Is there any way can I do it both in one jcl?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us