Preface
Command Line Programs and Utilities
- Command Line Programs and Utilities Overview
Installing and Configuring Command Line Utilities
- Installing and Configuring Command Line Utilities Overview
- Installing the Command Line Utilities
  - Installation Directories
- Configuring the Command Line Utilities
- Security Configuration for Informatica Utilities
Using the Command Line Programs
- Using the Command Line Programs Overview
- Entering Options and Arguments
- Syntax Notation
- Running Commands in a Secure Domain
- Running Commands on UNIX with Kerberos Authentication
  - Running Commands on UNIX with Single Sign-On
    - Setting the Kerberos Environment Variables
    - Generating the Credentials Cache File
  - Running Commands on UNIX Without Single Sign-On
- Running Commands on Windows with Kerberos Authentication
Environment Variables for Command Line Programs
- Environment Variables for Command Line Programs Overview
- ICMD_JAVA_OPTS
  - Configuring ICMD_JAVA_OPTS on UNIX
  - Configuring ICMD_JAVA_OPTS on Windows
- INFA_CLIENT_RESILIENCE_TIMEOUT
  - Configuring INFA_CLIENT_RESILIENCE_TIMEOUT on UNIX
  - Configuring INFA_CLIENT_RESILIENCE_TIMEOUT on Windows
- INFA_CODEPAGENAME
  - Configuring INFA_CODEPAGENAME on UNIX
  - Configuring INFA_CODEPAGENAME on Windows
- INFA_DEFAULT_DATABASE_PASSWORD
  - Configuring INFA_DEFAULT_DATABASE_PASSWORD on UNIX
  - Configuring INFA_DEFAULT_DATABASE_PASSWORD on Windows
- INFA_DEFAULT_DB_TRUSTSTORE_PASSWORD
  - Configuring INFA_DEFAULT_DB_TRUSTSTORE_PASSWORD on UNIX
  - Configuring INFA_DEFAULT_DB_TRUSTSTORE_PASSWORD on Windows
- INFA_DEFAULT_DOMAIN
  - Configuring INFA_DEFAULT_DOMAIN on UNIX
  - Configuring INFA_DEFAULT_DOMAIN on Windows
- INFA_DEFAULT_DOMAIN_PASSWORD
  - Configuring INFA_DEFAULT_DOMAIN_PASSWORD on UNIX
  - Configuring INFA_DEFAULT_DOMAIN_PASSWORD on Windows
- INFA_DEFAULT_DOMAIN_USER
  - Configuring INFA_DEFAULT_DOMAIN_USER on UNIX
  - Configuring INFA_DEFAULT_DOMAIN_USER on Windows
- INFA_DEFAULT_PWX_OSEPASSWORD
  - Configuring INFA_DEFAULT_PWX_OSEPASSWORD on UNIX
  - Configuring INFA_DEFAULT_PWX_OSEPASSWORD on Windows
- INFA_DEFAULT_PWX_OSPASSWORD
  - Configuring INFA_DEFAULT_PWX_OSPASSWORD on UNIX
  - Configuring INFA_DEFAULT_PWX_OSPASSWORD on Windows
- INFA_DEFAULT_SECURITY_DOMAIN
  - Configuring INFA_DEFAULT_SECURITY_DOMAIN on UNIX
  - Configuring INFA_DEFAULT_SECURITY_DOMAIN on Windows
- INFA_JAVA_CMD_OPTS
  - Configuring INFA_JAVA_CMD_OPTS on UNIX
  - Configuring INFA_JAVA_CMD_OPTS on Windows
- INFA_PASSWORD
  - Configuring INFA_PASSWORD on UNIX
  - Configuring INFA_PASSWORD on Windows
- INFA_NODE_KEYSTORE_PASSWORD
  - Configuring INFA_NODE_KEYSTORE_PASSWORD on UNIX
  - Configuring INFA_NODE_KEYSTORE_PASSWORD on Windows
- INFA_NODE_TRUSTSTORE_PASSWORD
  - Configuring INFA_NODE_TRUSTSTORE_PASSWORD on UNIX
  - Configuring INFA_NODE_TRUSTSTORE_PASSWORD on Windows
