[DB2 - z/OS] Catalog Tables Question

Satish Srikakulapu

[DB2 - z/OS] Catalog Tables Question
Dear Esteemed Listers:

Environment:
z/OS - V 1.10
DB2 - V9.1 NFM

This is a question that was brought up in the morning discussion today. In the SQL Reference manual, we do have description of each catalog table regarding when it is updated, and if the data in this table is updatable or not. But, what we don't have is why a particular catalog table is used for? For example, SYSIBM.SYSCOLDIST table is used in determining the accesspath but we do not know why and where SYSIBM.SYSCOLDISTSTATS is used.

The question here is, do we have any documentation that specifies what is the purpose of each catalog table and how the data populated in it (either through RUNSTATS or any other DB2 utility) is used?

Thanks in Advance.

Regards,
Satish Srikakulapu


--- NOTICE ---

This message is for the designated recipient only and may contain confidential, privileged or proprietary information. If you have received it in error, please notify the sender immediately and delete the original and any copy or printout. Unintended recipients are prohibited from making any other use of this e-mail. Although we have taken reasonable precautions to ensure no viruses are present in this e-mail, we accept no liability for any loss or damage arising from the use of this e-mail or attachments, or for any delay or errors or omissions in the contents which result from e-mail transmission.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Enrico Haak

Re: [DB2 - z/OS] Catalog Tables Question
(in response to Satish Srikakulapu)
Hi Satish,

if you are interested in the application performance issue and which
tables, columns are used by the DB2 optimizer
have a look at "Performance Monitoring and Tuning Guide" , SC18-9851,
Chapter 11.

Mit freundlichen Grüßen / Best Regards

Enrico Haak

___________________________________________________________________

InSoft Software GmbH, Derendorfer Str. 70, 40479 Düsseldorf / Germany
Tel. +49 211 44 03 166, Fax +49 211 48 80 33
Geschäftsführer: Colin Oakhill, Günther Wichmann
HRB 20486 DÜSSELDORF * UST-IDNR:DE 119253977 * www.insoft-software.de


Am 11.02.2011 16:08, schrieb Satish Srikakulapu:
> Dear Esteemed Listers:
> Environment:
> z/OS - V 1.10
> DB2 - V9.1 NFM
> This is a question that was brought up in the morning discussion
> today. In the SQL Reference manual, we do have description of each
> catalog table regarding when it is updated, and if the data in this
> table is updatable or not. But, what we don't have is why a particular
> catalog table is used for? For example, SYSIBM.SYSCOLDIST table is
> used in determining the accesspath but we do not know why and where
> SYSIBM.SYSCOLDISTSTATS is used.
> The question here is, do we have any documentation that specifies what
> is the purpose of each catalog table and how the data populated in it
> (either through RUNSTATS or any other DB2 utility) is used?
> Thanks in Advance.
> Regards,
> Satish Srikakulapu
> --- NOTICE ---
>
> This message is for the designated recipient only and may contain
> confidential, privileged or proprietary information. If you have
> received it in error, please notify the sender immediately and delete
> the original and any copy or printout. Unintended recipients are
> prohibited from making any other use of this e-mail. Although we have
> taken reasonable precautions to ensure no viruses are present in this
> e-mail, we accept no liability for any loss or damage arising from the
> use of this e-mail or attachments, or for any delay or errors or
> omissions in the contents which result from e-mail transmission.
> ------------------------------------------------------------------------
>
> Independent, not-for-profit, User Run - the IDUG difference!
> < http://www.idug.org >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. If
> you are not already an IDUG member, please register here.
> < http://www.idug.org/register >
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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

Satish Srikakulapu

Re: [DB2 - z/OS] Catalog Tables Question
(in response to Enrico Haak)
Hi Enrico,

Thank you for the information.

Regards,
Satish Srikakulapu

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Enrico Haak
Sent: Friday, February 11, 2011 8:18 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [DB2 - z/OS] Catalog Tables Question

Hi Satish,

if you are interested in the application performance issue and which tables, columns are used by the DB2 optimizer
have a look at "Performance Monitoring and Tuning Guide" , SC18-9851, Chapter 11.

Mit freundlichen Grüßen / Best Regards

Enrico Haak

___________________________________________________________________

InSoft Software GmbH, Derendorfer Str. 70, 40479 Düsseldorf / Germany
Tel. +49 211 44 03 166, Fax +49 211 48 80 33
Geschäftsführer: Colin Oakhill, Günther Wichmann
HRB 20486 DÜSSELDORF * UST-IDNR:DE 119253977 * www.insoft-software.de < http://www.insoft-software.de >

Am 11.02.2011 16:08, schrieb Satish Srikakulapu:
Dear Esteemed Listers:

Environment:
z/OS - V 1.10
DB2 - V9.1 NFM

This is a question that was brought up in the morning discussion today. In the SQL Reference manual, we do have description of each catalog table regarding when it is updated, and if the data in this table is updatable or not. But, what we don't have is why a particular catalog table is used for? For example, SYSIBM.SYSCOLDIST table is used in determining the accesspath but we do not know why and where SYSIBM.SYSCOLDISTSTATS is used.

The question here is, do we have any documentation that specifies what is the purpose of each catalog table and how the data populated in it (either through RUNSTATS or any other DB2 utility) is used?

Thanks in Advance.

Regards,
Satish Srikakulapu

--- NOTICE ---

This message is for the designated recipient only and may contain confidential, privileged or proprietary information. If you have received it in error, please notify the sender immediately and delete the original and any copy or printout. Unintended recipients are prohibited from making any other use of this e-mail. Although we have taken reasonable precautions to ensure no viruses are present in this e-mail, we accept no liability for any loss or damage arising from the use of this e-mail or attachments, or for any delay or errors or omissions in the contents which result from e-mail transmission.
________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

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