Articles & Content


DB2 9 LUW Core Engine Data Movement Utilities Overview: with Oracle database comparisons (G13)

Topic: 2011 NA

Subtopic: DB2 for LUW

DATE: 2011-5-6 (08:00 AM - 09:00 AM)
SPEAKERS: Burt Vialpando (IBM )

This presentation will give you an overview of each of the DB2 core engine data movement utilities: Load, Import, Export, db2move, admin_copy_schema, admin_move_table, db2relocatedb, restore from backup, split mirror and SQL replication. These will be compared to each other so that you can get a good idea of when to use and not to use each of them. To help round out the discussion a comparison to the Oracle database core engine data movement utilities will be made where applicable.

EXP. LEVEL: Intermediate


DB2 LUW core engine data movement utility overview

Getting data in and out with load, import, export and db2move

The administration stored procedures

db2relocatedb AKA "transportable databases"

Other techniques like restore from backup, split mirror, etc.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.