Thursday, February 13, 2014

DB2 : How to take backup of database (IBM DB2 9.7, command for Linux,Unix,Windos)

To take the database backup from IBM command line we can use following command.

Backup will be observed on the given location. In case of NOT providing location in below command, backup file will be observed on location on which Command prompt is pointing.

Command:- db2 backup database <DATABASE_NAME> to <LOCATION>

LOCATION is optional in the above command.

Example:- db2 backup database SAMPLE to C:\DB2Backups

No comments: