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 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

Command Reference

Command Reference

UpdateRepositoryService

UpdateRepositoryService

Updates or creates service options for the PowerCenter Repository Service.
For example, you can update the PowerCenter Repository Service operating mode, which you can set to normal or exclusive. Normal mode allows multiple users to access the PowerCenter Repository Service and update repository contents. Exclusive mode allows a single user to access the PowerCenter Repository Service and update repository contents. Set the operating mode to exclusive when you perform administrative tasks that require a single user to log in and update the configuration. To update the PowerCenter Repository Service operating mode, disable the PowerCenter Repository Service, update the operating mode, and then re-enable the PowerCenter Repository Service.
The infacmd isp UpdateRepositoryService command uses the following syntax:
UpdateRepositoryService

<-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 ...]

[<-ServiceOptions|-so> option_name=value ...]
The following table describes infacmd isp UpdateRepositoryService 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 you want to update. To enter a name that contains a space or other non-alphanumeric character, enclose the name in quotation marks.
-NodeName
-nn
node_name
Optional. Name of the node where the PowerCenter Repository Service process runs. 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.
-ServiceOptions
-so
option_name=value
Required. Service properties that define how the PowerCenter Repository Service runs.

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


Explore Informatica Network