All Forums Database 4 posts Joined 02/16
28 Feb 2016
unknown data in table

We found some curious cases in TD 14.10. The DB has 3 active nodes and 1 HSN. DBA switched one active node and HSN in Feb, after swithced:
1. In view point, it shows one node down. but the query and ETL job can, should be not actually down. If it's issue of view point?
2. After several days laer, the daily loading table size ( refer to dbc.tablesize ) is larger day by day, e.g., day is 6G, day 2 is 7 G..., but we ensure the real data size is almost the same in these days. This just happened in some table and some AMPs. Then encountered a DB auto restart later, DBA perform all table scan, then the size become normal again. Why this happened?
3. We checked log file in /var/log/sa, found the number of packets per second reduced by 80%. If the switching will change packet size?

Adeel Chaudhry 773 posts Joined 04/08
06 Mar 2016

Have you contacted Teradata CS? If no, you should. If yes, they must have an answer to why it happened.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.