- INFA_REPCNX_INFO
  - Configuring INFA_REPCNX_INFO on UNIX
  - Configuring INFA_REPCNX_INFO on Windows
- INFA_REPOSITORY_PASSWORD
  - Configuring INFA_REPOSITORY_PASSWORD on UNIX
  - Configuring INFA_REPOSITORY_PASSWORD on Windows
- INFATOOL_DATEFORMAT
  - Configuring INFATOOL_DATEFORMAT on UNIX
  - Configuring INFATOOL_DATEFORMAT on Windows
- Encrypting Passwords
  - Using a Password as an Environment Variable
    - Configuring a Password as an Environment Variable on UNIX
    - Configuring a Password as an Environment Variable on Windows
- Setting the User Name
  - Configuring a User Name as an Environment Variable on UNIX
  - Configuring a User Name as an Environment Variable on Windows
Using infacmd
- Using infacmd Overview
- infacmd ListPlugins
- Running Commands
- infacmd Return Codes
- infacmd UpdateGatewayInfo
infacmd as Command Reference
- CreateExceptionAuditTables
- CreateService
- DeleteExceptionAuditTables
- ListServiceOptions
- ListServiceProcessOptions
- UpdateServiceOptions
- UpdateServiceProcessOptions
infacmd aud Command Reference
- getDomainObjectPermissions
- getPrivilegeAssociation
- getUserGroupAssociation
- getUserGroupAssociationForRoles
- getUsersPersonalInfo
Infacmd bg Command Reference
- upgradeRepository
- listGlossary
- exportGlossary
- importGlossary
infacmd cluster Command Reference
- createConfiguration
- deleteConfiguration
- clearConfigurationProperties
- exportConfiguration
- listAssociatedConnections
- listConfigurationGroupPermissions
- listConfigurationSets
- listConfigurationProperties
- listConfigurations
- listConfigurationUserPermissions
- refreshConfiguration
- setConfigurationPermissions
- setConfigurationProperties
infacmd cms Command Reference
- CreateAuditTables
- CreateService
- DeleteAuditTables
- ListServiceOptions
- ListServiceProcessOptions
- Purge
- RemoveService
- ResyncData
- UpdateServiceOptions
- UpdateServiceProcessOptions
- Upgrade
infacmd dis Command Reference
- AddParameterSetEntries
- BackupApplication
- CancelDataObjectCacheRefresh
- CreateService
- DeleteParameterSetEntries
- DeployApplication
- disableMappingValidationEnvironment
- enableMappingValidationEnvironment
- ListApplicationObjectPermissions
- ListApplicationObjects
- ListApplicationOptions
- ListApplicationPermissions
- ListApplications
- ListComputeOptions
- ListDataObjectOptions
- ListParameterSetEntries
- ListParameterSetObjects
- ListParameterSets
- ListSequenceObjectProperties
- ListSequenceObjects
- ListServiceOptions
- ListServiceProcessOptions
- PurgeDataObjectCache
- PurgeResultSetCache
- RefreshDataObjectCache
- RenameApplication
- replaceMappingHadoopRuntimeConnections
- RestoreApplication
- SetApplicationPermissions
- SetApplicationObjectPermissions
- setMappingExecutionEnvironment
- SetSequenceState
- StartApplication
- StopApplication
- stopBlazeService
- UndeployApplication
- UpdateApplication
- UpdateApplicationOptions
- UpdateComputeOptions
- UpdateDataObjectOptions
  - Data Object Options
- UpdateParameterSetEntries
- UpdateServiceOptions
  - Data Integration Service Options
- UpdateServiceProcessOptions
  - Data Integration Service Process Options
