informatica 的shell command集合

命令和相关参数

Usage: pmrep run

-f <script_file_name>

[-o <output_file_name>]

[-e (echo commands)]

[-s (stop at first error)]

[-u (UTF-8 encoded script file and output file)]

Usage: pmrep connect（会产生一个连接配置文件，多人使用时，需要更改该文件的权限）

-r <repository_name>

{-d <domain_name> |

{-h <portal_host_name>

-o <portal_port_number>}}

[-n <user_name>

[-s <user_security_domain>]

[-x <password> |

-X <password_environment_variable>]]

[-t <client_resilience>]

Usage: pmrep create

-u <domain_user_name>

[-s <domain_user_security_domain>]

[-p <domain_password> |

-P <domain_password_environment_variable>]

[-g (create global repository)]

[-v (enable object versioning)]

Usage: pmrep delete

[-x <repository_password_for_confirmation> |

-X<repository_password_environment_variable_for_confirmation>]

[-f (forceful delete: unregisters local repositories anddeletes)]

Usage: pmrep upgrade

[-x <repository_password_for_confirmation> |

-X<repository_password_environment_variable_for_confirmation>]

Usage: pmrep restore

-u <domain_user_name>

[-s <domain_user_security_domain>]

[-p <domain_password> |

-P <domain_password_environment_variable>]

-i <input_file_name>

[-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 fromcurrent domain name)]

Usage: pmrep backup

-o <output_file_name>

[-d <description>]

[-f (overwrite existing output file)]

[-b (skip workflow and session logs)]

[-j (skip deploy group history)]

[-q (skip MX data)]

[-v (skip task statistics)]

Usage: pmrep registerplugin

-i <input_registration_file_name_or_path>

[-e (update plug-in)]

[-l <NIS_login>

[-w <NIS_password> |

-W <NIS_password_environment_variable>]

[-k (CRC check on security library)]]

[-N (is native plug-in)]

Usage: pmrep unregisterplugin

-v <vendor_id>

-l <plug-in_id>

[-s (is security module)

[-g (remove user-name-login mapping)]

{-w <new_password> |

-W <new_password_environment_variable>}]

Usage: pmrep installabapprogram

-s <folder_name>

-m <mapping_name>

[-v <version_number>]

[-l <log_filename>]

-u <user_name>

-x <password>

-c <connect_string>

-t <client>

[-y <language>]

{-f <input_file> |

-p <program_mode (file, stream)>

{-e (enable override)

-o <override_name> }

[-a (authority check)]

[-n (use namespace)] }

[-d <development_class_name>]

Usage: pmrep generateabapprogramtofile

-s <folder_name>

-m <mapping_name>

[-v <version_number>]

[-l <log_filename>]

-u <user_name>

-x <password>

-c <connect_string>

-t <client>

[-y <language>]

-p <program_mode (file, stream)>

-f <output_file_location>

{-e (enable override)

-o <override_name> }

[-a (authority check)]

[-n (use namespace)]

Usage: pmrep uninstallabapprogram

-s <folder_name>

-m <mapping_name>

[-v <version_number>]

[-l <log_filename>]

-u <user_name>

-x <password>

-c <connect_string>

-t <client>

[-y <language>]

-p <program_mode (file, stream)>

Usage: pmrep updatestatistics

Usage: pmrep updateemailaddr

-d <folder_name>

-s <session_name>

-u <success_email_address>

-f <failure_email_address>

Usage: pmrep updatetargprefix

-f <folder_name>

-s [<qualifying_path>.]<session_name>

[-t <target_name>]

-p <prefix_name>

[-n (use target instance name; not using -n gives old,deprecated behavior)]

Usage: pmrep updatesrcprefix

-f <folder_name>

-s [<qualifying_path>.]<session_name>

[-t <source_name>]

-p <prefix_name>

[-n (use source instance name; not using -n gives old,deprecated behavior)]

Usage: pmrep updateseqgenvals

-f <folder_name>

[-m <mapping_name>]

-t <sequence_generator_name>

[-s <start_value>]

[-e <end_value>]

[-i <increment_by>]

[-c <current_value>]

Usage: pmrep listobjects

-o <object_type>

[-t <object_subtype>]

[-f <folder_name>]

[-c <column_separator>]

[-r <end-of-record_indicator>]

[-l <end-of-listing_indicator>]

[-b (verbose)]

[-s < dbd_seperator>]

Usage: pmrep massupdate

-t <session_property_type (session_property,session_config_property,

transformation_instance_attribute,session_instance_runtime_option) >

-n <session_property_name>

-v <session_property_value>

[-w <transformation_type>]

{-i <persistent_input_file> |

-f <folder_name>}

[-o <condition_operator (equal, unequal, less, greater) >]

[-l <condition_value>]

[-g (update_session_instance_flag)]

