HP 3000 Manuals HP 3000 Manuals
Chapter 5 SQLUtil Syntax Summary
Invocation From Inside ISQL
isql=> sqlutil;
Invocation From Outside ISQL
: RUN SQLUTIL.PUB.SYS
SQLUtil Commands
SQLUtil Command Summary
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| ADDLOG | Adds a physical file to a log. |
| | |
| ALTDBE | Updates the DBEnvironment startup parameters. |
| | |
| ENDRECOVERY | Ends a rollforward recovery operation. |
| | |
| EXIT | Terminates SQLUtil execution. |
| | |
| HELP | Displays and describes all SQLUtil commands. |
| | |
| MOVEFILE | Moves a DBEFile across devices. |
| | |
| MOVELOG | Moves log file across devices. |
| | |
--------------------------------------------------------------------------------------------
Table 5-0. SQLUtil Command Summary (cont.)
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| PURGEALL | Purges both DBEnvironment and log files. |
| | |
| PURGEDBE | Purges a DBEnvironment. Does not purge log files. |
| | |
| PURGEFILE | Purges a DBEFile or log file. |
| | |
| PURGELOG | Purges an inactive log file. |
| | |
| QUIT | Terminates SQLUtil execution. |
| | |
| RECOVERLOG | Applies a log file during rollforward recovery operations. |
| | |
| RESCUELOG | Stores a current log file without accessing the DBECon file. |
| | This command must be used instead of STORELOG when the |
| | DBEnvironment cannot be restarted. |
| | |
| RESTORE | Restores a DBEnvironment that was saved with the STORE command. |
| | |
| RESTORELOG | Restores a log file that has previously been STOREd.[REV BEG] |
| | |
| SET | Defines a number of SQLUtil environment options.[REV END] |
| | |
| SETDBEMAINT | Sets or changes the maintenance word. |
| | |
| SETUPRECOVERY | Initiates a rollforward recovery operation following restoration |
| | of DBEnvironment files and log files from backups.[REV BEG] |
| | |
| SHOWACCESS | Displays the file access mode for all the DBEFiles in a |
| | DBEnvironment.[REV END] |
| | |
| SHOWDBE | Shows information about the specific DBEnvironment. |
| | |
| -ALL | Shows information contained in the DBECon file. |
| | |
| -EXIT | Terminates SHOWDBE execution. |
| | |
| -HELP | Displays and describes all SHOWDBE commands. |
| | |
| -LANG | Displays the DBEnvironment language. |
| | |
| -MAINT | Displays the maintenance word. |
| | |
| -QUIT | Terminates SHOWDBE execution. |
| | |
| -STARTPARMS | Shows the startup parameters. |
| | |
--------------------------------------------------------------------------------------------
Table 5-0. SQLUtil Command Summary (cont.)
--------------------------------------------------------------------------------------------
| | |
| Command | Function |
| | |
--------------------------------------------------------------------------------------------
| | |
| SHOWLOG | Displays the log directory.[REV BEG] |
| | |
| SHOWSET | Displays the setting of a parameter established with the SET |
| | command.[REV END] |
| | |
| STORE | Creates a backup copy of a DBEnvironment. Does not store log |
| | file(s) |
| | |
| STORELOG | Stores archive log files and marks them available for |
| | re-use.[REV BEG] |
| | |
| STOREONLINE | Backs up a DBEnvironment to tape or serial disk and enables |
| | archive logging if it is not already in effect. |
| | |
| SYSTEM | Escape temporarily to the operating system.[REV END] |
| | |
--------------------------------------------------------------------------------------------
ADDLOG
>> ADDLOG DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Enter Log File Name(s) Separated by a Blank? File1
[File2] New Log File Size? FileSize Add Log File (y/n)? {Y[es]}
{N[o] }
ALTDBE
>> ALTDBE DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord AutoStart Mode (on/off) (opt): AutoStartMode User Mode
(single/multi) (opt): UserMode DDL Enabled (y/n) (opt): DDLEnabled
No. of Runtime Control Block Pages (opt): ControlBlockPages No. of
Data Buffer Pages (opt): DataBufferPages [REV BEG]Data Buffer Pages
Memory Resident (y/n) (opt): MemoryResident [REV END]No. of Log Buffer
Pages (opt): LogBufferPages Max. Transactions (opt): MaxTransactions
[MaximumTimeout [SECONDS]]
[REV BEG]Maximum Timeout (opt): [ [MINUTES]] Default
[ ]
[NONE ]
[DefaultTimeout [SECONDS]]
Timeout (opt): [ [MINUTES]] [REV END] [REV BEG] Authorize
[ ]
[MAXIMUM ]
Once Per Session (on/off) (opt): AuthorizeOnce [REV END] Alter
DBEnvironment Startup Parameters (y/n)? {Y[es]}
{N[o] }
ENDRECOVERY
>> ENDRECOVERY DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord End Recovery (y/n)? {Y[es]}
{N[o] }
EXIT
>> E[XIT]
HELP
>> HELP Command Name (opt): CommandName
MOVEFILE
>> MOVEFILE DBEnvironment Name: DBEnvironmentName File Name: FileName
Current Device: CurrentDeviceNumber New Device (opt): NewDeviceNumber
[REV BEG]Access Mode (mapped/pseudo) (opt): FileAccessMode [REV END]
MOVELOG
>> MOVELOG DBEnvironment Name: DBEnvironmentName Current Log File
Name: CurrentFileName Current Device: CurrentDeviceClass [REV BEG]New
Device (opt): NewDeviceNumber New Log File Name: NewLogFileName [REV
END]
PURGEALL
>> PURGEALL DBEnvironment Name: DBEnvironmentName Purge DBEnvironment
and Log Files (y/n)? {Y[es]}
{N[o] }
PURGEDBE
>> PURGEDBE DBEnvironment Name: DBEnvironmentName Purge DBEnvironment
(y/n)? {Y[es]}
{N[o] }
PURGEFILE
>> PURGEFILE DBEFile Name: DBEFileName Purge DBEFile (y/n)? {Y[es]}
{N[o] }
PURGELOG
>> PURGELOG DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Log Identifier: LogIdentifier Purge Log File (y/n)?
{Y[es]}
{N[o] }
QUIT
>> Q[UIT]
RECOVERLOG
>> RECOVERLOG DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Next Log File to Recover: LogFileName Recover Log File
(y/n)? {Y[es]}
{N[o] }
RESCUELOG
>> RESCUELOG Log File Name: LogFileName Size Of The Log File:
LogFileSize To File Name? DeviceName Rescue Log File(y/n)? {Y[es]}
{N[o] }
RESTORE
>> RESTORE DBEnvironment Name: DBEnvironmentName From File Name:
StoreFileName Restore DBEnvironment (y/n)? {Y[es]}
{N[o] }
RESTORELOG
>> RESTORELOG DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Input Device: DeviceName Local (y/n) (opt): {Y[es]}
{N[o] }
Restore the Log File (y/n)? {Y[es]} Rename LogFileName Log File To:
{N[o] }
[File[.Group[.Account]]]
SET
[ {STORESET } ]
[BACKUP {RESTORESET} ['OptionString']]
[ {MOSET } [DEFAULT ]]
[ ]
>> SET [ECHO_ALL {ON } ]
[ {OFF} ]
[ ]
[EXIT_ON_DBERR {ON } ]
[ {OFF} ]
SETDBEMAINT
>> SETDBEMAINT DBEnvironment Name: DBEnvironmentName Current
Maintenance Word: OldMaintenanceWord New Maintenance Word:
NewMaintenanceWord Retype New Maintenance Word: NewMaintenanceWord
SETUPRECOVERY
>> SETUPRECOVERY DBEnvironment Name: DBEnvironmentName Maintenance
Word: MaintenanceWord Recover To (mm/dd/y/hh/mm/ss) (opt): RecoverTime
New Log Mode (Single/Dual) (opt): NewLogMode Enter New Log File Name(s)
Separated By A Blank: File1 [File2] New Log File Size (opt):
NewLogSize Setup Recovery (y/n)? {Y[es]}
{N[o] }
SHOWACCESS
>> SHOWACCESS DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord
SHOWDBE
>> SHOWDBE DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Output File Name (opt): OutputFileName
SHOWDBE-ALL
Syntax.
-> ALL
SHOWDBE-EXIT
Syntax.
-> E[XIT]
SHOWDBE-HELP
-> HELP Command Name (opt): CommandName
SHOWDBE-LANG
-> LANG
SHOWDBE-MAINT
-> MAINT
SHOWDBE-QUIT
Syntax.
-> Q[UIT]
SHOWDBE-STARTPARMS
-> STARTPARMS
SHOWLOG
>> SHOWLOG DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Connect? (y/n) (opt): {Y[es]}
{N[o] }
SHOWSET
[BACKUP ]
>> SHOWSET [ECHO_ALL ]
[EXIT_ON_DBERR]
STORE
>> STORE
WARNING: If you are using STORE to support RollForward Recovery
through archive logging, you must precede this command
with the BEGIN ARCHIVE and COMMIT ARCHIVE commands in
ISQL. (See the ALLBASE/SQL DBA Guide under Backup and
Recovery for details)
Do you wish to proceed (y/n)?: {Y[es]} DBEnvironment Name:
{N[o] }
DBEnvironmentName Maintenance Word: MaintenanceWord To File Name:
StoreFileName
STORELOG
>> STORELOG DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord Log Identifier (opt): LogIdentifier To File Name?
FileName Use Static Store (y/n)? {Y[es]} Store Log File (y/n)?
{N[o] }
{Y[es]}
{N[o] }
STOREONLINE
>> STOREONLINE DBEnvironment Name: DBEnvironmentName Maintenance Word:
MaintenanceWord To File Name: StoreFileName
SYSTEM
>> SYSTEM