Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 31 Jan 2008 @ 15:35:50 GMT

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

Subj:   Re: Any idea how to backup the accesslog table
From:   Prescott, Kyle R

The access log table, event log table, resource usage tables, dbql tables, etc. are deemed non-critical to recover the system catalog (DBC) so thus are skipped during a DBC archive.

You will need to refer to the archive & recovery manual for comprehensive list of objects that are in scope for a dbc backup.

The access logs, DBQL, event logs, and resusage tables can all be copied to a separately managed database. They can further be altered to improve performance (i.e. remove fallback protection since they are non-critical outside of DBC saving 50% space, add multi-value column compression, changing from UNICODE to LATIN where applicable, adding PPI, etc.).

You will find that you can keep much more history, have much better performance for queries, and full backup/recovery capability in a more managed form.

Kyle Prescott | Database Administrator | Unum-IODS

  <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: 28 Jun 2020