管理powercenter 资料库
PMREP
Usage: pmrep run
-f <script_file_name>
[-o <output_file_name>]
[-e (echo commands)]
[-s (stop at first error)]
[-u (UTF-8 encoded script fileand output file)]
Usage: pmrep connect
-r <repository_name>
-d <domain_name>
-n <user_name>
-x <password>
[-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 objectversioning)]
Usage: pmrep delete
[-x<repository_password_for_confirmation> |
-X<repository_password_environment_variable_for_confirmation>]
[-f (forceful delete:unregisters local repositories and deletes)]
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 globalrepository)]
[-y (enable objectversioning)]
[-b (skip workflow andsession logs)]
[-j (skip deployment grouphistory)]
[-q (skip MX data)]
[-f (skip taskstatistics)]
[-a (as new repository)]
[-e (exit if domain namein the binary file is different from current domain name)]
Usage: pmrep backup
-o <output_file_name>
[-d <description>]
[-f (overwrite existingoutput file)]
[-b (skip workflow andsession logs)]
[-j (skip deploy grouphistory)]
[-q (skip MX data)]
[-v (skip task statistics)]
Usage: pmrep registerplugin
-i<input_registration_file_name_or_path>
[-e (updateplug-in)]
[-l<NIS_login>
[-w <NIS_password> |
-W<NIS_password_environment_variable>]
[-k (CRC check onsecurity library)]]
[-N (is nativeplug-in)]
Usage: pmrep unregisterplugin
-v<vendor_id>
-l<plug-in_id>
[-s (is securitymodule)
[-g (removeuser-name-login mapping)]
{-w <new_password>|
-W<new_password_environment_variable>}]
Usage: pmrepinstallabapprogram
-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 (enableoverride)
-o <override_name> }
[-a(authority check)]
[-n (usenamespace)] }
[-d<development_class_name>]
Usage: pmrepgenerateabapprogramtofile
-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 (usenamespace)]
Usage: pmrepuninstallabapprogram
-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; notusing -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; notusing -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 forSybase ASE and MS SQL Server connection)]
[-b <database_name> (validfor Sybase ASE, Teradata and MS SQL Server connection)]
[-v <server_name> (valid forSybase ASE and MS SQL Server connection)]
[-d <domain_name> (valid forMS SQL Server connection only)]
[-t (enable trusted connection,valid for MS SQL Server connection only)]
[-a <data_source_name> (validfor Teradata connection only)]
[-x (enableadvanced security, lets users give Read, Write and Execute permissions only forthemselves.)]
[-k<connection_attributes> (attributes have the formatname=value;name=value; and so on)]
Usage: pmrepswitchconnection -o<old_connection_name> -n<new_connection_name>
Usage: pmrepdeleteconnection -n<connection_name> [-f (forcedelete)]
[ -s <connection type application,relational, ftp, loader or queue > ]
Usage: pmreplistconnections [-t (output includesconnection subtype)]
Usage: pmrepgetconnectiondetails
-n<connection name>
-t<connection type>
Usage: pmrep deleteobject
-o <objecttype>
-f <foldername>
-n <object name> (for source, usedbdname.sourcename and for all other objects use objectname)
[-s < dbd_seperator>]
Usage: pmrepshowconnectioninfo
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 typeapplication, relational, ftp, loader or queue > ]
[-l <codepage>]
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, or frozennodeploy)]
[-u <os_profile>]
Usage: pmreplistuserconnections
Usage: pmrepkilluserconnection
{-i<connection_id> |
-n<user_name> |
-a (kill all)}
Usage: pmrep truncatelog
-t<logs_truncated> (all or up to end time in MM/DD/YYYY HH24:MI:SS formator 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 includeparent 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-fkdependency)]
[-g (acrossrepositories)]
[-m (move label)]
[-c <comments>]
[-e <dbd_seperator>]
Usage: pmrepcreatedeploymentgroup
-p<deployment_group_name>
[-t<deployment_group_type (static or dynamic)>]
[-q <query_name>]
[-u<query_type (shared or personal)>]
[-c<comments>]
Usage: pmrepdeletedeploymentgroup
-p<deployment_group_name>
[-f(force_delete)]
Usage: pmrepcleardeploymentgroup
-p<deployment_group_name>
[-f(force_clear)]
Usage: pmrepaddtodeploymentgroup
-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: pmreplistobjectdependencies
{{-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 (acrossrepositories)]
[-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 a different domain)
[-l<log_file_name>]
Usage: pmreprollbackdeployment
-p<deployment_group_name>
-t <nth_latest_deploy_run>
Usage: pmrepdeploydeploymentgroup
-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>]
Usage: pmrep objectimport
-i<input_xml_file_name>
-c <control_file_name>
[-l<log_file_name>]
[-p (retainpersistent 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-fkdependency)]
[-s (export objectsreferred by shortcut)]
[-b (exportnon-reusable dependents)]
[-r (export reusabledependents)]
-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 uponvalid)
[-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 purgedobjects only)]
[-b (verbose)]
[-c (check deploymentgroup 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 local repository is in adifferent 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 adifferent domain)
Usage: pmrep notify
-m <message>
Usage: pmrep help
help [command].
Usage: pmrep -help
help [command].
Usage: pmrep cleanup