Skip to content

Migrating Data Between DB2 Servers

Pete

2010-10-28

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.

NewPush Events

Upcoming webinars

Security Automation for SOAR and Remediation in Higher Education

John McClure, CISO, Laureate

Register

Successful delivery of RPA for IT Compliance

Mark Johnson, Senior Principal, EY

Register

RPA in Higher Education

Jeff Tannebaum, VP IT Compliance, Laureate

Register

logo

We focus on reliability, quality, and value.

© 2020, All rights reserved. | NewPush LLC. | newpush.com