Inline statistics in BMC Reorg

Balachandran Chandrasekaran

Inline statistics in BMC Reorg
Hello Group,

Is there any installation option (I don't seem to find any) that matters to UPDATEDB2STATS yes/no while doing inline statistics in a BMC Reorg plus ? Or, is there any reason a table's statistics could be missed while tablespace,indexes statistics are collected/updated during a tablespace reorg ? Or, inline statistics be different for different SHRLEVEL options ?

BMC Reorg plus manual lists a set of columns that will be updated by inline db2 statistics but, I could see many discrepancies as I run in different systems.

We are on DB2 v7 Z /oS.

Thanks,
Bala.

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 November 30th. 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

Chris Blaicher

Re: Inline statistics in BMC Reorg
(in response to Balachandran Chandrasekaran)
Bala,

I would love to answer your question or get one of our Technical Support
people to answer it, but there is not enough detail to answer the
implied questions.

Please call our Technical Support center at 1-800-537-1813. You will be
connected to a real person 24/7. They can help you with just about any
question you may have on REORG+, and if they can't answer the question,
the developers are right down the hall from them.

Chris Blaicher
Senior Developer, DB2 Utilities
BMC Software, Inc.
Austin, Texas

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Chandrasekaran, Balachandran
Sent: Wednesday, December 05, 2007 4:35 AM
To: [login to unmask email]
Subject: [DB2-L] Inline statistics in BMC Reorg

Hello Group,

Is there any installation option (I don't seem to find any) that matters
to UPDATEDB2STATS yes/no while doing inline statistics in a BMC Reorg
plus ? Or, is there any reason a table's statistics could be missed
while tablespace,indexes statistics are collected/updated during a
tablespace reorg ? Or, inline statistics be different for different
SHRLEVEL options ?

BMC Reorg plus manual lists a set of columns that will be updated by
inline db2 statistics but, I could see many discrepancies as I run in
different systems.

We are on DB2 v7 Z /oS.

Thanks,
Bala.

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 November 30th. 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