DB2 database backup example classic edition

Today we will introduce you to the DB2 database backup example. If you are interested in the DB2 database backup example, you can click the following article to view it, the following is a detailed description of the relevant content, hoping to help you in this regard.

Database, example database, Example

Example 1

In the following example, the database SAMPLE is backed up to the TSM server that uses two concurrent TSM client sessions. The backup utility calculates the optimum number of buffers. The optimal buffer size is calculated based on the memory size and the number of available target devices. The value is 4 KB ). You can also automatically calculate the concurrency settings based on the number of available processors and the number of tablespaces to be backed up.

 
 

  
  
db2 backup database sample use tsm open 2 sessions with 4 buffers  
  
  
db2 backup database payroll tablespace (syscatspace, userspace1) to  
  
  
/dev/rmt0, /dev/rmt1 with 8 buffers without prompting  
 
 

Example 2

The following is a sample of the weekly Incremental backup policy for recoverable databases. Includes a weekly full DB2 database backup operation, a daily non-cumulative difference) backup operation, and a cumulative increment in the middle of the week) backup operation:

 
 

  
  
(Sun) db2 backup db kdr use tsm  
  
  
(Mon) db2 backup db kdr online incremental delta use tsm  
  
  
(Tue) db2 backup db kdr online incremental delta use tsm  
  
  
(Wed) db2 backup db kdr online incremental use tsm  
  
  
(Thu) db2 backup db kdr online incremental delta use tsm  
  
  
(Fri) db2 backup db kdr online incremental delta use tsm  
  
  
(Sat) db2 backup db kdr online incremental use tsm 
 
 

Example 3

In Windows®Start the backup operation on the tape device in the environment and issue the following:

 
 

  
  
db2 backup database sample to \\.\tape0  
 
 

The above content is an introduction to the DB2 database backup example. I hope you will find some gains.

The above content is a description of the DB2 database backup example, hoping to help you in this regard.