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

CreateService

CreateService

Creates a Test Data Manager Service in a domain.
The infacmd tdm CreateService command uses the following syntax:
CreateService <-DomainName|-dn> domain_name <-ServiceName|-sn> service_name <-UserName|-un> user_name <-Password|-pd> password [<-SecurityDomain|-sdn> security_domain] [<-ResilienceTimeout|-re> timeout_period_in_seconds] <-NodeName|-nn> node_name <-LicenseName|-ln> license_name <-PCRSServiceName|-pcrs> power_center_repo_service <-PCISServiceName|-pcis> power_center_int_service <-MRSServiceName|-mrs> model_repo_service <-MRSUserName|-rsun> model_repo_service_username <-MRSPassword|-rspd> model_repo_service_password [<-MRSSecurityDomain|-rsdn> model_repo_security_domain] <-AnalystService|-at> analyst_service <-EnableProfiling|-ep> enable_profiling <-EnableTDWService|-ets> enable_tdwservice <-DISServiceName|-dis> data_integration_service <-db_type|-dt> database_type (ORACLE, DB2, SQLSERVER or CUSTOM) [<-customDriver|-cd> custom_driver_name] <-DBUsername|-du> db_user <-DBPassword|-dp> db_password <-DBUrl|-dl> db_url <-DBConnString|-dc> db_conn_string [<-DbSchema|-ds> db_schema (used for SQL Server only)] [<-DbTablespace|-db> db_tablespace (used for DB2 only)] [<-HttpPort> http_port] [<-HttpsPort> https_port] [<-KeystoreFile|-kf> keystore_file_location] [<-KeystorePassword|-kp> keystore_password] [<-httpProtocolType|-pt> http_protocol_type] [<-jvmParams|-jp> jvmParameters] [<-connPoolSize|-cp> conn_pool_size] [<-jmxPort> jmx_port] [<-shutdownPort> shutdown_port]
The following table describes infacmd tdm CreateService 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.
-ServiceName
-sn
service_name
Required. Name of the Test Data Manager 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 exceed 230 characters, have leading or trailing spaces, or contain carriage returns, tabs, or the following characters:
/ * ? < > " |
-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.
-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. You can set the resilience timeout period with the -re option or the environment variable INFA_CLIENT_RESILIENCE_TIMEOUT. If you set a the resilience timeout period with both methods, the -re option takes precedence. Default is 180 seconds.
-NodeName
-nn
node_name
Required. Name of the node where the service will run.
-LicenseName
-ln
license_name
Required. Name of the license. The name is not case sensitive and must be unique within the domain. The name cannot exceed 79 characters, have leading or trailing spaces, or contain carriage returns, tabs, or the following characters:
/ * ? < > " |
-PCRSServicename
-pcrs
power_center_repo_service
Name of the PowerCenter Repository Service to which TDM connects.
-PCISServicename
-pcis
power_center_int_service
Name of the PowerCenter Integration Service to which TDM connects.
-MRSServiceName
-mrs
model_repo_service
Name of the Model Repository Service to which TDM connects.
-MRSUserName
-rsun
model_repo_service_username
Required. User name to connect to the Model repository.
-MRSPassword
-rspd
model_repo_service_password
Required. Password for the user name to connect to the Model repository. The password is case sensitive.
-AnalystService
-at
analyst_service
Optional. Name of the Analyst Service that TDM uses for asset linking. Required if you use the asset linking feature to link TDM global objects to the Business Glossary objects.
-MRSSecurityDomain
-rsdn
model_repo_security_domain
Required if you use LDAP authentication. Name of the security domain that the user belongs to. Security domain is case sensitive.
Default is Native.
-EnableProfiling
-ep
enable_profiling
Indicates data discovery settings. Set to true to enable data discovery. Set to false to disable data discovery.
-EnableTDWService
ets
enable_tdwservice
Indicates test data warehouse settings. Set to true if you plan to configure a test data repository and test data mart. Set to false if you do not need to create a test data warehouse.
Default is false.
-DISServiceName
-dis
data_integration_service
Name of the Data Integration Service to which TDM connects.
-db_type
-dt
database_type
Type of TDM repository database. Values are Oracle, SQL Server, DB2, or Custom.
-customDriver
-cd
custom_driver_name
Custom JDBC driver parameters. Required if you want to use a custom database type.
-DBUsername
-du
db_user
Required. Account for the repository database. Use the database client to set up this account.
-DBPassword
-dp
db_password
Required. Repository database password for the database user.
-DBUrl
-dl
db_url
Required. JDBC connect string to the database for the TDM repository. Use one of the following syntaxes:
Oracle:
jdbc:informatica:oracle: //<machineName>:<PortNo>;ServiceName= <DBName>; MaxPooledStatements=20; CatalogOptions=0; EnableServerResultCache=true
DB2:
jdbc:informatica:db2: //<host>:<port>; DatabaseName=<dbname>; BatchPerformanceWorkaround=true;DynamicSections=1000
SQLServer:
jdbc:informatica:sqlserver: //<host>:<port>; DatabaseName=<dbname>; SnapshotSerializable=true
-DBConnString
-dc
db_conn_string
Native connect string to the TDM repository database. The service uses the connect string to create a connection object to the Test Data Manager repository and the PowerCenter repository.
-DbSchema
-ds
db_schema
Optional. The schema name for a Microsoft SQL Server database.
-DbTablespace
-db
db_tablespace
Required for a DB2 database only. When you configure a tablespace name, the Test Data Manager Service creates all repository tables in the same tablespace. You cannot use spaces in the tablespace name.
The tablespace must be defined on a single node and the page size must be 32 KB. In a multipartition database, you must select this option. In a single-partition database, if you do not select this option, the installer creates the tables in the default tablespace.
-HttpPort
http_port
Required. Port number for the service.
-HttpsPort
https_port
Optional. Port number to secure the connection to the Administrator tool. Set this port number if you want to configure HTTPS for a node.
-KeystoreFile
-kf
keystore_file_location]
Optional. Keystore file that contains the keys and certificates required if you use the SSL security protocol with PowerCenter.
-KeystorePassword
-kp
keystore_password
Optional. If TLS is enabled, you must specify a password.
-httpProtocolType
-pt
http_protocol_type
Security protocol that the service uses. Enter one of the following values:
  • HTTP. Requests to the service must use an HTTP URL
  • HTTPS. Requests to the service must use an HTTPS URL.
  • Both. Requests to the service can use either an HTTP or an HTTPS URL.