[-m (test_mode)]

[-u <output_log_file_name>]

Usage: pmrep listtablesbysess

-f <folder_name>

-s [<qualifying_path>.]<session_name>

-t <object_type_listed> (source or target)

Usage: pmrep createconnection

-s <connection_type>

-n <connection_name>

-u <user_name>

[-p <password> |

-P <password_environment_variable>]

[-c <connect_string> (required for Oracle, Informix, DB2,ODBC, NetezzaRelational and NEOVIEW)]

-l <code_page>

[-r <rollback_segment> (valid for Oracle connection only)]

[-e <connection_environment_SQL>]

[-f <transaction_environment_SQL>]

[-z <packet_size> (valid for Sybase ASE and MS SQL Serverconnection)]

[-b <database_name> (valid for Sybase ASE, Teradata and MSSQL Server connection)]

[-v <server_name> (valid for Sybase ASE and MS SQL Serverconnection)]

[-d <domain_name> (valid for MS SQL Server connectiononly)]

[-t (enable trusted connection, valid for MS SQL Serverconnection only)]

[-a <data_source_name> (valid for Teradata connectiononly)]

[-x (enable advanced security, lets users give Read, Write andExecute permissions only for themselves.)]

[-k <connection_attributes> (attributes have the formatname=value;name=value; and so on)]

Usage: pmrep switchconnection

-o <old_connection_name>

-n <new_connection_name>

Usage: pmrep deleteconnection

-n <connection_name>

[-f (force delete)]

[ -s <connection type application, relational, ftp, loader orqueue > ]

Usage: pmrep listconnections

[-t (output includes connection subtype)]

Usage: pmrep getconnectiondetails

-n <connection name>

-t <connection type>

Usage: pmrep deleteobject

-o <object type>

-f <folder name>

-n <object name> (for source, use dbdname.sourcename andfor all other objects use objectname)

[-s < dbd_seperator>]

Usage: pmrep showconnectioninfo

Usage: pmrep updateconnection

-t <connection_subtype >

-d <connection_name>

[-u <new_user_name>]

[-p <new_password> |

-P <new_password_environment_variable>]

[-c <new_connection_string>]

[-a <attribute_name>

-v <new_attribute_value>]

[ -s <connection type application, relational, ftp, loader orqueue > ]

[-l <code page>]

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

Usage: pmrep deleteFolder

-n <folder_name>

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, orfrozennodeploy)]

[-u <os_profile>]

Usage: pmrep listuserconnections

Usage: pmrep killuserconnection

{-i <connection_id> |

-n <user_name> |

-a (kill all)}

Usage: pmrep truncatelog

-t <logs_truncated> (all or up to end time in MM/DD/YYYYHH24:MI:SS format or as number of days before current date)

[-f <folder_name>]

[-w <workflow_name>]

Usage: pmrep AssignPermission

-o <object_type>

[-t <object_subtype>]

-n <object_name>

{-u <user_name> |

-g <group_name>}

[-s <security_domain>]

-p <permission>

Usage: pmrep ChangeOwner

-o <object_type>

[-t <object_subtype>]

-n <object_name>

-u <new_owner_name>

[-s <security_domain>]

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

[-n (do not include parent path)]

[-s < dbd_seperator>]

Usage: pmrep createlabel

-a <label_name>

[-c <comments>]

Usage: pmrep deletelabel

-a <label_name>

[-f (force_delete)]

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

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

Usage: pmrep deletedeploymentgroup

-p <deployment_group_name>

[-f (force_delete)]

Usage: pmrep cleardeploymentgroup

-p <deployment_group_name>

[-f (force_clear)]

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

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

[-s < dbd_seperator>]

Usage: pmrep checkin

-o <object_type>

[-t <object_subtype>]

-n <object_name>

-f <folder_name>

[-c <comments>]

[-s < dbd_seperator>]

Usage: pmrep undocheckout

-o <object_type>

[-t <object_subtype>]

-n <object_name>

-f <folder_name>

[-s < dbd_seperator>]

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

[-e < dbd_seperator>]

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 adifferent domain)

[-l <log_file_name>]

Usage: pmrep rollbackdeployment

-p <deployment_group_name>

-t <nth_latest_deploy_run>

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 adifferent domain)

[-l <log_file_name>]

Usage: pmrep objectimport (导入xml是需要配置control file的）

-i <input_xml_file_name>

-c <control_file_name>

[-l <log_file_name>]

[-p (retain persistent value)]

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 byshortcut)]

[-b (export non-reusable dependents)]

[-r (export reusable dependents)]（这三个选项影响导出时子节点的内容）

-u <xml_output_file_name>

[-l <log_file_name>]

[-e < dbd_seperator>]

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

Usage: pmrep version

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

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 localrepository 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 localrepository is in a different domain)