 |
 |
Archives of the TeradataForum
Message Posted: Thu, 05 Dec 2002 @ 13:34:39 GMT
| Subj: | | Re: Why are _ET,_UV,_LOG created as Fallback? |
| |
| From: | | Adam DeYoung |
If you were to have a storage drive fail while your MLOAD was in progress and the error/log tables were non-Fallback, the MLOAD
could not complete successfully and your target table would be in an incomplete state until the failed drive was rebuilt and the
MLOAD completed. Because incomplete MLOADs leave you exposed to target table corruption and prevent other processes from writing to
that table, it is wise to do all you can to avoid this state.
With Fallback on both the log/error tables and the target table, the MLOAD keeps running with no issues when a drive fails.
Adam
| |
