sysibm.syscolstats column values

Tina Hilton

sysibm.syscolstats column values
Does anyone know how to interpret the high/low key values in
SYSIBM.SYSCOLSTATS (DB2 6.1 on OS/390)? There's a column that I want to see
the statistics for, but the column is defined as decimal(5,2) and I don't
know how to see the value in columns HIGHKEY, HIGH2KEY, LOWKEY, and LOW2KEY.
If I use the hex function to look at them, I get entries like
"F013994040404040" since the column is character with "for bit data". Would
this be the same as 13.99?

Thanks.

Tina Hilton
Random House Bertelsmann Shared Services


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

Agus Kwee

Re: sysibm.syscolstats column values
(in response to Tina Hilton)
Tina,

I have just test it with a similar column EMPTIME decimal(5,2) from
the IBM Sample Table EMPPROJACT under DB2 7.1 on OS/390
and get a result which is consistent with your interpretation:
F000754040404040 actualy represent the value of .75.

Regards,
Agus Kwee
Themis Training
http://www.themisinc.com


----- Original Message -----
From: "Hilton, Tina" <[login to unmask email]>
Date: Thursday, January 13, 2005 3:03 pm
Subject: [DB2-L] sysibm.syscolstats column values

> Does anyone know how to interpret the high/low key values in
> SYSIBM.SYSCOLSTATS (DB2 6.1 on OS/390)? There's a column that I
> want to see
> the statistics for, but the column is defined as decimal(5,2) and
> I don't
> know how to see the value in columns HIGHKEY, HIGH2KEY, LOWKEY,
> and LOW2KEY.
> If I use the hex function to look at them, I get entries like
> "F013994040404040" since the column is character with "for bit
> data". Would
> this be the same as 13.99?
>
> Thanks.
>
> Tina Hilton
> Random House Bertelsmann Shared Services
>
>
> -------------------------------------------------------------------
> --------------
> 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

Tina Hilton

Re: sysibm.syscolstats column values
(in response to Agus Kwee)
I thought that had to be right. We have column statistics from 1997 (!) and
I wondered if that was causing a performance problem we were having. It
ended up being something else, but it's nice to know how to interpret these
values anyway.

Thanks,

Tina

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of
Agus Kwee
Sent: Thursday, January 13, 2005 3:41 PM
To: [login to unmask email]
Subject: Re: [DB2-L] sysibm.syscolstats column values

Tina,

I have just test it with a similar column EMPTIME decimal(5,2) from
the IBM Sample Table EMPPROJACT under DB2 7.1 on OS/390
and get a result which is consistent with your interpretation:
F000754040404040 actualy represent the value of .75.

Regards,
Agus Kwee
Themis Training
http://www.themisinc.com


----- Original Message -----
From: "Hilton, Tina" <[login to unmask email]>
Date: Thursday, January 13, 2005 3:03 pm
Subject: [DB2-L] sysibm.syscolstats column values

> Does anyone know how to interpret the high/low key values in
> SYSIBM.SYSCOLSTATS (DB2 6.1 on OS/390)? There's a column that I
> want to see
> the statistics for, but the column is defined as decimal(5,2) and
> I don't
> know how to see the value in columns HIGHKEY, HIGH2KEY, LOWKEY,
> and LOW2KEY.
> If I use the hex function to look at them, I get entries like
> "F013994040404040" since the column is character with "for bit
> data". Would
> this be the same as 13.99?
>
> Thanks.
>
> Tina Hilton
> Random House Bertelsmann Shared Services
>
>
> -------------------------------------------------------------------
> --------------
> 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

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

Patrick Bossman

Re: sysibm.syscolstats column values
(in response to Tina Hilton)
Hello Tina,
The optimizer does not use COLSTATS directly in access path determination.
However, if SYSCOLSTATS is incorrect, then it's possible that SYSCOLUMNS
statistics are also incorrect - since SYSCOLUMNS are aggregated from
SYSCOLSTATS.

Regards,
Pat Bossman

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