BMCSTATS for Partition

Nirmal Doss

BMCSTATS for Partition
Hi,
Is there any extra option that we need to use to update stats for
the partitions when using BMCSTATS because when we used BMCSTATS the STATS
is not updated at the Partition level but it is updated at table etc
correctly

Nirmal doss

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

John Alexander

Re: BMCSTATS for Partition
(in response to Nirmal Doss)
Hi Nirmal,

A few weeks ago I was after the same thing, & found that I can add
PARTITION X any where in the command, the syntax I use is;



BMCSTATS TABLESPACE DBNAM.TSNAM PARTITION X

TABLE ALL

INDEX Y

SAVESTATS Y

REPORT Y

DELETEAGE 370

UPDATEDB2STATS Y

SPACEONLY N

RECALL Y

TASKS 5

BUFFERS 500

IMAGECOPY N

GROUPSIZE 0

KEYCARD Y

NUMCOLS 3

COUNT 10

TSSAMPLEPCT 10







Regards

John





The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
[link to http://www.idug.org/lsidug ] under the Listserv tab. While at
the site, you can also access the IDUG Online Learning Center, Tech
Library and Code Place, see the latest IDUG conference information [link
to http://www.idug.org/lsconf], and much more. If you have not yet
signed up for Basic Membership in IDUG, available at no cost, click on
Member Services [link to http://www.idug.org/lsms]

***********************************************************
CAUTION: This email and files included in its transmission
are solely intended for the use of the addressee(s) and may
contain information that is confidential and privileged.
If you receive this email in error, please advise us
immediately and delete it without copying the contents
contained within. Woolworths Limited (including its group
of companies) do not accept liability for the views
expressed within or the consequences of any computer
viruses that may be transmitted with this email. The
contents are also subject to copyright. No part of it
should be reproduced, adapted or transmitted without the
written consent of the copyright owner.
***********************************************************

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Nirmal Doss

Re: BMCSTATS for Partition
(in response to John Alexander)
Thanks John

On 12/17/07, Alexander John <[login to unmask email]> wrote:
>
> Hi Nirmal,
>
> A few weeks ago I was after the same thing, & found that I can add
> PARTITION X any where in the command, the syntax I use is;
>
>
>
> BMCSTATS TABLESPACE DBNAM.TSNAM PARTITION X
>
> TABLE ALL
>
> INDEX Y
>
> SAVESTATS Y
>
> REPORT Y
>
> DELETEAGE 370
>
> UPDATEDB2STATS Y
>
> SPACEONLY N
>
> RECALL Y
>
> TASKS 5
>
> BUFFERS 500
>
> IMAGECOPY N
>
> GROUPSIZE 0
>
> KEYCARD Y
>
> NUMCOLS 3
>
> COUNT 10
>
> TSSAMPLEPCT 10
>
>
>
>
>
>
>
> Regards
>
> John
>
>
>
>
>
> ***********************************************************
>
> CAUTION: This email and files included in its transmission
>
> are solely intended for the use of the addressee(s) and may
>
> contain information that is confidential and privileged.
>
> If you receive this email in error, please advise us
>
> immediately and delete it without copying the contents
>
> contained within. Woolworths Limited (including its group
>
> of companies) do not accept liability for the views
>
> expressed within or the consequences of any computer
>
> viruses that may be transmitted with this email. The
>
> contents are also subject to copyright. No part of it
>
> should be reproduced, adapted or transmitted without the
>
> written consent of the copyright owner.
>
> ***********************************************************
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at www.idug.org [link
> to http://www.idug.org/lsidug ] under the Listserv tab. While at the site,
> you can also access the IDUG Online Learning Center, Tech Library and Code
> Place, see the latest IDUG conference information [link to
> http://www.idug.org/lsconf], and much more. If you have not yet signed up
> for Basic Membership in IDUG, available at no cost, click on Member Services
> [link to http://www.idug.org/lsms]
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at *www.idug.org < http://www.idug.org/lsidug >
> * under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest *IDUG
> conference information*, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available at
> no cost, click on *Member Services*

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms