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
------------------------------
Original Message:
Sent: Thu February 25, 2021 09:21 AM
From: John Smith
Subject: 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