HP 3000 Manuals

DBChange Plus User's Guide

Using the QUICK Option with CHECK Commands 

When used with the CHECK PATH, CHECK SET, and CHECK BASE commands, the
QUICK option displays a summarized version of the standard CHECK output.
The QUICK option performs a serial read only.  This method is quicker
than standard checking, which uses both serial and chained reads.  The
QUICK option can identify that a problem exists, but it cannot isolate
the specific records that need to be fixed.  If you already know that a
problem exists, but you need more detailed information, such as which
records are in error, use the standard checking method.


NOTE  If a record contains only a damaged key, but does not contain any
      other damage, the CHECK BASE QUICK command will not detect the
      damaged key.  To locate damaged keys on a large database, create a
      copy of your database and perform a standard CHECK BASE on the
      database copy.  If you have a small database, perform a standard
      CHECK BASE followed by a FIX BASE.


The QUICK option is useful if you have a large database and want to
determine if a problem exists but you don't need to know exactly where.
In the following example, the QUICK option is used to check the paths in
the detail data set SALES. ACCOUNT is the search item linking SALES to
the master data set CUSTOMER.

     >check path sales (account) quick 
      Check Path pending for 1 set(s).

     >

After issuing a PERFORM COMMANDS to invoke DBAPLUS, the following output
is displayed:

     Check file ORDERSRX exists; it will be overwritten (DBA 125).
     Starting data set serial reads.

     Tabulating statistics.

     CHECK PATH
                                                       Pct
     Set Name           Type     Max     Avg     Std   Far     Avg  Packing
       Search Item      (PS)   Chain   Chain     Dev  Ptrs  Blocks    Ratio
     ----------------------------------------------------------------------
     SALES               D
       ACCOUNT          ( S)   17231 2874.67 7033.14     6    1.17     6.86

     Starting data set chained reads.

     CHECK INFORMATION

     Set Name           Type
       Search Item
         Message(s)
     ------------------------------------------------------------------------
     SALES               D
       ACCOUNT           (Path 1; linked to master CUSTOMER, path 1)
         Path Chain inconsistencies detected (CHK 400).

      PERFORM COMMANDS completed.

     HP36386 (A.00.00) DBCHANGE  (c) COPYRIGHT Hewlett-Packard Co. 1985

Refer to "CHECK PATH" and "FIX PATH" in chapter 10, "DBChange Plus
Commands," for a detailed description of the command syntax and output
statistics.

MPE/iX 5.0 Documentation