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 bg Command Reference
  10. infacmd cms Command Reference
  11. infacmd dis Command Reference
  12. Infacmd es Command Reference
  13. infacmd ihs Command Reference
  14. infacmd ipc Command Reference
  15. infacmd isp Command Reference
  16. infacmd ldm Command Reference
  17. infacmd mrs Command Reference
  18. infacmd ms Command Reference
  19. infacmd oie Command Reference
  20. infacmd ps Command Reference
  21. infacmd pwx Command Reference
  22. infacmd rms Command Reference
  23. infacmd rtm Command Reference
  24. infacmd sch Command Reference
  25. infacmd search Command Reference
  26. infacmd sql Command Reference
  27. infacmd tdm Command Reference
  28. infacmd wfs Command Reference
  29. infacmd ws Command Reference
  30. infacmd xrf Command Reference
  31. infacmd Control Files
  32. infasetup Command Reference
  33. pmcmd Command Reference
  34. pmrep Command Reference
  35. Working with pmrep Files

Command Reference

Command Reference

CreateRepositoryService

CreateRepositoryService

Creates a PowerCenter Repository Service in a domain.
By default, the PowerCenter Repository Service is enabled when you create it.
A PowerCenter Repository Service manages one repository. It performs all metadata transactions between the repository and repository clients.
The infacmd isp CreateRepositoryService command uses the following syntax:
CreateRepositoryService

<-DomainName|-dn> domain_name

<-UserName|-un> user_name

<-Password|-pd> password

[<-SecurityDomain|-sdn> security_domain]

[<-Gateway|-hp> gateway_host1:port gateway_host2:port...]

[<-ResilienceTimeout|-re> timeout_period_in_seconds]

<-ServiceName|-sn> service_name

<-NodeName|-nn> node_name

[<-BackupNodes|-bn> node1 node2 ...]

[<-ServiceDisable|-sd>]

<-ServiceOptions|-so> option_name=value ...

[<-LicenseName|-ln> license_name]

[<-FolderPath|-fp> full_folder_path]
The following table describes infacmd isp CreateRepositoryService options and arguments:
Option
Argument
Description
-DomainName
-dn
domain_name
Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-UserName
-un
user_name
Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence.
Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password
-pd
password
Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain
-sdn
security_domain
Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive.
If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-Gateway
-hp
gateway_host1:port gateway_host2:port ...
Required if the gateway connectivity information in the domains.infa file is out of date. The host names and port numbers for the gateway nodes in the domain.
-ResilienceTimeout
-re
timeout_period_in_seconds
Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. If you omit this option, infacmd uses the timeout value specified in the INFA_CLIENT_RESILIENCE_TIMEOUT environment variable. If no value is specified in the environment variable, the default of 180 seconds is used.
-ServiceName
-sn
service_name
Required. Name of the PowerCenter Repository Service. The name is not case sensitive and must be unique within the domain. The characters must be compatible with the code page of the associated repository. The name cannot have leading or trailing spaces, include carriage returns or tabs, exceed 79 characters, or contain the following characters:
\ / : * ? < > " | 
-NodeName
-nn
node_name
Required. Name of the node where you want the PowerCenter Repository Service process to run. If the PowerCenter environment is configured for high availability, this option specifies the name of the primary node.
-BackupNodes
-bn
node1 node2 ...
Optional. Nodes on which the service can run if the primary node is unavailable. You can configure backup nodes if you have high availability.
-ServiceDisable
-sd
-
Optional. Creates a disabled service. You must enable the service before you can run it.
-ServiceOptions
-so
option_name=value
Required. Service properties that define how the PowerCenter Repository Service runs.
-LicenseName
-ln
license_name
Required if you create an enabled service. Name of the license you want to assign to the PowerCenter Repository Service.
-FolderPath
-fp
full_folder_path
Optional. Full path, excluding the domain name, to the folder in which you want to create the PowerCenter Repository Service. Must be in the following format:
/parent_folder/child_folder
Default is “/” (the domain).

Repository Service Options (-so)

