HP 3000 Manuals HP 3000 Manuals
FIX SET
Examines data sets for internal pointer or structural inconsistency and
attempts to correct known problems.
Syntax
F[IX] SET {@ }
{DataSetName}
Parameters
@ indicates that all data sets in the database should
be examined and corrected.
DataSetName is the name of the data set to be examined and
corrected.
Description
Use this command to examine one or more data sets for internal pointer or
structural inconsistency and to correct known problems.
NOTE Before using the FIX SET command, read chapter 8, "Maintaining the
Database." In addition, because of the FIX SET command limitations
as described below, consider using the FIX PATH command instead.
FIX SET examines and corrects only the internal pointer consistency of
the set(s) specified. It does not correct pointer consistency across
sets. For example, it does not correct a pointer from a chain head in a
master data set to the first record on the chain in the associated detail
data set(s). To do this, use the FIX PATH command.
FIX SET does not repair broken chains. FIX SET only repairs structures
that reside entirely within the data set, such as user label, bit map,
and delete chains. For information about fixing both broken chains and
data set structure, refer to "FIX PATH" earlier in this chapter.
The database fixing process begins only after you issue the PERFORM
COMMANDS command.
The FIX SET command requires exclusive access to the database.
Example
In the example below, all the data sets in the ORDERS database are fixed
using the FIX SET command. A description of the output follows the
example.
>base orders
>fix set @
FIX SET issued for 5 set(s).
>perform commands
PERFORM COMMANDS now or create job file [job/y/N]? y
Please wait ...
HP36386 (A.00.00) DBALTER (c) COPYRIGHT Hewlett-Packard Co. 1985
TUE, MAY 29, 1990, 8:49 AM
Database has been modified since last DBSTORE (DBA 220).
Continue [y/N] ? y
Starting data set serial reads.
.....
Tabulating statistics.
CHECK SET (MASTER)
Pct Pct Longest Average
Master Set Name Type Entries Capacity Full Sec Cluster Cluster
-----------------------------------------------------------------------
CUSTOMER M 9 221 4 11.1 0 0.0
PRODUCT M 32 307 10 6.3 0 0.0
SUP-MASTER M 6 211 3 0.0 0 0.0
CHECK SET (DETAIL)
Pct Highest Delete
Detail Set Name Entries Capacity Full Entry Used Chain Count
-----------------------------------------------------------------------
SALES 17 504 3 17 0
INVENTORY 5 510 1 5 0
CHECK INFORMATION
Set Name Type
Search Item
Message(s)
------------------------------------------------------------------------
CUSTOMER M
Userlabel entry count does not match synonym chain count (CHK 570).
SALES D
ACCOUNT (Path 1; linked to master CUSTOMER, path 1)
Path Chain inconsistencies detected (CHK 400).
Sum of chain counts in the related master set does not
match bitmap entry count for this set (CHK 580).
STOCK# (Path 2; linked to master PRODUCT, path 1)
Path Chain inconsistencies detected (CHK 400).
FIX INFORMATION
------------------------------------------------------------------------
All problems detected have been fixed.
HP36386 (A.00.00) DBCHANGE (c) COPYRIGHT Hewlett-Packard Co. 1985
>
The FIX SET command first checks all the master and detail data sets in
the database. (For a description of the CHECK SET output, refer to
"CHECK SET" earlier in this chapter). After checking the data sets, any
problems that are detected are described in the CHECK INFORMATION section
of the output. Under FIX INFORMATION, a message is returned verifying
the status of the fix process. In the above example, all problems
detected are fixed.