Powermart PMREP Commands

The entire in this section describe changes to pmrep.

Command	Description	Comments
AssignPermission	Assigns permissions on a global object.	New command.
ChangeOwner	Changes the owner name for a global object.	New command.
RollbackDeployment	Rolls back a deployment to purge a deployed version from the target repository or folder.	New command.

Changed PMREP Commands
Command	Description	Comments
Connect	Connects to a repository.	-s option added to specify the security domain that the user belongs to.
Create	Creates the repository tables in the database.	-s option added to specify the security domain that the user belongs to.
CreateFolder	Creates a new folder in the repository.	-o option added to specify the security domain that the owner belongs to.
DeleteObject	Deletes an object.	You can specify “User Defined Function” as object type.
DeployDeploymentGroup	Deploys a deployment group.	-s option added to specify the security domain that the user belongs to.
DeployFolder	Deploys a folder.	-s option added to specify the security domain that the user belongs to.
ListObjects	Returns a list of objects in the repository.	You can specify “User Defined Function” as object type.
ModifyFolder	Modifies folder properties.	You can assign an operating system profile to a folder. -a option added to specify the security domain that the owner belongs to.
Register	Registers a local repository with a connected global repository.	-s option added to specify the security domain that the user belongs to.
Restore	Restores a repository backup file to a database.	The following option is added: -s. The security domain that the user belongs to. The following options are removed: - v. User name of the repository administrator or  another valid user defined in the external directory service. - x. Password for the user name as defined in the external directory service.   - X. Password environment variable that stores the password of the repository administrator as defined in the     external directory service. - w. Removes user-name-login mapping.
Unregister	Unregisters a local repository from a connected global repository.	-s option added to specify the security domain that the user belongs to.

Ported pmrep Commands
Command	INFACMD Replacement Command	Description
AddPrivilege	AddGroupPrivilege AddUserPrivilege	Adds a privilege to a user or a group.
AddUserToGroup	AddUserToGroup	Adds a user to a group.
ChangePasswd	ResetPassword	Changes the password of the user currently connected to the repository.
CreateGroup	CreateGroup	Creates a group.
CreateUser	CreateUser	Creates a user.
EditUser	EditUser	Edits the profile of a user.
ListAllGroups	ListAllGroups	Lists all groups registered with the repository.
LsPrivileges	ListGroupPrivileges ListRolePrivileges ListUserPrivileges	Lists the privileges granted to a user or group.
ListAllPrivileges	ListServicePrivileges	Lists all privileges that you can assign to a user or group.
ListAllUsers	ListAllUsers	Lists all users registered with the repository.
RmGroup	RemoveGroup	Removes a group from the repository.
RmPrivilege	RemoveGroupPrivilege RemoveUserPrivilege	Removes a privilege from a user or a group.
RmUser	RemoveUser	Removes a user from the repository.

New PMREP Commands
Command	Description	Comments
DeleteObject	Deletes an object.	New command.
GetConnectionDetails	Displays connection properties and attributes as name-value pairs.	New command.
ListConnections	Lists all connection objects and their respective types.	New command.
PurgeVersion	Removes older or all versions of objects from the repository.	New command. Use the -d option to purge versions of deleted objects. Use -n, -t, or both to purge specified versions of active objects.

Changed pmrep Commands
Command	Description
ListAllUsers	Lists all user names registered with the repository.	You can use the -g option to display the user name followed by all the group names associated with the user separated by a comma. Each line of the output represents information about a single user.
ObjectExport	Exports objects to an XML file.	You can use pmrep to export objects if you have one of the following privileges: - Admin Repository - Browse Repository   - Use Designer - Use Repository Manager   - Use Workflow Manager Note: If you only have the Use Designer privilege, you can export Designer objects only. If you only have the Use  Workflow Manager privilege, you can export Workflow Manager objects only.
ObjectImport	Imports objects from an XML file.	You can use pmrep to import objects if you have one of the following privileges: - Admin Repository - Use Designer   - Use Repository Manager - Use Workflow Manager Note: If you only have the Use Designer privilege, you can import Designer objects only. If you only have the Use Workflow Manager privilege, you can import Workflow Manager objects only.
TruncateLog	Truncates log details from repository level, folder level, or workflow level.	When you use the -t option to specify an end time, you can enter an integer greater than 0 to specify a number of days before the current date, or you can specify the end time in MM/DD/YYYY HH24:MI:SS format.
UpdateSeqGenValues	Updates transformation properties for Sequence Generator transformations.	You can use the UpdateSeqGenValues command with the Use Designer privilege and write permission on the folder. Previously, you needed the Super User privilege.

 

New PMREP Commands
Command	Description	Comments
ListGroupsForUser	Lists all the groups that the user belongs to.	New command.
LsPrivileges	Lists the privileges associated with a user or group.	New command. You can use the -o option to list privileges assigned directly to a user.

 

Changed PMREP Commands
Command	Description	Comments
CreateConnection	Creates a relational or application connection in the repository.	Previously, you could not use this command to create application connections. The -k option has been added to accept name/value pairs as connection attributes for application connections. The -t option has been modified. You can use the option with no argument, or you can enter the value 1. In both cases, you enable trusted-connection security for MS SQL Server connections.
ObjectImport	Imports objects from an   XML file.	The -p option has been added. You can use the option to retain persistent mapping variables when you import mappings.

 

