Error Code -922

Jerry Ragland

Error Code -922
Hi all,

I get the -922 error code when I run my cobol program which has a insert
stmt. in to a DB2.

The explanation for this error code is given as -

-922 AUTHORIZATION FAILURE: error-type
and the error-type I get is user authorization

If error-type is user authorization:, the authorization-ID specified to DB2
through your attachment facility is not valid for DB2. See your system
programmer or your CICS, IMS, or TSO system administrator.

What all the things I need to look for to avoid this problem ?

Please clarify..

Thanks in advance,
Jerry

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

Jay Reavill

Re: Error Code -922
(in response to Jerry Ragland)
Typically a -922 on authority is one of the following...

- Execute auth on the plan is missing
- Execute auth on the package is missing

Make sure the id you're executing under has these auths.

Hope that helps,
Jay

----------------------------------------
Jay Reavill DBA
Certegy Card Services
11601 Roosevelt Blvd.
St. Petersburg, FL. 33716
Office (727) 227-2144
----------------------------------------




"Jerry Ragland"
<jerry_r_ragland To: [login to unmask email]
@YAHOO.COM> cc:
Sent by: "DB2 Subject: [DB2-L] Error Code -922
Data Base
Discussion List"
<[login to unmask email]
.ORG>


12/27/2005 05:04
AM
Please respond
to "DB2 Database
Discussion list
at IDUG"





Hi all,

I get the -922 error code when I run my cobol program which has a insert
stmt. in to a DB2.

The explanation for this error code is given as -

-922 AUTHORIZATION FAILURE: error-type
and the error-type I get is user authorization

If error-type is user authorization:, the authorization-ID specified to DB2
through your attachment facility is not valid for DB2. See your system
programmer or your CICS, IMS, or TSO system administrator.

What all the things I need to look for to avoid this problem ?

Please clarify..

Thanks in advance,
Jerry

---------------------------------------------------------------------------------

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








------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail [login to unmask email]
=====

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

Jerry Ragland

Re: Error Code -922
(in response to Jay Reavill)
Hi Jay,

Thanks for your reply...
Can u please tell me where to give the execute auth and what should be given.

Thanks,
-Jerry.

On Tue, 27 Dec 2005 07:50:35 -0500, Jay Reavill <[login to unmask email]> wrote:

>Typically a -922 on authority is one of the following...
>
>- Execute auth on the plan is missing
>- Execute auth on the package is missing
>
>Make sure the id you're executing under has these auths.
>

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