DB2 for z/os, RTS-Question

Ruediger Kurtz

DB2 for z/os, RTS-Question
Hi everyone,

does anybody have any idea why space in SYSIBM.TABLESPACESTATS can sometimes be negative ?

First we thought this might be due to overflow but found this notion to be wrong.

Here a snippet from a few days ago:

SELECT DBNAME , NAME , PARTITION , SPACE

FROM SYSIBM.TABLESPACESTATS

WHERE SPACE < 0

ORDER BY 1 , 2 , 3

---------+---------+---------+---------+--

DBNAME NAME PARTITION SPACE

---------+---------+---------+---------+--

D00IM020 PRZKF0FL 27 -2006272

D00IM020 PRZKF0FL 33 -1372672

D00IM020 PRZKF0FL 49 -1245952

D00IM020 PRZKF0FL 99 -2006272

D00IM020 PRZKF0FL 100 -2006272

D00IM020 PRZKF0FL 104 -2069632

D00IM020 PRZKF2HL 2 -612352

D00IM020 PRZKF2HL 6 -548992

D00IM020 PRZKF2HL 7 -548992

D00IM020 PRZKF2HL 16 -548992

D00IM020 PRZKF2HL 18 -548992

D00IM020 PRZKF2HL 19 -485632

.....



And here's one from last Friday:

SELECT DBNAME , NAME , PARTITION , SPACE

FROM SYSIBM.TABLESPACESTATS

WHERE SPACE < 0

ORDER BY 1 , 2 , 3

---------+---------+---------+---------+---

DBNAME NAME PARTITION SPACE

---------+---------+---------+---------+---

D00IM020 PRZKF2HL 36 -485632

Regards

Ruediger



Rüdiger Kurtz
Abteilung Informatik Betrieb

HUK-COBURG
Bahnhofsplatz
96444 Coburg

Telefon 09561 96-3914
Telefax 09561 96-3678
E-Mail [login to unmask email]
Internet www.HUK.de

=============
HUK-COBURG Haftpflicht-Unterstützungs-Kasse kraftfahrender Beamter Deutschlands a. G. in Coburg
Reg.-Gericht Coburg HRB 100; St.-Nr. 9212/101/00021
Sitz der Gesellschaft: Bahnhofsplatz, 96444 Coburg
Vorsitzender des Aufsichtsrats: Werner Strohmayr.
Vorstand: Rolf-Peter Hoenen (Sprecher), Wolfgang Flaßhoff, Stefan Gronbach, Klaus-Jürgen Heitmann, Christian Hofer, Dr. Wolfgang Weiler.
=============


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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

Max Scarpa

Re: DB2 for z/os, RTS-Question
(in response to Ruediger Kurtz)

Hi Ruediger how's life going ?

If in V8 (or V9) take a look:


PK51197: THE COLUMN SPACE IN SYSIBM.TABLESPACESTATS HAS A NEGATIVE VALUE
WHEN THE NUMBER OF ALLOCATED PAGES ARE GREATER THAN 524287

PTFs are

UK28827
UK28828

HTH

Max Scarpa

Certified RTS cleaner
Certified S=k logW (i.e. the mess in DB2 is always increasing)


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the 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