Archives of the TeradataForum

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

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

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