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