ontape, which sysmaster table(s) ?

Hi to All what are the sysmaster tables where we can find informations about "ontape" backups ? thanks in advance ------------------------------ John Smith ------------------------------ #Informix

database sysmaster; select dbsnum, level0, DBINFO('utc_to_datetime',level0) from sysdbstab That will give you the info for the last level 0 archive for each dbspace ... which is the best you can do (I think) as regards ontape (as opposed to onbar) ------------------------------Jon Ritson ------------------------------

Thanks a lot :) ------------------------------ John Smith ------------------------------