When you set the HTTP protocol type to HTTPS or Both, you enable Transport Layer Security (TLS) for the service.
You can also enable TLS for each web service deployed to an application. When you enable HTTPS for the service and enable TLS for the web service, the web service uses an HTTPS URL. When you enable HTTPS for the service and do not enable TLS for the web service, the web service can use an HTTP URL or an HTTPS URL. If you enable TLS for a web service and do not enable HTTPS for the service, the web service does not start.
Default is HTTP.
-jvmParams
-jp
jvmParameters
JVM parameters to set:
  • The heap size allocated for Test Data Manager.
  • The time after which database connections are renewed if the TDM UI remains idle. Required if you have modified the database configuration settings to values less than the TDM defaults. Edit the values in TDM such that the values are less than the database values.
Include the JVM parameters in single quotes and then in double quotes. For example, 'value' and then "'value'".
The -Xms option is case sensitive. For example:
"'-
X
ms512m -
X
mx1024m -
XX
:MaxPermSize=512m'"
  • IDLE_TIME.
    -DIDLE_TIME=<seconds>
    . Default is 300 seconds.
  • CONNECT_TIME.
    -DCONNECT_TIME=<seconds>
    . Default is 5000 seconds.
-connPoolSize
-cp
conn_pool_size
Optional. The maximum number of idle connection instances that a pool maintains for a database connection before the maximum idle time is met. Set this value to be more than the minimum number of idle connection instances. Default is 15.
-jmxPort
jmx_port
Port number for the JMX/RMI connections to TDM. Default is 6675.
-shutdownPort
shutdown_port
Port number that controls shutdown for TDM.


Updated April 22, 2019