Backup Overview

The simplest form of the BACKUP DATABASE command requires only that you specify the alias or name of the database that you want to back up.

For example:

					db2 backup db sample

If the command completes successfully, you will have acquired a new backup image that is located in the path or the directory from which the command was issued. It is located in this directory because the command in this example does not explicitly specify a target location for the backup image.

On the Windows operating systems, for example, this command (when issued from the root directory of the D: drive) creates an image that appears in a directory listing as follows:

					Windows:
					Directory of D:\SAMPLE.0\DB2\NODE0000\CATN0000\20020829
					08/29/2002 15:26p ...

Get Advanced DBA Certification Guide and Reference for DB2® Universal Database™ v8 for Linux®, UNIX®, and Windows® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial