Informix

 View Only
  • 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
    ------------------------------

    #Informix


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