capacity of table alert

bekir arslan

capacity of table alert

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.

Neil Price

capacity of table alert
(in response to bekir arslan)
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]> 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-----
>

Philip Sevetson

capacity of table alert
(in response to Neil Price)
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]>
Sent: Friday, August 2, 2019 3:56 AM
To: [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.**

Roy Boxwell

capacity of table alert (AD)
(in response to Philip Sevetson)
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]
http://www.seg.de
Link zur Datenschutzerklärung

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]> 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]>
> Sent: Friday, August 2, 2019 3:56 AM
> To: [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]> 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.**
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)

bekir arslan

RE: capacity of table alert (AD)
(in response to Roy Boxwell)

Thanks to everyone,

Roy;

Can you give more information about SAX?

Who is support or full name of SAX?

Phil Grainger

capacity of table alert (AD)
(in response to bekir arslan)
A REALLY quick Google search “Db2 SAX” took me to https://www.seg.de/en/products/db2-zos-products/db2-database-maintenance-and-performance/

Amazing how Google can just find stuff ��

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)] [cid:[login to unmask email] [https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: bekir arslan <[login to unmask email]>
Sent: 02 August 2019 14:27
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: capacity of table alert (AD)


Thanks to everyone,

Roy;

Can you give more information about SAX?

Who is support or full name of SAX?

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
Attachments

  • image001.jpg (49.7k)
  • image002.png (6.7k)
  • image003.jpg (1.6k)
  • image004.png (<1k)

Roy Boxwell

capacity of table alert (AD)
(in response to bekir arslan)
Hi!
SpaceAssurance Expert is the full name. A quick visit to our web site will answer any questions!

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]
http://www.seg.de
Link zur Datenschutzerklärung

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

> On 2 Aug 2019, at 15:26, bekir arslan <[login to unmask email]> wrote:
>
> Thanks to everyone,
>
> Roy;
>
> Can you give more information about SAX?
>
> Who is support or full name of SAX?
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)

Roy Boxwell

capacity of table alert (AD)
(in response to bekir arslan)
Here‘s a newsletter I wrote a couple of years ago:
https://www.seg.de/size-db2-12-limit-maximum/

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]
http://www.seg.de
Link zur Datenschutzerklärung

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

> On 2 Aug 2019, at 15:26, bekir arslan <[login to unmask email]> wrote:
>
> Thanks to everyone,
>
> Roy;
>
> Can you give more information about SAX?
>
> Who is support or full name of SAX?
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)

Larry Jardine

capacity of table alert
(in response to bekir arslan)
I uploaded a more accurate version to the codeplace:
https://www.idug.org/p/do/sd/sid=12139&isnew=1&type=0


Larry Jardine
Database Advisor, Aetna, a CVS Health Company

[CVS]
CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments.



Proprietary
From: Sevetson, Phil <[login to unmask email]>
Sent: Friday, August 2, 2019 10:19 AM
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: capacity of table alert / (H/t Larry Jardine)

