ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Database Analyzer for DB2 for Z/OS : Copy / migrate Extract and Action procedures to DB2 subsystems on a different LPAR

book

Article ID: 50983

calendar_today

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

Copying Procedures