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: IntermediateOBJECTIVES:DB2 LUW core engine data movement utility overviewGetting data in and out with load, import, export and db2moveThe administration stored proceduresdb2relocatedb AKA "transportable databases"Other techniques like restore from backup, split mirror, etc.
4569 Technology DriveSte 1 Wilmington, NC 28405Phone: (910) 660-8649Fax: (910) 523-5504