DB2知识文档-3

 

如何使用DB2MOVE

Db2move DB_NAME action <options> -u USERID –p PASSWORD

Action:export,import,load

Options如下：

Option		Default	Notes
-tc	table-creators	all_creators	EXPORT.Wildcard
-tn	table-names	all_user_tables	EXPORT.Wildcard
-sn	schema-names	all_schemas	EXPORT.Wildcard
-ts	tblspace-names	all_tablespace	EXPORT.Wildcard
-tf	tables	from	file
-io	import-option	REPLACE_CREATE	IMPORT_only.
-lo	load-option	INSERT	LOAD_only.
-l	lobpaths	current_dir	separated_by_commas.NO
-u	userid	logged_on_userid
-p	password	logged_on_password
-aw	allow-warnings	false	include
	warnings	during	export.

例如：

Db2move ehrdb export –u ehr –p ehr

Db2move ehrdb import –u her –p ehr