New DEPLOYPARAMS Parameter
Parameter	Required/ Optional	Description
DEPLOYTIMEOUT	Optional	Period of time (in seconds) that pmrep attempts to acquire locks on objects in the target repository. A value of 0 fails the copy operation immediately if pmrep cannot obtain a lock. A value of -1 instructs pmrep to wait indefinitely until it acquires locks or the user cancels the operation. Default is -1.

 

PMREPAGENT Commands Ported to PMREP
pmrepagent Command	Replacement pmrep Command	Description	Comments
Backup	Backup	Backs up repository.	Existing pmrep command.
Create	Create	Creates repository tables in the database.	New pmrepcommand.
Delete	Delete	Deletes the repository tables from the database	New pmrepcommand.
Registerplugin	RegisterPlugin	Registers a new external module to the  repository.	New pmrepcommand.
Restore	Restore	Restores a repository from a repository backup file.	New pmrepcommand.
Unregisterplugin	UnregisterPlugin	Unregisters a plug-in module from the repository.	New pmrepcommand.
Upgrade	Upgrade	Upgrades an existing repository to the latest version.	New pmrepcommand.

. New pmrep Commands
Command	Description	Comments
Create	Creates repository tables in the database.	Ported from pmrepagent.
Delete	Deletes the repository tables from the database.	Ported from pmrepagent.
KillUserConnections	Terminates user connection to the repository.	New command.
ListUserConnections	Lists user connections to the Repository Service.	New command.
RegisterPlugin	Registers a new external module to the repository.	Ported from pmrepagent.
Restore	Restores a repository from a repository backup file.	Ported from pmrepagent.
UnregisterPlugin	Unregisters a plug-in module from the repository.	Ported from pmrepagent.
Upgrade	Upgrades an existing repository to the latest version.	Ported from pmrepagent.
Version	Displays the PowerCenter version number.	New command.

. Changed PMREP Commands
Command	Description	Comments
ApplyLabel	Applies a label to an object or set of objects in a folder.	-g option added to find object dependencies across repositories.
BackUp	Backs up a repository.	-v option added to skip task statistics.
Connect	Connects to the repository.	The following options have been added: -d. Domain name. -t. Resilience timeout.
CreateConnection	Creates a relational connection.	-f option added to enter SQL commands to set the database environment when you connect to the database
CreateDeploymentGroup	Creates a deployment group.	Privileges changed.
CreateFolder	Creates a folder.	Privileges changed. -f option added to change the folder status.
CreateLabel	Creates a label object.	Privileges changed. -t option (label type) removed.
CreateUser	Creates a user.	-i option added to add contact information about the user.
DeleteConnection	Deletes an existing relational connection.	Privileges changed.
DeleteDeploymentGroup	Deletes a deployment group.	Privileges changed.
DeleteFolder	Deletes a folder.	Privileges changed.
DeleteLabel	Deletes a label object and all references to the label.	Privileges changed.
DeployDeploymentGroup	Copies a deployment group.	Privileges changed. The following options have been added: -d. Domain name. -o. Repository Service port number. The following option has been removed: -u. Login user name for the target repository. The following option has been changed: -n. Login user name for the target repository, not the target repository server port number.
DeployFolder	Deploys a folder.	Privileges changed. The following options have been added: -d. Domain name. -o. Repository Service port number. The following option has been removed: -u. Login user name for the target repository. The following option has been changed: -n. Login user name for the target repository, not the target repository server port number.
EditUser	Edits the profile of a user.	-i option added to edit contact information about the user.
ListObjects	Lists objects in the repository.	The Java transformation type has been added.
ModifyFolder	Modifies folder properties.	Privileges changed. -f option added to change the folder status.
Notify	Sends notification messages.	All options removed except -m, the message you want to send.
ObjectExport	Exports objects to an XML file.	The following options have been added: -m. Exports primary key table definitions when you export   sources or targets with foreign keys. -s. Exports the original object referenced by the shortcut. -b. Exports non-reusable objects. -r. Exports reusable objects.
ObjectImport	Imports objects from an XML file.	-l option added to log file that records each export step.
Register	Registers local repositories with global repositories.	-d option added to specify domain name. -a and -A (password) options removed.
Run	Displays messages stating whether a run has completed or failed.	-u option added to encode the output file in UTF-8 format.
Unregister	Unregisters local repositories from global repositories.	-d option added to specify domain name. -a and -A (password) options removed.
UpdateSrcPrefix	Updates source table owner names.	Privileges changed.
UpdateStatistics	Updates statistics for repository tables and indexes.	-s option (file of tables to skip) removed.
Validate	Validates objects.	-t option (task or transformation type) removed.

 

Deprecated PMREP Commands
Command	Description	infacmd Replacement Command
AddRepository	Adds a repository configuration to the Repository Server.	CreateRepositoryService
AddServer	Adds a PowerCenter Server.	CreateIntegrationService
DeleteServer	Deletes a PowerCenter Server.	RemoveService
DisableRepository	Disables a repository.	DisableService
EnableRepository	Enables a repository.	EnableService
RemoveRepository	Removes a repository from the Repository Server cache entry list.	RemoveService
StopRepository	Stops the repository you last connected to using pmrep.	DisableService
UpdateServer	Edits server details.	UpdateIntegrationService or UpdateRepositoryService
UpdateServVar	Updates server variables.	UpdateServiceProcess