Antwort: Re: [DB2-L] DB2 z/OS V7 - Real Time Statistics Questions

Roy Boxwell

Antwort: Re: [DB2-L] DB2 z/OS V7 - Real Time Statistics Questions

My guess and it is only a guess is that the CA tool does a direct update of the RTS COPYLASTTIME column so it is "RTS Compatible"....but they forgot the UPDATESTATSTIME...

Just my 2 cents /Euro cents of cousre and so worth MUCH more that the normal regular run-of-the-mill cents....)

 

Roy

 

[login to unmask email]
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
15.11.2007 01:38 PM CST
Bitte antworten an DB2 Database Discussion list at IDUG

An: [login to unmask email]
Kopie:
Blindkopie:
Thema: Re: [DB2-L] DB2 z/OS V7 - Real Time Statistics Questions
 

Well, I tried doing a copy both IBM & BMC utilities and made sure that RUNSTATS NO was in effect.
RTS was updated and         UPDATESTATSTIME WAS EQUAL TO COPYLASTTIME for both copies.
This proves that the UPDATESTATSTIME will be updated when an image copy is done.
So I am stumped same as James - !!
Mark.




Nicola Nur <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

11/14/2007 04:21 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>
To
[login to unmask email]
cc
Subject
Re: DB2 z/OS V7 - Real Time Statistics Questions
Hi James

Your understanding is correct about the fields but I believe your conclusion is not accurate. Imagine you updated a field in a table yesterday it will bear the timestamp of yesterday. Let us say you took an image copy today so the timestamp of the copylasttime will be today and clearly yesterday is less than  today. This is my understanding unless I am out to lunch...! (this is a credit to my colleague Charlie who explained to me)

Nick

"Hannis, James D (GE Comm Fin)" <[login to unmask email]> wrote:
It's my understanding that the UPDATESTATSTIME column reflects the time the row was inserted or last updated.    If that's the case, how can UPDATESTATSTIME ever be less than COPYLASTTIME?   Note: we're using CA Quick Copy utility for our copy process.
Is my understanding of UPDATESTATSTIME wrong or am I seeing a DB2 bug?
Here's the query results causing my confusion:
   SELECT                                                            
        "NAME"                                                      
       ,UPDATESTATSTIME                                            
       ,COPYLASTTIME                                                
FROM SYSIBM.TABLESPACESTATS                                          
WHERE DBNAME = 'DBMAXZ01'                                            
  AND     UPDATESTATSTIME < COPYLASTTIME                            
 ORDER BY                                                          
   DBNAME                                                          
 , NAME                                                            
    ;                                                              
---------+---------+---------+---------+---------+---------+---------
NAME      UPDATESTATSTIME             COPYLASTTIME                  
---------+---------+---------+---------+---------+---------+---------
TSDDD00S  2007-11-11-12.12.50.000000  2007-11-13-17.05.08.253917    
TSDDS00S  2007-10-21-11.33.40.067840  2007-11-13-17.06.08.636298    
James Hannis
Data Architect
GE Capital Solutions
--------------------------------------------------------------------------------- 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




[IMAGE]Yahoo! Canada Toolbar : Search from anywhere on the web and bookmark your favourite sites. Download it now!

--------------------------------------------------------------------------------- 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





This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.




--------------------------------------------------------------------------------- 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

--------------------------------------------------------------------------------- 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

James Hannis

Re: DB2 z/OS V7 - Real Time Statistics Questions
(in response to Roy Boxwell)
Thanks for the feedback - I'll try an IBM vs. CA test in my shop. If I
get the same IBM results as you did, I will assume that I have a CA
issue to explore.

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of [login to unmask email]
Sent: Thursday, November 15, 2007 1:38 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V7 - Real Time Statistics Questions



Well, I tried doing a copy both IBM & BMC utilities and made sure that
RUNSTATS NO was in effect.
RTS was updated and UPDATESTATSTIME WAS EQUAL TO COPYLASTTIME
for both copies.
This proves that the UPDATESTATSTIME will be updated when an image copy
is done.
So I am stumped same as James - !!
Mark.




Nicola Nur <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>

11/14/2007 04:21 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc
Subject
Re: DB2 z/OS V7 - Real Time Statistics Questions






Hi James

Your understanding is correct about the fields but I believe your
conclusion is not accurate. Imagine you updated a field in a table
yesterday it will bear the timestamp of yesterday. Let us say you took
an image copy today so the timestamp of the copylasttime will be today
and clearly yesterday is less than today. This is my understanding
unless I am out to lunch...! (this is a credit to my colleague Charlie
who explained to me)

Nick

"Hannis, James D (GE Comm Fin)" <[login to unmask email]> wrote:
It's my understanding that the UPDATESTATSTIME column reflects the time
the row was inserted or last updated. If that's the case, how can
UPDATESTATSTIME ever be less than COPYLASTTIME? Note: we're using CA
Quick Copy utility for our copy process.
Is my understanding of UPDATESTATSTIME wrong or am I seeing a DB2 bug?
Here's the query results causing my confusion:
SELECT
"NAME"
,UPDATESTATSTIME
,COPYLASTTIME
FROM SYSIBM.TABLESPACESTATS
WHERE DBNAME = 'DBMAXZ01'
AND UPDATESTATSTIME < COPYLASTTIME
ORDER BY
DBNAME
, NAME
;
---------+---------+---------+---------+---------+---------+---------
NAME UPDATESTATSTIME COPYLASTTIME
---------+---------+---------+---------+---------+---------+---------
TSDDD00S 2007-11-11-12.12.50.000000 2007-11-13-17.05.08.253917
TSDDS00S 2007-10-21-11.33.40.067840 2007-11-13-17.06.08.636298
James Hannis
Data Architect
GE Capital Solutions
------------------------------------------------------------------------
--------- 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


________________________________

Yahoo! Canada Toolbar : Search from anywhere on the web and bookmark
your favourite sites. Download it now! < http://ca.toolbar.yahoo.com/ >

------------------------------------------------------------------------
--------- 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





This e-mail (and any attachments) may contain information that is
confidential and/or protected by law. Any review, use, distribution or
disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the
intended recipient, please contact the sender by reply email and delete
all copies of this message.




------------------------------------------------------------------------
--------- 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


---------------------------------------------------------------------------------
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

Nick Nur

Re: DB2 z/OS V7 - Real Time Statistics Questions
(in response to James Hannis)
Hi James and Mark

It seems IBM Copy Utility will update the Pageset Header of the TS. That means at least the UPDATESTATSTIME should be equal to COPYLASTTIME. However it could be greater because some other activities such as INSERT may have occured. We are talking about IBM copy utility. We do not know about other utilities. We suspect the reason for your UPDATESTATSTIME being smaller than the COPYLASTTIME is due to using CA Quick Copy . Again (this is a credit to my colleague Charlie who explained to me again). I hope we did not confuse you more.


"Hannis, James D (GE Comm Fin)" <[login to unmask email]> wrote:
Thanks for the feedback - I'll try an IBM vs. CA test in my shop. If I get the same IBM results as you did, I will assume that I have a CA issue to explore.


---------------------------------
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Thursday, November 15, 2007 1:38 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V7 - Real Time Statistics Questions




Well, I tried doing a copy both IBM & BMC utilities and made sure that RUNSTATS NO was in effect.
RTS was updated and UPDATESTATSTIME WAS EQUAL TO COPYLASTTIME for both copies.
This proves that the UPDATESTATSTIME will be updated when an image copy is done.
So I am stumped same as James - !!
Mark.



Nicola Nur <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]> 11/14/2007 04:21 PM Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email] cc
Subject
Re: DB2 z/OS V7 - Real Time Statistics Questions




Hi James

Your understanding is correct about the fields but I believe your conclusion is not accurate. Imagine you updated a field in a table yesterday it will bear the timestamp of yesterday. Let us say you took an image copy today so the timestamp of the copylasttime will be today and clearly yesterday is less than today. This is my understanding unless I am out to lunch...! (this is a credit to my colleague Charlie who explained to me)

Nick

"Hannis, James D (GE Comm Fin)" <[login to unmask email]> wrote:
It's my understanding that the UPDATESTATSTIME column reflects the time the row was inserted or last updated. If that's the case, how can UPDATESTATSTIME ever be less than COPYLASTTIME? Note: we're using CA Quick Copy utility for our copy process.
Is my understanding of UPDATESTATSTIME wrong or am I seeing a DB2 bug?
Here's the query results causing my confusion:
SELECT
"NAME"
,UPDATESTATSTIME
,COPYLASTTIME
FROM SYSIBM.TABLESPACESTATS
WHERE DBNAME = 'DBMAXZ01'
AND UPDATESTATSTIME < COPYLASTTIME
ORDER BY
DBNAME
, NAME
;
---------+---------+---------+---------+---------+---------+---------
NAME UPDATESTATSTIME COPYLASTTIME
---------+---------+---------+---------+---------+---------+---------
TSDDD00S 2007-11-11-12.12.50.000000 2007-11-13-17.05.08.253917
TSDDS00S 2007-10-21-11.33.40.067840 2007-11-13-17.06.08.636298
James Hannis
Data Architect
GE Capital Solutions
--------------------------------------------------------------------------------- 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

---------------------------------

Yahoo! Canada Toolbar : Search from anywhere on the web and bookmark your favourite sites. Download it now! --------------------------------------------------------------------------------- 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



