capacity of table alert / (H/t Larry Jardine)

Philip Sevetson

capacity of table alert / (H/t Larry Jardine)
Roy,

I dug a bit deeper into the Code Place. It looks like I’m thinking about Larry Jardine’s contribution from 2012 ( https://www.idug.org/p/do/sd/sid=3185 ) -

From that date, I’m not completely sure that it’s up to date to V12, but I’m going to run it in V11.

Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Boxwell, Roy <[login to unmask email]>
Sent: Friday, August 2, 2019 8:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: capacity of table alert (AD)

I think I posted some SQL years ago but all the SQL relies on uptodate statistics. Better is to catch the ifcid issued by extent/lds allocation and use the data within to calculate where you are at. We sell a programme suite called SAX that does this and a ton of other stuff as well...
Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de
Link zur Datenschutzerklärung https://www.seg.de/corporate/rechtliche-hinweise/datenschutz

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

On 2 Aug 2019, at 14:46, Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>> wrote:
A couple of years ago, someone on the List here posted code which explicitly determined how much space a tablespace (or index, I think) was occupying, and (based on DB2 catalog information) how close it was to being completely full. HOWEVER, I can’t find the article in the DB2-L history or archives (weak “google-fu”), and I don’t seem to have saved a copy in my personal files. Based on a search of titles, it never made it to the IDUG Code Place (and it should!!).

Does anyone have a copy of this code, or alternately remember enough about this that we can find that code for bekir (and for me)?

-phil (sevetson)



From: Neil Price <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 3:56 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: capacity of table alert

If this is Db2 for z/OS then you can gather space-only statistics without affecting access paths, using the STATISTICS UPDATE SPACE clause of REORG or the UPDATE SPACE clause of RUNSTATS. Maybe that would satisfy your requirements.

On Fri, 2 Aug 2019 at 08:31, bekir arslan <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hello All,

I have a case about table empty space.

I have a log table on my system and I need system alert when my table's fullness capacity get %90. By the way I can't use reorg statistic. Because I Schedule (never change my table's statisctic) constant statistics because of performance reason.

Is there any product or any other alert tool?



thanks for yor advice.

have a nice day.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)