Workload Migration from TASM-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. When upgrading from a TASM-licensed SLES 10 system, you can use the Pre-Migration Tool to refine the otherwise automatic results of the migrating workload priority-scheduling settings. Use the tool before running the TDWMDIP program as part of the transition process to increase the likelihood of emulating existing priority-scheduling behavior upon upgrade to SLES 11. Regardless of whether you use the tool, use the Workload Designer portlet in Teradata Viewpoint post upgrade to review and adjust workload-management settings as necessary.

Default Results of Workload Migration from TASM-Licensed Systems

When used alone, the TDWMDIP program yields the following results related to workload migration, which are otherwise subject to modification by using the Pre-Migration Tool.
  • All SLES 10 rule sets and workloads are migrated.
    This result is subject to modification by using the tool only with the following Teradata Database versions: 13.10; 14.0 earlier than 14.0.4.1; and 14.10 earlier than 14.10.1.1. When you use the tool to select rule sets for migration from any of these database versions, only those rule sets and their corresponding workloads are migrated. For all other Teradata Database versions that support using the tool, all SLES 10 rule sets are migrated regardless of selection.
  • All SLES 10 workloads associated with allocation groups that are assigned the Tactical enforcement priority and are configured to use single or few AMPs are converted to SLES 11 tactical workloads, which automatically designates them for expedited processing.
  • All SLES 10 workloads associated with allocation groups that are assigned the Tactical enforcement priority and are configured to use all AMPs or that have no AMP designation set as part of their classification criteria are converted based on SLES 11 licensing:
    SLES 11 Licensing Conversion Method
    TASM Assigned to SLG tier 1 and allocated 5% of tier resources.
    SLG tiers are available only with TASM licensing.
    IWM Converted to timeshare workloads and assigned the Top access level. For information on the effect of access level on resource provision, see the following bullet.
  • All other SLES 10 workloads are converted to SLES 11 timeshare workloads and assigned access levels based the relative weight of the corresponding SLES 10 allocation groups, as shown in the following table.
    SLES 10 Allocation Group Relative Weight SLES 11 Access Level
    > 10% Top
    > 5% to 10% High
    > 2% to 5% Medium
    0 to 2% 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 TDWMDIP program yields the following additional results related to workload migration, which are not subject to modification by using the Pre-Migration Tool.
  • All workloads are placed in the single, default Standard virtual partition.
  • The rule set that was active at the time of migration is automatically activated.

Pre-Migration Workload Configuration Options for TASM-to-IWM Upgrades

If when using the Pre-Migration Tool, you indicate that the SLES 11 system is not licensed for TASM, you can use the tool to perform the following workload-configuration activities, which are authorized with IWM licensing.
  • Reclassify automatically designated tactical workloads as timeshare workloads, if they are not reserved for highly critical queries with response-time requirements of 1 second or less, and, therefore, should not be expedited.
  • Reclassify automatically designated timeshare workloads as tactical workloads, if they are reserved for highly critical queries with response-time requirements of 1 second or less, and, therefore, should be expedited.
  • Adjust access levels for timeshare workloads to meet priority-scheduling goals.
Workload rules supported with TASM licensing on SLES 10 but not supported with IWM licensing on SLES 11 have no impact after upgrade. The rules remain in the TDWM database but are not visible in the Teradata Viewpoint Workload Designer portlet.

Pre-Migration Workload Configuration Options for TASM-to-TASM Upgrades

If when using the Pre-Migration Tool, you indicate that the SLES 11 system is licensed for TASM, you can perform all the IWM-specific activities as well as the following activities, which are authorized only with TASM licensing.
  • Reclassify automatically designated SLG workloads to other tiers.

    The SLG tier should be reserved for workloads that are of secondary importance to tactical workloads but are associated with a short service level goal or service level expectation; require a short response time due to business importance; and do not generally consume a significant amount of CPU resources. If any workloads automatically assigned to the SLG tier do not meet this criteria, use the Pre-Migration Tool to reclassify them as tactical or timeshare workloads, as appropriate.

  • Reassign automatically designated tactical or timeshare workloads that meet the criteria for SLG workloads to SLG tier 1.

    If any automatically designated tactical workloads are not reserved for highly critical queries with response-time requirements of 1 second or less but do meet the criteria for SLG tier assignment, use the Pre-Migration Tool to reclassify them as SLG workloads. Likewise, if any automatically designated timeshare workloads meet the criteria for SLG tier assignment, use the tool to reclassify them accordingly.

  • Change allocation percentages for SLG workloads.

    Without pre-migration intervention, each workload assigned to the SLG tier is by default allocated 5% of tier resources. Use the Pre-Migration Tool to change these values as necessary.

    After upgrading to SLES 11 and monitoring the outcome of your original settings, you can adjust SLG workload allocation percentages using the Workload Designer portlet in Teradata Viewpoint.