**** External Email - Use Caution ****
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 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_do_sd_sid-3D3185&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=ricPHa9xlxBpfZ4nJofrMkkGG37urDot644dgGQV0-4&e= ) -

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]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 8:51 AM
To: [login to unmask email]<mailto:[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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=MwKownszmX2IozDpnqeyhCHbvbZS1rDS8Db6v1UHDd0&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=FzQfGvSyNTW2umZrUlkNvZqpIvyXerr9ixyXpPYk6aY&e=

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.**
________________________________
Attachment Links: image001.png (3 k) https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D10386&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=wzZNk9kTH4mqLGS4S8fT0FKw-pbyPtFE1nVMVq0aQLU&e=
Site Links: View post online https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_st_-3Fpost-3D189792-26anc-3Dp189792-23p189792&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=QRzk6VqUQC2rZ-4NkZWq71kmdNzdh5T9lovHRiqWxtQ&e= View mailing list online https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_si_-3Ftopic-3D19&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=vwQDu7YqVezt_TrE83L5kmywcD3yrO6x7p7KWb97gwA&e= Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_us_to_&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=znIO_8GtYG7zit1alXaK6vcgJuKPp-ygU3FFtkSW_oE&e=

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ESAIGroup.com_idug&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=5d8ySHHqHE1zUdWdAZe2zAtn9YuJTCJFAgalnRuLezY&e=

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_cm_ld_fid-3D2&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=Vi15qdj9FJlLlYW5B_vQTk6pZkTWCDhgQMOdTAvSsaE&e=

________________________________

NOTICE TO RECIPIENT OF INFORMATION:
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.
This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information.
Thank you. Aetna
Attachments

  • image003.png (3.8k)

Philip Sevetson

capacity of table alert
(in response to Larry Jardine)
Larry,

Thanks very much. I'm working this into our DB2 Health Check, so the updated version will get exercise soon.

-phil (sevetson)


From: Jardine, Lawrence J <[login to unmask email]>
Sent: Tuesday, August 6, 2019 7:37 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: capacity of table alert

I uploaded a more accurate version to the codeplace:
https://www.idug.org/p/do/sd/sid=12139&isnew=1&type=0


Larry Jardine
Database Advisor, Aetna, a CVS Health Company

[CVS]
CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments.



Proprietary
From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 10:19 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: capacity of table alert / (H/t Larry Jardine)

**** External Email - Use Caution ****
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 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_do_sd_sid-3D3185&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=ricPHa9xlxBpfZ4nJofrMkkGG37urDot644dgGQV0-4&e= ) -

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]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 8:51 AM
To: [login to unmask email]<mailto:[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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=MwKownszmX2IozDpnqeyhCHbvbZS1rDS8Db6v1UHDd0&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=FzQfGvSyNTW2umZrUlkNvZqpIvyXerr9ixyXpPYk6aY&e=

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.**
-----End Original Message-----
NOTICE TO RECIPIENT OF INFORMATION:
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.
This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information.
Thank you. Aetna

-----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.**

Philip Sevetson

capacity of table alert
(in response to Philip Sevetson)
Larry - quick update. I found a partition which is likely to fill up within three weeks by this method. I confirmed it by separate work. Thanks very much - this is clearly well-written code.

-phil (sevetson)


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: Sevetson, Phil <[login to unmask email]>
Sent: Tuesday, August 6, 2019 9:16 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: capacity of table alert

Larry,

Thanks very much. I'm working this into our DB2 Health Check, so the updated version will get exercise soon.

-phil (sevetson)


From: Jardine, Lawrence J <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Tuesday, August 6, 2019 7:37 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: capacity of table alert

I uploaded a more accurate version to the codeplace:
https://www.idug.org/p/do/sd/sid=12139&isnew=1&type=0


Larry Jardine
Database Advisor, Aetna, a CVS Health Company

[CVS]
CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments.



Proprietary
From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 10:19 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: capacity of table alert / (H/t Larry Jardine)

**** External Email - Use Caution ****
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 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_do_sd_sid-3D3185&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=ricPHa9xlxBpfZ4nJofrMkkGG37urDot644dgGQV0-4&e= ) -

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]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 8:51 AM
To: [login to unmask email]<mailto:[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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=MwKownszmX2IozDpnqeyhCHbvbZS1rDS8Db6v1UHDd0&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=FzQfGvSyNTW2umZrUlkNvZqpIvyXerr9ixyXpPYk6aY&e=

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.**
-----End Original Message-----
NOTICE TO RECIPIENT OF INFORMATION:
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.
This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information.
Thank you. Aetna

-----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)

Larry Jardine

capacity of table alert
(in response to Philip Sevetson)
Awesome!

Larry Jardine
Database Advisor, Aetna, a CVS Health Company

[CVS]
CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments.



Proprietary
From: Sevetson, Phil <[login to unmask email]>
Sent: Wednesday, August 7, 2019 1:31 PM
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: capacity of table alert

**** External Email - Use Caution ****
Larry - quick update. I found a partition which is likely to fill up within three weeks by this method. I confirmed it by separate work. Thanks very much - this is clearly well-written code.

-phil (sevetson)


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: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Tuesday, August 6, 2019 9:16 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: capacity of table alert

Larry,

Thanks very much. I'm working this into our DB2 Health Check, so the updated version will get exercise soon.

-phil (sevetson)


From: Jardine, Lawrence J <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Tuesday, August 6, 2019 7:37 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: capacity of table alert

I uploaded a more accurate version to the codeplace:
https://www.idug.org/p/do/sd/sid=12139&isnew=1&type=0 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_do_sd_sid-3D12139-26isnew-3D1-26type-3D0&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=leMkE5FLebxN1a1v_xCWcmc_YEqHqGnou7uVeRPHhnM&e=


Larry Jardine
Database Advisor, Aetna, a CVS Health Company

[CVS]
CONFIDENTIALITY NOTICE: This communication and any attachments may contain confidential and/or privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify the sender immediately by email or telephone and destroy all copies of this communication and any attachments.



