z/OS V8, V9 History madness

Roy Boxwell

z/OS V8, V9 History madness
Hi list!

I know its friday but go and have a look at the HIST table docu in the
IBM Manual in my V8manualon P. 913

History statistics
Several catalog tables provide historical statistics for other catalog
tables. These catalog history tables include:
SYSIBM.SYSCOLDIST_HIST
SYSIBM.SYSCOLUMNS_HIST
SYSIBM.SYSINDEXES_HIST
SYSIBM.SYSINDEXPART_HIST
SYSIBM.SYSINDEXSTATS_HIST
SYSIBM.SYSLOBSTATS_HIST
SYSIBM.SYSTABLEPART_HIST
SYSIBM.SYSTABLES_HIST
SYSIBM.SYSTABSTATS_HIST

For example, SYSIBM.SYSTABLESPACE_HIST provides statistics for activity in
SYSIBM.SYSTABLESPACE, SYSIBM.SYSTABLEPART_HIST provides statistics for
activity in SYSIBM.SYSTABLEPART, and so on.

When DB2 adds or changes rows in a catalog table, DB2 might also write
information about the rows to the corresponding catalog history table.
Although
the catalog history tables are not identical to their counterpart tables,
they do
contain the same columns for access path information and space utilization
information. The history statistics provide a way to study trends, to
determine
when utilities, such as REORG, should be run for maintenance, and to aid
in space
management.


So *where* in the wide wide world of sports *is* SYSTABLESPACE_HIST
?!??!?! It's in the example above but I cannot find it anywhere!!! Then I
looked for SYSCOLSTATS_HIST as SYSCOLSTATS is used for access path choice
and this table does not exist either...is it me or has IBM forgotten some
tables???


Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Jorg Lueke

Re: z/OS V8, V9 History madness
(in response to Roy Boxwell)
We're just now looking at adding the History Stats collection to our jobs,
though mostly for space trending. What would you be looking for in
SYSTABLESPACE_HIST that you can't get from the other history tables?

On Fri, 8 Jan 2010 09:56:47 +0100, Roy Boxwell <[login to unmask email]>
wrote:

>Hi list!
>
> I know its friday but go and have a look at the HIST table docu in the
>IBM Manual in my V8manualon P. 913
>
>History statistics
>Several catalog tables provide historical statistics for other catalog
>tables. These catalog history tables include:
> SYSIBM.SYSCOLDIST_HIST
> SYSIBM.SYSCOLUMNS_HIST
> SYSIBM.SYSINDEXES_HIST
> SYSIBM.SYSINDEXPART_HIST
> SYSIBM.SYSINDEXSTATS_HIST
> SYSIBM.SYSLOBSTATS_HIST
> SYSIBM.SYSTABLEPART_HIST
> SYSIBM.SYSTABLES_HIST
> SYSIBM.SYSTABSTATS_HIST
>
>For example, SYSIBM.SYSTABLESPACE_HIST provides statistics for
activity in
>SYSIBM.SYSTABLESPACE, SYSIBM.SYSTABLEPART_HIST provides
statistics for
>activity in SYSIBM.SYSTABLEPART, and so on.
>
>When DB2 adds or changes rows in a catalog table, DB2 might also write
>information about the rows to the corresponding catalog history table.
>Although
>the catalog history tables are not identical to their counterpart tables,
>they do
>contain the same columns for access path information and space utilization
>information. The history statistics provide a way to study trends, to
>determine
>when utilities, such as REORG, should be run for maintenance, and to aid
>in space
>management.
>
>
>So *where* in the wide wide world of sports *is* SYSTABLESPACE_HIST
>?!??!?! It's in the example above but I cannot find it anywhere!!! Then I
>looked for SYSCOLSTATS_HIST as SYSCOLSTATS is used for access
path choice
>and this table does not exist either...is it me or has IBM forgotten some
>tables???
>
>
>Roy Boxwell
>SOFTWARE ENGINEERING GMBH
>-Product Development-
>Robert-Stolz-Stra�e 5
>40470 D�sseldorf/Germany
>Tel. +49 (0)211 96149-675
>Fax +49 (0)211 96149-32
>Email: [login to unmask email]
>http://www.seg.de
>
>Software Engineering GmbH
>Amtsgericht D�sseldorf, HRB 37894
>Gesch�ftsf�hrung: Siegfried F�rst, Gerhard Schubert
>
>__________________________________________________________
___________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
>__________________________________________________________
___________
>
>http://www.idug.org/db2-content/index.html has THOUSANDS of free
technical presentations!
>DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
>many more categories of help waiting for you!
>Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
>__________________________________________________________
___________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Roy Boxwell

