[DB2 V9 z/OS] Extents and indexes and RTS (and piecesize)

Lynne Flatley

[DB2 V9 z/OS] Extents and indexes and RTS (and piecesize)
I'm wondering if this has been discussed before. I searched the archives and
didn't see it.

I did a 3.4 (Data Set List) this morning on indexes in this production
database. I then sorted the listing by extents and found several whose space
allocations needed tweaking. I thought I'd double check my results in RTS
and noticed that only one of the index datasets for an index with multiple
files (because of the piecesize value) was stored in
SYSIBM.SYSINDEXSPACESTATS. So we cannot use RTS to monitor extents for
indexes if we use the piecesize parm (and additional datasets actually get
created)?

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Steen Rasmussen

Re: [DB2 V9 z/OS] Extents and indexes and RTS (and piecesize)
(in response to Lynne Flatley)
Since it seems like you're using RTS to monitor which indexes (and
tablespaces) need attention, have you looked at adding an OR predicate
for these SYSINDEXSPACESTATS columns : NPAGES, NLEAF, NACTIVE.



I can't help adding a small AD here - so stop reading now.

CA Database Analyzer has a number of built-in features to handle this
like:



(IX) Total extents per dataset

(IX) Total extents for last dataset



As always - for interested parties please feel free to contact me off
the list.



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified database Administrator - DB2 9 DBA for z/OS
Tel: +1-630-505-6673
Mobile: +1-708-382-1363
[login to unmask email]
<mailto:[login to unmask email]> < http://www.ca.com/ >



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lynne Flatley
Sent: Thursday, December 16, 2010 10:52 AM
To: [login to unmask email]
Subject: [DB2-L] [DB2 V9 z/OS] Extents and indexes and RTS (and
piecesize)



I'm wondering if this has been discussed before. I searched the archives
and didn't see it.

I did a 3.4 (Data Set List) this morning on indexes in this production
database. I then sorted the listing by extents and found several whose
space allocations needed tweaking. I thought I'd double check my
results in RTS and noticed that only one of the index datasets for an
index with multiple files (because of the piecesize value) was stored in

SYSIBM.SYSINDEXSPACESTATS. So we cannot use RTS to monitor extents for
indexes if we use the piecesize parm (and additional datasets actually
get created)?

________________________________

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 EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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

Lynne Flatley

Re: [DB2 V9 z/OS] Extents and indexes and RTS (and piecesize)
(in response to Steen Rasmussen)
Well, I was really just looking to see if I would have gotten my info more
quickly by just querying the RTS tables instead of doing a 3.4

So my point is that it appears to be a bug that RTS for indices, doesn't
seem to account for multiple datasets of non-partitioned indices...

On Thu, Dec 16, 2010 at 1:45 PM, Rasmussen, Steen <[login to unmask email]>wrote:

> Since it seems like you’re using RTS to monitor which indexes (and
> tablespaces) need attention, have you looked at adding an OR predicate for
> these SYSINDEXSPACESTATS columns : NPAGES, NLEAF, NACTIVE.
>
>
>
> I can’t help adding a small AD here – so stop reading now.
>
> CA Database Analyzer has a number of built-in features to handle this like:
>
>
>
> (IX) Total extents per dataset
>
> (IX) Total extents for last dataset
>
>
>
> As always – for interested parties please feel free to contact me off the
> list.
>
>
>
> *Steen Rasmussen*
> CA Technologies
> Sr Engineering Services Architect
>
> IBM Certified Database Associate - DB2 9 Fundamentals
>
> IBM Certified database Administrator - DB2 9 DBA for z/OS
> Tel: +1-630-505-6673
> Mobile: +1-708-382-1363
> [login to unmask email]
> < http://www.ca.com/ >
>
>
>
> *From:* IDUG DB2-L [mailto:[login to unmask email] *On Behalf Of *Lynne
> Flatley
> *Sent:* Thursday, December 16, 2010 10:52 AM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] [DB2 V9 z/OS] Extents and indexes and RTS (and
> piecesize)
>
>
>
> I'm wondering if this has been discussed before. I searched the archives
> and didn't see it.
>
> I did a 3.4 (Data Set List) this morning on indexes in this production
> database. I then sorted the listing by extents and found several whose space
> allocations needed tweaking. I thought I'd double check my results in RTS
> and noticed that only one of the index datasets for an index with multiple
> files (because of the piecesize value) was stored in
> SYSIBM.SYSINDEXSPACESTATS. So we cannot use RTS to monitor extents for
> indexes if we use the piecesize parm (and additional datasets actually get
> created)?
> ------------------------------
>
> [image: 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 >
>
> ------------------------------
>
> [image: 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 EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

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