Table of Contents


  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 idp Command Reference
  16. infacmd edp 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 roh Command Reference
  30. infacmd rms Command Reference
  31. infacmd rtm Command Reference
  32. infacmd sch Command Reference
  33. infacmd search Command Reference
  34. infacmd sql Command Reference
  35. infacmd tdm Command Reference
  36. infacmd tools Command Reference
  37. infacmd wfs Command Reference
  38. infacmd ws Command Reference
  39. infacmd xrf Command Reference
  40. infacmd Control Files
  41. infasetup Command Reference
  42. pmcmd Command Reference
  43. pmrep Command Reference
  44. Working with pmrep Files

Metadata Manager Service Options

Metadata Manager Service Options

Enter Metadata Manager Service options in the following format:
infacmd isp CreateMMService ... -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 the Metadata Manager Service options:
Required. Port number for the Metadata Manager Agent. The agent uses this port to communicate with metadata source repositories. Default is 10251.
Required. Code page description for the Metadata Manager repository. To enter a code page description that contains a space or other non-alphanumeric character, enclose the name in quotation marks.
Required. Native connect string for the Metadata Manager repository database.
Required. User account for the Metadata Manager repository database.
Required. Password for the Metadata Manager repository database user. User password. 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.
Required. Host name for the Metadata Manager repository database.
Required. Full service name or SID for Oracle databases. Service name for IBM DB2 databases. Database name for Microsoft SQL Server database.
Required. Port number for the Metadata Manager repository database.
Required. Type of database for the Metadata Manager repository.
Optional. Level of error messages written to the Metadata Manager Service log. Default is ERROR.
Required. Location of the files used by the Metadata Manager application.
Optional. Additional JDBC options.
You can use this property to specify the following information:
  • Backup server location
  • Oracle Advanced Security Option (ASO) parameters
  • Microsoft SQL Server authentication parameters
  • Additional JDBC parameters when secure communication is enabled for the Metadata Manager repository database
For more information about these parameters, see the
Informatica Application Service Guide
Optional. Maximum number of request processing threads available, which determines the maximum number of client requests that Metadata Manager can handle simultaneously. Default is 100.
Optional. Amount of RAM in megabytes allocated to the Java Virtual Manager (JVM) that runs Metadata Manager. Default is 512.
Optional. Maximum queue length for incoming connection requests when all possible request processing threads are in use by the Metadata Manager application. Default is 500.
Optional. Number of active connections to the Metadata Manager repository database available. The Metadata Manager application maintains a connection pool for connections to the repository database. Default is 20.
Optional. Amount of time in seconds that Metadata Manager holds database connection requests in the connection pool. Default is 180.
Optional. Number of child objects that appear in the Metadata Manager metadata catalog for any parent object. Default is 100.
Connection mode the Integration Service uses to connect to metadata sources and the Metadata Manager repository when loading resources. Value can be true or false.
You must set this property to True if the Integration Service runs on a UNIX machine and you want to load metadata from a Microsoft SQL Server database or if you use a Microsoft SQL Server database for the Metadata Manager repository.
Required if you select Oracle for the DatabaseType. Oracle connection type. You can enter one of the following options:
  • OracleSID
  • OracleServiceName
Required. Port number the Metadata Manager application runs on. Default is 10250.
Optional. Maximum number of resources that Metadata Manager can load simultaneously. Default is 3.
Tablespace name for the Metadata Manager repository on IBM DB2.
Optional. Amount of time in minutes that Metadata Manager holds a failed resource load in the load queue. Default is 30.
Required. Indicates the security protocol that you configure for the Metadata Manager application: HTTP or HTTPS.
Required if you use HTTPS. Keystore file that contains the keys and certificates required if you use the SSL security protocol with the Metadata Manager application.


We’d like to hear from you!