Infacmd es Command Reference
- ListServiceOptions
- UpdateServiceOptions
- UpdateSMTPOptions
infacmd ihs Command Reference
- createservice
- ListServiceOptions
- UpdateServiceOptions
- UpgradeClusterService
infacmd ipc Command Reference
- ExportToPC
- ImportFromPC
- genReuseReportFromPC
infacmd isp Command Reference
- AddAlertUser
- AddConnectionPermissions
- AddDomainLink
- AddDomainNode
- AddGroupPrivilege
- AddLicense
- AddNamespace
- AddNodeResource
- AddRolePrivilege
- AddServiceLevel
- AddUserPrivilege
- AddUserToGroup
- AssignDefaultOSProfile
- AssignedToLicense
- AssignGroupPermission
- AssignISToMMService
- AssignLicense
- AssignRoleToGroup
- AssignRoleToUser
- AssignRSToWSHubService
- AssignUserPermission
- ConvertLogFile
- convertUserActivityLogFile
- CreateConnection
  - Adabas Connection Options
  - Amazon Redshift Connection Options
  - Amazon S3 Connection Options
  - DataSift Connection Options
  - DB2 for i5/OS Connection Options
  - DB2 for z/OS Connection Options
  - Facebook Connection Options
  - Greenplum Connection Options
  - Hadoop Connection Options
  - HBase Connection Options
  - HDFS Connection Options
  - Hive Connection Options
  - IBM DB2 Connection Options
  - IMS Connection Options
  - JDBC Connection Options
  - JD Edwards EnterpriseOne Connection Options
  - LDAP Connection Options
  - LinkedIn Connection Options
  - MapR-DB Connection Options
  - Microsoft Azure Blob Storage Connection Options
  - Microsoft Azure Data Lake Store Connection Options
  - Microsoft Azure SQL Data Warehouse Connection Options
  - Microsoft SQL Server Connection Options
  - Microsoft Dynamics CRM Connection Options
  - Netezza Connection Options
  - OData Connection Options
  - ODBC Connection Options
  - Oracle Connection Options
  - Salesforce Connection Options
  - SAP Connection Options
  - Sequential Connection Options
  - Teradata Parallel Transporter Connection Options
  - Twitter Connection Options
  - Twitter Streaming Connection Options
  - VSAM Connection Options
  - Web Content-Kapow Katalyst Connection Options
- CreateFolder
- CreateGrid
- CreateGroup
- CreateIntegrationService
  - Integration Service Options
  - Integration Service Process Options
- CreateMMService
  - Metadata Manager Service Options
- CreateOSProfile
  - Data Integration Service Process Options for Operating System Profiles
  - PowerCenter Integration Service Process Options for Operating System Profiles
- CreateRepositoryService
- CreateRole
- CreateSAPBWService
  - SAP BW Service Options
  - SAP BW Service Process Option
- CreateUser
- CreateWSHubService
  - Web Services Hub Options
