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
su - db2inst1
db2move sample export
db2inst1 is the db2 instance owner,
/tmp/db2export is where the DB2 data and structures are being exported, and
sample is the database name.
For more DB2 Support hints, please visit our DB2 category.