Db2 Error Code 922
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
Sqlcode 922 Error
a DB2 plan from a CICS transaction. DB2 returns SQLCODE -922 and SQLERRC 00F30034. You are running db2 sql 922 with CA ACF2 from CA. It is active in log mode so you do not expect CA ACF2 to deny access to DB2. Cause CA
Ibm Db2 Error Code
ACF2 is returning the security 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 db2 error code 803 id but there was no logon id 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 db2 error code 104 = -922 AT 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 m
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
Db2 Error Code 551
and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware db2 error code 911 Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker
Db2 Error Code 302
JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All http://www-01.ibm.com/support/docview.wss?uid=swg21161021 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 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 http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-resolve-dsnt408i-sqlcode-922-error-5385111 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 Disaster Recovery Basics - Be Ready For Mother Nature 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
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference http://www.idug.org/p/fo/et/thread=22123 ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional http://www.ibmmainframeforum.com/db2/topic6828.html User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community SQLCODE -922 USER Authorization in DB2 v7 Z/OS Chris Earl SQLCODE -922 USER Authorization in DB2 v7 Z/OS January 9, 2006 11:46 AM We are also receiving intermittent db2 error -922 Authorization Errors. The particular users has authority to the plan and data. What changes if anything should we consider for DSN3SSGN or the DSN3SATH authorization exits. We have multiple IMS regions attaching to one DB2 subsystem could this be a factor? Regards Chris B Earl Systems db2 error code DBA State of Indiana --------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm Gerard LE ROY Re: SQLCODE -922 USER Authorization in DB2 v7 Z/OS January 9, 2006 12:33 PM (in response to Chris Earl) Perhaps the factor is IMS. By default, from IMS, the PLANname is the program name. To override, you need to define an entry in the RTT. Hope this help. Gerard "Earl, Chris" > We are also receiving intermittent -922 Authorization Errors. The > particular users has authority to the plan and data. What changes if > anything shoul
- 922 IBM's flagship relational database management system Post a reply Previous topic • Next topic • 4 posts • Page 1 of 1 SQL error - 922 by p19689 » Tue Dec 20, 2011 10:35 pm Hi , We are getting 922 on one of our COBOL programs after potential RACF changes and the RACF guy is on leave. This happens when it tries to do a INSERT into the Table 'EMPLOYEE'. I have checked all DB2 privilleges and looks OK but couldn't locate the error ! The Table OWNER is 'ABC' and Package owner is also 'ABC' and it's bound to a Collection (An old program) and ABC has execute on collection. the program runs via CA7 by the user XYZ . The user 'XYZ is a member of RACF group 'ABC' , which is the table owner. Could someone shade some light on this please ? What's I'm missing here , Thanks in advance. p19689 Posts: 63Joined: Fri Oct 01, 2010 1:13 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQL error - 922 Top Re: SQL error - 922 by Akatsukami » Tue Dec 20, 2011 11:05 pm Please give the error type and reason code. "You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day Akatsukami Global moderator Posts: 988Joined: Sat Oct 16, 2010 2:31 amLocation: Tottering-on-the-Brink Hasthanked: 6 times Beenthanked: 46 times Top Re: SQL error - 922 by p19689 » Wed Dec 21, 2011 1:57 pm That's one of the problems I'm having. I can't see any error type and reason code it just shows the message 'Update failed - SQL CODE : 00000922 - Contact IT Department ' . How can can I display the error type and the reason code please ? p19689 Posts: 63Joined: Fri Oct 01, 2010 1:13 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQL error - 922 by NicC » Wed Dec 21, 2011 5:19 pm If your RACF guy is on leave he should have a stand-in so ask that person. If there is no stand-in I am moving my business. The problem I have is that people can explain things quickly but I can only comprehend slowly.RegardsNic NicC Global moderator Posts: 2499Joined: Sun Jul 04, 2010 12:13 amLocation: Down on the pig farm Hasthanked: 4 times Beenthanked: 85 times Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Post a reply Previous topic • Next topic • 4 posts • Page 1 of 1 Return to DB2 Jump to: Select a forum ------------------ ANNOUNCEMENTS Forum Rules Site Announcements Suggestions & Feedback Mainframe Related Videos PROGRAMM