Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1783
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: 1783
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: 1544
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 -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us