Antwort: [DB2-L] Problem with RTS reorgleafnear/v8 z/os

Roy Boxwell

Antwort: [DB2-L] Problem with RTS reorgleafnear/v8 z/os
This is a "known" problem in RTS....here is my little RTS APAR list that I
keep handy

RTS APARS from IBM

APAR V7 V8 V9 Description
PK35250 UK24354 UK24355 UK24356 Incorrect key numbers possible
during log apply
PK46792 UK27887 UK27888 UK27889 DBID's with 255 possible when
using REPAIR
PK49433 UK36450 UK31869 UK31870 REORGPSEDUODELETE is incorrect
PK49823 UK28667 UK28668 UK28669 Bad NULL indicator handling
PK51197 N/A UK28827 UK28828 SPACE can be negative if more
than 524287 pages
PK52434 UK29778 UK29779 UK29780 HIPER EXTENT sometimes not
updated by shrlevel
change reorg
PK53341 UK32913 UK32914 UK32915 TOTALROWS or TOTALENTRIES < 0 or
> 2**40 and Counter
overflow and bad
REORGPSEUDODELETES
PK54691 N/A UK31675 UK31676 DEFINE NO objects created RTS
entries incorrectly
PK54836 N/A N/A UK31871 TOTALENTRIES for NPI's after
REORG PART, LOAD
REPLACE or ALTER PART ROTATE
incorrect
PK56504 N/A UK32960 UK32961 REORGLASTTIME for
Catalog/Directory
PK56693 N/A UK34333 UK34334 NLEVELS incorrect
PK57606 N/A UK32717 UK32718 Incorrect RTS data and negative
REORGUNCLUSTINS
PK60481 N/A UK38136 UK38137 INCORRECT VALUES FOR
TOTALROWS,TOTALENTRIES,DATASIZE,
NPAGES,REORGNEARINDREF,REORGFARINDREF,NLEAF,
REORGPSEUDODELETES,REORGLEAFNEAR,REORGLEAFFAR
AND REORGNUMLEVELS IN A DATA
SHARING ENVIRONMENT
PK69354 N/A N/A UK38837 MISSING RTS ROWS FOR NEWLY ADDED
PBG PARTITIONS BY LOAD REPLACE
PK71506 N/A UK40597 N/A REORG/LOAD PART with SHRLEVEL
NONE updates all COPYLASTTIME for all PARTS



Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Straße 5
40470 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Siegfried Fürst, Gerhard Schubert





"Backes, Mike" <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
08.12.2008 17:45
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: [DB2-L] 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



______________________________________________________________________

* 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