This e-mail (and any attachments) may contain information that is confidential and/or protected by law. Any review, use, distribution or disclosure to anyone other than the
intended recipient(s) is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and delete all copies of this message.
--------------------------------------------------------------------------------- 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
--------------------------------------------------------------------------------- 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


---------------------------------
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail

---------------------------------------------------------------------------------
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

Steen Rasmussen

Re: DB2 z/OS V7 - Real Time Statistics Questions
(in response to Nick Nur)
Hello James -



Based on your concern, we investigated this issue and your observation
is correct.

CA Quick Copy currently doesn't update UPDATESTATSTIME even though you
have the highlvl.PARMLIB(UTIL) parameter UPDTE-RTS-TABLES (YES).

This is now being addressed and a PTF will be available shortly.



Steen Rasmussen
CA

Principal Technical Specialist DB2 tools

IBM Certified Database Associate -- DB2 9 Fundamentals

IBM Certified Database Administrator - DB2 9 DBA for z/OS

Tel : +1-630-505-6673 (US direct)
Tel : +1-815-274-9589 (US mobile)

Tel : +45-22 15 44 98 (Europe mobile)
[login to unmask email]
< http://www.ca.com >

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Hannis, James D (GE Comm Fin)
Sent: Monday, November 19, 2007 2:36 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 z/OS V7 - Real Time Statistics Questions



Thanks for the feedback - I'll try an IBM vs. CA test in my shop. If I
get the same IBM results as you did, I will assume that I have a CA
issue to explore.



------------------------------------------------------------------------
--------- 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

---------------------------------------------------------------------------------
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

Nick Nur

DB2 statistics
(in response to Steen Rasmussen)
Hi colleagues
What is the easiest way to port DB2 z/OS statistics from one DB2 subsystem to another? Is there a procedure in any of the v8 manuals that I can read about it?

Any advice or suggestions?
Thanks in advance.

Nick




---------------------------------
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail

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

Roy Boxwell

Antwort: [DB2-L] DB2 statistics
(in response to Nick Nur)

There is indeed a very "interesting" set of SQLs in the docu abourt updating statistics. However a quick search of listserv will also show up

a) It doesnt work as well as it should

b) You must REXX the output

c) A bunch of people have written their own routines to do it

d) Lots of firms, including my own, sell programs to do it for you (With various levels of renaming, selecting, changing etc.)

Basically you tend to get what you pay for - so a free REXX is generally great when you have one thing you do all the time (DR Test etc.) but a PITA

when you want to do lots of things...as always it depends...

Hope that Helps!

Ryo Boxwell

Nicola Nur <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
13.12.2007 10:05 PM EST
Bitte antworten an DB2 Database Discussion list at IDUG

An: [login to unmask email]
Kopie:
Blindkopie:
Thema: [DB2-L] DB2 statistics
 

Hi colleagues
What is the easiest way to port DB2 z/OS statistics from one DB2 subsystem to another? Is there a procedure in any of the v8 manuals that I can read about it?

Any advice or suggestions?
Thanks in advance.

Nick





Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail 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/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 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 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 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

Avram Friedman

Re: DB2 statistics
(in response to Roy Boxwell)
There is a good sample on the IDUG CodePage
One needs to be registered to obtain access but the price is right, FREE.

Regards
Avram Friedman

On Thu, 13 Dec 2007 22:05:55 -0500, Nicola Nur <[login to unmask email]>
wrote:

>Hi colleagues
> What is the easiest way to port DB2 z/OS statistics from one DB2
subsystem to another? Is there a procedure in any of the v8 manuals that I
can read about it?
>
> Any advice or suggestions?
> Thanks in advance.
>
> Nick
>
>
>
>
>---------------------------------
>Be smarter than spam. See how smart SpamGuard is at giving junk email the
boot with the All-new Yahoo! Mail
>
>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

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

John Amsden

Re: DB2 statistics
(in response to Avram Friedman)
The DB2 admin guide also has the SQL needed. I've used it pretty well
right-out-of-the-box and it seems to work well.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Avram Friedman
Sent: Friday, December 14, 2007 8:31 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 statistics


There is a good sample on the IDUG CodePage
One needs to be registered to obtain access but the price is right, FREE.

Regards
Avram Friedman

On Thu, 13 Dec 2007 22:05:55 -0500, Nicola Nur <[login to unmask email]>
wrote:

>Hi colleagues
> What is the easiest way to port DB2 z/OS statistics from one DB2
subsystem to another? Is there a procedure in any of the v8 manuals that I
can read about it?
>
> Any advice or suggestions?
> Thanks in advance.
>
> Nick
>
>
>
>
>---------------------------------
>Be smarter than spam. See how smart SpamGuard is at giving junk email the
boot with the All-new Yahoo! Mail
>
>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

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




Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**

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

Jeff L'Italien

