Informix

Expand all | Collapse all

ontape, which sysmaster table(s) ?

  • 1.  ontape, which sysmaster table(s) ?

    Posted Thu February 25, 2021 09:22 AM
    Hi to All

    what are the sysmaster tables where we can find informations about "ontape" backups  ?

    thanks in advance



    ------------------------------
    John Smith
    ------------------------------


  • 2.  RE: ontape, which sysmaster table(s) ?

    Posted Thu February 25, 2021 12:37 PM
    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
    ------------------------------



  • 3.  RE: ontape, which sysmaster table(s) ?

    Posted Fri February 26, 2021 04:52 AM
    Thanks a lot :)

    ------------------------------
    John Smith
    ------------------------------