INFORMATICA PMREP COMMANDS

pmrep is a customizable performance metrics reporting tool.  Any
       available performance metric, live or archived, system and/or
       application, can be selected for reporting using one of the output
       alternatives listed below together with applicable formatting
       options.

Commands

1. Usage: pmrep run
   -f
   [-o ]
   [-e (echo commands)]
   [-s (stop at first error)]
   [-u (UTF-8 encoded script file and output file)]
2. Usage: pmrep connect
   -r
   {-d |
   {-h -o }}
   [{-n
   [-s ]
   [-x |
   -X ]} |
   -u (connect without user in kerberos mode)]
   [-t ]
3. Usage: pmrep create
   [-u ]
   [-s ]
   [-p |
   -P ]
   [-g (create global repository)]
   [-v (enable object versioning)]
4. Usage: pmrep delete
   [-x |
   -X ]
   [-f (forceful delete: unregisters local repositories and deletes)]
5. Usage: pmrep upgrade
   [-x |
   -X ]
6. Usage: pmrep restore
   [-u ]
   [-s ]
   [-p |
   -P ]
   -i
   [-g (create global repository)]
   [-y (enable object versioning)]
   [-b (skip workflow and session logs)]
   [-j (skip deployment group history)]
   [-q (skip MX data)]
   [-f (skip task statistics)]
   [-a (as new repository)]
   [-e (exit if domain name in the binary file is different from current domain name)]
7. Usage: pmrep backup
   -o
   [-d ]
   [-f (overwrite existing output file)]
   [-b (skip workflow and session logs)]
   [-j (skip deploy group history)]
   [-q (skip MX data)]
   [-v (skip task statistics)]
8. Usage: pmrep registerplugin
   -i
   [-e (update plug-in)]
   [-l
   [-w |
   -W ]
   [-k (CRC check on security library)]]
   [-N (is native plug-in)]
9. Usage: pmrep unregisterplugin
   -v
   -l [-s (is security module)
   [-g (remove user-name-login mapping)]
   {-w |
   -W }]
10. Usage: pmrep installabapprogram
    -s
    -m [-v ]
    [-l ]
    -u
    -x -c
    -t
    [-y ]
    {-f |
    -p {-e (enable override)
    -o }
    [-a (authority check)]
    [-n (use namespace)] }
    [-d ]
11. Usage: pmrep generateabapprogramtofile
    -s
    -m [-v ]
    [-l ]
    -u
    -x -c
    -t
    [-y ]
    -p -f
    {-e (enable override)
    -o }
    [-a (authority check)]
    [-n (use namespace)]
12. Usage: pmrep uninstallabapprogram
    -s
    -m [-v ]
    [-l ]
    -u
    -x -c
    -t
    [-y ]
    -p
13. Usage: pmrep updatestatistics
14. Usage: pmrep updateemailaddr
    -d
    -s
    -u
    -f
15. Usage: pmrep updatetargprefix
    -f
    -s [.]
    [-t ]
    -p [-n (use target instance name; not using -n gives old, deprecated behavior)]
16. Usage: pmrep updatesrcprefix
    -f
    -s [.]
    [-t ]
    -p [-n (use source instance name; not using -n gives old, deprecated behavior)]
17. Usage: pmrep updateseqgenvals
    -f
    [-m ]
    -t
    [-s ]
    [-e ]
    [-i ]
    [-c ]
18. Usage: pmrep listobjects
    -o
    [-t ]
    [-f ]
    [-c ]
    [-r ]
    [-l ]
    [-b (verbose)]
    [-y (print database type)]
    [-s < dbd_seperator>]
19. Usage: pmrep massupdate
    -t
    -n
    -v
    [-w ]
    {-i |
    -f }
    [-o ]
    [-l ]
    [-g (update_session_instance_flag)]
    [-m (test_mode)]
    [-u ]
20. Usage: pmrep listtablesbysess
    -f
    -s [.]
    -t (source or target)
21. Usage: pmrep createconnection
    -s
    -n
    [{-u
    [-p |
    -P ]}|
    -K ]
    [-c (required for Oracle, Informix, DB2, Microsoft SQL Server, ODBC, and NetezzaRelational)]
    [-l ]
    [-r (valid for Oracle connection only)]
    [-e ]
    [-f ]
    [-z (valid for Sybase ASE and MS SQL Server connection)]
    [-b (valid for Sybase ASE, Teradata and MS SQL Server connection)]
    [-v (valid for Sybase ASE and MS SQL Server connection)]
    [-d (valid for MS SQL Server connection only)]
    [-t (enable trusted connection, valid for MS SQL Server connection only)]
    [-a (valid for Teradata connection only)]
    [-x (enable advanced security, lets users give Read, Write and Execute permissions only for themselves.)]
    [-k (attributes have the format name=value;name=value; and so on)]
    [-y (Provider Type (1 for ODBC and 2 for OLEDB), valid for MS SQL Server connection only)]
    [-m (UseDSN, valid for MS SQL Server connection only)]
