Db2move command details

Db2move command details db2move <database-name> <action> [<option> <value>] First, you must specify the database name (the database where the table to be moved is located) and the operations (export, import, or load) to be executed ). Specify an option to define the operation range. For example, you can restrict an operation to a specific table (-tn), tablespace (-ts), table creator (-tc), or schema name (-sn. A specified table, tablespace, or a subset of the table creator is only valid for the export operation. If multiple values are specified, they must be separated by commas. spaces are not allowed between values. You can specify up to 10 items. The table creation command will be exported at the same time at www.2cto.com Export! You can also specify the-tf option. A file name is used as the parameter to list the table name to be exported. In this file, only one full table name can be listed in each row. You can also specify the following:-io import-option specifies a mode that DB2's import tool can run. Valid options include CREATE, INSERT, INSERT_UPDATE, REPLACE, and REPLACE_CREATE. The default value is REPLACE_CREATE. Www.2cto.com-lo load-option specifies a mode that DB2's load tool can run. Valid options include INSERT and REPLACE. The default value is INSERT. -L lobpaths specifies the location of the LOB file to be created or searched. One or more absolute path names must be specified. If multiple absolute paths are specified, they must be separated by commas. spaces are not allowed between values. The default value is the current directory. -U userid specifies a user ID, which can be used to log on to the remote system. -P password indicates the password to authenticate the user. This tool requires a valid user ID and password to log on to the remote system. Db2move is a DB2 data transfer command used for data transfer between different operating systems (such as linux and windows. you can first use db2move export to export data, and then use db2move import or db2move load to import data in another DB2. export method: Create an empty folder and use db2move Mydatabase export to export data. import method: Enter the exported folder and enter the command db2move Newdb load. In actual operations, when using load, the table integrity constraints may be damaged, you need to execute set integrity for <tablename> immediate checked to remove the status of the table check pending. However, in some bad cases, the system will automatically create tables during db2move, but only tables. The views and indexes of tables need to be created on their own.) After importing data, use scripts to create indexes, views, and authorizations. This prevents damage to table integrity.