922 Db2 Error Code
Contents |
ACF2 ACF2 00F30034 RSN00F30034 CODE -922 SQLCODE-922 SQLCODE922 negative 922 computer associates 5697E9300 R200 200 R620 620 R300 300 R630 630 HCI6300 HCI6200 5697-E93 5697E93 KIXINFO retention23 Technote (troubleshooting) Problem(Abstract) You receive an abend AD2U ( abendAD2U ) in module DFHD2EX1 when trying to access a DB2 plan db2 sql 922 from a CICS transaction. DB2 returns SQLCODE -922 and SQLERRC 00F30034. You are running with CA ACF2 from ibm db2 error code CA. It is active in log mode so you do not expect CA ACF2 to deny access to DB2. Cause CA ACF2 is returning the security db2 error code 803 violation because transaction security is being used instead of user security. When transaction security is used there is no userid associated with the task. CA ACF2 is looking for a userid to check for a valid logon id but there was no logon id
Db2 Error Code 104
found. Diagnosing the problem Following is a CEDF screen that contains the DB2 error: STATUS: COMMAND EXECUTION COMPLETE CALL TO RESOURCE MANAGER DSNCSQL EXEC SQL SET HOST VAR P.AUTH=RXMU , S.AUTH= PLAN=DPO2701L, DBRM=DPO2701L, STMT=00368, SECT=00001 SQL COMMUNICATION AREA: SQLCABC = 136 AT X'001887E0' SQLCODE = -922 AT db2 error code 551 X'001887E4' SQLERRML = 020 AT X'001887E8' SQLERRMC = 'PLAN ACCESS,00F30034' AT X'001887EA’ CICS trace contains the same error information. The plan name (DP02701L) is in the LOT+54, the primary authorization (RMXU) is in the LOT+80, and the SQLERRMC (00F30034) is in the FRB+10. A reason code of 00F30034 means the program attempting to execute the plan is not authorized to use the plan. This typically is fixed by GRANTing authority to the authid. It was surprising that CA ACF2 denied access to DB2 because it was active in LOG mode as follows: This should mean that access violations are logged but access is not denied. Resolving the problem Do one or both of the following: Inactivate CA ACF2 for the DB2 subsystem and cycle DB2 by entering the following commands: SET CONTROL(DB2) SYSID(xxxx) - where xxxx is the DB subsystem CHANGE OPTS NOACTIVE Apply CA ACF2 release 1.1 fixes TB0064C, TB0064B, and TB0065B. These fixes stop CA ACF2 from doing CICS security checking. This accomplishes the same thing as inactivating CA ACF2. CA ACF2 security should be inactive for CICS. Security checking should be done within CICS and DB2. Contact CA if you need further assistance. When you inactivate ACF2 for the DB2 subsystem the following messages are written to the DB2 log (DSNBMSTR): When you activate ACF2 for the DB2 subsystem the following messages are written to the DB2 log ( DSNBMSTR ) after message DSNR002I -xxxx RESTART COMPLETED: Product Alias/Synonym CICS/TS CICS TS C
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio db2 error code 911 Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and
Db2 Error Code 302
Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design
Db2 Error Code 805
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 http://www-01.ibm.com/support/docview.wss?uid=swg21161021 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 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 http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-resolve-dsnt408i-sqlcode-922-error-5385111 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 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 Business Intelligence with SharePoint 2010 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving..
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 http://database.ittoolbox.com/groups/technical-functional/db2zos-l/error-922-authorization-failure-while-executing-cicsdb2-pgm-3604514 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 http://www.mainframegurukul.com/ibmmainframeforums/viewtopic.php?t=3950 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. View All db2 error 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 account,sign in here db2 error code 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 take care of the Issue T
Log in MAINFRAME - TIP OF THE DAY : programming pearls - Good judgement comes from experience, and experience comes from bad judgement. Web mainframegurukul.com Programmers Voted for below topics. Please Vote for good Posts. Votes Salutes Topic Title Votes Salutes EJECT Verb in COBOL 21 Cobol Multiple Choice Questions By Shravan Wipro 16 what is index or subscript in cobol. please give me brief ex 14 jcl sort to add leading zeroes 13 SOC 7 abend - interview question 13 what is static or dynamic call in cobol 13 How to resolve soc7? 12 Hexadecimal to decimal conversion - SORT JCL INREC OUTREC 12 Infosys Training Program for freshers 10 HOW TO FIND LINKAGE LENGTH 10 VSAM File status 23 ,but records are present in the file 7 Changes in copybook 6 splitting of records using cobol 6 JOIN UNPAIRED,F1,F2,ONLY 6 Endevor 6 Difference Between XCTL and LINK 5 Frequently used commands in FileAid. 5 Interview questions - 3 years Exp - BOA, HCL and CTS 4 Various Locking mechanism for cursors and other SQL? 4 GDG interview question 4 Comparing two files 4 JCL return codes 4 COBOL Program performance tuning tips 4 JOIN UNPAIRED,F1,F2,ONLY 3 3 alphanumeric to numeric value padding with ZEROS in COBOL 3 3 How to Display COMP-3 value in report 3 3 JCL to Purge All Held output? 3 IKJ56500I COMMAND DSN NOT FOUND 3 S322 abend while sorting records 3 Call & Execute a COBOL-DB2 from a COBOL program? 3 compare two files using SORT 3 Submit a JCL thru Cobol - sysout=(INTRDR,*) 3 Comparing 2 files based on Acct number without using tables 3 Sort fields difference 3 Sending an Email from JCL with attachment 3 Control flow from one STEP to another 3 Recently faced mainframe cobol Interview Questions. 3 RESTART - Executing 2 and 3 rd step in 5 step jcl 3 sort two files with same sort condition 3 static and dynamic calls 3 What are the issues related with corr