Runstats

Barbara Nigh

Runstats
Can someone please tell me if the statistics we are collecting during an
on-line conditional REORG are the same as the ones we are collecting when
we execute the RUNSTATS utility prior to running the
conditional REORG? Listed below are the parameters we are using for each
utility:

RUNSTATS Utility -- TABLE INDEX (ALL) KEYCARD UPDATE ALL
REORG Utility -- STATISTICS TABLE (ALL) INDEX (ALL KEYCARD) UPDATE ALL


Barbara J Nigh
CONSULTANT DATABASE MGMT | HSBC Technology Services (HTS)
1441 Schilling Place
Salinas, CA 93901
______________________________________________________

Phone. 831 754 1400 2048
Fax. 831-759-7073
Mobile. 831-776-6194 Pager [login to unmask email]
Email. [login to unmask email]
Internet. http://www.hsbc.com
______________________________________________________


-----------------------------------------
******************************************************************
This E-mail is confidential. It may also be legally privileged. If
you are not the addressee you may not copy, forward, disclose or
use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return E-mail.

Internet communications cannot be guaranteed to be timely, secure,
error or virus-free. The sender does not accept liability for any
errors or omissions.
******************************************************************
SAVE PAPER - THINK BEFORE YOU PRINT!

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Peter Vanroose

Re: Runstats
(in response to Barbara Nigh)
On Fri, 8 Jan 2010 09:09:27 -0800, [login to unmask email] wrote:
>Can someone please tell me if the statistics we are collecting during an
>on-line conditional REORG are the same as the ones we are collecting when
>we execute the RUNSTATS utility ***prior to*** running the
>conditional REORG? Listed below are the parameters we are using for each
>utility:
>
>RUNSTATS Utility -- TABLE INDEX (ALL) KEYCARD UPDATE ALL
>REORG Utility -- STATISTICS TABLE (ALL) INDEX (ALL KEYCARD) UPDATE ALL

I'd rather say that the REORG will collect statistics as if you ran RUNSTATS
***after*** running the REORG.

-- Peter Vanroose
ABIS Training & Consulting.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L