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 dis Queries
  16. infacmd dp Command Reference
  17. infacmd idp Command Reference
  18. infacmd edp Command Reference
  19. Infacmd es Command Reference
  20. infacmd ics Command Reference
  21. infacmd ipc Command Reference
  22. infacmd isp Command Reference
  23. infacmd ldm Command Reference
  24. infacmd mas Command Reference
  25. infacmd mi Command Reference
  26. infacmd mrs Command Reference
  27. infacmd ms Command Reference
  28. infacmd oie Command Reference
  29. infacmd ps Command Reference
  30. infacmd pwx Command Reference
  31. infacmd roh Command Reference
  32. infacmd rms Command Reference
  33. infacmd rtm Command Reference
  34. infacmd sch Command Reference
  35. infacmd search Command Reference
  36. infacmd sql Command Reference
  37. infacmd tdm Command Reference
  38. infacmd tools Command Reference
  39. infacmd wfs Command Reference
  40. infacmd ws Command Reference
  41. infacmd xrf Command Reference
  42. infacmd Control Files
  43. infasetup Command Reference
  44. pmcmd Command Reference
  45. pmrep Command Reference
  46. Working with filemanager
  47. 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
<-MRSServiceName|-mrs> model_repo_service <-MRSUserName|-rsun> model_repo_service_username <-MRSPassword|-rspd> model_repo_service_password [<-MRSSecurityDomain|-rsdn> model_repo_security_domain]
<-EnableProfiling|-ep> enable_profiling
<-DISServiceName|-dis> data_integration_service <-db_type|-dt> database_type (ORACLE, DB2, SQLSERVER or CUSTOM) <-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] [<-SSLProtocol|-sp> ssl_protocol] [<-jvmParams|-jp> jvmParameters] [<-connPoolSize|-cp> conn_pool_size] [<-jmxPort> jmx_port] [<-shutdownPort> shutdown_port] [<-hadoopDistDir> Hadoop Distribution Directory] [<-hadoopKerbSPN> Hadoop Kerberos Service Principal Name] [<-hadoopKerbKeytab> Hadoop Kerberos Keytab]
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:
/ * ? < > " |
-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.
-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.
-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.
-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 or Model 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.
-SSLProtocol
-pt
SSL Protocol
Optional. Secure Sockets Layer protocol to use. Editable if you enable Transport Layer Security (TLS).
-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.
-hadoopDistDir
-hdd
Hadoop Distribution Directory
The Hadoop distribution directory on the Test Data Manager Service node.
-hadoopKerbSPN
-hks
Hadoop Kerberos Service Principal Name
Service Principal Name (SPN) of the Data Integration Service to connect to a Hadoop cluster that uses Kerberos authentication.
Not required when you run the MapR Hadoop distribution. Required for other Hadoop distributions.
-hadoopKerbKeytab
-hkt
Hadoop Kerberos Keytab
The file path to the Kerberos keytab file on the machine on which the Data Integration Service runs.
Not required when you run the MapR Hadoop distribution. Required for other Hadoop distributions.

0 COMMENTS

We’d like to hear from you!