Sometimes backups may not be transportable to another operating system, or you may have to copy only a subset of a database, or perhaps just a schema. Since the backup command does not support these operations, we can still use db2move
and db2look
for alternate backups.
db2look
is useful with extracting DDL, or data definition language, so we can recreate database objects, if need be. db2move
will take care of data movement.
Allow for sufficient space and time for data extraction. We suggest you have a separate drive or filesystem for these, especially if you intend to have huge tables copied this way.