Methods for moving a geodatabase in DB2

There are several options for moving a geodatabase: you can create a new geodatabase and move the data, or you can move the whole database.

Creating a new geodatabase then moving the data

You can create a new IBM DB2 database, create a geodatabase in it, then move your existing data to the new geodatabase. This can be done using copy and paste, the export tool, the Extract Data wizard, or XML workspace documents in ArcGIS.

Be aware that the user who logged in when loading the data to the new geodatabase will own the data. If you want the data to have the same owner in the new geodatabase, have each user move their own data.

Moving a DB2 database

To move a geodatabase stored in a DB2 database management system (DBMS) and ensure you include all the necessary database objects, back up the database that you want to transfer and restore it to your target server. Doing this achieves the following:

NoteNote:

You need to create your database on the destination machine with the correct code page before you perform the restore operation if the source and destination aren't using the default code page. If you do not do this and your production code page is different from that of the source, the restore utility assumes the default code page. This results in an SQL2548N error.

See the IBM DB2 Information Center documentation for instructions on creating backups of and restoring DB2 databases.

11/6/2014