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
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 184.108.40.206; and 14.10 earlier than 220.127.116.11. 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.
- 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
- 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.
Pre-Migration Workload Configuration Options for TASM-to-TASM Upgrades
- 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.