SET [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
SET
The SET command lets you specify the following operating parameters for
SQLUtil: BACKUP, EXIT_ON_DBERR, and ECHO_ALL.
Scope
SQLUtil only.
SQLUtil Syntax
[REV BEG]
[ {STORESET } ]
[BACKUP {RESTORESET} ['OptionString']]
[ {MOSET } [DEFAULT ]]
[ ]
>> SET [ECHO_ALL {ON } ]
[ {OFF} ]
[ ]
[EXIT_ON_DBERR {ON } ]
[ {OFF} ]
[REV END]
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" chapter 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 :
>>
MPE/iX 5.5 Documentation