![]() Data temperature values are maintained by the TVS allocator vproc.Īlthough a current snapshot of the heatmap report can help the users answer some of temperature related questions about their tables, heatmap data that has been captured over time will provide even greater value to administrators. If a cylinder stops being accessed then its temperature will start to drop, and over time it may fall to zero. The cylinder temperature decreases over time through the use of a mathematical model. ![]() ![]() The cylinder temperature increases as data access on that cylinder increases. Specifically, TVS monitors customer data block reads and writes, and full cylinder reads. TVS Metric Collection monitors how often data is accessed by the database on a per cylinder basis. See Appendix A for ‘How to check to see if TBBLC or TVS is enabled’. ![]() The system is enabled with Teradata Virtual Storage(TVS) – ONE_DIMENSIONAL with Metric Collection On The system is enabled with Temperature Based Block Level Compression (TBBLC) The data temperature collection requirements are described as follows: The users can run the heatmap function with or without TIM enabled on their system as long as the data temperature collection requirements are met. The heatmap table function requires Teradata 14.10 (or higher) and the system that must have data temperature collection enabled.
0 Comments
Leave a Reply. |