The implementation of DB2 database backup and recovery is in the Linux environment

This article describes how to back up and restore a DB2 database in a Linux environment. The following article describes how to back up and restore a DB2 database in a Linux environment, I hope it will help you in this regard.

Solution, Linux, environment, database Linux, database, Environment

Restore the database backed up by the following backup script

Backup script:

 
 

  
  
./Home/db2admin/sqllib/db2profile
  
  
Db2 backup db datedb online to/dbbackup/date include logs
  
  
Cd/dbbackup/datetoday = 'date + "% Y % m % d "'
  
  
File1 = "* $ today *"
  
  
Ftpfile = 'ls $ file1'
  
  
Echo $ ftpfile
  
  
Lftp-c "open ftp address; user username and password @ \ $0; put $ ftpfile"
  
  
Find/dbbackup/date-ctime + 15-exec rm {}\;
 
 

Recovery command:

Log on to the server using the root command and switch to the database user name using the su-db2admin command.

Go to the backup file storage directory

Run the following command:

 
 

  
  
[db2admin@localhost db2back]$ db2 restore db datedb from /hom  
 
 

The above content is an introduction to the backup and recovery of the DB2 database in the Linux environment. I hope you will have some gains.

The above content describes the backup and recovery of the DB2 database in the Linux environment, hoping to provide you with some help in this regard.