22. Usage: pmrep switchconnection
    -o -n
23. Usage: pmrep deleteconnection
    -n
    [-f (force delete)]
    [ -s ]
24. Usage: pmrep listconnections
    [-t (output includes connection subtype)]
25. Usage: pmrep getconnectiondetails
    -n
    -t
26. Usage: pmrep deleteobject
    -o <object type>
    -f <folder name>
    -n <object name> (for source, use dbdname.sourcename and for all other objects use objectname)
    [-s < dbd_seperator>]
27. Usage: pmrep assignintegrationservice
    -f <folder name>
    -n <workflow name>
    -i <integration service name>
28. Usage: pmrep showconnectioninfo
29. Usage: pmrep updateconnection
    -t <connection_subtype >
    -d <connection_name>
    [{-u <new_user_name>
    [-p <new_password> |
    -P <new_password_environment_variable>]}|
    -K <connection_to_the_Kerberos_server>]
    [-c <new_connection_string>]
    [-a <attribute_name>
    -v <new_attribute_value>]
    [ -s <connection type application, relational, ftp, loader or queue > ]
    [-l <code page>]
30. Usage: pmrep createFolder
    -n <folder_name>
    [-d <folder_description>]
    [-o <owner_name>]
    [-a <owner_security_domain>]
    [-s (shared_folder)]
    [-p <permissions>]
    [-f <active | frozendeploy | frozennodeploy>]
31. Usage: pmrep deleteFolder
    -n <folder_name>
32. Usage: pmrep modifyFolder
    -n <folder_name>
    [-d <folder_description>]
    [-o <owner_name>]
    [-a <owner_security_domain>]
    [-s (shared folder)]
    [-p <permissions>]
    [-r <new_folder_name>]
    [-f <folder_status> (active, frozendeploy, or frozennodeploy)]
    [-u <os_profile>]
33. Usage: pmrep listuserconnections
34. Usage: pmrep killuserconnection
    {-i <connection_id> |
    -n <user_name> |
    -a (kill all)}
35. Usage: pmrep truncatelog
    -t <logs_truncated> (all or up to end time in MM/DD/YYYY HH24:MI:SS format or as number of days before current date)
    [-f <folder_name>]
    [-w <workflow_name>]
36. Usage: pmrep AssignPermission
    -o <object_type>
    [-t <object_subtype>]
    -n <object_name>
    {-u <user_name> |
    -g <group_name>}
    [-s <security_domain>]
    -p <permission>
37. Usage: pmrep ChangeOwner
    -o <object_type>
    [-t <object_subtype>]
    -n <object_name>
    -u <new_owner_name>
    [-s <security_domain>]
38. Usage: pmrep executequery
    -q <query_name>
    [-t <query_type (shared or personal)>]
    [-u <output_persistent_file_name>]
    [-a (append)]
    [-c <column_separator>]
    [-r <end-of-record_separator>]
    [-l <end-of-listing_indicator>]
    [-b (verbose)]
    [-y (print database type)]
    [-n (do not include parent path)]
    [-s < dbd_seperator>]
39. Usage: pmrep createlabel
    -a <label_name>
    [-c <comments>]
40. Usage: pmrep deletelabel
    -a <label_name>
    [-f (force_delete)]
41. Usage: pmrep applylabel
    -a <label_name>
    {{-n <object_name>
    -o <object_type>
    [-t <object_subtype>]
    [-v <version_number>]
    [-f <folder_name>]} |
    -i <persistent_input_file>}
    [-d <dependency_object_types>]
    [-p <dependency_direction (children, parents, or both)>]
    [-s (include pk-fk dependency)]
    [-g (across repositories)]
    [-m (move label)]
    [-c <comments>]
    [-e < dbd_seperator>]
42. Usage: pmrep createdeploymentgroup
    -p <deployment_group_name>
    [-t <deployment_group_type (static or dynamic)>]
    [-q <query_name>]
    [-u <query_type (shared or personal)>]
    [-c <comments>]
43. Usage: pmrep deletedeploymentgroup
    -p <deployment_group_name>
    [-f (force_delete)]
44. Usage: pmrep cleardeploymentgroup
    -p <deployment_group_name>
    [-f (force_clear)]
45. Usage: pmrep addtodeploymentgroup
    -p <deployment_group_name>
    {{-n <object_name>
    -o <object_type>
    [-t <object_subtype>]
    [-v <version_number>]
    [-f <folder_name>]} |
    -i <persistent_input_file>}
    [-d <dependency_types (all, non-reusable or none)>]
    [-s < dbd_seperator>]
46. Usage: pmrep findcheckout
    [-o <object_type>]
    [-f <folder_name>]
    [-u (all_users)]
    [-c <column_separator>]
    [-r <end-of-record_separator>]
    [-l <end-of-listing_indicator>]
    [-b (verbose)]
    [-y (print database type)]
    [-s < dbd_seperator>]
47. Usage: pmrep checkin
    -o <object_type>
    [-t <object_subtype>]
    -n <object_name>
    -f <folder_name>
    [-c <comments>]
    [-s < dbd_seperator>]
