Performance issue

JITINDER CHOUDHARY

Performance issue

One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months. 

Could you please let me know how check how much tablespace/table grew in last two months.

Thanks in advance!!!

Roy Boxwell

Performance issue
(in response to JITINDER CHOUDHARY)
If you have an RTS History table it could help you

If you run RUNSTATS with HISTORY SPACE or ALL then the relevant _HIST tables could help you

If you have volume level dumps then you could even look at them!



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


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



From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: Wednesday, December 12, 2018 12:58 PM
To: [login to unmask email]
Subject: [DB2-L] - Performance issue



One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months.

Could you please let me know how check how much tablespace/table grew in last two months.

Thanks in advance!!!



-----End Original Message-----

Attachments

  • smime.p7s (5.1k)

D. R.

RE: Performance issue
(in response to JITINDER CHOUDHARY)

There is a 'CREATEDTS' column in SYSIBM.SYSTABLEPART indicating when partition yy was created. Could be useful as you also know on what size TS will create another partition.

Phil Grainger

Performance issue
(in response to Roy Boxwell)
Or you could use your favourite Log Analysis tool to see how many rows were inserted into the table over periods of time
________________________________

Phil Grainger

Principal Enablement Manager

[login to unmask email]

Direct



+44 (0)118 921 8000

Mobile



+44(0)7808 643 479


E2, Eskdale Road
Winnersh
Berkshire
RG41 5TS


