History info from SYSTABLESPACESTATS

Bharath Nunepalli

History info from SYSTABLESPACESTATS

Hi All,

I read about availability of system time temporal for RTS in Db2 v12. Is this available in Db2 v11 as well (through some PTF)?

My requirement is to store details from SYSTABLESPACESTATS for at least a month (we want to use these details for row count verification).
Can anyone please share their experiences if they have done such thing already?


Thanks.

Steen Rasmussen

History info from SYSTABLESPACESTATS
(in response to Bharath Nunepalli)
The System Time Temporal design for the RTS tables is Db2 12 only and not Db2 11.

But, I know a lot of Db2’ers do save RTS information in their own tables – some on a daily basis some prior to a reorg and some on a weekly basis (I am sure there are many more variations).

Steen

From: Bharath Nunepalli [mailto:[login to unmask email]
Sent: Wednesday, June 06, 2018 10:26 AM
To: [login to unmask email]
Subject: [DB2-L] - History info from SYSTABLESPACESTATS

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi All,

I read about availability of system time temporal for RTS in Db2 v12. Is this available in Db2 v11 as well (through some PTF)?

My requirement is to store details from SYSTABLESPACESTATS for at least a month (we want to use these details for row count verification).
Can anyone please share their experiences if they have done such thing already?

Thanks.

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

Bharath Nunepalli

RE: History info from SYSTABLESPACESTATS
(in response to Steen Rasmussen)

Steen,
Thanks for the response.

Actually, it's in one of your presentations I read about system temporal support for RTS :)

 

I remember seeing CREATE TABLE statement for RTS history table in Db2 v11.

Unable to recall where I saw that. Do you have any idea about that?

 

Bharath Nunepalli,

Senior DB2 DBA.

Steen Rasmussen

History info from SYSTABLESPACESTATS
(in response to Bharath Nunepalli)
Glad to see my IDUG presentation was useful – mission accomplished.

I don’t recall I have seen anything in Db2 11, and looking at one of my Db2 11 systems current on maintenance I don’t see anything related to the RTS tables having history tables.

Steen

From: Bharath Nunepalli [mailto:[login to unmask email]
Sent: Wednesday, June 06, 2018 11:01 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: History info from SYSTABLESPACESTATS

CAUTION: This email originated from outside of CA. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Steen,
Thanks for the response.

Actually, it's in one of your presentations I read about system temporal support for RTS :)



I remember seeing CREATE TABLE statement for RTS history table in Db2 v11.

Unable to recall where I saw that. Do you have any idea about that?



Bharath Nunepalli,

Senior DB2 DBA.

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