Hi,

How can I list the backup and log files using some system views in db2 v8.1 (something equivalent to SYSIBMADM.DB_HISTORY available in v9)?

thanks.

Check the LIST HISTORY command.

for sure.... but I must access the information via SQL (views or tables) not db2 cli

select * from table (admin_list_hist()) as x

You can customize it as you need it. Here is the documentation:

http://publib.boulder.ibm.com/infoce...n/r0012548.htm

Andy

Thanks Andy, that was exactly what I was searchiing for.

(Sorry, for my newby question, but I'm new on db2 (coming from oracle world) and I 'm still searching for a good way to find the good ref guide ...does not seem to be as easy as Oracle... or I'm too colored by Oracle maybe )