I looked at this manual first. It mentions to not delete temporary files
if a REORG abends. It doesn't however mention where these temporary files
are, how to use them in a restart situation, or how to display what step
the utility is in. That is the information that I am particularly
interested in. According to the Performance Administration guide, it
states :
"If a REORG utility does not complete successfully, do NOT delete the
temporary files, tables or tablespaces. These files are used by the
Database Manager to roll back the changes made by the REORG utility, or to
complete the reorganization, depending on how far the reorganization had
progressed before the failure."
Does this mean that DB2 will cleanup after itself if a REORG fails for some
reason and that there is no manual intervention necessary?
Tim
Phil Gunning
<[EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL
PROTECTED]
.net> cc:
Subject: Re: [DB2EUG] REORGs on DB2
UDB
02/24/2003 12:51
PM
Tim, The DB2 UDB Command Reference is a good reference. Phil
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 1:37 PM
Subject: [DB2EUG] REORGs on DB2 UDB
> Hello List,
>
> I am wondering if there is documentation on the actual steps involved
with
> a REORG (or any other utility) on DB2 UDB and what the restart options
are
> should a REORG (or any other utility) abend. For S/390, there is very
> detailed documentation in the utility guide on the steps of a REORG and
how
> to restart a REORG should one fail. Are there ways to display the
utility
> to see what steps they are in, what the status of the utility is, etc?
>
> Any help and direction is appreciated.
>
> Thanks,
> Tim
>
>
>
>
> -
> ::: When replying to the list, please use 'Reply-All' and make sure
> ::: a copy goes to the list ([EMAIL PROTECTED]).
> *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> *** For more information, check http://www.db2eug.uni.cc
>
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
