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 maxcc 256 while running a db2 batch job

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
madhan r

New User


Joined: 29 Jul 2011
Posts: 4
Location: INDIA

PostPosted: Fri Aug 12, 2011 4:59 pm    Post subject: Error maxcc 256 while running a db2 batch job
Reply with quote

hi friends i got an error maxcc 256 while running a db2 batch job

this is my error reportREADY
DSN SYSTEM(DA11)
DSN
RUN PROGRAM(INSERT1) PLAN(TRC113AD) LIBRARY ('TRC113.DB2.LOADLIB')
PLAN TRC113AD NOT AUTHORIZED FOR SUBSYSTEM DA11 AND AUTH ID TRC113
DSN
END
READY
END

this is my run jcl

SQLSTEP EXEC PGM=IKJEFT01,DYNAMNBR=30
SYSTSPRT DD SYSOUT=*
SYSTSIN DD *
DSN SYSTEM(DA11)
RUN PROGRAM(INSERT1) PLAN(TRC113AD) -
LIBRARY ('TRC113.DB2.LOADLIB')
END
SYSPRINT DD SYSOUT=*
SYSOUT DD SYSOUT=*
DD1 DD DSN='TRC113.DB2.ADDBOOK',DISP=SHR
SYSOUT DD SYSOUT=*
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Aug 12, 2011 5:04 pm    Post subject:
Reply with quote

PLAN TRC113AD NOT AUTHORIZED FOR SUBSYSTEM DA11 AND AUTH ID TRC113
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Fri Aug 12, 2011 5:14 pm    Post subject:
Reply with quote

madhan r: either you cannot read, or you do not believe what the computer tells you for who knows what reason -- in either case, a career in IT is definitely NOT your best bet. The computer does not lie -- it may be difficult to interpret what the computer is telling you, but it does not lie. But in this case the interpretation is very easy and straightforward.

On the other hand, your statement
Quote:
this is my run jcl
is a lie. JCL lines start with two slashes or a slash asterisk and continue from there. Since NONE of your lines have slashes at the front, this is not JCL.
Back to top
View user's profile Send private message
madhan r

New User


Joined: 29 Jul 2011
Posts: 4
Location: INDIA

PostPosted: Tue Aug 16, 2011 3:35 pm    Post subject:
Reply with quote

am using same plan trc113ad for my bindjcl...... it has been binded successfully..........
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Tue Aug 16, 2011 3:58 pm    Post subject: Reply to: Error maxcc 256 while running a db2 batch job
Reply with quote

Isn't it obvious to look into the authorised bit?
Back to top
View user's profile Send private message
prasun dhara

New User


Joined: 01 Mar 2008
Posts: 49
Location: kolkata

PostPosted: Wed Aug 17, 2011 11:39 pm    Post subject:
Reply with quote

Have you tried the following ?

GRANT EXECUTE ON PLAN TRC113AD TO PUBLIC
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 17, 2011 11:47 pm    Post subject:
Reply with quote

Hello,

What if the plan is NOT for public use?

@madhan r
Suggest yoiu talk with your management or the dba before granting to public . . .
Back to top
View user's profile Send private message
BrantleyL

New User


Joined: 03 Jun 2010
Posts: 14
Location: Dallas TX

PostPosted: Thu Aug 18, 2011 1:34 am    Post subject:
Reply with quote

Gentlemen,

Let's try and be a bit more civil. No need to YELL.

The question I have is what level is the DA11 system at? Test/Production??

In our shop, we have 3 levels - Work (development), Test (real User Acceptance Testing) and Production. Developers can run jobs for work. Some of us can run jobs for some of our UAT tables. None of us can run them for production. So, I'd suspect that it's something along those lines.

Talk to your DBA.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Aug 18, 2011 1:52 pm    Post subject: Reply to: Error maxcc 256 while running a db2 batch job
Reply with quote

it is not an issue about civilization...
it is just the usual issue with posters who ask without reading and understanding what the <computer> tells them ...
in the hope that an answer from the forum will slap their system and fix things automagically
so yelling in this case is more than justified icon_cool.gif

the message was clear, there are authorization issues...

the level the system (prod,trest,toy1,toy2,....) is irrelevant,
Your setup is irrelevant

the TS must work with his DBA support team to find out what is going on in the subsystem he is working ...

none of the people answering belong to the TS organization,
we do not know their standards and their setup

so the only thing to do is to pursue the message received
Quote:
PLAN TRC113AD NOT AUTHORIZED FOR SUBSYSTEM DA11 AND AUTH ID TRC113
with the in house support!
Back to top
View user's profile Send private message
BrantleyL

New User


Joined: 03 Jun 2010
Posts: 14
Location: Dallas TX

PostPosted: Thu Aug 18, 2011 6:10 pm    Post subject:
Reply with quote

I agree that there are autrhoization issues. I was trying to ewxpand on that thought. Developers should have (full) access to development environments. Much less so for UAT and Production.

Just trying to give him a pointer.

I still say (as do you) - talk to the DBA.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 19, 2011 1:37 am    Post subject:
Reply with quote

Hello,

Quote:
Developers should have (full) access to development environments.
Opinions vary icon_wink.gif

Many of the organizagtions i've supported treat development with as much care as uat or production. This is because in organizatons with a large IT staff, IT is the most expensive department in the organization. They do not want someone working on one project to "take out" somethng others are using.

A few places have set un a separate lpar for large projects and only those working on the project have a login id. These sometimes are allowed to have more access.

As i'm the migrant data worker, i go with whatever the site standard dictate - unless there so horrible that i must at least point out alternatives. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 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 How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
This topic is locked: you cannot edit posts or make replies. MIPS reduction for Batch job Virendra Shambharkar All Other Mainframe Topics 8 Mon Nov 07, 2016 4:02 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm


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