Table of Contents

Search

  1. Preface
  2. Command Line Programs and Utilities
  3. Installing and Configuring Command Line Utilities
  4. Using the Command Line Programs
  5. Environment Variables for Command Line Programs
  6. Using infacmd
  7. infacmd as Command Reference
  8. infacmd aud Command Reference
  9. infacmd autotune Command Reference
  10. Infacmd bg Command Reference
  11. infacmd ccps Command Reference
  12. infacmd cluster Command Reference
  13. infacmd cms Command Reference
  14. infacmd dis Command Reference
  15. Infacmd dis Queries
  16. infacmd dp Command Reference
  17. infacmd idp Command Reference
  18. infacmd edp Command Reference
  19. Infacmd es Command Reference
  20. infacmd ics Command Reference
  21. infacmd ipc Command Reference
  22. infacmd isp Command Reference
  23. infacmd ldm Command Reference
  24. infacmd mas Command Reference
  25. infacmd mi Command Reference
  26. infacmd mrs Command Reference
  27. infacmd ms Command Reference
  28. infacmd oie Command Reference
  29. infacmd ps Command Reference
  30. infacmd pwx Command Reference
  31. infacmd roh Command Reference
  32. infacmd rms Command Reference
  33. infacmd rtm Command Reference
  34. infacmd sch Command Reference
  35. infacmd search Command Reference
  36. infacmd sql Command Reference
  37. infacmd tdm Command Reference
  38. infacmd tools Command Reference
  39. infacmd wfs Command Reference
  40. infacmd ws Command Reference
  41. infacmd xrf Command Reference
  42. infacmd Control Files
  43. infasetup Command Reference
  44. pmcmd Command Reference
  45. pmrep Command Reference
  46. Working with filemanager
  47. Working with pmrep Files

MassUpdate

MassUpdate

Updates session properties for a set of sessions that meet specified conditions. You can update all sessions in a folder or a list of sessions. To update a list of sessions, create a persistent input file. The list can contain a specific list of sessions, or it can contain conditions such as a name pattern or a property value. Use ExecuteQuery to generate a persistent input file.
When you run MassUpdate, you can view information such as the folder name, the number of sessions that are successfully updated or failed, and the names of the sessions that are updated. You can view the status of the update in the command line window or in a log file that the command generates. You specify the name and path for the log file when you run the command. By default, the log file is stored in the directory where you run the command.
Use MassUpdate to update a session property across multiple sessions when a PowerCenter version changes a default value.
You cannot update dependent session properties.
Before you update the sessions, you can also run MassUpdate in a test mode to view changes. To view a sample log file, see Sample Log File.
The MassUpdate command uses the following syntax:
pmrep massupdate -t <session_property_type (session_property, session_config_property, transformation_instance_attribute, session_instance_runtime_option)> -n <session_property_name> -v <session_property_value> [-w <transformation_type>] {-i <persistent_input_file> | -f <folder_name> } [-o <condition_operator (equal, unequal, less, greater)>] [-l <condition_value>] [-g <update_session_instance_flag>] [-m <test_mode>] [-u <output_log_file_name>]
The following table describes
pmrep
MassUpdate options and arguments:
Option
Argument
Description
-t
session_property_type
Required. Session property type to update. Session properties are of the following types:
  • session_property
  • session_config_property
  • transformation_instance_attribute
  • session_instance_runtime_option
-n
session_property_name
Required. Name of the attribute or property to update.
-v
session_property_value
Required. Value that you want to assign to the property followed by a semicolon.
For example, to assign a value to the property, use the following syntax:
-v "IgnoreNULLInExpressionComparison=Yes;"
Enclose the session property value in double quotes.
-w
transformation_type
Required if you update a transformation instance attribute. Transformation type to update. You can update the following transformation types: aggregator, joiner, lookup procedure, rank, sorter, source definition, and target definition.
-i
persistent_input_file
Required if you do not use the -f option. Name of the file that contains the selected list of sessions to update. You can use the
pmrep
ExecuteQuery command to run a query and generate this file. MassUpdate returns an error if you specify an object that is not a session. You must use the -i option or the -f option, but not both.
-f
folder_name
Required if you do not use the -i option. Name of the folder. Use to update all sessions in a folder. You must use the -i option or the -f option, but not both.
-o
condition_operator
Required if you use condition_value. Part of the condition that defines the session set.
The attribute of a session or session instance is updated when the condition is met.
You can use the following condition operators to update a string: equal or unequal.
You can use the following condition operators to update an integer: equal, unequal, less, or greater.
-l
condition_value
Required if you use a condition operator. Part of the condition. The condition appears as follows:
<session_property_value> <condition operator> <condition_value>
-g
update_session_instance_flag
Required if you update a session instance run-time option.
Optional for the following session property types: session property, session configuration attribute, and transformation instance attribute.
Updates session instances.
You can update an attribute in a session instance if the session instance overrides the attribute.
-m
test_mode
Optional. Runs MassUpdate in test mode. View sessions that will be impacted by the command before you commit changes. You can see the following details in the command line window:
  • Session name
  • Type of session: reusable or non-reusable
  • Current value of the session property
  • Sessions for which the attribute has the same value and are not affected by the command.
-u
output_log_file_name
Optional. Name of the log file that stores the status of the update and basic information about the sessions or session instances. Previous attribute values are also written to this file. If you do not use this option, the details appear in the command line window.
The MassUpdate command returns “massupdate successfully completed” or returns “failed to execute massupdate” message. The update might fail for the following reasons:
  • You did not specify a valid attribute value pertaining to the attribute name.
  • You specified the correct session property name and the wrong session property type along with it.
  • You did not specify the -v option that ends with a semicolon while updating a session property value.
  • You did not specify the -w option while updating a transformation instance attribute.
  • You did not specify the -g option while updating a session instance run-time option.
  • You do not have the Repository Services Administrator role.

0 COMMENTS

We’d like to hear from you!