DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager

[login to unmask email]

DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager
All,

Looking for input on converting existing Stored Procedures under ****SPAS
control to WorkLoad Manager (WLM). Could use feedback on plan accuracy and
anything I might have missed.

Thanks

Ed


Our plan is the following:

(1) Bring up DB2 using the existing ****SPAS address space and with ZPARM
changes for WLM.

(allow existing Stored Procedure to execute in **SPAS until
conversion takes place)

(2) Define necessary application environment in WLM
(3) For existing stored procedures, convert to WLM as follows:

- Stop Stored Procedure
- Linkedit stored procedure using DSNRLI
- use SQL to alter stored procedure (ALTER PROCEDURE YYYYYY WLM
ENVIRONMENT XXXXXXXX ):
- START Stored Procedure

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Walter Trovijo Jr

Re: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager
(in response to Ed_Vetock@NAVYFEDERAL.ORG)
Ed,

Also, check if RRS is up and running, and if subsystem RRS attachment is
allowed. It´s controlled by profile ssid.RRSAF of RACF DSNR class.

Walter Trovijo Jr





[login to unmask email]
Enviado Por: DB2 Data Base Discussion List <[login to unmask email]>
03/12/2003 09:32
Responder a DB2 Database Discussion list at IDUG


Para: [login to unmask email]
cc:
Assunto: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager

All,

Looking for input on converting existing Stored Procedures under ****SPAS
control to WorkLoad Manager (WLM). Could use feedback on plan accuracy
and
anything I might have missed.

Thanks

Ed


Our plan is the following:

(1) Bring up DB2 using the existing ****SPAS address space and with ZPARM
changes for WLM.

(allow existing Stored Procedure to execute in **SPAS until
conversion takes place)

(2) Define necessary application environment in WLM
(3) For existing stored procedures, convert to WLM as follows:

- Stop Stored Procedure
- Linkedit stored procedure using DSNRLI
- use SQL to alter stored procedure (ALTER PROCEDURE YYYYYY WLM
ENVIRONMENT XXXXXXXX ):
- START Stored Procedure

---------------------------------------------------------------------------------
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". If you will be out of
the office, send the SET DB2-L NO MAIL command to
[login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Philippe Godfrin

Re: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager
(in response to Walter Trovijo Jr)
Greetings,

I've got a similar project underway. I have yet to make WLM and SPAS co-
habitate though. Have you been able to do that?

pg

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

[login to unmask email]

Re: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager
(in response to Philippe Godfrin)
Hi,

we will know tomorrow. WE are going to try and stand up with SPAS and WLM
at same time

R/..Ed



Philippe Godfrin
<[login to unmask email] To: [login to unmask email]
TATE.NJ.US> cc:
Sent by: DB2 Data Base Subject: Re: DB2 z/OS V7.1: Converting Stored Procedures to
Discussion List Workload Manager
<[login to unmask email]>


12/03/2003 10:53 AM
Please respond to DB2
Database Discussion list at
IDUG






Greetings,

I've got a similar project underway. I have yet to make WLM and SPAS co-
habitate though. Have you been able to do that?

pg

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

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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Mark Fleming

Re: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager
(in response to Ed_Vetock@NAVYFEDERAL.ORG)
Ed,

You may also want to check if there are any triggers that are invoking
SPs. When you alter the SP, the dependant trigger package will be
invalidated. If you have auto rebind enabled, then the next time the
trigger package is accessed an auto rebind will be attempted, however,
if the lock on the catalog cannot be obtained it will time out and the
package will be marked not operative. Not a good thing. So, you may want
to add a step to your plan to check trigger packages to ensure they are
all valid and operative.

Mark

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of [login to unmask email]
Sent: Wednesday, December 03, 2003 6:33 AM
To: [login to unmask email]
Subject: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager


All,

Looking for input on converting existing Stored Procedures under
****SPAS
control to WorkLoad Manager (WLM). Could use feedback on plan accuracy
and
anything I might have missed.

Thanks

Ed


Our plan is the following:

(1) Bring up DB2 using the existing ****SPAS address space and with
ZPARM
changes for WLM.

(allow existing Stored Procedure to execute in **SPAS until
conversion takes place)

(2) Define necessary application environment in WLM
(3) For existing stored procedures, convert to WLM as follows:

- Stop Stored Procedure
- Linkedit stored procedure using DSNRLI
- use SQL to alter stored procedure (ALTER PROCEDURE YYYYYY WLM
ENVIRONMENT XXXXXXXX ):
- START Stored Procedure

------------------------------------------------------------------------
---------
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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

James Campbell

Re: DB2 z/OS V7.1: Converting Stored Procedures to Workload Manager
(in response to Mark Fleming)
You've probably got it about right. What I would do a bit different
is to use a different steplib library for the WLM stored procedure.
That way I could
- run with the SPAS address space
- relink all the sp modules with DSNRLI into the wlm library
- alter the first SP as you suggest.
- check the first SP still works, if not alter back to NO WLM
ENVIRONMENT, fix, and retry
- alter remaining SPs, checking as you go.
- there's no pressing need to stop the SPAS.

Has the advantage that the SPs are only off the air for a brief
moment in time.

James Campbell

On 3 Dec 2003 at 7:32, [login to unmask email] wrote:

> All,
>
> Looking for input on converting existing Stored Procedures under ****SPAS
> control to WorkLoad Manager (WLM). Could use feedback on plan accuracy and
> anything I might have missed.
>
> Thanks
>
> Ed
>
>
> Our plan is the following:
>
> (1) Bring up DB2 using the existing ****SPAS address space and with ZPARM
> changes for WLM.
>
> (allow existing Stored Procedure to execute in **SPAS until
> conversion takes place)
>
> (2) Define necessary application environment in WLM
> (3) For existing stored procedures, convert to WLM as follows:
>
> - Stop Stored Procedure
> - Linkedit stored procedure using DSNRLI
> - use SQL to alter stored procedure (ALTER PROCEDURE YYYYYY WLM
> ENVIRONMENT XXXXXXXX ):
> - START Stored Procedure
>
> ---------------------------------------------------------------------------------
> 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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