IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ERROR WHILE SUBMITTING LOAD JOB


IBM Mainframe Forums -> JCL & VSAM
Post new topic   This topic is locked: you cannot edit posts or make replies.
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
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: 88
Location: India

PostPosted: Thu Aug 25, 2016 12:18 pm
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
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: 316
Location: Room: TREE(3). Hilbert's Hotel

PostPosted: Thu Aug 25, 2016 3:08 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Aug 25, 2016 4:01 pm
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
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Thu Aug 25, 2016 10:43 pm
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
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: 1788
Location: Bloomington, IL

PostPosted: Sun Aug 28, 2016 1:15 am
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: 2455
Location: Hampshire, UK

PostPosted: Sun Aug 28, 2016 4:03 pm
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
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: 202
Location: Toronto, ON, Canada

PostPosted: Wed Oct 05, 2016 1:58 am
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
Warnings : 1

Active User


Joined: 12 Jul 2006
Posts: 191
Location: USA

PostPosted: Mon Nov 21, 2016 3:04 am
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. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts How to load to DB2 with column level ... DB2 6
Search our Forums:

Back to Top