- DeleteNamespace
- DisableNodeResource
- DisableService
- DisableServiceProcess
- DisableUser
- EditUser
- EnableNodeResource
- EnableService
- EnableServiceProcess
- EnableUser
- ExportDomainObjects
- ExportUsersAndGroups
- generateHadoopConnectionFromHiveConnection
- GetFolderInfo
- GetLastError
- GetLog
- GetNodeName
- getDomainSamlConfig
- GetServiceOption
- GetServiceProcessOption
- GetServiceProcessStatus
- GetServiceStatus
- GetSessionLog
- GetSystemLogDirectory
- getUserActivityLog
- GetWorkflowLog
- Help
- ImportDomainObjects
- ImportUsersAndGroups
- ListAlertUsers
- ListAllGroups
- ListAllRoles
- ListAllUsers
- ListConnectionOptions
- ListConnectionPermissions
- ListConnectionPermissionsByGroup
- ListConnectionPermissionsByUser
- ListConnections
- ListConnectionOptions
- ListDefaultOSProfiles
- ListDomainCiphers
- ListDomainLinks
- ListDomainOptions
- ListFolders
- ListGridNodes
- ListGroupPermissions
- ListGroupPrivileges
- ListGroupsForUser
- ListLDAPConnectivity
- ListLicenses
- ListMonitoringOptions
- ListNodeOptions
- ListNodeResources
- ListNodeRoles
- ListNodes
- ListOSProfiles
- infacmd ListPasswordRules
- ListRepositoryLDAPConfiguration
- ListRolePrivileges
- ListSecurityDomains
- ListServiceLevels
- ListServiceNodes
- ListServicePrivileges
- ListServices
- ListSMTPOptions
- ListUserPermissions
- ListUserPrivileges
- infacmd ListWeakPasswordUsers
- migrateUsers
- MoveFolder
- MoveObject
- Ping
- PingDomain
- PrintSPNAndKeytabNames
- PurgeLog
- RemoveAlertUser
- RemoveConnection
- RemoveConnectionPermissions
- RemoveDomainLink
- RemoveFolder
- RemoveGrid
- RemoveGroup
- RemoveGroupPermission
- RemoveGroupPrivilege
- RemoveLicense
- RemoveNode
- RemoveNodeResource
- RemoveOSProfile
- RemoveRole
- RemoveRolePrivilege
- RemoveService
- RemoveServiceLevel
- RemoveUser
- RemoveUserFromGroup
- RemoveUserPermission
- RemoveUserPrivilege
- RenameConnection
- ResetPassword
- RunCPUProfile
- SetConnectionPermissions
- SetLDAPConnectivity
- SetRepositoryLDAPConfiguration
- ShowLicense
- ShutdownNode
- SwitchToGatewayNode
- SwitchToWorkerNode
- SyncSecurityDomains
- UnassignDefaultOSProfile
- UnassignISMMService
- UnassignLicense
- UnassignRoleFromGroup
- UnassignRoleFromUser
- UnassignRSWSHubService
- UnassociateDomainNode
- UpdateConnection
- UpdateDomainOptions
- UpdateFolder
- UpdateGatewayInfo
- UpdateGrid
- UpdateIntegrationService
- UpdateLicense
- UpdateMMService
- UpdateMonitoringOptions
- UpdateNamespace
- UpdateNodeOptions
- UpdateNodeRole
- UpdateOSProfile
- UpdateRepositoryService
- UpdateSAPBWService
- UpdateServiceLevel
- UpdateServiceProcess
- UpdateSMTPOptions
- UpdateWSHubService
- validateFeature
- Version
infacmd ldm Command Reference
- BackupContents
- CreateService
- ListServiceOptions
- restoreContents
- removesnapshot
- UpdateServiceOptions
- upgrade
infacmd mrs Command Reference
- BackupContents
- CheckInObject
- CreateContents
- CreateFolder
- CreateProject
- CreateService
- DeleteContents
- DeleteFolder
- DeleteProject
- disableMappingValidationEnvironment
- enableMappingValidationEnvironment
- ListBackupFiles
- ListCheckedOutObjects
- listFolders
- ListLockedObjects
- ListProjects
- ListServiceOptions
- ListServiceProcessOptions
- ManageGroupPermissionOnProject
- ManageUserPermissionOnProject
- PopulateVCS
- ReassignCheckedOutObject
- rebuildDependencyGraph
- RenameFolder
- replaceMappingHadoopRuntimeConnections
- RestoreContents
- UndoCheckout
- setMappingExecutionEnvironment
- UnlockObject
- UpdateServiceOptions
  - Model Repository Service Options
- UpdateServiceProcessOptions
- UpgradeContents
- UpgradeExportedObjects
infacmd ms Command Reference
- GetMappingStatus
- GetRequestLog
- ListMappingParams
  - ListMappingParams Output
- ListMappings
- RunMapping
- UpgradeMappingParameterFile
infacmd oie Command Reference
- DeployApplication
- ExportObjects
- exportResources
- ImportObjects
infacmd ps Command Reference
- cancelProfileExecution
- CreateWH
- detectOrphanResults
- DropWH
- Execute
- executeProfile
- getExecutionStatus
- getProfileExecutionStatus
- List
- ListAllProfiles
- migrateProfileResults
- migrateScorecards
- Purge
- purgeOrphanResults
- restoreProfilesAndScorecards
- synchronizeProfile
infacmd pwx Command Reference
- CloseForceListener
- CloseListener
- CondenseLogger
- createdatamaps
- CreateListenerService
- CreateLoggerService
- DisplayAllLogger
- DisplayCPULogger
- DisplayEventsLogger
- DisplayMemoryLogger
- DisplayRecordsLogger
- displayStatsListener
- DisplayStatusLogger
- FileSwitchLogger
- ListTaskListener
- ShutDownLogger
- StopTaskListener
- UpgradeModels
- UpdateListenerService
- UpdateLoggerService
infacmd rms Command Reference
- ListComputeNodeAttributes
- ListServiceOptions
- SetComputeNodeAttributes
- UpdateServiceOptions
  - Resource Manager Service Options
