-922 Authorization Error

gaurav.rajvanshi · Posted: Tue May 28, 2013 7:54 pm

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?

Akatsukami · Posted: Tue May 28, 2013 8:15 pm

Please give the exact message, including the error type and reason code.

gaurav.rajvanshi · Posted: Tue May 28, 2013 8:22 pm

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...

Akatsukami · Posted: Tue May 28, 2013 8:35 pm

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.

Pandora-Box · Posted: Tue May 28, 2013 8:48 pm

And I would suggest to use DSNTIAR

So even in future you could narrow down by looking at a better displayed error message

gaurav.rajvanshi · Posted: Wed May 29, 2013 4:57 pm

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.

Anuj Dhawan · Posted: Wed May 29, 2013 5:44 pm

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:

gaurav.rajvanshi · Posted: Wed May 29, 2013 7:00 pm

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.

Anuj Dhawan · Posted: Wed May 29, 2013 7:11 pm

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.