| VP-49071 |
TASM: Query Characteristics - Cannot select options in menus for query characteristic types. This impacts only Join Type and Memory Usage in Query Characteristics.
|
Export and reimport fixed ruleset:
- Export Ruleset from Workload Designer portlet (select Export menu option from menu).
- Edit exported XML file, changing values for query characteristic to correct bits.
- Search for name of rule to update and note ruleid.
- Search for criteriontype="JOIN" and ruleid identified above and modify integervalue field of Join Type values as follows:
integervalue=“1” for Join
integervalue=“2” for No Join
integervalue=“3” for Product Join
integervalue=“4" for No Product Join
integervalue=“5” for Unconstrained Product Join
integervalue=“6” for No Unconstrained Product Join
- Search for criteriontype="MEMORY" and ruleid identified above and modify integervalue field of Memory Usage values as follows:
integervalue=“1” for Increased
integervalue=“2” for Large
integervalue=“3” Very Large
- Save XML file.
- Import Rules from Workload Designer portlet (icon to left of + icon in Local panel title).
|
| VP-49081 |
TASM: Cannot honor classification criteria for object with name greater than 30 characters. |
Possible workarounds:
- Delete or rename function in Teradata to at most 30 characters (this allows you to configure throttles using the portlet), or
- Export and reimport fixed ruleset:
- Export Ruleset from Workload Designer portlet (Export menu option from menu).
- Edit xml file to change truncated_name to full_name_of_object and save.
- Import Rules from Workload Designer portlet (icon to left of + icon in Local panel title).
- [Optional] Activate ruleset from Workload Designer portlet.
|