Automated DB2 Statistics replication between Production & Test

Christine Sawyer

Automated DB2 Statistics replication between Production & Test
Can anyone share some experience on this one? I will like to set up a ajob
to automatically update one of our test databases with production statistics
on a weekly basis. Currently, we manually do this using Platinum's MIGRATOR
product. I will appreciate any information/material anyone may provide Or
where I can get more information about it? Any documented step by step
procedure?

We are running DB2 V5.

Thanks
Christine


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



Chris Miller

Re: Automated DB2 Statistics replication between Production & Test
(in response to Christine Sawyer)
If you're running DB2 on Unix or NT, you can use the DB2LOOK command to get your
production statistics replicated to your test system. I'm not sure if there is
such a thing on OS/390. (I'm not an OS/390 DBA).



DANIEL CYR

Re: Automated DB2 Statistics replication between Production
(in response to Chris Miller)

Christine,

I have a set of QMF queries/forms/proc/REXX that migrates our
production stats to the test/development subsystem. Let me know and
I can send an e-mail with attachments.

Dan
[login to unmask email]


______________________________ Reply Separator _________________________________
Subject: Automated DB2 Statistics replication between Production & Te
Author: [login to unmask email] at INTERNET
Date: 01/03/2000 6:33 PM


Can anyone share some experience on this one? I will like to set up a ajob to
automatically update one of our test databases with production statistics on
a weekly basis. Currently, we manually do this using Platinum's MIGRATOR
product. I will appreciate any information/material anyone may provide Or
where I can get more information about it? Any documented step by step
procedure?

We are running DB2 V5.

Thanks
Christine


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com


visit the




ODIMIR BARBOSA

Re: Automated DB2 Statistics replication between Production
(in response to DANIEL CYR)
Dan,

I would be interested in obtaining a the QMF queries/forms/proc and
REXX mentioned below.

Thanks in advance.

Odimir
mailto: [login to unmask email]
> -----Original Message-----
> From: DANIEL CYR [SMTP:[login to unmask email]
> Sent: Tuesday, January 04, 2000 12:37 AM
> To: [login to unmask email]
> Subject: Re: Automated DB2 Statistics replication between Production
>
>
> Christine,
>
> I have a set of QMF queries/forms/proc/REXX that migrates our
> production stats to the test/development subsystem. Let me know and
> I can send an e-mail with attachments.
>
> Dan
> [login to unmask email]
>
>
> ______________________________ Reply Separator
> _________________________________
> Subject: Automated DB2 Statistics replication between Production & Te
> Author: [login to unmask email] at INTERNET
> Date: 01/03/2000 6:33 PM
>
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to
> automatically update one of our test databases with production statistics
> on
> a weekly basis. Currently, we manually do this using Platinum's MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
> the
>
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]



Lynne Flatley

Re: Automated DB2 Statistics replication between Production & Tes t
(in response to ODIMIR BARBOSA)
Actually, Platinum's Database Analyzer product is supposed to be able to
automate this process. I haven't gotten it to do that yet, though. Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production &
> Test
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>



Sibimon Philip

Re: Automated DB2 Statistics replication between Production & Tes t
(in response to Lynne Flatley)
Is there any BMC product which does this? I too would like to know more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able to
automate this process. I haven't gotten it to do that yet, though. Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production &
> Test
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>








Andy Hunt

Re: Automated DB2 Statistics replication between Production & Tes t
(in response to Sibimon Philip)
BMC DASD Manager Plus allows you to use the following 'utilities'.
BMCUPRS - Update the DB2 catalog using stats held in the DASD Manager database.
BMCCPRS - Update the 'BMC' stats held in the DASD Manager database using stats
from the DB2 Catalog.

It would require 'BMC' stats data being copied from DASD Manager tables in your
'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not the
same DB2 sub-system.

Kind Regards,
Andy Hunt - Scottish And Southern Energy





"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production & Tes
t



Is there any BMC product which does this? I too would like to know more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able to
automate this process. I haven't gotten it to do that yet, though. Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production &
> Test
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>
















**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



Jerry Lobenstein

Re: Automated DB2 Statistics replication between Production & Tes t
(in response to DANIEL CYR)
DBA-Xpert Utility Manager will allow the DBA to define a rules set to move
stat's between
DB2 Catalogs. It would collect the stat's in the UM Tables and then copy
from the UM tables
source DB2 to your target DB2 if the 'source' and the 'target' are not the
same DB2 sub-system.

Jerry Lobenstein
Compuware Corporation


"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production & Tes
t



Is there any BMC product which does this? I too would like to know more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able to
automate this process. I haven't gotten it to do that yet, though. Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production &
> Test
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>
















**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************








Sibimon Philip

Re: Automated DB2 Statistics replication between Production & Tes t
(in response to Jerry Lobenstein)
Andy...Thanks for the reply
Our production and TEST is in two different subsystem. I would like to have
an option in BMC as follows

1. Create a migration profile which contain all the table for which the
statistics need to be copied from production.
2. Do a analysis in production
3. Import the analysis and execute it in TEST.

It will be good if it can be automated using a batch job. Is there anything
like this? Since DB2 query access path is determined based on the statistics
in DB2 catalog, I would like to keep statistics in DB2 catalog instead of
BMC DASD manager database.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Andy Hunt [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 9:28 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


BMC DASD Manager Plus allows you to use the following 'utilities'.
BMCUPRS - Update the DB2 catalog using stats held in the DASD Manager
database.
BMCCPRS - Update the 'BMC' stats held in the DASD Manager database using
stats
from the DB2 Catalog.

It would require 'BMC' stats data being copied from DASD Manager tables in
your
'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not
the
same DB2 sub-system.

Kind Regards,
Andy Hunt - Scottish And Southern Energy





"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production & Tes
t



Is there any BMC product which does this? I too would like to know more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able to
automate this process. I haven't gotten it to do that yet, though. Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production &
> Test
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>
















**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************








Christine Sawyer

Re: Automated DB2 Statistics replication between Production
(in response to Sibimon Philip)
Good morning Mr. Cyr,
Re: your email below: Please by all means do!!.
Thanks in advance for the time & effort
Christine


>From: DANIEL CYR <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: Automated DB2 Statistics replication between Production
>Date: Mon, 3 Jan 2000 20:36:35 -0600
>
>
> Christine,
>
> I have a set of QMF queries/forms/proc/REXX that migrates our
> production stats to the test/development subsystem. Let me know and
> I can send an e-mail with attachments.
>
> Dan
> [login to unmask email]
>
>
>______________________________ Reply Separator
>_________________________________
>Subject: Automated DB2 Statistics replication between Production & Te
>Author: [login to unmask email] at INTERNET
>Date: 01/03/2000 6:33 PM
>
>
>Can anyone share some experience on this one? I will like to set up a ajob
>to
>automatically update one of our test databases with production statistics
>on
>a weekly basis. Currently, we manually do this using Platinum's MIGRATOR
>product. I will appreciate any information/material anyone may provide Or
>where I can get more information about it? Any documented step by step
>procedure?
>
>We are running DB2 V5.
>
>Thanks
>Christine
>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>the
>
>
>
>
>http://www.ryci.com/db2-l. The owners of the list can be reached at
>[login to unmask email]

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



Andy Hunt

Re: Automated DB2 Statistics replication between Production & Tes t
(in response to Christine Sawyer)
If your 'source' and 'target' are in different DB2 sub-systems, then I think
that the BMC DASD Manager option may be too complicated. Transferring BMC
statistics data between DB2 sub-systems and converting object qualifier/names
etc. (if different) would require an in-house program to be written. This does
not deliver the degree of automation you require. Therefore I think a system
using BMCUPRS/BMCCPRS could only be practically used in the same sub-system.
Kind Regards,
Andy Hunt - Scottish And Southern Energy








"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 15:41:59

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production & Tes
t



Andy...Thanks for the reply
Our production and TEST is in two different subsystem. I would like to have
an option in BMC as follows

1. Create a migration profile which contain all the table for which the
statistics need to be copied from production.
2. Do a analysis in production
3. Import the analysis and execute it in TEST.

It will be good if it can be automated using a batch job. Is there anything
like this? Since DB2 query access path is determined based on the statistics
in DB2 catalog, I would like to keep statistics in DB2 catalog instead of
BMC DASD manager database.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Andy Hunt [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 9:28 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


BMC DASD Manager Plus allows you to use the following 'utilities'.
BMCUPRS - Update the DB2 catalog using stats held in the DASD Manager
database.
BMCCPRS - Update the 'BMC' stats held in the DASD Manager database using
stats
from the DB2 Catalog.

It would require 'BMC' stats data being copied from DASD Manager tables in
your
'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not
the
same DB2 sub-system.

Kind Regards,
Andy Hunt - Scottish And Southern Energy





"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production & Tes
t



Is there any BMC product which does this? I too would like to know more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production &
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able to
automate this process. I haven't gotten it to do that yet, though. Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production &
> Test
>
> Can anyone share some experience on this one? I will like to set up a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may provide Or
> where I can get more information about it? Any documented step by step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
>
>
















**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************
















**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



Karen Daniels

Re: Automated DB2 Statistics replication between Production
(in response to Andy Hunt)
I would appreciate a copy of those myself.

Thanks,
Karen Daniels

<<< DANIEL CYR <[login to unmask email]> 1/ 3 8:39p >>>

Christine,

I have a set of QMF queries/forms/proc/REXX that migrates our
production stats to the test/development subsystem. Let me know and
I can send an e-mail with attachments.

Dan
[login to unmask email]


______________________________ Reply Separator _________________________________
Subject: Automated DB2 Statistics replication between Production & Te
Author: [login to unmask email] at INTERNET
Date: 01/03/2000 6:33 PM


Can anyone share some experience on this one? I will like to set up a ajob to
automatically update one of our test databases with production statistics on
a weekly basis. Currently, we manually do this using Platinum's MIGRATOR
product. I will appreciate any information/material anyone may provide Or
where I can get more information about it? Any documented step by step
procedure?

We are running DB2 V5.

Thanks
Christine


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com


the


=======================



DANIEL CYR

Re: Automated DB2 Statistics replication between Production
(in response to Andy Hunt)

Christine, e-mail if you have any questions. Dan

______________________________ Reply Separator _________________________________
Subject: Automated DB2 Statistics replication between Production & Te
Author: [login to unmask email] at INTERNET
Date: 01/03/2000 6:33 PM


Can anyone share some experience on this one? I will like to set up a ajob to
automatically update one of our test databases with production statistics on
a weekly basis. Currently, we manually do this using Platinum's MIGRATOR
product. I will appreciate any information/material anyone may provide Or
where I can get more information about it? Any documented step by step
procedure?

We are running DB2 V5.

Thanks
Christine


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com


visit the

Slot J.P.

Re: Automated DB2 Statistics replication between Production
(in response to Karen Daniels)
The size of the Message Text is 7736(> 6K), So it is kept in the First Attachment
Andy,

Just at thought crossed my mind..
Isn't it possible to use change manager form BMC to do this? Using
the migrate option?

Regards,

Jaap Slot

PS. A little late perhaps, but all you Listers a very happy and
prosperous 2000!
----------------------[Reply - Original Message]----------------------

Sent by:Andy Hunt <[login to unmask email]>
SUBJECT too long. Original SUBJECT is
Re: Automated DB2 Statistics replication between Production & Tes t


---------------------- Original Message Follows ----------------------

If your 'source' and 'target' are in different DB2 sub-systems, then I
think
that the BMC DASD Manager option may be too complicated.
Transferring BMC
statistics data between DB2 sub-systems and converting object
qualifier/names
etc. (if different) would require an in-house program to be written. This
does
not deliver the degree of automation you require. Therefore I think a
system
using BMCUPRS/BMCCPRS could only be practically used in the same
sub-system.
Kind Regards,
Andy Hunt - Scottish And Southern Energy








"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 15:41:59

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production
& Tes
t



Andy...Thanks for the reply
Our production and TEST is in two different subsystem. I would like to
have
an option in BMC as follows

1. Create a migration profile which contain all the table for which the
statistics need to be copied from production.
2. Do a analysis in production
3. Import the analysis and execute it in TEST.

It will be good if it can be automated using a batch job. Is there
anything
like this? Since DB2 query access path is determined based on the
statistics
in DB2 catalog, I would like to keep statistics in DB2 catalog instead of
BMC DASD manager database.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Andy Hunt [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 9:28 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production
&
Tes t


BMC DASD Manager Plus allows you to use the following 'utilities'.
BMCUPRS - Update the DB2 catalog using stats held in the DASD
Manager
database.
BMCCPRS - Update the 'BMC' stats held in the DASD Manager
database using
stats
from the DB2 Catalog.

It would require 'BMC' stats data being copied from DASD Manager
tables in
your
'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not
the
same DB2 sub-system.

Kind Regards,
Andy Hunt - Scottish And Southern Energy





"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production
& Tes
t



Is there any BMC product which does this? I too would like to know
more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production
&
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able
to
automate this process. I haven't gotten it to do that yet, though.
Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production
&
> Test
>
> Can anyone share some experience on this one? I will like to set up
a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may
provide Or
> where I can get more information about it? Any documented step by
step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
visit
> the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the
list can
>



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be




visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be




visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can

=========
============



Sally Mir

Re: Automated DB2 Statistics replication between Production & Test
(in response to Slot J.P.)
I haven't seen anyone mention Platinum's Statistics Manager, which comes with Plan Analyzer. With it, you can extract stats from one subsystem, apply masks to change database names, table
and index creator names, etc., and update the catalog in another subsystem with those stats. Sounds like what you're looking for.


Sally Mir

Andy Hunt wrote:

> If your 'source' and 'target' are in different DB2 sub-systems, then I think
> that the BMC DASD Manager option may be too complicated. Transferring BMC
> statistics data between DB2 sub-systems and converting object qualifier/names
> etc. (if different) would require an in-house program to be written. This does
> not deliver the degree of automation you require. Therefore I think a system
> using BMCUPRS/BMCCPRS could only be practically used in the same sub-system.
> Kind Regards,
> Andy Hunt - Scottish And Southern Energy
>
> "Philip, Sibimon" <[login to unmask email]> on 04/01/2000 15:41:59
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
> To: [login to unmask email]
> cc: (bcc: Andy Hunt/HAV/SSE)
> Subject: Re: Automated DB2 Statistics replication between Production & Tes
> t
>
> Andy...Thanks for the reply
> Our production and TEST is in two different subsystem. I would like to have
> an option in BMC as follows
>
> 1. Create a migration profile which contain all the table for which the
> statistics need to be copied from production.
> 2. Do a analysis in production
> 3. Import the analysis and execute it in TEST.
>
> It will be good if it can be automated using a batch job. Is there anything
> like this? Since DB2 query access path is determined based on the statistics
> in DB2 catalog, I would like to keep statistics in DB2 catalog instead of
> BMC DASD manager database.
>
> Thanks
> Sibimon Philip
> 972-702-2515 - Office
> 972-417-3597 - Residence
> E-mail - [login to unmask email]
>
> -----Original Message-----
> From: Andy Hunt [mailto:[login to unmask email]
> Sent: Tuesday, January 04, 2000 9:28 AM
> To: [login to unmask email]
> Subject: Re: Automated DB2 Statistics replication between Production &
> Tes t
>
> BMC DASD Manager Plus allows you to use the following 'utilities'.
> BMCUPRS - Update the DB2 catalog using stats held in the DASD Manager
> database.
> BMCCPRS - Update the 'BMC' stats held in the DASD Manager database using
> stats
> from the DB2 Catalog.
>
> It would require 'BMC' stats data being copied from DASD Manager tables in
> your
> 'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not
> the
> same DB2 sub-system.
>
> Kind Regards,
> Andy Hunt - Scottish And Southern Energy
>
> "Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06
>
> Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
> To: [login to unmask email]
> cc: (bcc: Andy Hunt/HAV/SSE)
> Subject: Re: Automated DB2 Statistics replication between Production & Tes
> t
>
> Is there any BMC product which does this? I too would like to know more
> about this.
>
> Thanks
> Sibimon Philip
> 972-702-2515 - Office
> 972-417-3597 - Residence
> E-mail - [login to unmask email]
>
> -----Original Message-----
> From: Lynne Flatley [mailto:[login to unmask email]
> Sent: Tuesday, January 04, 2000 6:27 AM
> To: [login to unmask email]
> Subject: Re: Automated DB2 Statistics replication between Production &
> Tes t
>
> Actually, Platinum's Database Analyzer product is supposed to be able to
> automate this process. I haven't gotten it to do that yet, though. Anyone
> else?
>
> > -----Original Message-----
> > From: Christine Sawyer [SMTP:[login to unmask email]
> > Sent: Monday, January 03, 2000 6:23 PM
> > To: [login to unmask email]
> > Subject: Automated DB2 Statistics replication between Production &
> > Test
> >
> > Can anyone share some experience on this one? I will like to set up a ajob
> > to automatically update one of our test databases with production
> > statistics
> > on a weekly basis. Currently, we manually do this using Platinum's
> > MIGRATOR
> > product. I will appreciate any information/material anyone may provide Or
> > where I can get more information about it? Any documented step by step
> > procedure?
> >
> > We are running DB2 V5.
> >
> > Thanks
> > Christine
> >
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com
> >
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
> **********************************************************************
> The information in this E-Mail is confidential and may be legally
> privileged. It may not represent the views of Scottish and Southern
> Energy plc.
> It is intended solely for the addressees. Access to this E-Mail by
> anyone else is unauthorised. If you are not the intended recipient,
> any disclosure, copying, distribution or any action taken or omitted
> to be taken in reliance on it, is prohibited and may be unlawful.
> Any unauthorised recipient should advise the sender immediately of
> the error in transmission.
>
> Scottish Hydro-Electric and Southern Electric are trading names of
> Scottish and Southern Energy Group
> **********************************************************************
>
>
>
>
>
>
>
>
>
>
>
> **********************************************************************
> The information in this E-Mail is confidential and may be legally
> privileged. It may not represent the views of Scottish and Southern
> Energy plc.
> It is intended solely for the addressees. Access to this E-Mail by
> anyone else is unauthorised. If you are not the intended recipient,
> any disclosure, copying, distribution or any action taken or omitted
> to be taken in reliance on it, is prohibited and may be unlawful.
> Any unauthorised recipient should advise the sender immediately of
> the error in transmission.
>
> Scottish Hydro-Electric and Southern Electric are trading names of
> Scottish and Southern Energy Group
> **********************************************************************
>
>
>



Andy Hunt

Re: Automated DB2 Statistics replication between Production
(in response to Sally Mir)
Jaap,
I dont believe you can just migrate data using BMC Change Manager. If you
migrate a table and specify 'Data Y (and everything else N) ' in the migration
options for the table, the worklist generates a CREATE TABLE.... statement in
the worklist. I have used Change Manager to move data in this way but it has
always involved me manually editing the worklist to remove unwanted DDL.
I dont think Change Manager could help in changing the names of the objects in
the statistics records since these changes would need to be made to the
unloaded/reloaded data (rather than actual object names).
Kind Regards,
Andy Hunt - Scottish And Southern Energy.





[login to unmask email] on 04/01/2000 16:39:07

Please respond to [login to unmask email]

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production



The size of the Message Text is 7736(> 6K), So it is kept in the First
Attachment
Andy,

Just at thought crossed my mind..
Isn't it possible to use change manager form BMC to do this? Using
the migrate option?

Regards,

Jaap Slot

PS. A little late perhaps, but all you Listers a very happy and
prosperous 2000!
----------------------[Reply - Original Message]----------------------

Sent by:Andy Hunt <[login to unmask email]>
SUBJECT too long. Original SUBJECT is
Re: Automated DB2 Statistics replication between Production & Tes t


---------------------- Original Message Follows ----------------------

If your 'source' and 'target' are in different DB2 sub-systems, then I
think
that the BMC DASD Manager option may be too complicated.
Transferring BMC
statistics data between DB2 sub-systems and converting object
qualifier/names
etc. (if different) would require an in-house program to be written. This
does
not deliver the degree of automation you require. Therefore I think a
system
using BMCUPRS/BMCCPRS could only be practically used in the same
sub-system.
Kind Regards,
Andy Hunt - Scottish And Southern Energy








"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 15:41:59

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production
& Tes
t



Andy...Thanks for the reply
Our production and TEST is in two different subsystem. I would like to
have
an option in BMC as follows

1. Create a migration profile which contain all the table for which the
statistics need to be copied from production.
2. Do a analysis in production
3. Import the analysis and execute it in TEST.

It will be good if it can be automated using a batch job. Is there
anything
like this? Since DB2 query access path is determined based on the
statistics
in DB2 catalog, I would like to keep statistics in DB2 catalog instead of
BMC DASD manager database.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Andy Hunt [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 9:28 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production
&
Tes t


BMC DASD Manager Plus allows you to use the following 'utilities'.
BMCUPRS - Update the DB2 catalog using stats held in the DASD
Manager
database.
BMCCPRS - Update the 'BMC' stats held in the DASD Manager
database using
stats
from the DB2 Catalog.

It would require 'BMC' stats data being copied from DASD Manager
tables in
your
'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not
the
same DB2 sub-system.

Kind Regards,
Andy Hunt - Scottish And Southern Energy





"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production
& Tes
t



Is there any BMC product which does this? I too would like to know
more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production
&
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able
to
automate this process. I haven't gotten it to do that yet, though.
Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production
&
> Test
>
> Can anyone share some experience on this one? I will like to set up
a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may
provide Or
> where I can get more information about it? Any documented step by
step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
visit
> the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the
list can
>



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be




visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be




visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can

=========
============











**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



Libby Horton

Re: Automated DB2 Statistics replication between Production
(in response to Andy Hunt)
Hello,
For a data only migrate using BMC Change Manager if you go to the Override
screen from the Analysis interface and then remove the S from SQL you won't
get the Create Table DDL in the worklist.
Best regards,
Libby Horton
BMC Product Support
1-800-537-1813

-----Original Message-----
From: Andy Hunt [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 11:10 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production


Jaap,
I dont believe you can just migrate data using BMC Change Manager. If you
migrate a table and specify 'Data Y (and everything else N) ' in the
migration
options for the table, the worklist generates a CREATE TABLE.... statement
in
the worklist. I have used Change Manager to move data in this way but it has
always involved me manually editing the worklist to remove unwanted DDL.
I dont think Change Manager could help in changing the names of the objects
in
the statistics records since these changes would need to be made to the
unloaded/reloaded data (rather than actual object names).
Kind Regards,
Andy Hunt - Scottish And Southern Energy.





[login to unmask email] on 04/01/2000 16:39:07

Please respond to [login to unmask email]

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production



The size of the Message Text is 7736(> 6K), So it is kept in the First
Attachment
Andy,

Just at thought crossed my mind..
Isn't it possible to use change manager form BMC to do this? Using
the migrate option?

Regards,

Jaap Slot

PS. A little late perhaps, but all you Listers a very happy and
prosperous 2000!
----------------------[Reply - Original Message]----------------------

Sent by:Andy Hunt <[login to unmask email]>
SUBJECT too long. Original SUBJECT is
Re: Automated DB2 Statistics replication between Production & Tes t


---------------------- Original Message Follows ----------------------

If your 'source' and 'target' are in different DB2 sub-systems, then I
think
that the BMC DASD Manager option may be too complicated.
Transferring BMC
statistics data between DB2 sub-systems and converting object
qualifier/names
etc. (if different) would require an in-house program to be written. This
does
not deliver the degree of automation you require. Therefore I think a
system
using BMCUPRS/BMCCPRS could only be practically used in the same
sub-system.
Kind Regards,
Andy Hunt - Scottish And Southern Energy








"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 15:41:59

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production
& Tes
t



Andy...Thanks for the reply
Our production and TEST is in two different subsystem. I would like to
have
an option in BMC as follows

1. Create a migration profile which contain all the table for which the
statistics need to be copied from production.
2. Do a analysis in production
3. Import the analysis and execute it in TEST.

It will be good if it can be automated using a batch job. Is there
anything
like this? Since DB2 query access path is determined based on the
statistics
in DB2 catalog, I would like to keep statistics in DB2 catalog instead of
BMC DASD manager database.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Andy Hunt [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 9:28 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production
&
Tes t


BMC DASD Manager Plus allows you to use the following 'utilities'.
BMCUPRS - Update the DB2 catalog using stats held in the DASD
Manager
database.
BMCCPRS - Update the 'BMC' stats held in the DASD Manager
database using
stats
from the DB2 Catalog.

It would require 'BMC' stats data being copied from DASD Manager
tables in
your
'source' DB2 to your 'target' DB2 if the 'source' and the 'target' are not
the
same DB2 sub-system.

Kind Regards,
Andy Hunt - Scottish And Southern Energy





"Philip, Sibimon" <[login to unmask email]> on 04/01/2000 14:57:06

Please respond to DB2 Data Base Discussion List
<[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Andy Hunt/HAV/SSE)
Subject: Re: Automated DB2 Statistics replication between Production
& Tes
t



Is there any BMC product which does this? I too would like to know
more
about this.

Thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Tuesday, January 04, 2000 6:27 AM
To: [login to unmask email]
Subject: Re: Automated DB2 Statistics replication between Production
&
Tes t


Actually, Platinum's Database Analyzer product is supposed to be able
to
automate this process. I haven't gotten it to do that yet, though.
Anyone
else?

> -----Original Message-----
> From: Christine Sawyer [SMTP:[login to unmask email]
> Sent: Monday, January 03, 2000 6:23 PM
> To: [login to unmask email]
> Subject: Automated DB2 Statistics replication between Production
&
> Test
>
> Can anyone share some experience on this one? I will like to set up
a ajob
> to automatically update one of our test databases with production
> statistics
> on a weekly basis. Currently, we manually do this using Platinum's
> MIGRATOR
> product. I will appreciate any information/material anyone may
provide Or
> where I can get more information about it? Any documented step by
step
> procedure?
>
> We are running DB2 V5.
>
> Thanks
> Christine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
>
visit
> the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the
list can
>



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be




visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be




visit the
DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
be







**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************



visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can

=========
============











**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric and Southern Electric are trading names of
Scottish and Southern Energy Group
**********************************************************************








Libby Horton

Automated statistics replication
(in response to Libby Horton)
Hello,
Recently there was a question about statistics propagation. Here is some
information from one of our support representatives:

BMC has a product called PATROL SQL-EXPLORER which has the functionality to
migrate statistics from DB2 to DB2. It can also migrate BMCSTATS to the
DB2 Catalog. This will be available in the 3.1.01 ISPF version which is
due to go GA in February 2000.

You can also save your statistics so that if new statistics starts to impede
performance, you can quickly copy over your 'saved' or favorite statistics
and investigate the access path differences later without effecting
production.

Dorothy Cimarosti
BMC Product Support
1-800-537-1813


Best regards, Libby Horton



Robert Galambos

Re: Automated statistics replication
(in response to Libby Horton)
Hi

I thought I may put my two cents in here as well. <s>

Compuware's DBA tool, called DBA-XPERT, has the capability to move DB2
runstats statistics from one DB2 sub-system/database/etc. to another. This
capability is build within the product.

Robert Galambos
[login to unmask email]

Compuware Corp. Of Canada
1-905-803-8600
1-800-348-8299 (Canada & US)
1-905-803-8603 (fax)
1-800-447-1662 (Quebec)


Attachments

  • Galambos, Robert.vcf (<1k)