Finding Last Backup Timestamp

[Ray]

Is there a simple way of selecting the last backup timestamp of a
database from a table? Something like

select last_backup_timestamp from tablename where
database_name='WHATEVER'

Or am I forced to check the backup history with

list history backup all for WHATEVER

Thanks.

[Ramachandran Subramanian]

br****@lsmp.com (Ray) wrote in message news:<f3**************************@posting.google. com>...

Is there a simple way of selecting the last backup timestamp of a
database from a table? Something like

select last_backup_timestamp from tablename where
database_name='WHATEVER'

Or am I forced to check the backup history with

list history backup all for WHATEVER

Thanks.

The only way as far I can tell is by doing a list history. It is not
like the mainframe where you can select from SYSIBM.SYSCOPY.

[PM \(pm3iinc-nospam\)]

Closest to your requirement would be solution no.3

1-
Prompt>db2 list history backup all for xxxx
....

2-
Prompt>db2 get snapshot for all on xxxx | findstr /i /C:"backup"
/C:"snapshot"
Database Snapshot
Last backup timestamp =

3- SNAPSHOT_DATABASE
db2 select SQLM_ELM_LAST_BACKUP from table(SNAPSHOT_DATABASE( cast( null as
VARCHAR(255)), cast(null as int))) as ref

PM

[Ray]

I was afraid the answer would be just that.

Thanks.
Ray

[PM \(pm3iinc-nospam\)]

Make it a view then...

PM

"Ray" <br****@lsmp.com> a écrit dans le message de
news:f3**************************@posting.google.c om...

I was afraid the answer would be just that.

Thanks.
Ray

[Tomas Hallin]

br****@lsmp.com (Ray) wrote in message news:<f3**************************@posting.google. com>...

I was afraid the answer would be just that.

Thanks.
Ray

You have your answer in PM's option 3... assuming you're DB2 V8.

/T

Tomas Hallin
Database Administration
Robert Half International
Pleasanton, CA

[Ray]

I am using V7

ja*****@hotmail.com (Tomas Hallin) wrote in message news:<2c*************************@posting.google.c om>...

br****@lsmp.com (Ray) wrote in message news:<f3**************************@posting.google. com>...

I was afraid the answer would be just that.

Thanks.
Ray

You have your answer in PM's option 3... assuming you're DB2 V8.

/T

Tomas Hallin
Database Administration
Robert Half International
Pleasanton, CA