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
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.
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
Can anyone please share their experiences if they have done such
-----End Original Message-----