DB2 for z/OS - REXX for VCAT Defined DS

Robert Tilkes

DB2 for z/OS - REXX for VCAT Defined DS
I am posting this as we are looking at improving our DR process.
Currently at DR we have to delete and reallocate all VCAT Define DB2
Datasets, and we maintain those definitions in several locations. The
problem with this is if the definiton changes or say for example the DB2
catalog you have to add an additional dataset then we currently have
numerous places we need to update. I would like to setup automation to
aid us not forgeting to make a change.

I would like to provide a prefix, for example, XXXXX.DSNDBD.DSNDB06 and
then the REXX so it can generate the IDCAMS delete and allocate statments
into a PDS member or dataset. Does anyone have anything they are willing
to share?

Bob

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Robert Tilkes

DB2 for z/OS - REXX for VCAT Defined DS
(in response to DB2information@AOL.COM)
I am posting this as we are looking at improving our DR process.
Currently at DR we have to delete and reallocate all VCAT Define DB2
Datasets, and we maintain those definitions in several locations. The
problem with this is if the definiton changes or say for example the DB2
catalog you have to add an additional dataset then we currently have
numerous places we need to update. I would like to setup automation to
aid us not forgeting to make a change.

I would like to provide a prefix, for example, XXXXX.DSNDBD.DSNDB06 and
then the REXX so it can generate the IDCAMS delete and allocate statments
into a PDS member or dataset. Does anyone have anything they are willing
to share?

Bob

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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


This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Robert Lawrence

Re: DB2 for z/OS - REXX for VCAT Defined DS
(in response to Robert Tilkes)
I have such a routine which I just uploaded to the IDUG CODE PAGE
http://www.idug.org/user/userlogin.asp


HTH

Bob Lawrence
DBA
Boscov's Dept Stores LLc



> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Robert Tilkes
> Sent: Wednesday, January 18, 2006 1:29 PM
> To: [login to unmask email]
> Subject: [DB2-L] DB2 for z/OS - REXX for VCAT Defined DS
>
>
> I am posting this as we are looking at improving our DR process.
> Currently at DR we have to delete and reallocate all VCAT Define DB2
> Datasets, and we maintain those definitions in several locations. The
> problem with this is if the definiton changes or say for example the DB2
> catalog you have to add an additional dataset then we currently have
> numerous places we need to update. I would like to setup automation to
> aid us not forgeting to make a change.
>
> I would like to provide a prefix, for example, XXXXX.DSNDBD.DSNDB06 and
> then the REXX so it can generate the IDCAMS delete and allocate statments
> into a PDS member or dataset. Does anyone have anything they are willing
> to share?
>
> Bob
>
> ---------------------------------------------------------------------------------
> 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
> 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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 for z/OS - REXX for VCAT Defined DS
(in response to Robert Lawrence)
Bob,
Visit www.recoveryknowledge You will find a software tool that will do what
you are looking for and much more.

Ed.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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 for z/OS - REXX for VCAT Defined DS
(in response to DB2information@AOL.COM)
Visit: www.recoveryknowledge.com

Ed.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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