[DB2-L] Runstats

Walter Janißen

[DB2-L] Runstats
Barbara

There are some restrictions to inline stats:

- you cannot collect statistics for NPIs, when you reorg on partition level
- you cannot collect histogramm-stats

may be, there are further restrictions, I am not aware of.

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Düsseldorf
mailto:[login to unmask email]

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996



________________________________
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von [login to unmask email]
Gesendet: Freitag, 8. Januar 2010 18:09
An: [login to unmask email]
Betreff: [DB2-L] 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]<mailto:[login to unmask email]>
Internet. http://www.hsbc.com < 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!

________________________________

[ http://www.idug.org/images/M_images/idug%20org.jpg ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________

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

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

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