Chapter 6. Database administration 133
6.1.3 Backup command and authorities required
The BACKUP DATABASE command creates a backup copy of a database or a table
space. The syntax for the backup command is:
BACKUP DATABASE database-alias [USER username [USING password]]
[TABLESPACE (tblspace-name [ {,tblspace-name} ... ])] [ONLINE]
[OPTIONS {options-string | options-filename}] | TO dir/dev
[ {,dir/dev} ... ] | LOAD lib-name [OPEN num-sess SESSIONS]
[OPTIONS {options-string | options-filename}]]
[WITH num-buff BUFFERS] [BUFFER buffer-size] [PARALLELISM n]
[COMPRESS [COMPRLIB lib-name [EXCLUDE]] [COMPROPTS options-string]]
The simplest form of the database backup command is shown in Example 6-1.
Example 6-1 Offline database backup command
db2 backup database QA78RBA to /dbbkup/qa78rba/ucsdb2
Backup successful. The timestamp for this backup image is : 20050710131120
The backup can also be performed using the Control Center.
To open a Control Center:
򐂰 In Windows, click Start Programs IBM DB2 General
Administration Tools Control Center.
򐂰 In Linux, open the IBM DB2 folder on the desktop and click Control Center.
򐂰 In UNIX, enter the db2cc command from a terminal session.
Right-click on the database and select Backup.
Back up of database to disk provides the fastest I/O. However, disks are
expensive for backup storage. Running the database backup to multiple disks/
devices at the same time will decrease backup time.
Authorities required for database backup
Performing backup requires one of the following authorizations:
򐂰 System Administrator (SYSADM)
򐂰 System Control (SYSCTRL)
򐂰 System Maintenance (SYSMAINT)

Get Siebel 7.8 with IBM DB2 UDB V8.2 Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.