[http://media.cms.bmc.com/images/corp_signature_bmclogo_2014.jpg] http://www.bmc.com

[https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]





From: Boxwell, Roy [mailto:[login to unmask email]
Sent: 12 December 2018 12:52
To: [login to unmask email]
Subject: [DB2-L] - RE: Performance issue

If you have an RTS History table it could help you
If you run RUNSTATS with HISTORY SPACE or ALL then the relevant _HIST tables could help you
If you have volume level dumps then you could even look at them!

Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
Web http://www.seg.de https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=WUNY1fHoRuhcXVOIIwyjfK82V9cbz42uX14bUvzdav4&s=L7R78QISA9wbW9VVZ63EkhWUcMwS9BpRsxf9_YEB76s&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=WUNY1fHoRuhcXVOIIwyjfK82V9cbz42uX14bUvzdav4&s=zDH5T50HBxP8VL3etH1GiAqGwv_iqDzXrMrqPJr2iKM&e=

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

From: JITINDER CHOUDHARY [mailto:[login to unmask email]
Sent: Wednesday, December 12, 2018 12:58 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - Performance issue


One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months.

Could you please let me know how check how much tablespace/table grew in last two months.

Thanks in advance!!!

-----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 (8k)
  • image002.png (9.3k)

Chris Hoelscher

Performance issue
(in response to JITINDER CHOUDHARY)
Or – if you have periodic IC, unload from earlier IC and count the rows?

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: JITINDER CHOUDHARY <[login to unmask email]>
Sent: Wednesday, December 12, 2018 6:58 AM
To: [login to unmask email]
Subject: [DB2-L] - Performance issue


One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months.

Could you please let me know how check how much tablespace/table grew in last two months.

Thanks in advance!!!

-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

steen rasmussen

Performance issue
(in response to Chris Hoelscher)
If you were on Db2 12 you could have exploited the new feature where the RTS tables can be enabled to System Time Temporal tables and you would have all the history rows from when the RTS metrics were externalized.
Steen Rasmussen 
On Wednesday, December 12, 2018, 9:18:07 AM EST, Chris Hoelscher <[login to unmask email]> wrote:

#yiv8238792250 #yiv8238792250 -- _filtered #yiv8238792250 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8238792250 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv8238792250 {font-family:Sans;panose-1:3 15 7 2 3 3 2 2 2 4;}#yiv8238792250 #yiv8238792250 p.yiv8238792250MsoNormal, #yiv8238792250 li.yiv8238792250MsoNormal, #yiv8238792250 div.yiv8238792250MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv8238792250 a:link, #yiv8238792250 span.yiv8238792250MsoHyperlink {color:blue;text-decoration:underline;}#yiv8238792250 a:visited, #yiv8238792250 span.yiv8238792250MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv8238792250 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv8238792250 p.yiv8238792250msonormal0, #yiv8238792250 li.yiv8238792250msonormal0, #yiv8238792250 div.yiv8238792250msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv8238792250 span.yiv8238792250EmailStyle19 {font-family:sans-serif;color:#1F497D;}#yiv8238792250 .yiv8238792250MsoChpDefault {font-family:sans-serif;} _filtered #yiv8238792250 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv8238792250 div.yiv8238792250WordSection1 {}#yiv8238792250
Or – if you have periodic IC, unload from earlier IC and count the rows?

 

Chris Hoelscher

Technology Architect, Database Infrastructure Services

Technology Solution Services

Humana Inc.

123 East Main Street

Louisville, KY 40202

Humana.com

(502) 476-2538 or 407-7266

 

From: JITINDER CHOUDHARY <[login to unmask email]>
Sent: Wednesday, December 12, 2018 6:58 AM
To: [login to unmask email]
Subject: [DB2-L] - Performance issue

 

One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months. 

Could you please let me know how check how much tablespace/table grew in last two months.

Thanks in advance!!!

 
-----End Original Message-----
The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

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]
ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
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

Anguraj Rathinasamy

Performance issue
(in response to Roy Boxwell)
Hi Jitinder,
RTS History or in-house utility to collect space stats for db2 datasets or most straightforward way, analysis the table data such as audit columns (insert date)

Regards,
Raj


> On Dec 12, 2018, at 7:51 AM, Boxwell, Roy <[login to unmask email]> wrote:
>
> If you have an RTS History table it could help you
> If you run RUNSTATS with HISTORY SPACE or ALL then the relevant _HIST tables could help you
> If you have volume level dumps then you could even look at them!
>
> Roy Boxwell
>
> SOFTWARE ENGINEERING GmbH and SEGUS Inc.
> -Product Development-
>
> Heinrichstrasse 83-85
> 40239 Duesseldorf/Germany
> Tel. +49 (0)211 96149-675
> Fax +49 (0)211 96149-32
> Email: [login to unmask email]
> Web http://www.seg.de
> Link zur Datenschutzerklärung
>
> Software Engineering GmbH
> Amtsgericht Düsseldorf, HRB 37894
> Geschäftsführung: Gerhard Schubert, Ulf Heinrich
>
>
> From: JITINDER CHOUDHARY [mailto:[login to unmask email]
> Sent: Wednesday, December 12, 2018 12:58 PM
> To: [login to unmask email]
> Subject: [DB2-L] - Performance issue
>
> One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months.
>
> Could you please let me know how check how much tablespace/table grew in last two months.
>
> Thanks in advance!!!
>
>
> 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]
> ESAi has well-regarded tools for Fast Cloning, Buffer Pool Tuning, Log Analysis, TDM & more.
> BCV4, BCV5, BPA4DB2, ULT4DB2... modern power tools to get the job done faster & easier than ever.
> 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
>

Michael Hannan

RE: Performance issue
(in response to JITINDER CHOUDHARY)



In Reply to JITINDER CHOUDHARY:

One of our partition by growth tablespace reach to its max space allocated. I need to check how much it grew in last two months. 

Could you please let me know how check how much tablespace/table grew in last two months.

Thanks in advance!!!

What I use as an indicator of growth is REORGINSERTS (and REORGDELETES) and REORGLASTTIME in SYSTABLESPACESTATS. This is not growth for 2 months, depends when last reorg occurred. I just mention in case is good enough, although NOT meeting your requirement precisely. Not very useful if Reorg was last night.

Partitioned by Growth is intended to prevent running out of space, so MAX Partitions could have been set too small or DSSIZE too small. Not sure of main reason why partitioned by growth should reach a max space allocated. No need to be overly conservative with Partitioned by Growth spaces that potentially could grow large.

Michael Hannan,

DB2 Application Performance Specialist
CPT Global Ltd

Edited By:
Michael Hannan[Organization Members] @ Dec 13, 2018 - 01:33 AM (Europe/Berlin)

James Campbell

Performance issue
(in response to Chris Hoelscher)
If the growth was creating aditional partitions, you could look at the creation date of the
partitions' clusters.

James Campbell

> From: JITINDER CHOUDHARY <[login to unmask email]>
> Sent: Wednesday, December 12, 2018 6:58 AM
> To: [login to unmask email]
> Subject: [DB2-L] - Performance issue
>  
> One of our partition by growth tablespace reach to its max space allocated. I need
> to check how much it grew in last two months. 
> Could you please let me know how check how much tablespace/table grew in last
> two months.
> Thanks in advance!!!
>