ERROR WHILE SUBMITTING LOAD JOB

ANURADHA NEELAKANTAN · New User Joined: 23 Aug 2016 Posts: 5 Location: INDIA

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

Abid Hasan · New User Joined: 25 Mar 2013 Posts: 88 Location: India

Hello,

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

ANURADHA NEELAKANTAN · New User Joined: 23 Aug 2016 Posts: 5 Location: INDIA

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.

mistah kurtz · Posted: Thu Aug 25, 2016 3:08 pm

Check with your site support. I guess you need to define //*MAIN parameter in the job, just after the job card something like below:

Robert Sample · Posted: Thu Aug 25, 2016 4:01 pm

//*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.

ANURADHA NEELAKANTAN · New User Joined: 23 Aug 2016 Posts: 5 Location: INDIA

I posted my query to the site support as suggested. Will update you once i get what is the reason behind this problem.

Rohit Umarjikar · Posted: Thu Aug 25, 2016 10:43 pm

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.

ANURADHA NEELAKANTAN · New User Joined: 23 Aug 2016 Posts: 5 Location: INDIA

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 ..

Ironic to deal!

Akatsukami · Posted: Sun Aug 28, 2016 1:15 am

Again, Anuradha-chan, we need to see the JCL and control cards used, and the actual messages received.

Nic Clouston · Posted: Sun Aug 28, 2016 4:03 pm

There can be differences between online and batch authorities. Check with your security group.

ANURADHA NEELAKANTAN · New User Joined: 23 Aug 2016 Posts: 5 Location: INDIA

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?

jerryte · Posted: Wed Oct 05, 2016 1:58 am

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

jasorn · Active User Joined: 12 Jul 2006 Posts: 191 Location: USA

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.