Proprietary
From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 10:19 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [EXTERNAL] [DB2-L] - RE: capacity of table alert / (H/t Larry Jardine)

**** External Email - Use Caution ****
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 https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_do_sd_sid-3D3185&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=ricPHa9xlxBpfZ4nJofrMkkGG37urDot644dgGQV0-4&e= ) -

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]<mailto:[login to unmask email]>>
Sent: Friday, August 2, 2019 8:51 AM
To: [login to unmask email]<mailto:[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 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=MwKownszmX2IozDpnqeyhCHbvbZS1rDS8Db6v1UHDd0&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=BmE8zfQvXPxs35wwcSnfzLHYOLDHqT1ED91JKTH0y24&s=FzQfGvSyNTW2umZrUlkNvZqpIvyXerr9ixyXpPYk6aY&e=

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.**
-----End Original Message-----
NOTICE TO RECIPIENT OF INFORMATION:
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.
This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information.
Thank you. Aetna

-----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.**
________________________________
Attachment Links: image001.png (3 k) https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_do_-3Fdownload-3D1-26fid-3D10397&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=paEpKFf8x4f606z-EMxDsMEIJeUC9us-y28qriA1N_Q&e=
Site Links: View post online https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_st_-3Fpost-3D189811-26anc-3Dp189811-23p189811&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=8TnKGNb_or_AIZGCy7QXlr9bbOvBzldXdBC83FobeQo&e= View mailing list online https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_fo_si_-3Ftopic-3D19&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=yVyHZm6rJI1y9xbVkwtE6XjmBgsWInlQXNZnSUxzvGY&e= Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.proofpoint.com/v2/url?u=https-3A__www.idug.org_p_us_to_&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=4aU7Goci5arS9oURpD-5zePWBE0f4MI4Ipe9qMExaCs&e=

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
http://www.ESAIGroup.com/idug https://urldefense.proofpoint.com/v2/url?u=http-3A__www.ESAIGroup.com_idug&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=sBIOpiX9TUGftOIxYdD6NEOQRB8n8GAyi53vHJwkMaM&e=

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.idug.org_p_cm_ld_fid-3D2&d=DwMFAw&c=wluqKIiwffOpZ6k5sqMWMBOn0vyYnlulRJmmvOXCFpM&r=wfE0VOZJYg9uIjc5BuTMYexNGrByDwh1giBA3sSm6qo&m=Q2ab3lhIg6FJqMSvD11cL-hdr59Ziii4cDZxTn6yxA4&s=WL2feRnhHO6MgC_VWhrQX6gFgut0f2BISmrllvVpcjw&e=

________________________________

NOTICE TO RECIPIENT OF INFORMATION:
This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately.
This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or pregnancy. This type of information may be protected by various federal and/or state laws which prohibit any further disclosure without the express written consent of the person to whom it pertains or as otherwise permitted by law. Any unauthorized further disclosure may be considered a violation of federal and/or state law. A general authorization for the release of medical or other information may NOT be sufficient consent for release of this type of information.
Thank you. Aetna
Attachments

  • image003.png (3.8k)

Bharath Nunepalli

RE: capacity of table alert
(in response to bekir arslan)

I use this query to get the details.

SELECT
SUBSTR(SPCRPT.DBNAME,1,8) AS DBNAME
,SUBSTR(SPCRPT.NAME,1,10) AS TSNAME
,CONCAT(SPCRPT.TYPE,' ') AS TYPE
,SUBSTR(CHAR(SPCRPT.PART),1,4) AS PARTITION
,SUBSTR(CHAR(SPCRPT.TROW),1,10) AS TOTALROWS
,SUBSTR(CHAR(SPCRPT.EXTENTS),1,4) AS EXTENTS
,SUBSTR(CHAR(SPCRPT.ALLOC_SPACE_INKB),1,10) AS ALLOC_SPC_INKB
,SUBSTR(CHAR(SPCRPT.MAX_SPACE_INKB),1,10) AS MAX_SPC_INKB
,SUBSTR(CHAR(SPCRPT.ALLOC_SPACE_INPAGES),1,10) AS ALLOC_SPC_INPAGES
,SUBSTR(CHAR(SPCRPT.MAX_SPACE_INKB/SPCRPT.PGSIZE),1,10)
AS MAX_SPC_INPAGES
,SUBSTR(CHAR(ROUND((SPCRPT.ALLOC_SPACE_INPAGES*100)/
((SPCRPT.MAX_SPACE_INKB/
(SPCRPT.PGSIZE-((SPCRPT.PGSIZE*SPCRPT.PCTFREE)/100)))
-SPCRPT.FREEPAGE),2)),1,4)
AS USED_PAGES_PERC
,SUBSTR(CHAR(SPCRPT.ALLOC_SPACE_INTRACKS),1,8) AS ALLOC_SPC_INTRKS
,SUBSTR(CHAR(SPCRPT.MAX_SPACE_INTRACKS),1,8) AS MAX_SPC_INTRKS
,SUBSTR(CHAR(ROUND((SPCRPT.ALLOC_SPACE_INTRACKS*100)
/MAX_SPACE_INTRACKS,2)),1,4) AS USED_TRKS_PERC
FROM(
SELECT
STATS.DBNAME
,STATS.NAME
,TS.TYPE
,CASE WHEN STATS.PARTITION IS NULL THEN -1
ELSE STATS.PARTITION
END AS PART
,CASE WHEN STATS.TOTALROWS IS NULL THEN -1
ELSE STATS.TOTALROWS
END AS TROW
,CASE WHEN STATS.EXTENTS IS NULL THEN -1
ELSE STATS.EXTENTS
END AS EXTENTS
,CASE WHEN STATS.SPACE IS NULL THEN -1
ELSE STATS.SPACE
END AS ALLOC_SPACE_INKB
,(STATS.SPACE/48) AS ALLOC_SPACE_INTRACKS
,CASE WHEN STATS.NACTIVE IS NULL THEN -1
ELSE STATS.NACTIVE
END AS ALLOC_SPACE_INPAGES
,TS.PGSIZE
,TP.FREEPAGE
,TP.PCTFREE
,(CASE
WHEN SUBSTR(TS.DSSIZE,1,1) IN (0,2,3,4,8) AND
TS.TYPE=' ' THEN CEILING((64*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,2)=16 AND
TS.TYPE=' ' THEN CEILING((64*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,1)=2 THEN CEILING((2*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,1)=3 THEN CEILING((32*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,1)=4 THEN CEILING((4*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,1)=6 THEN CEILING((64*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,1)=8 THEN CEILING((8*1024*1024)/48)
WHEN SUBSTR(TS.DSSIZE,1,2)=16 THEN CEILING((16*1024*1024)/48)
ELSE CEILING((4*1024*1024)/48)
END) AS MAX_SPACE_INTRACKS
,(CASE TS.DSSIZE
WHEN 0 THEN
CASE WHEN TS.TYPE = 'G' THEN 4194304
WHEN TS.TYPE = 'L' THEN 4194304
WHEN TS.TYPE = 'O' THEN 4194304
WHEN TS.TYPE = 'P' THEN 4194304
WHEN TS.TYPE = 'R' THEN 4194304
WHEN TS.TYPE = ' ' THEN 67108864
ELSE
CASE WHEN TS.PARTITIONS > 254 THEN
CASE WHEN TS.PGSIZE = 4 THEN 4194304
WHEN TS.PGSIZE = 8 THEN 8388608
WHEN TS.PGSIZE = 16 THEN 16777216
WHEN TS.PGSIZE = 32 THEN 33554432
ELSE NULL
END
WHEN TS.PARTITIONS > 64 THEN 4194304
WHEN TS.PARTITIONS > 32 THEN 1048576
WHEN TS.PARTITIONS > 16 THEN 2097152
WHEN TS.PARTITIONS > 0 THEN 4194304
ELSE 2097152
END
END
ELSE TS.DSSIZE
END) AS MAX_SPACE_INKB
FROM SYSIBM.SYSTABLESPACESTATS STATS
INNER JOIN
SYSIBM.SYSTABLESPACE TS
ON STATS.DBNAME = TS.DBNAME AND
STATS.DBID = TS.DBID AND
STATS.NAME = TS.NAME AND
STATS.PSID = TS.PSID
INNER JOIN
SYSIBM.SYSTABLEPART TP
ON STATS.DBNAME = TP.DBNAME AND
STATS.NAME = TP.TSNAME AND
STATS.PARTITION = TP.PARTITION
) AS SPCRPT
WHERE DECIMAL((SPCRPT.ALLOC_SPACE_INPAGES*100)/
((SPCRPT.MAX_SPACE_INKB/(SPCRPT.PGSIZE-((SPCRPT.PGSIZE*5)/100)))
-SPCRPT.FREEPAGE),4,2) > 80
AND SPCRPT.TYPE <> 'G'
ORDER BY 6,3
WITH UR;

 

Bharath Nunepalli,

Senior DB2 DBA.