Error maxcc 256 while running a db2 batch job

madhan r · New User Joined: 29 Jul 2011 Posts: 4 Location: INDIA

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=*

dbzTHEdinosauer · Posted: Fri Aug 12, 2011 5:04 pm

PLAN TRC113AD NOT AUTHORIZED FOR SUBSYSTEM DA11 AND AUTH ID TRC113

Robert Sample · Posted: Fri Aug 12, 2011 5:14 pm

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

madhan r · New User Joined: 29 Jul 2011 Posts: 4 Location: INDIA

am using same plan trc113ad for my bindjcl...... it has been binded successfully..........

Bill Woodger · Posted: Tue Aug 16, 2011 3:58 pm

Isn't it obvious to look into the authorised bit?

prasun dhara · New User Joined: 01 Mar 2008 Posts: 49 Location: kolkata

Have you tried the following ?

GRANT EXECUTE ON PLAN TRC113AD TO PUBLIC

dick scherrer · Posted: Wed Aug 17, 2011 11:47 pm

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

BrantleyL · New User Joined: 03 Jun 2010 Posts: 14 Location: Dallas TX

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.

enrico-sorichetti · Posted: Thu Aug 18, 2011 1:52 pm

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

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

BrantleyL · New User Joined: 03 Jun 2010 Posts: 14 Location: Dallas TX

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.

dick scherrer · Posted: Fri Aug 19, 2011 1:37 am

Hello,