DBMS Check (DBM CH)

Qualifiers:

BRIEF (B)

FULL (F)

KILL (K)

ON

OFF

TIME (T) <hour>

Purpose:

Performs a variety of checking functions on the database.

Details:

The BRIEF qualifier checks the sanity of the database. There should be no detected errors.

The FULL qualifier checks the sanity and current status of the database. There should be no detected errors.

The KILL qualifier aborts the latest DBMS Check command.

The ON qualifier enables automatic checking of the database. The default time for an automatic check of the database is 5:00.

The OFF qualifier disables automatic checking of the database.

The TIME <hour> qualifier assigns the time of day at which the automatic check is completed. The <hour> qualifier is any number from 1 to 23.

• Note: If a Guest Service function is performed during a DBMS Check, a major alarm is raised as the database is not fully accessible. A subsequent DBMS Check command will clear the error.
  It is recommended that a DBMS CHECK BRIEF be performed after all lengthy programming sessions.

On the SUPERCONSOLE 1000, this command is found under the SYSTEM group of commands.

Examples:

Entry: DBM CH B

System Response:

DBMS info: DBMS CHECK has commenced.
n view error(s), m table error(s) detected.

Entry: DBM CH F

System Response:

DBMS CHECK has commenced
DBMS info: Lab Default DB is off
DBMS info: DBMS_INITIALIZED is on
DBMS info: Journal is on
DBMS info: Debug is off
DBMS info: Cab: 14 Dim: 17 Traffic: 20
DBMS info: DBMS CHECK scheduled for 2004-OCT-08 05:00:00.00
DBMS info: DBMS CHECK completed 2004-OCT-07 05:03:36.00
Machine variant:  IP
Installation ID: IPBX165
Time: 2004-OCT-08 01:46:21.00    FRI
Plane: A - active
File Redundancy: enabled
 

View: 1 cor             Tuples (Max): 32767 (Current):  64
View: 2 cos             Tuples (Max):    96 (Current):  64
View: 3 fac             Tuples (Max): 32767 (Current):  77
View: 4 pickup_group    Tuples (Max):  7680 (Current):   0
: : : :
View: 156  real_tenant  Tuples (Max):    64 (Current):  64
View: 157  dev_reslt    Tuples (Max):   700 (Current): 700             
Internal level audit starting
DBMS info: DBMS CHECK completed 2004-OCT-08 01:49:58.00
Internal level audit finished successfully.
0 view error(s), 0 table error(s) detected.

Entry: DBM CH K

System Response:

DBMS info: DBMS CHECK has been aborted

Entry: DBM CH ON

System Response:

DBMS info: DBMS CHECK scheduled for 1991-MAY-23 05:00

Entry: DBM CH T 1

System Response:

DBMS info: DBMS CHECK scheduled for 1991-MAY-23 01:00:00.00