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 <[email protected]> wrote on 03/06/2013 11:45:17 AM: > From: william janulin <[email protected]> > To: [email protected], > Date: 03/06/2013 11:47 AM > Subject: DSNE106E message on DB2 batch job > Sent by: IBM Mainframe Discussion List <[email protected]> > > 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 [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
