Appendix F SQLUtil

Table of Contents

ADDLOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

ALTDBE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

ATTACHFILE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

CHANGELOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

DETACHFILE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

ENDRECOVERY

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

EXIT

Scope
SQLUtil Syntax
Description
Example

HELP

Scope
SQLUtil Syntax
Parameters
Description
Example

MOVEFILE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

MOVELOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

PURGEALL

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

PURGEDBE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

PURGEFILE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

PURGELOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

QUIT

Scope
SQLUtil Syntax
Description
Example

RECOVERLOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

RESCUELOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

RESTORE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

RESTORELOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Examples

RESTORE PARTIAL

Scope
SQLUtil Syntax - RESTORE PARTIAL
Parameters
Description
Authorization
Example

SET

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

SETDBEMAINT

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

SETUPRECOVERY

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

SETUPRECOVERY PARTIAL

Scope
SQLUtil Syntax - SETUPRECOVERY PARTIAL
Parameters
Description
Authorization
Example of Partial Recovery

SHOWACCESS

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

SHOWDBE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

SHOWDBE-ALL

Scope
Syntax
Description
Authorization
Example

SHOWDBE-EXIT

Scope
Syntax
Description
Authorization
Example

SHOWDBE-HELP

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

SHOWDBE-LANG

Scope
SQLUtil Syntax
Description
Authorization
Example

SHOWDBE-MAINT

Scope
SQLUtil Syntax
Description
Authorization
Example

SHOWDBE-QUIT

Scope
Syntax
Description
Authorization
Example

SHOWDBE-STARTPARMS

Scope
SQLUtil Syntax
Description
Authorization
Example

SHOWLOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Examples

SHOWSET

Scope
SQLUtil Syntax
Parameters
Description
Example

STORE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

STOREINFO

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

STORELOG

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

STOREONLINE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

STOREONLINE PARTIAL

Scope
SQLUtil Syntax - STOREONLINE PARTIAL
Parameters
Description
Authorization
Example

STORE PARTIAL

Scope
SQLUtil Syntax - STORE PARTIAL
Parameters
Description
Authorization
Example

SYSTEM

Scope
SQLUtil Syntax
Parameters
Description
Example

WRAPDBE

Scope
SQLUtil Syntax
Parameters
Description
Authorization
Example

The following pages contain SQLUtil command syntax. A discussion of how to use SQLUtil is in the "DBA Tasks and Tools" chapter.




	NOTE: As in other ALLBASE/SQL utilities, you can use a semicolon following any SQLUtil command. The semicolon is not required, however.

Appendix F SQLUtil

Technical documentation

» Table of Contents

» Index