Workload Migration from Appliance-Licensed Systems - Teradata Database - Teradata Viewpoint

Workload Pre-Migration User Guide

Product
Teradata Database
Teradata Viewpoint
Published
January 2016
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
yfc1467307781404.ditamap
dita:ditavalPath
ft:empty
dita:id
scv1467244925615
Product Category
Analytical Ecosystem
Software

As part of upgrading to SLES 11, priority-scheduling settings for workloads are migrated from the SLES 10 system. Because workloads are not provided on SLES 10 appliance-licensed systems, you cannot use the Pre-Migration Tool to refine the otherwise automatic results of migrating priority-scheduling settings. Instead, when the TDWMDIP program is run as part of the process, the four SLES 10 performance groups are automatically converted to four SLES 11 timeshare workloads, placed in the single default virtual partition named Standard, and assigned access levels based on SLES 10 account string value (that is, Top, High, Medium, and Low).

Access level affects the resource volume provided to timeshare workload queries, known as query access rate , at a ratio of 2:1. Queries in a Top workload receive eight times the resource volume as queries in a Low workload, four times the resource volume as queries in a Medium workload, and two times the resource volume as queries in a High workload. The following table illustrates the SLES 11 timeshare workload names, access levels, and access rates that result from conversion of SLES 10 performance groups when upgrading or migrating from appliance-licensed systems.

SLES 10 Performance Group SLES 11 Timeshare Workload Access Level Access Rate
$R* T-WD Top 8
$H* H-WD High 4
$M* M-WD Medium 2
$L* L-WD Low 1
The following additional results occur automatically when the TDWMDIP program is run as part of the SLES 11 upgrade process.
  • The rule set that was active at the time of migration is automatically activated.
  • Query milestones are lost. However, you can achieve similar results following upgrade to SLES 11 by using the Workload Designer portlet in Teradata Viewpoint to enable the Decay option for timeshare workloads.
  • Two throttles to limit system concurrence are provided: GeneralQuery (with a limit of 52) and OneSecondQuery (with a limit of 30). You can use the Workload Designer portlet post upgrade to change or delete these throttles, as required.

After operating system upgrade, use the Workload Designer portlet in Teradata Viewpoint to review and adjust workload configurations as necessary.