48. Usage: pmrep undocheckout
    -o <object_type>
    [-t <object_subtype>]
    -n <object_name>
    -f <folder_name>
    [-s < dbd_seperator>]
49. Usage: pmrep listobjectdependencies
    {{-n <object_name>
    -o <object_type>
    [-t <object_subtype>]
    [-v <version_number>]
    [-f <folder_name>]} |
    -i <persistent_input_file>}
    [-d <dependency_object_types>]
    [-p <dependency_direction (children, parents, or both)>]
    [-s (include pk-fk dependency)]
    [-g (across repositories)]
    [-u <persistent_output_file_name>
    [-a (append)]]
    [-c <column_separator>]
    [-r <end-of-record_separator>]
    [-l <end-of-listing_indicator>]
    [-b (verbose)]
    [-y (print database type)]
    [-e < dbd_seperator>]
50. Usage: pmrep deployfolder
    -f <folder_name>
    -c <control_file_name>
    -r <target_repository_name>
    [-n <target_repository_user_name>
    [-s <target_repository_user_security_domain>]
    [-x <target_repository_password> |
    -X <target_repository_password_environment_variable>]
    [-d <target_domain_name> |
    {-h <target_portal_host_name>
    -o <target_portal_port_number>}]] (only if target is in a different domain)
    [-l <log_file_name>]
51. Usage: pmrep rollbackdeployment
    -p <deployment_group_name>
    [-r <repository_name>]
    [-v <nth_latest_version_of_deployment_group>]
    -t <nth_latest_deploy_run>
52. Usage: pmrep deploydeploymentgroup
    -p <deployment_group_name>
    -c <control_file_name>
    -r <target_repository_name>
    [-n <target_repository_user_name>
    [-s <target_repository_user_security_domain>]
    [-x <target_repository_password> |
    -X <target_repository_password_environment_variable>]
    [-d <target_domain_name> |
    {-h <target_portal_host_name>
    -o <target_portal_port_number>}]] (only if target is in a different domain)
    [-l <log_file_name>]
53. Usage: pmrep objectimport
    -i <input_xml_file_name>
    -c <control_file_name>
    [-l <log_file_name>]
    [-p (retain persistent value)]
54. Usage: pmrep objectexport
    {{-n <object_name>
    -o <object_type>
    [-t <object_subtype>]
    [-v <version_number>]
    [-f <folder_name>]} |
    -i <persistent_input_file>}
    [-m (export pk-fk dependency)]
    [-s (export objects referred by shortcut)]
    [-b (export non-reusable dependents)]
    [-r (export reusable dependents)]
    -u <xml_output_file_name>
    [-l <log_file_name>]
    [-e < dbd_seperator>]
55. Usage: pmrep validate
    {{-n <object_name>
    -o <object_type (mapplet, mapping, session, worklet, workflow)>
    [-v <version_number>]
    [-f <folder_name>]} |
    -i <persistent_input_file>}
    [-s (save upon valid)
    [-k (check in upon valid)
    [-m <check_in_comments>]]]
    [-p <output_option_types (valid, saved, skipped, save_failed, invalid_before, invalid_after, or all)>]
    [-u <persistent_output_file_name>
    [-a (append)]]
    [-c <column separator>]
    [-r <end-of-record_separator>]
    [-l <end-of-listing_indicator>]
    [-b (verbose)]
    [-y (print database type)]
56. Usage: pmrep version
57. Usage: pmrep purgeversion
    {-d <all | time_date | num_day> |
    {-n <last_n_versions_to_keep> |
    -t <time_date | num_day>}}
    [-f <folder_name>]
    [-q <query_name>]
    [-o <output_file_name>]
    [-p (preview purged objects only)]
    [-b (verbose)]
    [-c (check deployment group reference)]
    [-s < dbd_seperator>]
    [-k (log objects not purged)]
58. Usage: pmrep register
    -r <local_respoitory_name>
    [-n <local_repository_user_name>]
    [-s <local_repository_user_security_domain>]
    [-x <local_repository_password> |
    -X <local_repository_password_environment_variable>]
    [-d <local_repository_domain_name> |
    {-h <local_repository_portal_host_name>
    -o <local_repository_portal_port_number>}] (only if local repository is in a different domain)Usage: pmrep unregister
    -r <local_repository_name>
    [-n <local_repository_user_name>]
    [-s <local_repository_user_security_domain>]
    [-x <local_repository_password> |
    -X <local_repository_password_environment_variable>]
    [-d <local_repository_domain_name> |
    {-h <local_repository_portal_host_name>
    -o <local_repository_portal_port_number>}] (only if local repository is in a different domain)

    Usage: pmrep notify
    -m <message>

    Usage: pmrep help
    help [command].
    Print help. If command is specified print help for command, else print help for all commands

    Usage: pmrep -help
    help [command].
    Print help. If command is specified print help for command, else print help for all commands

    Usage: pmrep cleanup