Articles & Content

Archives

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

Topic: DB2 for LUW

Subtopic: 2011



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

OBJECTIVES:

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.