Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

-922 Authorization Error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gaurav.rajvanshi

New User


Joined: 08 Jul 2010
Posts: 23
Location: Mainframe World

PostPosted: Tue May 28, 2013 7:54 pm    Post subject: -922 Authorization Error
Reply with quote

Hi,

As my colleague is also working on the same program, so to start testing for one of the sections in that module, I created a copy of the program and renamed it in same Changeman package. I staged and promoted it with same plan and compilation and bind were successful.

When I ran the JCL, the program is returning -922 error. Please guide as what can be the issue here, as the original program is running without any issue with my id.

Does plan has relation with the program name also?
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Tue May 28, 2013 8:15 pm    Post subject:
Reply with quote

Please give the exact message, including the error type and reason code.
Back to top
View user's profile Send private message
gaurav.rajvanshi

New User


Joined: 08 Jul 2010
Posts: 23
Location: Mainframe World

PostPosted: Tue May 28, 2013 8:22 pm    Post subject: Reply to: -922 Authorization Error
Reply with quote

Sorry Akatsukami, but there is an error handling condition in the program for db2 error codes and the program does not abend. It is coded to display the type of error in spool sysout.

Any suggestions can help...
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Tue May 28, 2013 8:35 pm    Post subject:
Reply with quote

Did I stutter? I asked for the exact message, including the error type and reason code. I did not say that the program did or should have abended (note that there is a difference between a true abend, a non-zero return code, and a negative SQLCODE).

Apparently your shop adopts the policy of concealing as much information as possible from the analyst. To debug under those circumstances required some dedicated, hands-on work by a skilled analyst. Good luck.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Tue May 28, 2013 8:48 pm    Post subject:
Reply with quote

And I would suggest to use DSNTIAR icon_smile.gif

So even in future you could narrow down by looking at a better displayed error message
Back to top
View user's profile Send private message
gaurav.rajvanshi

New User


Joined: 08 Jul 2010
Posts: 23
Location: Mainframe World

PostPosted: Wed May 29, 2013 4:57 pm    Post subject: Reply to: -922 Authorization Error
Reply with quote

Thanks All for the suggestions...

We need to have an RTT(Resource Translation Table) entry of the new module renamed.

We need to define any Program/Transaction which calls a DB2 table in the RTT table (in all profiles and environments). The RTT provides the optimum path to take data from DB2 table, by defining the Main driver program/transaction. Resource translation table (RTT), maps the IMS application names into DB2 plan names. If this entry is omitted, the DB2 plan name is the IMS application load module name.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed May 29, 2013 5:44 pm    Post subject:
Reply with quote

Gaurav,

SQLCODE -922 would mean "AUTHORIZATION FAILURE" as you've also said, however, why the Authorization might fail will be displayed in the 'failed-Job' somewhere (SYSOUT?). You might get one of these failures:
  • User authorization
  • Plan access
  • Duplicate exit requested
  • Installation error
  • Connect
and that's what Akatsukami has asked for, so that we'd know/guess the reason behind the failure.

OTOH, I'll try to read between the lines and per this:
Quote:
I staged and promoted it with same plan and compilation and bind were successful.
I'll ask - have you changed the MEMBER(new-program) also in the "new-BIND card"?
Back to top
View user's profile Send private message
gaurav.rajvanshi

New User


Joined: 08 Jul 2010
Posts: 23
Location: Mainframe World

PostPosted: Wed May 29, 2013 7:00 pm    Post subject: Reply to: -922 Authorization Error
Reply with quote

Yes Anuj, the new member name was also changed in the Bind Card.

As I checked the Reason/Status codes from the abend, everthing pointed towards Authorization. Also, i checked the SYSPKGAUTH table where the entry for the new program was made with all necessary accesses and they matched with the old program's accesses also.

I went thru one of the links where it was stated to have an RTT entry to prevent -922.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed May 29, 2013 7:11 pm    Post subject:
Reply with quote

Then set-up at your site does not allow to use some BIND card "on the fly" and you'd need to involve your DBA to create the BIND for you. Not doing so might give you kind of error you see.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us