Performing an offline database backup

An offline backup is the sole option for backups on a circular logging database, and is used especially for small databases, such as a tools catalog database. This is different from a cold backup, since you have to connect to the database as instance owner, or a user that has database administration authority to perform the backup.

Getting ready

You will have to clear any sessions accessing the database. Allow for downtime and space for a full backup of the database.

How to do it...

1. Quiesce the database:

   [db2inst1@nodedb21 ~]$ db2 "CONNECT TO POS"
   
      Database Connection Information
   
    Database server        = DB2/LINUXX8664 9.7.4
    SQL authorization ID   = DB2INST1
    Local database alias   = POS
   [db2inst1@nodedb21 ~]$ db2 "QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS"
   DB20000I  The QUIESCE DATABASE command completed successfully.
   [db2inst1@nodedb21 ~]$ db2 "CONNECT RESET"
   DB20000I  The SQL command completed successfully.
   

2. Back up the database, offline:

   [db2inst1...