922 Db2 Error
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back
Plan Access Error. Reason 00f30034
CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS
Sql Reason=00f30034
Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day JoeTorre Andrew.S.Baker Richard bracke Ramnath.Awate DukeGanote Locutus Nikki sqlcode 922 mainframe Klein Dennis Stevenson Craig Borysowich AbhaiTripathi Clinton Jones bluesguyAZ59 iudithm knowscognosdoi mircea_luca Iqbalyk COMPANIES CloudLock Trend Micro Incorporated Citrix Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n922.html New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-resolve-dsnt408i-sqlcode-922-error-5385111 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. How to Resolve DSNT408I SQLCODE = -922 Error Santa asked Dec 16, 2013 | Replies (1) While debugging a cobol-db2 program getting DSNT408I SQLCODE = -922 error when trying to open a cursor. Can anyone suggest a solution? Join this group Popular White Paper On This Topic Taking Business Intelligence to the Next Level 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Angelo Sironi replied Dec 16, 2013 Hi Santa, I guess you get the error while trying to conenct to DB2 for z/OS. If that's the case, you should use the DB2 for z/OS thread and not the DB2 for LUW one. You should also tell us the DB2 Version and Release level. If you look at the DB2 for z/OS Codes manula (you can download it from the IBM site), you'll find that -922 is an authorization issue. -922 AUTHORIZATION FAILURE: error-type ERROR. REASON reason-code The Reason Code tells you the reason
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual http://database.ittoolbox.com/groups/technical-functional/db2zos-l/error-922-authorization-failure-while-executing-cicsdb2-pgm-3604514 Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day JoeTorre Andrew.S.Baker Richard bracke Ramnath.Awate DukeGanote Locutus Nikki Klein Dennis Stevenson Craig Borysowich AbhaiTripathi Clinton Jones bluesguyAZ59 iudithm knowscognosdoi mircea_luca Iqbalyk COMPANIES CloudLock Trend Micro Incorporated Citrix Panaya Inc. db2 error View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 for z/OS For discussion on DB2 for z/OS , please visit the Database - General Discussions group. More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your 922 db2 error account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error -922 Authorization Failure while Executing CICS-Db2 Pgm Jeyan S asked Jun 30, 2010 | Replies (10) Hi while executing the CICS-Db2 Pgm I am getting an Error -922 ( Authorization Failure ) , but I am not able track the issue whether plan authorization / User ID Auth , So I displayed the SQLERRP - that is showing DSNAET03 and ERRM is ..PLAN ACCESS.00F30034, what is that ? in which table of SYSIBM. can I find that one ? Please suggest Join this group 10Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Suren Pathuri replied Jun 30, 2010 Hi There The userid who trying to execute need to have execute privelage GRANT EXECUTE ON PLAN(NAME) TO USERID COMMIT; It should