Re: z/OS V8, V9 History madness
(in response to Jorg Lueke)
NACTIVEF ??




Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Jorg Lueke <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
08.01.2010 18:22
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] z/OS V8, V9 History madness






We're just now looking at adding the History Stats collection to our jobs,

though mostly for space trending. What would you be looking for in
SYSTABLESPACE_HIST that you can't get from the other history tables?

On Fri, 8 Jan 2010 09:56:47 +0100, Roy Boxwell <[login to unmask email]>
wrote:

>Hi list!
>
> I know its friday but go and have a look at the HIST table docu in the
>IBM Manual in my V8manualon P. 913
>
>History statistics
>Several catalog tables provide historical statistics for other catalog
>tables. These catalog history tables include:
> SYSIBM.SYSCOLDIST_HIST
> SYSIBM.SYSCOLUMNS_HIST
> SYSIBM.SYSINDEXES_HIST
> SYSIBM.SYSINDEXPART_HIST
> SYSIBM.SYSINDEXSTATS_HIST
> SYSIBM.SYSLOBSTATS_HIST
> SYSIBM.SYSTABLEPART_HIST
> SYSIBM.SYSTABLES_HIST
> SYSIBM.SYSTABSTATS_HIST
>
>For example, SYSIBM.SYSTABLESPACE_HIST provides statistics for
activity in
>SYSIBM.SYSTABLESPACE, SYSIBM.SYSTABLEPART_HIST provides
statistics for
>activity in SYSIBM.SYSTABLEPART, and so on.
>
>When DB2 adds or changes rows in a catalog table, DB2 might also write
>information about the rows to the corresponding catalog history table.
>Although
>the catalog history tables are not identical to their counterpart tables,

>they do
>contain the same columns for access path information and space
utilization
>information. The history statistics provide a way to study trends, to
>determine
>when utilities, such as REORG, should be run for maintenance, and to aid
>in space
>management.
>
>
>So *where* in the wide wide world of sports *is* SYSTABLESPACE_HIST
>?!??!?! It's in the example above but I cannot find it anywhere!!! Then I

>looked for SYSCOLSTATS_HIST as SYSCOLSTATS is used for access
path choice
>and this table does not exist either...is it me or has IBM forgotten some

>tables???
>
>
>Roy Boxwell
>SOFTWARE ENGINEERING GMBH
>-Product Development-
>Robert-Stolz-Stra�e 5
>40470 D�sseldorf/Germany
>Tel. +49 (0)211 96149-675
>Fax +49 (0)211 96149-32
>Email: [login to unmask email]
>http://www.seg.de
>
>Software Engineering GmbH
>Amtsgericht D�sseldorf, HRB 37894
>Gesch�ftsf�hrung: Siegfried F�rst, Gerhard Schubert
>
>__________________________________________________________
___________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
>__________________________________________________________
___________
>
>http://www.idug.org/db2-content/index.html has THOUSANDS of free
technical presentations!
>DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
>many more categories of help waiting for you!
>Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
>__________________________________________________________
___________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
the home of IDUG's DB2-L
>

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical
presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L


Jorg Lueke

Re: z/OS V8, V9 History madness
(in response to Roy Boxwell)
Maybe they want you to keep history from SYSTABLESPACESTATS

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Roy Boxwell

Re: z/OS V8, V9 History madness
(in response to Jorg Lueke)
nah I think they just "forgot" like they forgot that SYSCOLSTATS also
needs a _HIST table nowadays.....<sigh>...



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert




Jorg Lueke <[login to unmask email]>
Gesendet von: IDUG DB2-L <[login to unmask email]>
13.01.2010 16:56
Bitte antworten an
IDUG DB2-L <[login to unmask email]>


An
[login to unmask email]
Kopie

Thema
Re: [DB2-L] z/OS V8, V9 History madness






Maybe they want you to keep history from SYSTABLESPACESTATS

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG
meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L


_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L