Backing up table spaces
This type of backup allows you to back up single or multiple table spaces, while users are connected to the database.
Getting ready
DB2 can back up the table space with users connected, but it is always preferable to do it when nobody is connected.
How to do it...
There is no need to connect to the database; the backup utility will initiate the connection. This is the tablespace backup we made earlier:
[db2inst1@nodedb21 ~]$ db2 "BACKUP DATABASE POS TABLESPACE ( POS_TBLS ) ONLINE TO "/xchng/backups" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING" Backup successful. The timestamp for this backup image is : 20111125232007
How it works...
The table space will be backed up to this file: POS.3.db2inst1.NODE0000.CATN0000.20111125232007.001. Note the POS.3 at the beginning of the filename that indicates the backup type:
[db2inst1@nodedb21 ~]$ cd /xchng/backups [db2inst1@nodedb21 backups]$ ls -al *20111125232007* -rw------- 1 db2inst1 dba 12603392 2011-11-25...
