On this screen, specify
the restore access, performance, and search options.
In the Database user
access box, specify the state of the database during the
If you restore a
tablespace, you can choose to . This option only applies
when you restore a tablespace. It allows other, uneffected
tablespaces to remain available while the restore is in progress.
This option is equivalent to the TABLESPACE
ONLINE option of the DB2
RESTORE command. This option is ignored when you restore an
object that is not a tablespace.
The option works with the with the DB2 database version
is 8.1 or later. If you choose this option and have an appropriate
DB2 version, all connections to the database are forcibly
terminated before a recovery. This setting is equivalent to the
DB2 QUIESCE DATABASE command.
If the database version
is earlier than 8.1, this option has no effect and an offline
restore is attempted.
To enforce an offline
restore, you can choose to . If this option is selected,
the restore fails if any users are connected.
In the Restore
performance box, specify the parameters for the restore. The fields
in this box require either a default or an entered value to
For , enter a value from 1 to 32. This
value specifies the number of sessions or restore streams for the
For , enter a value from 1 to 1024.
This value specifies the number of DB2 concurrent processes that
are used to read tablespaces.
For , enter a value from 2 to 16384. The
minimum value for this parameter should be equal to twice the value
that you specified in the
For , enter a value from 8 to 524228.
The value is the number of 4-KB pages that are used for buffering
data. The total buffer size is the buffer value multiplied by
The button takes you back to the screen.
Click to continue.