This section applies only to migrations from following releases: 13.10; 14.0 lower than 14.0.4.1; and 14.10 lower than 14.10.1.1.
On supported Teradata platforms, the Workload Management Pre-migration Tool (known as the Pre-Migration Tool) enables DBAs to refine the otherwise automatic results of converting workloads when migrating form SLES10 SP3 to SLES11. Used prior to migration, the tool writes output directives to a table called tdwm.premigrate. At upgrade time, TDWMDIP, a utility within the post_data_restore script, migrates SLES10 SP3 TDWM rule sets into SLES11 rule sets based on the directives in the tdwm.premigrate table, if any.
Not setting or incorrectly setting workload management values prior to migration may result in performance problems.
The Pre-Migration Tool allows you to select which rule sets you want to migrate. In this case, other rule sets are not converted and are not migrated to SLES 11. If you do not use the tool, TDWMDIP migrates all rule sets. To speed workload migration, delete rule sets that you have not used and do not intend to use in the future before using the tool and upgrading to SLES 11.
If you have in-depth understanding of Priority Definition (PD) set configuration and want to use the Pre-Migration Tool when migrating from a Priority Scheduling Facility (PSF) system, you must first do the following while still running Teradata Database 13.0 or earlier:
- Use Priority Scheduler Administrator (PSA) to capture schmon settings in PD sets. For more information, see Utilities, B035-1102.
- Use Teradata Workload Analzyer (TWA) to convert PD sets to rule sets. For more information, see Teradata Workload Analyzer User Guide, B035-2514.
The Pre-Migration Tool provides direct access to PSA and TWA.
For further details on workload migration when upgrading from SLES10 SP3 to SLES11, see the Workload Pre-Migration User Guide .