Re: DSTATS

Hello,<br />
DSTATS was an application which collected frequencies and multi-column
cardinalities prior to DB2 for z/OS V8.  With DB2 for z/OS V8, RUNSTATS was
enhanced to collect these statistics using the COLGROUP options.  With DB2 9 for
z/OS support for HISTOGRAM statistics was added.<br />
<br />
Here's a presentation to give you some background on the issue.<br />
<br />
http://www-1.ibm.com/support/docview.wss?uid=swg27000101&#38;aid=1<br
/>
<br />
It's also getting easier to identify what statistics to collect.<br />
Visual Explain V8 includes Statistics Adviser capability which will analyze your
SQL statement and generate appropriate RUNSTATS.<br />
<br />
Optimization Service Center (replacement for VE) also includes the query based
statistics adviser as well as a workload statistics adviser.  You provide a
query workload, and workload statistics adviser will analyze the SQL, search
conditions, existing statistics and generate appropriate RUNSTATS
statements.<br />
<br />
Best regards,<br />