Monday, January 08, 2007

Informatica 7.1: All available tasks can be done by pmrep

run
-f #script file name#
[-o #output file name#]
[-e #echo commands#]
[-s #stop at first error#]

connect
-r #repository name#
-n #repository user name#
[-x #repository password# |
-X #repository password environment variable#]
-h #repserver host name#
-o #repserver port number#

backup
-o #output file name#
-f (overwrite existing output file)
-d #description#
[-b (skip workflow/session logs)]
[-j (skip deploy group history)]
[-q (skip MX data)]

updatestatistics

updateemailaddr
-d #folder name#
-s #session name#
-u #success email address#
-f #failure email address#

updatesrvvar
-s #server name#
-v #variable name#
-u #new value#

updatetargprefix
-f #folder name#
-s [#qualifying path#.]#session name#
[-t #target name#]
-p #prefix name#
-n

updatesrcprefix
-f #folder name#
-s [#qualifying path#.]#session name#
[-t #source name#]
-p #prefix name#
-n

updateseqgenvals
-f #folder name#
[-m #mapping name#]
-t #sequence generator name#
[-s #start value#]
[-e #end value#]
[-i #increment by#]
[-c #current value#]

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

listtablesbysess
-f #folder name#
-s [#qualifying path#.]#session name#
-t #source or target#

listallusers

listallgroups

createuser
-u #repository user name#
[{-p #password#
-c #password again#} |
-P #password environment variable#]
[-d #description#]
[-g #group name#]
[-i #contact info# ] }

registeruser
-u #repository user name#
-l #external login#
[-d #description#]
[-g #group name#]
[-i #contact info# ] }

rmuser
-u #repository user name#

changepasswd
[{-p #new password#
-c #password again#} |
-P #new password environment variable#]

edituser
-u #repository user name#
[{-p #new password#
-c #password again#} |
-P #new password environment variable#]
[ -l #new login# ]
[ -d #new description# ]
[ -e #enabled: yes|no# ]
[ -i #contact info# ]

addusertogroup
-u #repository user name#
-g #group name#

rmuserfromgroup
-u #repository user name#
-g #group name#

creategroup
-g #group name#
[-d #description#]

rmgroup
-g #group name#

listallprivileges

addprivilege
-p #privilege#
{ [-u #repository user name#]
[-g #group name#] }

rmprivilege
-p #privilege#
{ [-u #repository user name#]
[-g #group name#] }

createconnection
-s #relational connection subtype#
-n #connection name#
-u #user name#
[-p #password# |
-P #password environment variable#]
[-c (connect string, required for Oracle, Informix, Db2 and ODBC)]
-l #code page#
[-r (Rollback Segment, valid for Oracle connection only)]
[-e (Environment SQL)]
[-z (Packet Size, valid for Sybase and MS SQL Server connection)]
[-b (Database Name, valid for Sybase, Teradata and MS SQL Server connection)]
[-v (Server Name, valid for Sybase and MS SQL Server connection)]
[-d (Domain Name, valid for MS SQL Server connection only)]
[-t (1 for Trusted Connection, valid for MS SQL Server connection only)]
[-a (Data Source Name, valid for Teradata connection only)]

switchconnection
-o #old connection name#
-n #new connection name#

deleteconnection
-n #relational connection name#
[-f (force delete)]

showconnectioninfo

updateconnection
-t #database type#
-d #database connection name#
-u #new user name#
[-p #new database password# |
-P #new database password environment variable#]
-c #new database connection string#

updateserver
-v #server name#
[-h #new host name#]
[-k #new servername#]
[-o #new port number#]
[-t #new timeout value#]
[-p #new protocol name#]
[-l #new codepage name#]

deleteserver
-v #server name#

addserver
-v #server name#
-h #new host name#
[-o #new port number#]
[-t #new timeout value#]
[-p #new protocol name#]
[-l #new codepage name#]

createFolder
-n #folder name#
[-d #folder description#]
[-o #owner name#]
[-g #group name#]
[-s #shared folder#]
[-p #permissions#]

deleteFolder
-n #folder name#

modifyFolder
-n #folder name#
[-d #folder description#]
[-o #owner name#]
[-g #group name#]
[-s #shared folder#]
[-p #permissions#]
[-r #new name#]

truncatelog
-t #all | #endtime# (MM/DD/YYYY HH24:MI:SS)#
[-f #folder name#]
[-w #workflow name#]

createlabel
-a #label name#
[-c #comments#]

deletelabel
-a #label name#
[-f #force delete#]

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

createdeploymentgroup
-p #deployment group name#
[-t #deployment group type (static or dynamic)#]
{ [-q #query name#]
[-u #query type (shared or personal)#] }
[-c #comments#]

deletedeploymentgroup
-p #deployment group name#
[-f #force delete#]

cleardeploymentgroup
-p #deployment group name#
[-f #force clear#]

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

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

checkin
-o #object type#
[-t #object subtype#]
-n #object name#
-f #folder name#
-c #comments#

undocheckout
-o #object type#
[-t #object subtype#]
-n #object name#
-f #folder name#

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

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 #output persistent file name#]
[-a #append#]
[-c #column separator]
[-r #end-of-record separator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

deployfolder
-f #folder name#
-c #control file name#
-r #target repository name#
[-n #target repository user name#
[-x #target repository password# |
-X #target repository password environment variable#]
-h #target repserver host name#
-o #target repserver port number#]
[-l #log file name#]

deploydeploymentgroup
-p #deployment group name#
-c #control file name#
-r #target repository name#
[-n #target repository user name#
[-x #target repository password# |
-X #target repository password environment variable#]
-h #target repserver host name#
-o #target repserver port number#]
[-l #log file name#]

objectimport
-i #input xml file name#
-c #control file name#
[-l #log file name#]

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

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 #output persistent file name#]
[-a #append#]
[-c #column separator]
[-r #end-of-record separator#]
[-l #end-of-listing indicator#]
[-b #verbose#]

addrepository
-h #repserver host name#
-o #repserver port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#
-t #database type#
-u #database user name#
[-p #database password# |
-P #database password environment variable#]
[-m (Trusted Connection, valid for Microsoft SQL Server only)]
-c #database connect string#
[-d #code page name#]
[-e #DB2 tablespace name#]

stoprepository
[-a #repserver password# |
-A #repserver password environment variable#]
[-h #hostname#
-o #port number#
-r #repository name#]

enablerepository
-h #hostname#
-o #port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#

disablerepository
-h #hostname#
-o #port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#

register
-r #repository name#
-n #repository user name#
[-x #repository password# |
-X #repository password environment variable#]
[-a #GDR repserver password#
-A #GDR repserver password environment variable#]
[-h #LDR host name# (only if LDR is managed by a different RepServer)
-o #LDR port number# (only if LDR is managed by a different RepServer)]

unregister
-r #repository name#
-n #repository user name#
[-x #repository password# |
-X #repository password environment variable#]
[-a #GDR repserver password#
-A #GDR repserver password environment variable#]
[-h #LDR host name# (only if LDR is managed by a different RepServer)
-o #LDR port number# (only if LDR is managed by a different RepServer)]

notify
-h #hostname#
-o #port number#
[-a #repserver password# |
-A #repserver password environment variable#]
-r #repository name#
-t #notify | broadcast# (message type)
-m #message#

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

cleanup
help completed successfully.

Labels:

0 Comments:

Post a Comment

<< Home