Stored Procedure without WLM

Buz W

Stored Procedure without WLM

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



---------------------------------
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.

Dave Nance

Re: Stored Procedure without WLM
(in response to Buz W)
Buz,
You can create stored procs without WLM. Are you sure your create stmt was correct? Here's a copy of a create in V6 on os/390 machine that does work fine.

CREATE PROCEDURE XXXXX.FHSC_DATE_ROUTINE
(INOUT VARIN CHAR(164) ) -- FOR BIT DATA)
LANGUAGE COBOL
EXTERNAL NAME CNVDT
COLLID SQLTOOLS
NO WLM ENVIRONMENT
PROGRAM TYPE MAIN
STAY RESIDENT YES
PARAMETER STYLE GENERAL
READS SQL DATA


>>> [login to unmask email] 01/09/02 02:14PM >>>

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



---------------------------------
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.

This message, including any attachments, is intended solely for the use of the named
recipient(s) and may contain confidential and/or privileged information. Any
unauthorized review, use, disclosure or distribution of this communications is expressly
prohibited. If you are not the intended recipient, please contact the sender by reply e-mail
and destroy any and all copies of the original message. Thank you.



Buz W

Stored Procedure without WLM
(in response to Dave Nance)

It has been requested that I post the CREATE statement to the list..............

--*
CREATE PROCEDURE SYSPROC.SPDSMESX
(MESS_ID CHAR(8) INOUT,
MESS_TEXT VARCHAR(1022),
OUT_CODE INTEGER OUT)
EXTERNAL NAME 'SPDSMESX'
LANGUAGE COBOL
PARAMETER STYLE GENERAL
STAY RESIDENT YES
NO WLM ENVIRONMENT
PROGRAM TYPE MAIN
COMMIT ON RETURN NO
--*


Thanks.

Buz Williams
Dallas, TX



---------------------------------
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.

teldb2kals

Re: Stored Procedure without WLM
(in response to Buz W)
Buz,

Did u try giving READ access to the DSNR class RACF profile protecting
the SPAS (ssid.WLMENV.ssidSPAS), where "ssid" is ur subsystem name ?

For more infm, please refer to the section "Establishing RACF
protection for stored procedures" in the Admin Guide (Control of stored
procedures in a DB2 established address space) in Chapter 3.4

Cheers,
Kals

-----Original Message-----
From: Buz W [SMTP:[login to unmask email]
Sent: Thursday, January 10, 2002 7:40 AM
To: [login to unmask email]
Subject: Stored Procedure without WLM

It has been requested that I post the CREATE statement to the
list..............

--*                             
CREATE PROCEDURE SYSPROC.SPDSMESX
       (MESS_ID CHAR(8) INOUT,  
       MESS_TEXT VARCHAR(1022), 
       OUT_CODE INTEGER OUT)    
   EXTERNAL NAME 'SPDSMESX'     
   LANGUAGE COBOL               
   PARAMETER STYLE GENERAL      
   STAY RESIDENT YES            
   NO WLM ENVIRONMENT           
   PROGRAM TYPE MAIN    ! ! ! ;        
   COMMIT ON RETURN NO          
--*                             


Thanks.

Buz Williams
Dallas, TX


----------------
Powered by telstra.com