Phil - great tip on the "GET SNAPSHOT FOR TABLES...". I never realized that information would be here while a reorg was going on. FYI - I just did a reorg this morning, and the "ROWS READ" appears to be double the number of rows in the table.
Thanks. Phil Gunning <[EMAIL PROTECTED]>@Lugwash.org on 02/24/2003 04:26:02 PM Please respond to Phil Gunning <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: [DB2EUG] REORGs on DB2 UDB Tim, you can use the db2 list history command, and table snapshots to monitor and check on status of a reorg. You can use load query to obtain the state of a table (v8) , and any reorg errors are written to the db2diag.log and administration notification event log, and SQLCA is written to the history file. You will want to take a backup of the tablespace after reorg, if you don't and you end up doing a roll forward, DB2 will roll forward through the reorg. The temporary files will be created along the TEMPSPACE1 path or tablespace path involved if using in-place. Cheers, Phil ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Phil Gunning" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 2:43 PM 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 - ::: 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
