[DB2-L] Error Code -922

Georg Peter

[DB2-L] Error Code -922
Jerry, you may try

GRANT EXECUTE ON PLAN yourplan TO XYZ ;

XYZ can be a userid or a racf group e.g.

If your cobol program is bound as a package (and not as a plan) use

GRANT EXECUTE ON PACKAGE yourcollection.* TO XYZ ;

HTH.

With kind regards - mit freundlichen Gruessen,
G e o r g H . P e t e r
Asst. Chairmain GSE Workinggroups DB2 Nord und Sued
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Development and Product Support (E3)
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany, Europe
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------
»"Next time you think you're perfect - try walk on water!"«

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag
von Jerry Ragland
Gesendet: Dienstag, 27. Dezember 2005 13:51
An: [login to unmask email]
Betreff: Re: [DB2-L] Error Code -922


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

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

Martin Kenney

Re: Error Code -922
(in response to Georg Peter)
Jerry, if this is a CICS program then the RCT definition of the
transaction
determines what you need to grant authority to.

Marty Kenney
Sr. DB2 DBA
Railinc
(919) 651-5211


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jerry Ragland
Sent: Tuesday, December 27, 2005 7:51 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Error Code -922

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

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

Avram Friedman

Re: Error Code -922
(in response to Martin Kenney)
Hi Jerry
Your question yesterday titled
"[DB2-L] DB2 - Plan Error"
contained the correct statement for GRANT of EXECUTE authorities.
It was missing the BIND.

It might pay to read the

Title: DB2 UDB for OS/390 and z/OS V7 Application Programming and SQL Guide

at http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnaph15/CCONTENTS


and

Title: DB2 UDB for OS/390 and z/OS V7 Administration Guide
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnagh15/CCONTENTS

In the case of todays question
Section 3 of the Administration Guide covesw this in great detail.
There is a fair amount of detail involved in developimg and managing applications in most production environments. Being able to get through difficulties in an open test system is often much diffrent than dealing with the same questions in a more controled production system.

Best wishes, I am sure I reflect the sentament of the group when I say 'everyone' is willing to help you get over the problems.

Jerry Ragland <[login to unmask email]> wrote:
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 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




Avram Friedman
(877)311-0480 Voice Mail
[login to unmask email]
Http://www.IBMsysProg.com




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