Problem with RTS reorgleafnear/v8 z/os

Mike Backes

Problem with RTS reorgleafnear/v8 z/os
We have serveral indexes that have been reorganized within the last
month or so, that are now maxing out the integer type
Of reorgleafnear. Not sure what could be causing this and I was
wondering if anyone else had any similar experience on what is going on
here?

I did not have any utilities or any other type of abends that would
cause this or anything like that, and most of these are fairly
inactive/small
Indexes on smallish tablespaces.(non partitioned).


LASTREORG ACTIVEPAGES LEAFNEAR LEAFFAR
-+---------+---------+---------+---------+---------+---------+----
2008-10-24-11.15.39.436311 3240 2147483647 12
2008-10-24-11.10.47.460905 900 2147483647 64
2008-10-24-13.41.25.839564 43801 2147483647 2264
2008-10-24-14.14.06.006779 181260 2147483647 1866
2008-10-24-14.34.49.424550 80820 2147483647 5030
2008-10-24-11.56.34.317739 2520 2147483647 92
2008-10-24-11.51.42.978608 30060 2147483647 1455
2008-10-24-11.09.15.436103 2160 2147483647 368



In addition We seem to be having another intermittent problem with the
reorg utility not updating the normal catalog statistics.
For example we run a reorg, and everything but the index statistics in
the catalog get updated. The tablespace statistics get updated,
Ther rts for tablespace and indexspace get updated, but not the
indexspace statistics for the catalog. No error messages from the
utility nor any kind of hint that something didn't work.






Mike Backes

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms