Backup Options

On this screen, specify the database backup options.

The Database user access choices help you specify the state of the database during the backup.

If you choose to Perform the backup while users are connected and the DB2 database has either the LOGRETAIN or USEREXIT setting enabled, then a "hot" or online backup will be performed. This allows the backup to proceed while users execute transactions. This option is equivalent to the ONLINE option of the DB2 BACKUP command.

If this option is selected and DB2 is not configured for online backups, then an offline backup is attempted.

If you choose Disconnect users and prohibit access during the backup and the DB2 database is version 8.1 or later, then all connections to the database will be forcibly terminated prior to performing the backup. This setting is equivalent to the DB2 QUIESCE DATABASE command.

If the database version is prior to 8.1, this option has no effect and an offline backup is attempted.

To enforce an offline backup, you can choose to Abort the backup if users are connected. If this option is selected, then a "cold" or offline backup will be attempted. The backup will fail if any users are connected.

The Backup performance choices help you to specify the parameters for the backup. All of the fields in the Backup performance box require either a default or an entered value to continue.

For Sessions, enter a value from 1 to 32. This value specifies the number of sessions or backup streams for the backup.

For Parallelism, enter a value from 1 to 1024. This value specifies the number of DB2 concurrent processes used to read tablespaces.

For Buffers, enter a value from 2 to 16384. The minimum value for this parameter should be equal to twice the value specified in the Sessions field, above.

For Buffer Size, enter a value from 8 to 524228. The value is the number of 4 KB pages used for buffering data. The total buffer size is the buffer value multiplied by 4096.

The Back button will take you back to the Initial Settings screen. Click Back only if you wish to reset the Backup Options to the default settings or to the settings of an existing template. All entries on the Backup Options screen will be reset if you click Back.

Click Next to continue.