Archives of the TeradataForum
Message Posted: Thu, 03 Aug 2006 @ 14:17:55 GMT
I am new at Teradata and looking for help in the form of a suggestion to an issues explained below.
Currently backup for our biggest table O_PSTEB_BAL takes 6 hours 15 minutes to complete (we are running "all amp backup"; therefore, backup for single table cannot run across multiple tape drives).
If we combine "cold data" and "hot data" into single table backup will run for 7 hours 30 minutes. Every consecutive month backup will take +/- 20 minutes more to complete due to table growth.
Currently we are running stats on "need to have basis" when performance problem occur. Requirement is that we run regular daily/weekly stats for all tables and at list for following columns:
primary index columns
partitioning key columns
all known columns used in joins
combinations of columns known to be frequently joined
any column which features in WHERE conditions
Running this type of stats for our big tables is very long process and cannot be scheduled to run regularly after mload.
Split our big tables into "hot tables" and multiple "cold tables" after Teradata upgrade is completed.
Backup for big tables will be spread across multiple tape drives and will complete in +/- 3 hours using 10 of 12 available tape drives.
Daily stats will run for "hot data" only and we will be able to schedule regular daily/weekly stats for all "hot tables".
Only backups of "hot tables" will be used for DRP and to restore/refresh future test/pre-prod system.
Any thoughts or suggestions ? Thanks in advance!!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|