 |
» |
|
|
|
The SET command lets you specify the following operating parameters for
SQLUtil: BACKUP, EXIT_ON_DBERR, and ECHO_ALL. Scope | |
SQLUtil Only. SQLUtil Syntax | |
>> SET [ BACKUP { STORESET RESTORESET MOSET } [
'OptionString'
DEFAULT
] ECHO_ALL { ON OFF } EXIT_ON_DBERR { ON OFF }] Parameters | |
- STORESET
Together with 'OptionString',
specifies a set of devices for use in storing DBEnvironment
files and logs.
- RESTORESET
Together with 'OptionString',
specifies a set of devices for use in restoring
DBEnvironment files and logs.
- MOSET
Together with 'OptionString',
specifies a set of DASS devices for use in restoring
DBEnvironment files and logs.
- ECHO_ALL
Causes SQLUtil to echo all input.
The initial default setting is OFF.
- EXIT_ON_DBERR
Causes SQLUtil to terminate
immediately when a DBERR is encountered.
The initial default setting is OFF.
Description | |
Choosing a BACKUP parameter lets you select TurboSTORE II
backup options if you are using TurboSTORE II
with your operating system.
The STORESET, RESTORESET, and MOSET options are only
available when you have installed TurboSTORE II software on
your system.
In the STORESET option, you specify multiple drives for use
in backup operations. You can specify either sequential or
parallel operation. The specification of a STORESET is
shown in the TurboSTORE II User's Guide.
In the RESTORESET option, you specify multiple drives for
use in restore operations. You can specify a parallel RESTORESET,
but only for tapes that were created using a parallel STORESET.
The specification of a RESTORESET is shown in the
TurboSTORE II User's Guide.
The MOSET option is for use only with direct access secondary
storage (DASS) devices using optical disk drives. The MOSET is
for use in both STORE and RESTORE operations.
The specification of an MOSET is shown in the
TurboSTORE II User's Guide.
If you specify a parallel STORE operation, the division of files to be
backed up is left to TurboSTORE II.
You can use a parallel RESTORE, but you must specify the same
sequence of devices in the RESTORESET that you specified at
STORE time in the STORESET.
The SET BACKUP parameters STORESET and RESTORESET cannot be set if
the MOSET parameter has already been set. Similarly, the MOSET
parameter cannot be set if either STORESET or RESTORESET has
been set.
If no option is specified for STORESET, RESTORESET, or MOSET,
then the previous option specified for that parameter will be reset.
Entering the keyword DEFAULT as an option has the same
effect as specifying no option.
When the ECHO_ALL command option is ON, batch user input is echoed to the
standard list.
The initial default setting is OFF.
Setting the EXIT_ON_DBERR to ON causes immediate termination
of SQLUtil when an ALLBASE/SQL error is encountered.
If EXIT_ON_DBERR is ON,
the system JCW is set to FATAL if a DBERR is encountered or to
0 if no DBERRs are encountered.
See the "DBA Tasks and Tools" SECT of this manual for information
on checking
JCWs
when SQLUtil terminates.
Issuing a SET command without parameters displays the current
settings, exactly as in the SHOWSET command.
Authorization | |
Anyone can use this command.
Example | |
>> set echo_all on
>> set exit_on_dberr on
set exit_on_dberr on
|
The following sets a STORESET for sequential operation.
>> set backup storeset '(*TAPE1, *TAPE2, *TAPE3)'
|
The following sets a RESTORESET for parallel operation.
(The previous STORE was done using the same list of devices.)
>> set backup restoreset '(*TAPE1),(*TAPE2),(*TAPE3)'
|
The following displays current settings.
>> set
ECHO_ALL : ON
EXIT_ON_DBERR : ON
BACKUP:
STORESET : (*TAPE1, *TAPE2, *TAPE3)
RESTORESET : (*TAPE1),(*TAPE2),(*TAPE3)
MOSET :
>>
|
|