infacmd rtm Command Reference
- DeployImport
- Export
- Import
infacmd sch Command Reference
- CreateSchedule
  - Valid Time Zone Parameters
- DeleteSchedule
- ListSchedule
- ListServiceOptions
- ListServiceProcessOptions
- PauseAll
- PauseSchedule
- ResumeAll
- ResumeSchedule
- UpdateSchedule
- UpdateServiceOptions
  - Scheduler Service Options
- UpdateServiceProcessOptions
  - Scheduler Service Process Options
- Upgrade
infacmd search Command Reference
- CreateService
- ListServiceOptions
- ListServiceProcessOptions
- UpdateServiceOptions
- UpdateServiceProcessOptions
infacmd sql Command Reference
- ExecuteSQL
- ListColumnOptions
- ListColumnPermissions
- ListSQLDataServiceOptions
- ListSQLDataServicePermissions
- ListSQLDataServices
- ListStoredProcedurePermissions
- ListTableOptions
- ListTablePermissions
- PurgeTableCache
- RefreshTableCache
- RenameSQLDataService
- SetColumnPermissions
- SetSQLDataServicePermissions
- SetStoredProcedurePermissions
- SetTablePermissions
- StartSQLDataService
- StopSQLDataService
- UpdateColumnOptions
  - Column Options
- UpdateSQLDataServiceOptions
  - SQL Data Service Options
- UpdateTableOptions
  - Virtual Table Options
infacmd tdm Command Reference
- CreateService
- CreateContents
- EnableService
- DisableService
infacmd wfs Command Reference
- abortWorkflow
- bulkComplete
- cancelWorkflow
- completeTask
- createTables
- delegateTask
- dropTables
- listActiveWorkflowInstances
- listMappingPersistedOutputs
- listTasks
- listWorkflowParams
  - listWorkflowParams Output
- listWorkflows
- pruneOldInstances
- recoverWorkflow
- releaseTask
- setMappingPersistedOutputs
- startTask
- startWorkflow
- upgradeWorkflowParameterFile
infacmd ws Command Reference
- ListOperationOptions
- ListOperationPermissions
- ListWebServiceOptions
- ListWebServicePermissions
- ListWebServices
- RenameWebService
- SetOperationPermissions
- SetWebServicePermissions
- StartWebService
- StopWebService
- UpdateOperationOptions
  - Operation Options
- UpdateWebServiceOptions
  - Web Service Options
infacmd xrf Command Reference
- generateReadableViewXML
- updateExportXML
infacmd Control Files
- infacmd Control Files Overview
- Control File Configuration
  - Control File Naming Conventions
- Export Control Files
  - Export Control File Parameters for Domain Objects
    - Export Control File Sample for Domain Objects
  - Export Control File Parameters for Model Repository Objects
    - Export Control File Sample for Model Repository Objects
- Import Control Files
  - Import Control File Parameters for Domain Objects
    - Import Control File Sample for Domain Objects
  - Import Control File Parameters for Model Repository Objects
    - Import Control File Sample for Model Repository Objects
- Rules and Guidelines for Control Files
- Control File Examples for Domain Objects
- Control File Examples for Model Repository Objects
infasetup Command Reference
- Using infasetup
  - Running Commands
  - Command Options
  - infasetup Return Codes
  - Using Database Connection Strings
- BackupDomain
- DefineDomain
- DefineGatewayNode
- DefineWorkerNode
- DeleteDomain
- GenerateEncryptionKey
- Help
- ListDomainCiphers
- MigrateEncryptionKey
- RestoreDomain
- restoreMitKerberosLinkage
- SwitchToKerberosMode
- UpdateDomainCiphers
- updateDomainName
- UpdateGatewayNode
- UpdateKerberosAdminUser
- UpdateKerberosConfig
- updateMitKerberosLinkage
- updateDomainSamlConfig
- UpdateWorkerNode
- UnlockUser
- ValidateandRegisterFeature
pmcmd Command Reference
- Using pmcmd
  - Running Commands in Command Line Mode
    - pmcmd Return Codes
  - Running Commands in Interactive Mode
    - Setting Defaults
  - Running in Wait Mode
  - Scripting pmcmd Commands
  - Entering Command Options
