Tim - we've just got done reorging a lot of objects in our database over
the last month or two to reclaim some space due to purging that was done.
Due to the size of the some of the objects that we reorged (5.8 million
pages was the biggest table (or over 22 gb)), we had to use the tempspace
because there wasn't enough freespace in the original tablespace. This
largest object took 3 hours and 25 minutes to reorg. I didn't think that
was too bad given the size of the table.
We've never had any problems doing a reorg. Quest says that you should
copy the object after a reorg. This is due to the amount of logging that
is done during the reorg and would need to be reapplied if a recovery was
necessary. I can't say that we noticed a tremendous amount of logging even
when doing this large table. But I wasn't watching the logs real close,
so I can't say for sure.
Our biggest gripe is what you mentioned, there is no way to see the
progress of a reorg like you can on the mainframe. Nowhere is there any
documentation that talks about the different phases of a reorg. Is there
even an unload/load/rebuild like on the mainframe? You just hit the start
button and wait. There are a couple of ways that we can monitor and
convince ourselves that stuff is still happening. First, if you are using
tempspace that is SMS defined, you can watch the appropriate directory for
the SMS tablespace and you will see occasional increases to files in this
directory as the reorg is progressing. It's not consistent, but you do see
periodic activity here. Second, in the Control Center you can watch the
"sized used" increase for the tempspace tablespace as the reorg is going
on. Again, it's not real consistent but at least it gives you a warm
feeling that things are progressing.
Hope this helps.
[EMAIL PROTECTED]@Lugwash.org on 02/24/2003 02:43:56 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Phil Gunning <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED]
Subject: Re: [DB2EUG] REORGs on DB2 UDB
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
******************* PLEASE NOTE *******************
This E-Mail/telefax message and any documents accompanying this
transmission may contain privileged and/or confidential information and is
intended solely for the addressee(s) named above. If you are not the
intended addressee/recipient, you are hereby notified that any use of,
disclosure, copying, distribution, or reliance on the contents of this
E-Mail/telefax information is strictly prohibited and may result in legal
action against you. Please reply to the sender advising of the error in
transmission and immediately delete/destroy the message and any
accompanying documents. Thank you.
-
::: 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
