Migrating Data Between DB2 Servers
DB2 Support for Data Migration
When it is time to upgrade from DB2 on Intel to DB2 on Power for example, taking a backup/restore approach isn’t possible as DB2’s backups are platform dependent. The solution is to use a DB2 command called .
Basics of db2move
db2move allows to export data from DB2 at different levels of granularity. It also has a very simple syntax to allow exporting all of the data and structure of a database.
Exmaple of db2move
Where is the db2 instance owner, is where the DB2 data and structures are being exported, and is the database name.
For more DB2 Support hints, please visit our DB2 category.