New Features in ALLBASE/SQL Release G.0 (continued)

Feature (Category)

Description

Documented in . . .

 

 

 

High Availability

Provides a collection of features to

ALLBASE/SQL Reference Manual , \SQL

 

keep systems available nonstop

Statements;" ALLBASE/SQL Database

 

including: Partial STORE and

Administration Guide , \Maintaining a

 

RESTORE, Partial rollforw ard

Nonstop Production System" in

 

recovery, DBEFiles in di￿erent

\Maintenance" chapter and \SQLUtil"

 

groups (MPE/iX), detaching and

appendix.

 

attaching database objects,

 

 

CHECKPOINT host variable,

 

 

changing log ￿les, console

 

 

messages logged to a ￿le,

 

 

generating fewer log records by

 

 

using TRUNCATE TABLE to

 

 

delete rows, and new system

 

 

catalog information. See the

 

 

following features for new and

 

 

changed syntax.

 

 

 

 

Partial rollforw ard

Supports partial rollforward

recovery

recovery through PARTIAL option

(High Availability)

on SETUPRECOVERY. Used to

 

recover speci￿c DBEFiles while

 

allowing access to other DBEFiles.

 

 

ALLBASE/SQL Database Administration Guide, \Backup and Recovery" chapter and SETUPRECOVERY PARTIAL in \SQLUtil" appendix.

Partial STORE

Gives more ￿exibility in backup

and RESTORE

and recovery strategies b y allowing

(High Availability)

partial store and restore of

 

DBEFiles, DBEFileSets or

 

combinations of both. See \New

 

and changed SQLUtil commands

 

for increased availability" later in

 

this table.

 

 

ALLBASE/SQL Database Administration Guide, \Backup and Recovery" chapter and \SQLUtil" appendix.

DBEFile group

Manages DBEFiles so they can be

ALLBASE/SQL Reference Manual ,

change on MPE/iX

placed in a particular group or on

CREATE DBEFile in \SQL Statemen ts;"

(High Availability)

a particular volume (MPE/iX).

ALLBASE/SQL Database Administration

 

Use either CREATE DBEFILE or

Guide, \Maintaining a Nonstop Production

 

MOVEFILE.

System" in \Maintenance" chapter and

 

 

MOVEFILE in \SQLUtil" appendix.

 

 

 

Detaching and

Detaches or attaches a DBEFile or

attaching database

DBEFileSet from the

objects

DBEnvironment. This is useful for

(High Availability)

data that is accessed infrequen tly

 

such as tables containing historical

 

data only. New SQLUtil

 

commands: DETACHFILE,

 

ATTACHFILE.

 

 

ALLBASE/SQL Database Administration Guide, \Maintaining a Nonstop Production System" in \Maintenance" chapter and DETACHFILE, ATTACHFILE in \SQLUtil" appendix.

viii