Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 14 Jun 2004 @ 18:52:05 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: How to find tables not backed up
 
From:   Dye Lisa

Pete,

If you use Netvault software, you could use the Netvault Catalog database "Catalog" table and the "DBC.RCEvent" table on Teradata:

     SELECT
      a.eventnum AS nv_evtnum
     ,b.eventnum AS rcevent_evtnum
     ,a.seqnum
     ,b.eventtype
     ,a.objlevel
     ,a.tvmkind
     ,a.tableprotection
     ,a.databasename
     ,a.tablename
     ,a.postype
     ,b.createdate
     ,b.createtime
     FROM
      Your_NETVAULT_CATALOG.CATALOG  a
     ,DBC.RCEvent                            b
     WHERE   a.tvmkind               = 'T'
       AND b.eventtype               = 'DUMP'
       AND   a.eventnum              = b.eventnum
       AND   a.databasename  = b.databasename
       AND   b.createdate    = date
     ORDER   BY a.databasename, a.tablename;

Unfortunately, I haven't been able to find much documentation regarding the Netvault Catalog database except that each time a backup is performed, a row is added to the Catalog table describing the location of each item included in that backup.


Cheers!

Lisa



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016