Specific command entries are used when you back up DB2® databases.
The following table summarizes the commands that are associated
with backing up DB2 databases
according to the various database configurations and corresponding
backup types.
Table 1. Summary of backup commands for DB2 databases| Database configuration |
Snapshot backup (disk
only) |
Back up
to Tivoli® Storage Manager |
|---|
| From production database (tape only) |
Integrated with snapshot |
From existing snapshot |
|---|
| DB2 |
db2 backup ... use snapshot ... |
db2 backup ... use tsm |
db2 backup ... use snapshot ...
1 |
fcmcli -f tape_backup
2 |
| DB2 in an SAP environment |
db2 backup ... use snapshot ... |
db2 backup ... load <library> or backom |
db2 backup ... use snapshot ...
1 |
fcmcli -f tape_backup
2 |
Note: - The Tivoli Storage FlashCopy® Manager profile
parameter TSM_BACKUP is set to one of the following
options: YES, MANDATE, or LATEST,
and the offload agent (tsm4acs) is running in daemon mode on the production
server.
- The profile parameter TSM_BACKUP is set to
one of the following options: YES, MANDATE,
or LATEST, and the offload agent (tsm4acs) is not
running in daemon mode.
The
db2 backup database command with
the
use snapshot option is described in the
DB2 Command Reference guide.
The DB2 Data Partitioning Feature (DPF)
has a single system view (SSV) mode to back up a multi-partition database
with a single command entry. IBM® DB2 pureScale® uses the IBM General Parallel File System (GPFS™) software to provide data access to databases
from nodes in a clustered system environment. When you backup with
Tivoli Storage FlashCopy Manager the
typical
db2 backup commands are used in the following
format:
- Multi-partition database: Log on to one of the production hosts
and use the DB2 instance owner
ID. Issue the backup command: db2 backup db dbname on
all dbpartitionnums use snapshot
- Single partition database: Log on to the production host and use
the DB2 instance owner ID. Issue
the backup command: db2 backup db dbname use
snapshot
- DB2 pureScale database: Log on to a member
of the production database instance and use the DB2 instance owner ID. Issue the backup command
as for a single partition database: db2 backup db dbname use
snapshot
The default profile that is used by
Tivoli Storage FlashCopy Manager is
INSTANCE_DIR/profile file.
If a different
Tivoli Storage FlashCopy Manager profile
is required, enter the following command to back up and specify the
new profile:
db2 backup db <dbname> on
all dbpartitionnums use snapshot options "PROFILE=<path
to profile/name of profile>"