- aborttask
- abortworkflow
- Connect
- Disconnect
- Exit
- getrunningsessionsdetails
- GetServiceDetails
- getserviceproperties
- getsessionstatistics
- gettaskdetails
- getworkflowdetails
- help
- pingservice
- recoverworkflow
- scheduleworkflow
- SetFolder
- SetNoWait
- SetWait
- ShowSettings
- StartTask
  - Using Parameter Files with starttask
- StartWorkflow
  - Using Parameter Files with startworkflow
- StopTask
- StopWorkflow
- UnscheduleWorkflow
- UnsetFolder
- Version
- WaitTask
- WaitWorkflow
pmrep Command Reference
- Using pmrep
  - Running Commands in Command Line Mode
  - Running Commands in Interactive Mode
  - Running Commands in Normal Mode and Exclusive Mode
  - pmrep Return Codes
  - Using Native Connect Strings
  - Scripting pmrep Commands
    - Tips for Scripting pmrep Commands
  - Connection Subtypes
- AddToDeploymentGroup
- ApplyLabel
- AssignIntegrationService
- AssignPermission
  - Example
- BackUp
- ChangeOwner
- CheckIn
- CleanUp
- ClearDeploymentGroup
- Connect
- Create
- CreateConnection
  - Specifying the Database Code Page
- CreateDeploymentGroup
- CreateFolder
  - Assigning Permissions
- CreateLabel
- CreateQuery
- Delete
- DeleteConnection
- DeleteDeploymentGroup
- DeleteFolder
- DeleteLabel
- DeleteObject
- DeleteQuery
- DeployDeploymentGroup
- DeployFolder
- ExecuteQuery
- Exit
- FindCheckout
- GetConnectionDetails
- GenerateAbapProgramToFile
- Help
- InstallAbapProgram
- KillUserConnection
- ListConnections
- ListObjectDependencies
- ListObjects
  - Listing Object Types
  - Listing Folders
  - Listing Objects
- ListTablesBySess
- ListUserConnections
- MassUpdate
  - Session Property Types
  - Rules and Guidelines for MassUpdate
  - Sample Log File
- ModifyFolder
- Notify
- ObjectExport
  - Examples
- ObjectImport
- PurgeVersion
  - Examples
- Register
- RegisterPlugin
  - Registering a Security Module
  - Example
- Restore
  - Example
- RollbackDeployment
  - Example
- Run
- ShowConnectionInfo
- SwitchConnection
- TruncateLog
- UndoCheckout
- Unregister
- UnregisterPlugin
  - Unregistering an External Security Module
  - Example
- UpdateConnection
- UpdateEmailAddr
- UpdateSeqGenVals
- UpdateSrcPrefix
- UpdateStatistics
- UpdateTargPrefix
- Upgrade
- UninstallAbapProgram
- Validate
- Version
Working with pmrep Files
- Working with pmrep Files Overview
- Using the Persistent Input File
  - Creating a Persistent Input File with pmrep
    - Example
  - Creating a Persistent Input File Manually
    - Example
- Using the Object Import Control File
  - Object Import Control File Parameters
- Object Import Control File Examples
- Using the Deployment Control File
  - Deployment Control File Parameters
    - Persisted Mapping Variables
- Deployment Control File Examples
- Tips for Working with pmrep Files

Command Reference

10.2 HotFix 1
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.2
- 10.2.1
- 10.2 HotFix 2
- 10.2
- 10.1.1 Update 2
- 10.1.1 HotFix 1
- 10.1.1
- 10.1
- 10.0 Update 1
- 10.0

Back Next

Version

Displays the PowerCenter version and Informatica trademark and copyright information.

The Version command uses the following syntax in the command line mode:

pmcmd Version

The Version command uses the following syntax in the interactive mode:

Version

pmcmd Command Reference

Updated April 22, 2019

Download Guide

Send Feedback

Explore Informatica Network

Communities

Knowledge Base

Success Portal

Table of Contents

Command Reference

Command Reference

Version

Version