LASTUSED in SYSINDEXSPACESTATS

NULL NULL

LASTUSED in SYSINDEXSPACESTATS
Hello,

I'm trying to determine index usage partly by looking at the LASTUSED column
of the RTS table SYSIBM.SYSINDEXSPACESTATS. I'm on V9.1 for z/OS.

The SQL Reference manual (SC18-9854) states that the default value is
'0001-01-01' which would mean that index haven't been used if I understand
it correctly.

But what does NULL for the column mean? I can't seem to find any information
about it in the manuals.

Best regards,
--
Andreas Spångberg

_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Richard Janni

Re: LASTUSED in SYSINDEXSPACESTATS
(in response to NULL NULL)
Andreas,
Try reorging the object to initialize it in real time stats. That's the way it
works in V8 for other columns that are null.
Rich

_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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

Deborah Gresham

Re: LASTUSED in SYSINDEXSPACESTATS
(in response to Richard Janni)
We noticed the same thing and opened a question with IBM. The resolution was that they are going to update the documentation to say the default is NULL instead of '0001-01-01.'
Thanks,
Deborah

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Andreas Spångberg
Sent: Friday, December 11, 2009 6:51 AM
To: [login to unmask email]
Subject: [DB2-L] LASTUSED in SYSINDEXSPACESTATS

Hello,

I'm trying to determine index usage partly by looking at the LASTUSED column
of the RTS table SYSIBM.SYSINDEXSPACESTATS. I'm on V9.1 for z/OS.

The SQL Reference manual (SC18-9854) states that the default value is
'0001-01-01' which would mean that index haven't been used if I understand
it correctly.

But what does NULL for the column mean? I can't seem to find any information
about it in the manuals.

Best regards,
--
Andreas Spångberg

_____________________________________________________________________

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

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

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