db2move and db2look utilities as alternative backup methods
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.
Getting ready
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.
How to do it...
Choose a proper directory:
[db2inst1@nodedb21 ~]$ cd /xchng/exports/pos/Check if enough space is available:
[db2inst1@nodedb21 pos]$ df . Filesystem Size Used Avail Use% Mounted on /dev/sdb1 459G 64G 372G 15% /xchng
Do the export:
In this case, we chose to export all the
POSschema...
