LISTDEF and the Repair Utility

Louwrens Minnie

LISTDEF and the Repair Utility
Hi All

We are running DB2 V7 on z/OS 1.4. If I understand the Utility Guide
correctly, one can not use Listdef and the Repair utility (nocopypend)
together. I can use the 'old' method, ie defining each tablespace, but
because the number of tablespaces for this application will change every
month, it will become a constant maintenance function.

Is there some 'un-documented' way that I can use Listdef and Repair
together?

Thanks in advance.

Louwrens Minnie
Mainframe
Hogan Technology
First National Bank
Tel(w) +27 011 371 3427
(c) +27 083 449 0586
Fax +27 011 371 3383



___________________________________________________________________________________________________


The views expressed in this email are, unless otherwise stated, those of the author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider or its management.
The information in this e-mail is confidential and is intended solely for the addressee.
Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution or any action taken or
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data
transmitted electronically and to preserve the confidentiality thereof, no liability or
responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted
or does not reach its intended destination.

________________________________

---------------------------------------------------------------------------------
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

Isaac Yassin

Re: LISTDEF and the Repair Utility
(in response to Louwrens Minnie)
Use REXX to generate the REPAIR commands (it's un-documented :-) )
(BTW - no LISTDEF for REPAIR in V8 as well)

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Minnie, Louwrens
Sent: Wednesday, January 12, 2005 8:37 AM
To: [login to unmask email]
Subject: [DB2-L] LISTDEF and the Repair Utility

Hi All

We are running DB2 V7 on z/OS 1.4. If I understand the Utility Guide
correctly, one can not use Listdef and the Repair utility (nocopypend)
together. I can use the 'old' method, ie defining each tablespace, but
because the number of tablespaces for this application will change every
month, it will become a constant maintenance function.

Is there some 'un-documented' way that I can use Listdef and Repair
together?

Thanks in advance.

Louwrens Minnie
Mainframe
Hogan Technology
First National Bank
Tel(w) +27 011 371 3427
(c) +27 083 449 0586
Fax +27 011 371 3383



____________________________________________________________________________
_______________________


The views expressed in this email are, unless otherwise stated, those of the
author and not those of the FirstRand Banking Group an Authorised Financial
Service Provider or its management.
The information in this e-mail is confidential and is intended solely for
the addressee.
Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted in reliance on this, is prohibited and may be
unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity
of information and data transmitted electronically and to preserve the
confidentiality thereof, no liability or responsibility whatsoever is
accepted if information or data is, for whatever reason, corrupted or does
not reach its intended destination.

________________________________

----------------------------------------------------------------------------
-----
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

Mark Vickers

Re: LISTDEF and the Repair Utility
(in response to Isaac Yassin)
One option is to use the SQL option of DSNTIAUL [PARMS('SQL')]and generate
the REPAIR control cards.

Mark Vickers.

-----Original Message-----
From: Minnie, Louwrens [mailto:[login to unmask email]
Sent: Wednesday, January 12, 2005 12:37 AM
To: [login to unmask email]
Subject: [DB2-L] LISTDEF and the Repair Utility

Hi All

We are running DB2 V7 on z/OS 1.4. If I understand the Utility Guide
correctly, one can not use Listdef and the Repair utility (nocopypend)
together. I can use the 'old' method, ie defining each tablespace, but
because the number of tablespaces for this application will change every
month, it will become a constant maintenance function.

Is there some 'un-documented' way that I can use Listdef and Repair
together?

Thanks in advance.

Louwrens Minnie
Mainframe
Hogan Technology
First National Bank
Tel(w) +27 011 371 3427
(c) +27 083 449 0586
Fax +27 011 371 3383



____________________________________________________________________________
_______________________


The views expressed in this email are, unless otherwise stated, those of the
author and not those
of the FirstRand Banking Group an Authorised Financial Service Provider or
its management.
The information in this e-mail is confidential and is intended solely for
the addressee.
Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity
of information and data
transmitted electronically and to preserve the confidentiality thereof, no
liability or
responsibility whatsoever is accepted if information or data is, for
whatever reason, corrupted
or does not reach its intended destination.

________________________________

----------------------------------------------------------------------------
-----
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

Jim Schaeffer

Re: LISTDEF and the Repair Utility
(in response to Mark Vickers)
MINNIE,

I have written a REXX program to read a LISTDEF preview sysprint and
generate a utility statement for each object or a command for each
object. Then the next JOBSTEP executes the commands or utilities.

Minnie, Louwrens wrote:

>Hi All
>
>We are running DB2 V7 on z/OS 1.4. If I understand the Utility Guide
>correctly, one can not use Listdef and the Repair utility (nocopypend)
>together. I can use the 'old' method, ie defining each tablespace, but
>because the number of tablespaces for this application will change every
>month, it will become a constant maintenance function.
>
>Is there some 'un-documented' way that I can use Listdef and Repair
>together?
>
>Thanks in advance.
>
>Louwrens Minnie
>Mainframe
>Hogan Technology
>First National Bank
>Tel(w) +27 011 371 3427
> (c) +27 083 449 0586
>Fax +27 011 371 3383
>
>
>
>___________________________________________________________________________________________________
>
>
>The views expressed in this email are, unless otherwise stated, those of the author and not those
>of the FirstRand Banking Group an Authorised Financial Service Provider or its management.
>The information in this e-mail is confidential and is intended solely for the addressee.
>Access to this e-mail by anyone else is unauthorised.
>If you are not the intended recipient, any disclosure, copying, distribution or any action taken or
>omitted in reliance on this, is prohibited and may be unlawful.
>Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data
>transmitted electronically and to preserve the confidentiality thereof, no liability or
>responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted
>or does not reach its intended destination.
>
> ________________________________
>
>---------------------------------------------------------------------------------
>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