Re: DB2 statistics
(in response to John Amsden)
The best way to port the statistics is through the Service SQL data of the
Visual Explain tool which is free from the IBM Website. The following is a
related link for the tool:

http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-12-
07+12%3A36%
3A33.258737R&cat=&fam=&s=z&S_TACT=TrialsAndBetas&S_CMP=

Assuming that you have Admin rights to your PC you can download/configure
the application. After you have extracted the statistics information from your
production environment you may have to modify the associated DDL to match
it up with you test environment....I.E. database names/tablespace
names/table creators.

Regards,
Jeff L'Italien

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

Phil Grainger

Re: DB2 statistics
(in response to Jeff L'Italien)
OK, but don't forget that Visual Explain is one of the bits of DB2 that
"goes away" with DB2 9....

Replaced by the Optimization Service Center


Phil Grainger
CA
Product Management Director
Phone: +44 (0)1753 577 733
Mobile: +44 (0)7970 125 752
eMail: [login to unmask email]

Ditton Park
Riding Court Road
Datchet
Slough
SL3 9LL

CA plc a company registered in England and Wales under company
registration number 1282495 with its registered office at the address
set out above. VAT number 697904179.



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Jeff
Sent: 14 December 2007 15:55
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 statistics

The best way to port the statistics is through the Service SQL data of
the Visual Explain tool which is free from the IBM Website. The
following is a related link for the tool:

http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-12-
07+12%3A36%
3A33.258737R&cat=&fam=&s=z&S_TACT=TrialsAndBetas&S_CMP=

Assuming that you have Admin rights to your PC you can
download/configure the application. After you have extracted the
statistics information from your production environment you may have to
modify the associated DDL to match it up with you test
environment....I.E. database names/tablespace names/table creators.

Regards,
Jeff L'Italien

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

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

Shery hepp

Re: DB2 statistics
(in response to Phil Grainger)
I use the service SQL component of Visual Explain to gather the stats. I
then make the modifications for dbname and tbowner name, cut and paste
it and run it in command center. It's quick and easy so I let VE do the
work for me. (plus it's a free tool from IBM)



Regards, Shery



________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Nicola Nur
Sent: Thursday, December 13, 2007 8:06 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 statistics



Hi colleagues

What is the easiest way to port DB2 z/OS statistics from one DB2
subsystem to another? Is there a procedure in any of the v8 manuals that
I can read about it?



Any advice or suggestions?

Thanks in advance.



Nick






________________________________

Be smarter than spam. See how smart SpamGuard is at giving junk email
the boot with the All-new Yahoo! Mail
< http://ca.promos.yahoo.com/newmail/overview2/ > 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/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 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 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 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

Sally Mir

Re: DB2 statistics
(in response to Shery hepp)
There is a free program you can request from IBM called DB2PLI8. One of
the things it can do is extract the stats and write the catalog
update/insert statements for you.


Sally A. Mir, AVP
Wachovia Enterprise Data Management
(336) 773-4011
IBM Certified Database Administrator
DB2 9 DBA for Z/OS
DB2 Universal Database V8.1 for Z/OS
IBM Certified Database Associate
DB2 Universal Database V8.1 Family

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

William Favero

Re: DB2 statistics
(in response to Sally Mir)
The "Service SQL" feature still exist in optimization Service Center.
However, in OSC it is now called "Gather Service Information"

Willie

Grainger, Phil wrote:
> OK, but don't forget that Visual Explain is one of the bits of DB2 that
> "goes away" with DB2 9....
>
> Replaced by the Optimization Service Center
>
>
> Phil Grainger
> CA
> Product Management Director
> Phone: +44 (0)1753 577 733
> Mobile: +44 (0)7970 125 752
> eMail: [login to unmask email]
>
> Ditton Park
> Riding Court Road
> Datchet
> Slough
> SL3 9LL
>
> CA plc a company registered in England and Wales under company
> registration number 1282495 with its registered office at the address
> set out above. VAT number 697904179.
>
>
>
> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Jeff
> Sent: 14 December 2007 15:55
> To: [login to unmask email]
> Subject: Re: [DB2-L] DB2 statistics
>
> The best way to port the statistics is through the Service SQL data of
> the Visual Explain tool which is free from the IBM Website. The
> following is a related link for the tool:
>
> http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-12-
> 07+12%3A36%
> 3A33.258737R&cat=&fam=&s=z&S_TACT=TrialsAndBetas&S_CMP=
>
> Assuming that you have Admin rights to your PC you can
> download/configure the application. After you have extracted the
> statistics information from your production environment you may have to
> modify the associated DDL to match it up with you test
> environment....I.E. database names/tablespace names/table creators.
>
> Regards,
> Jeff L'Italien
>
> 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
>
> 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
>
>
>

--
Willie
My DB2 blog --> http://blogs.ittoolbox.com/database/db2zos

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