Enter Repository Service options in the following format:
infacmd CreateRepositoryService ... -so option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Repository Service options:
Option
Description
AllowWritesWithRACaching
Optional. Uses PowerCenter Client tools to modify metadata in the repository when repagent caching is enabled. Default is Yes.
CheckinCommentsRequired
Optional. Requires users to add comments when checking in repository objects. Default is Yes. To apply changes, restart the PowerCenter Repository Service.
CodePage
Required. Code page description for the database. To enter a code page description that contains a space or other non-alphanumeric character, enclose the name in quotation marks.
ConnectString
Required. Database connection string specified during PowerCenter Repository Service setup. To apply changes, restart the PowerCenter Repository Service.
DBPassword
Required. Repository database password corresponding to the database user. You can set a password with the -so option or the environment variable INFA_DEFAULT_DATABASE_PASSWORD. If you set a password with both methods, the password set with the -so option takes precedence.
To apply changes, restart the PowerCenter Repository Service.
DBPoolExpiryThreshold
Optional. The minimum number of idle database connections allowed by the PowerCenter Repository Service. For example, if there are 20 idle connections, and you set this threshold to 5, the PowerCenter Repository Service closes no more than 15 connections. Minimum is 3. Default is 5.
DBPoolExpiryTimeout
Optional. The interval, in seconds, at which the PowerCenter Repository Service checks for idle database connections. If a connection is idle for a period of time greater than this value, the PowerCenter Repository Service can close the connection. Minimum is 300. Maximum is 2,592,000 (30 days). Default is 3,600 (1 hour).
DBUser
Required. Account for the database containing the repository. To apply changes, restart the PowerCenter Repository Service.
DatabaseArrayOperationSize
Optional. Number of rows to fetch each time an array database operation is issued, such as insert or fetch. Default is 100. To apply changes, restart the PowerCenter Repository Service.
DatabaseConnectionTimeout
Optional. Amount of time in seconds that the PowerCenter Repository Service attempts to establish a connection to the database management system. Default is 180.
DatabasePoolSize
Optional. Maximum number of connections to the repository database that the PowerCenter Repository Service can establish. Minimum is 20. Default is 500.
DatabaseType
Required. Type of database that stores the repository metadata. To apply changes, restart the PowerCenter Repository Service.
EnableRepAgentCaching
Optional. Enables the repository agent caching feature. Default is Yes.
ErrorSeverityLevel
Optional. Minimum level of error messages written to the PowerCenter Repository Service log:
  • Fatal
  • Error
    Warning
  • Info
  • Trace
  • Debug
Default is Info.
HeartBeatInterval
Optional. Interval at which the PowerCenter Repository Service verifies its connections with clients of the service. Default is 60 seconds.
MaxResilienceTimeout
Optional. Maximum amount of time in seconds that the service holds on to resources for resilience purposes. Default is 180.
MaximumConnections
Optional. Maximum number of connections the repository accepts from repository clients. Default is 200.
MaximumLocks
Optional. Maximum number of locks the repository places on metadata objects. Default is 50,000.
OperatingMode
Optional. Mode in which the PowerCenter Repository Service is running:
  • Normal
  • Exclusive
Default is Normal. To apply changes, restart the PowerCenter Repository Service.
OptimizeDatabaseSchema Optional. Optimizes the repository database schema when you create repository contents or back up and restore an IBM DB2 or Microsoft SQL Server repository. When enabled, the PowerCenter Repository Service tries to create repository tables that contain Varchar columns with a precision of 2000 instead of CLOB columns. Use Varchar columns to increase repository performance. When you use Varchar columns, you reduce disk input and output, and the database can cache the columns.
To use this option, verify the page size requirements for the following repository databases:
  • IBM DB2. Database page size 4 KB or greater. At least one temporary tablespace with page size 16 KB or greater.
  • Microsoft SQL Server. Database page size 8 KB or greater.
Default is disabled.
PreserveMXData
Optional. Preserves MX data for prior versions of mappings. Default is disabled.
RACacheCapacity
Optional. Number of objects that the cache can contain when repository agent caching is enabled. Default is 10,000.
SecurityAuditTrail
Optional. Tracks changes made to users, groups, privileges, and permissions. Default is No.
ServiceResilienceTimeout
Optional. Amount of time in seconds that the service tries to establish or reestablish a connection to another service. Default is 180. To apply changes, restart the PowerCenter Repository Service.
TableOwnerName
Optional. Name of the owner of the repository tables for an IBM DB2 repository.
TablespaceName
Optional. Tablespace name for IBM DB2 repositories. To apply changes, restart the PowerCenter Repository Service.
TrustedConnection
Optional. Uses Windows authentication to access the Microsoft SQL Server database. Default is No. To apply changes, restart the PowerCenter Repository Service.


Updated April 22, 2019