RE : Stored Procedure without WLM

Renaud Plourde

RE : Stored Procedure without WLM
Here's another cause for the SQLCODE -592: 


  ***Action for PQ23079:

  See PQ23079 APAR/PTF text for additional information.

  This APAR/PTF changes the text of SQL code -592.  The change is
  documented in the DB2 Messages and Codes manual (GC26-9011).

  The new text for SQL code -592 is:

   -592 NOT AUTHORIZED TO CREATE FUNCTIONS OR
   PROCEDURES IN WLM ENVIRONMENT env-name

   System Action: The statement cannot be executed.

   Programmer Response: Choose a different value for the WLM
   ENVIRONMENT keyword, or request authorization to create
   objects in the specified WLM ENVIRONMENT from the system
   administrator.
  |If the value of the 'env-name' token is 'NO WLM ENVIRONMENT'
  |then NO WLM ENVIRONMENT was specified on CREATE PROCEDURE,
  |and the check for authorization to the DB2-managed
  |stored procedures address space failed.  This can also occur
  |if there is no DB2-managed stored procedures address space.
  |Request that a DB2-managed stored procedures address space
  |be created if one doesn't currently exist. Request that a
  |RACF PERMIT be done to allow access to this resource.
   After doing one of the above reissue the SQL statement.
 


Renaud Plourde
Regie des rentes du Quebec

 


 Greetings all,

I'm trying to create a stored procedure in a DB2 v6 environment that has no
WLM regions defined. I'm using NO WLM ENVIRONMENT, but the message I get
back is "DSNT408I SQLCODE = -592, ERROR: NOT AUTHORIZED TO CREATE FUNCTIONS
OR PROCEDURES IN WLM ENVIRONMENT NO WLM ENVIRONMENT"; which is odd since I'm
a SYSADM.

I know it's best to use WLM. I'm working on a client system and they don't
have WLM (yet). I can't very well tell them I won't continue the project
until WLM is in place.

Any suggestions?

Thanks.

Buz Williams
Dallas, TX