Table of Contents


  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 dps Command Reference
  16. infacmd edl Command Reference
  17. Infacmd es Command Reference
  18. infacmd ihs Command Reference
  19. infacmd ipc Command Reference
  20. infacmd isp Command Reference
  21. infacmd ldm Command Reference
  22. infacmd mas Command Reference
  23. infacmd mi Command Reference
  24. infacmd mrs Command Reference
  25. infacmd ms Command Reference
  26. infacmd oie Command Reference
  27. infacmd ps Command Reference
  28. infacmd pwx Command Reference
  29. infacmd rms Command Reference
  30. infacmd rtm Command Reference
  31. infacmd sch Command Reference
  32. infacmd search Command Reference
  33. infacmd sql Command Reference
  34. infacmd tdm Command Reference
  35. infacmd wfs Command Reference
  36. infacmd ws Command Reference
  37. infacmd xrf Command Reference
  38. infacmd Control Files
  39. infasetup Command Reference
  40. pmcmd Command Reference
  41. pmrep Command Reference
  42. Working with pmrep Files



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
MassUpdate options and arguments:
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
Required. Name of the attribute or property to update.
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.
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.
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
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.
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.
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.
Required if you use a condition operator. Part of the condition. The condition appears as follows:
<session_property_value> <condition operator> <condition_value>
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.
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.
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.


We’d like to hear from you!