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
------------------------------

Original Message:
Sent: Thu February 25, 2021 12:37 PM
From: Jon Ritson
Subject: ontape, which sysmaster table(s) ?

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
------------------------------