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.Interested? Click here to contact us for a free consultation →