Database Analyzer for DB2 for Z/OS : Copy / migrate Extract and Action procedures to DB2 subsystems on a different LPAR
Article ID: 50983
Updated On:
Products
Database Analyzer for DB2 for z/OS
Issue/Introduction
Are Extract and Actions procedures able to be copied into a sandbox system rather than recreating them on the sandbox system?
Is there a way to copy Extract and Action procedures to a different subsystem?
Environment
Release: R20
Component: PDA
Resolution
Existing Extract or Action procedures are able to be copied to another location or a local subsystem.
This feature is useful for:
1. copying procedures from one environment to another.
2.quickly create procedures in multiple locations rather than creating entire procedures.
The task is accomplished with the C(opy) option within the Extract/Action Procedure Services screens.
As an example: One Extract and one tied action procedure:
RDA.CPL ----- EXTRACT PROCEDURE SERVICES ---- yyyy/mm/dd hh:mm
COMMAND ==> SCROLL ==> CSR
PROCEDURE SELECTION LIST PARAMETERS
Name ==> G% Creator ==> AUTHID Subsystem ==> SRC1
Desc ==> * Location ==> LOCAL
-------------------------------------------- SQLID: AUTHID User ID: AUTHID
S A DB2 LAST UPDATE LAST SUBMIT
O EXT PROC PROCEDURE DESCRIPTION CREATOR O P SYSD DATE TIME DATE TIME
_ ________ _________________________ AUTHID N N <=== NEW PROCEDURE CREATION
C GDGIC GDGIC AUTHID U Y SRC1 09/08 01:55 09/08 01:51
******************************** BOTTOM OF DATA *******************************
RDA.APL ---- ACTION PROCEDURE SERVICES ---- yyyy/mm/dd hh:mm
COMMAND ==> SCROLL ==> CSR
PROCEDURE SELECTION LIST PARAMETERS
Name ==> * Creator ==> AUTHID1 Subsystem ==> SRC1
Desc ==> * Location ==> LOCAL
------------------------------------------- SQLID: AUTHID1 User ID: AUTHID1
O ACT PROC PROCEDURE DESCRIPTION CREATOR SHR SYB CND DATE TIME EXTR CNT
_ ________ _________________________ AUTHID1 N <=== NEW PROCEDURE CREATION
_ GDGCRE CREATE GDG IF REQ'D AUTHID1 U D N 09/08 00:43 1
******************************** BOTTOM OF DATA *******************************
Enter the copy line command against the extract procedure....
RDA.CPL ----- EXTRACT PROCEDURE SERVICES ---- yyyy/mm/dd hh:mm
COMMAND ==> SCROLL ==> CSR
PROCEDURE SELECTION LIST PARAMETERS
Name ==> G% Creator ==> AUTHID Subsystem ==> SRC1
Desc ==> * Location ==> LOCAL
-------------------------------------------- SQLID: AUTHID User ID: AUTHID
S A DB2 LAST UPDATE LAST SUBMIT
O EXT PROC PROCEDURE DESCRIPTION CREATOR O P SYSD DATE TIME DATE TIME
_ ________ _________________________ AUTHID N N <=== NEW PROCEDURE CREATION
C GDGIC GDGIC AUTHID U Y SRC1 09/08 01:55 09/08 01:51
******************************** BOTTOM OF DATA *******************************
On the next screen the targeting information must be entered.
RDA.CPLR ---- PROVIDE LOCATION OR SSID ---- yyyy/mm/dd hh:mm
COMMAND ==>
Creator ==> AUTHID1 (Creator for target procedure)
Procedure ==> GDGIC (Name for target procedure)
Location ==> (Remote location name)
-or- -or-
SSID ==> TRG1 (Local SSID)
Object SSID ==> TRG1 (SSID of objects for target procedure)
Copy OSPs ==> Y (Y, N, default is N)
Copy Actions ==> Y (Y, N, default is N)
Copy POP ==> Y (Y, N, default is N)
Enter the Location or SSID to copy the procedure to, and press PF3 to
start the copy process. If Copy OSPs Y , Copy Actions Y or Copy POP Y is
specified, all tied OSPs, Action Procedures, or POP will also be
updated/inserted, all old ties will be deleted and new ties will be inserted.
Object SSID should be changed if you want the procedure on the target
subsystem to refer to objects on a different SSID than is defined here.
Enter CANCEL command to cancel copy request.
The user will be returned to the EXTRACT PROCEDURE SERVICES where a message will inform of the status of the copy.
RDA.CPL ----- EXTRACT PROCEDURE SERVICES ---- yyyy/mm/dd hh:mm
COMMAND ==> SCROLL ==> CSR
RAP224 RAP224I - EXTRACT procedure "GDGIC" copied to TRG1
PROCEDURE SELECTION LIST PARAMETERS
Name ==> G% Creator ==> AUTHID1 Subsystem ==> SRC1
Desc ==> * Location ==> LOCAL
-------------------------------------------- SQLID: AUTHID1 User ID: AUTHID1
S A DB2 LAST UPDATE LAST SUBMIT
O EXT PROC PROCEDURE DESCRIPTION CREATOR O P SYSD DATE TIME DATE TIME
_ ________ _________________________ AUTHID1 N N <=== NEW PROCEDURE CREATION
_ GDGIC GDGIC AUTHID1 U Y SRC1 09/08 01:55 09/08 01:51
******************************** BOTTOM OF DATA *******************************
Now going to the TRG1 subsystem, displaying the Extract Procedure, the time stamps associated
with it reflect the data/time that they were copied to the target subsystem.
RDA.CPL ----- EXTRACT PROCEDURE SERVICES ---- yyyy/mm/dd hh:mm
COMMAND ==> SCROLL ==> CSR
PROCEDURE SELECTION LIST PARAMETERS
Name ==> G% Creator ==> AUTHID1 Subsystem ==> TRG1
Desc ==> * Location ==> LOCAL
-------------------------------------------- SQLID: AUTHID1 User ID: AUTHID1
S A DB2 LAST UPDATE LAST SUBMIT
O EXT PROC PROCEDURE DESCRIPTION CREATOR O P SYSD DATE TIME DATE TIME
_ ________ _________________________ AUTHID1 N N <=== NEW PROCEDURE CREATION
_ GDGIC GDGIC AUTHID1 U Y TRG1 05/16 01:59 01/01 00:00
******************************** BOTTOM OF DATA *******************************
Looking at the action procedure, it has also been copied to the target subsystem and tied to
the extract procedure.
RDA.APL ---- ACTION PROCEDURE SERVICES ---- yyyy/mm/dd hh:mm
COMMAND ==> SCROLL ==> CSR
PROCEDURE SELECTION LIST PARAMETERS
Name ==> * Creator ==> AUTHID1 Subsystem ==> TRG1
Desc ==> * Location ==> LOCAL
------------------------------------------- SQLID: AUTHID1 User ID: AUTHID1
O ACT PROC PROCEDURE DESCRIPTION CREATOR SHR SYB CND DATE TIME EXTR CNT
_ ________ _________________________ AUTHID1 N <=== NEW PROCEDURE CREATION
_ GDGCRE CREATE GDG IF REQ'D AUTHID1 U D N 05/16 01:59 1
******************************** BOTTOM OF DATA *******************************
Additional Information
Feedback
Yes
No
Powered by
