F.Y.I. see below. Was able to resolve my issue with the help of Sri. See below
for information on it.
Regards,
Bill J.
----- Forwarded Message -----
From: Sri h Kolusu <skol...@us.ibm.com>
To: william janulin <wjanu...@yahoo.com>
Sent: Thursday, March 7, 2013 2:34 PM
Subject: Re: DSNE106E message on DB2 batch job
Hi Bill,
Glad that you got it resolved. It would
be good if you can update IBM-MAIN also with the findings so that it would
be useful for someone looking at the same problem.
DSNTIAUL indeed Supports SQL all you
need is to have a PARMS('SQL') in SYSTSIN ex:
//SYSTSIN DD *
DSN SYSTEM(DB2P)
RUN PROGRAM(DSNTIAUL) -
PLAN(DSNTIAUL)
-
PARMS('SQL')
-
LIB('DB2P.RUNLIB.LOAD')
//*
Further if you have any questions please
let me know
Thanks,
Sri
From:
william janulin <wjanu...@yahoo.com>
To:
Sri h Kolusu/Silicon
Valley/IBM@IBMUS,
Date:
03/07/2013 11:20 AM
Subject:
Re: DSNE106E
message on DB2 batch job
________________________________
Yes, I had to use DSNTEP2 as, according to
the documentation, DSNTIAUL does not support the SELECT statement. Turns
out that the plan names were not enabled for BATCH processing. Thank you
for your help on this one.
Regards,
Bill J.
________________________________
From: Sri h Kolusu <skol...@us.ibm.com>
To: william janulin <wjanu...@yahoo.com>
Sent: Thursday, March 7, 2013 11:10 AM
Subject: Re: DSNE106E message on DB2 batch job
Hi William,
You need to run the SQL I showed in either SPUFI or QMF .
I am guessing that you ran using a JCL? If so you need to run it using
the plan DSNTIAUL or DSNTEP2
Thanks,
Sri
From: william
janulin <wjanu...@yahoo.com>
To: Sri
h Kolusu/Silicon Valley/IBM@IBMUS,
Date: 03/07/2013
07:27 AM
Subject: Re:
DSNE106E message on DB2 batch job
________________________________
Sri,
OK I tried that and I get the following error message on the job:
SELECT *
FROM SYSIBM.SYSPLSYSTEM
WHERE NAME='TRANSLD'
SQL ERROR DURING EXECUTE IMMEDIATE
DSNT408I SQLCODE = -518, ERROR: THE EXECUTE STATEMENT DOES NOT IDENTIFY
A VALID PREPARED STATEMENT
DSNT418I SQLSTATE = 07003 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEDS1 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -515 0 0 -1 0
0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFDFD' X'00000000' X'00000000'
X'FFFFFFFF' X'000
INFORMATION
?????
Bill J.
________________________________
From: Sri h Kolusu <skol...@us.ibm.com>
To: IBM-MAIN@LISTSERV.UA.EDU
Sent: Wednesday, March 6, 2013 3:06 PM
Subject: Re: DSNE106E message on DB2 batch job
Check SYSIBM.SYSPLSYSTEM catalog table and make sure you have the right
value in column "SYSTEM" for the plan
SELECT *
FROM SYSIBM.SYSPLSYSTEM
WHERE NAME = 'TRANSLD'
;
The SYSIBM.SYSPLSYSTEM table layout is explained here
http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_sysibmsysplsystemtable.htm
Sri
IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu>
wrote on
03/06/2013 11:45:17 AM:
> From: william janulin <wjanu...@yahoo.com>
> To: IBM-MAIN@listserv.ua.edu,
> Date: 03/06/2013 11:47 AM
> Subject: DSNE106E message on DB2 batch job
> Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu>
>
> To list;
>
> I have a batch job that is getting an error message:
>
> DSNE106E PLAN TRANSLD NOT AUTHORIZED FOR SUBSYSTEM DB8G AND AUTH ID
IBMUSER
>
>
> This is also happening on another plan name TRANSPD.
>
> I did a GRANT EXECUTE on both plans to the userid of PUBLIC.
>
> Not sure where to go next on this. I know that a DB2BIND was run
> against the two plann and the subsystem.
>
> Any help would be greatly appreciated.
>
> Regards,
> Bill J.
>
> ----------------------------------------------------------------------
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.eduwith the message: INFO IBM-MAIN
>
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.eduwith the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
