Archives of the TeradataForum

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

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

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