LASTDATACHANGE in SYSIBM.SYSTABLESPACESTATS

Bharath Nunepalli

LASTDATACHANGE in SYSIBM.SYSTABLESPACESTATS

Hi All,

I did a Recovery for a Tablespace to a old date and data got modified. But, LASTDATACHANGE column did not change for that.
LASTDATACHANGE column changed only when I did LOAD REPLACE on the Tablespace.

 

IBM Knowledge center is saying that LASTDATACHANGE is the last time that this row was updated because data was modified in the table space or partition. But, does not say what kind of data modify activity updates the column.

 

I want to make sure I understood the column correctly.
Can someone please clarify that?

 

Thanks,

Bharath Nunepalli

alain pary

RE: LASTDATACHANGE in SYSIBM.SYSTABLESPACESTATS
(in response to Bharath Nunepalli)

Hello, 

the purpose of recovery is to restore data in the tablespace. The utility doesn't restore all the satelitte data . 

This kind of data is not present in the backup.

regards 

Alain