ALLBASE/SQL Reference Manual (36216-90216)

290 Chapter10
SQL Statements A - D
SQL Statement Summary
SET DEFAULT
DBEFILESET
Sets a default DBEFileSet.
DROP DBEFILESET Removes the definition of a
DBEFileSet from the system
catalog.
Temporary sort space
CREATE TEMPSPACE Defines and creates a temporary
storage space.
DROP TEMPSPACE Removes the definition of a
temporary storage space from the
system catalog.
Logging
Recovery of
log space
BEGIN ARCHIVE
COMMIT ARCHIVE
Starts a new archive log file before a
DBEnvironment is back up.
CHECKPOINT Causes an ALLBASE/SQL system
checkpoint to be taken. A system
checkpoint causes data and log
buffers to be written to disk and
makes old log space, occupied by
completed transactions, available
for reuse if nonarchive logging is in
effect. Returns values in host
variable.
START DBE NEWLOG Reinitializes log file(s) when you
need to change the size. Makes
audit logging effective when used
with AUDIT LOG option.
START DBE Initiates the first DBE session if the
DBE is not in autostart mode and
causes a checkpoint to be taken,
recovering log file space if
nonarchive logging is in effect.
STOP DBE Terminates all DBE sessions and
causes a checkpoint to be taken,
recovering log file space if
nonarchive logging is in effect.
Dual logging START DBE NEW Causes ALLBASE/SQL to maintain
two separate, identical logs, when
used with the DUAL LOG option.
Makes audit logging effective when
used with AUDIT LOG option.
Table 10-1. SQL Statement Summary
Group Category Statement Statement Use