DB2 Database migration from Linux to Windows Steps
1. Get the ddl from linux system by using the following command. This ddl contains the table structures and associated indexes and sequesenses for a perticular Schema. db2look -d <db_name> -z <schema_name> -e |tee <Filename>.ddl 2. Export the data from the Database for a perticular schema using the following command. db2move <DB_NAME> export -sn <schema_Name> -- This will generate one .lst file and multiple .ixf,.msg files 3. Transfer the files generated in the above step to the windows system. 4. create the Database,bufferpool,tablespaces and schema manually in the windows machine using the following commands. 1. create db <DB_NAME>; ...