I'm curious about the list history command only I want the information in the last week. I've been looking in the command reference and they only use a hardcoded date. Does anyone know how to get it to work with the current date minus # days?


db2 list history backup since 20080101 for database

thanks for any help!

I don't know. But you could use the "date" utility to calculate the date 1 week ago and to format it according to the needs of LIST HISTORY.

there is a function that allows you to selct data from history file with sql
SELECT * FROM TABLE(DB_HISTORY()) AS LIST_HISTORY
in that case you can add where predicate and select data with days/date.. functions

Thanks, I used the db-history table like this:

connect to rmdb5a user db2inst1 using ****;
Select substr(comment,1,20), end_time
from sysibmadm.DB_history
Where comment like 'DB2 BACKUP%'
Order by end_time desc
FETCH FIRST 3 ROWS ONLY;
connect reset;

we never know until it's too late that our servers are down. I needed something to let me know if things were working and I also can quickly check out the backups.