HP 3000 Manuals HP 3000 Manuals
FIX BASE
Examines all sets and paths in the database and attempts to correct known
problems.
Syntax
F[IX] BA[SE]
Description
NOTE Before using the FIX BASE command, read chapter 8, "Maintaining the
Database."
Use this command to examine all sets and paths in the database and to
correct known problems. The FIX BASE command is equivalent to issuing
the FIX SET @ and FIX PATH @ commands simultaneously. The database
fixing process begins only after you issue the PERFORM COMMANDS command.
The FIX BASE command requires exclusive access to the database.
Example
In the example below, the ORDERS database is fixed using the FIX BASE
command. A description of the output follows the example.
>base orders
>fix base
FIX BASE (FIX SET and FIX PATH) pending 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
FRI, MAY 25, 1990, 2:47 PM
Database has been modified since last DBSTORE (DBA 220).
Continue [y/N] ? y
Checking root file.
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 PATH
Pct
Set Name Type Max Avg Std Far Avg Packing
Search Item (PS) Chain Chain Dev Ptrs Blocks Ratio
----------------------------------------------------------------------
CUSTOMER M
SYNONYM CHAINS 1 1.00 0.00 0 1.00 N/A
PRODUCT M
SYNONYM CHAINS 2 1.07 0.25 0 1.00 N/A
SALES D
ACCOUNT ( S) 17231 2874.67 7033.14 6 1.17 6.86
STOCK# (P ) 5 2.13 1.64 6 1.13 0.89
SUP-MASTER M
SYNONYM CHAINS 1 1.00 0.00 0 1.00 N/A
INVENTORY D
STOCK# 1 1.00 0.00 0 1.00 1.00
SUPPLIER (P ) 5 5.00 0.00 0 1.00 1.00
Starting data set chained reads.
...
CHECK INFORMATION
Set Name Type
Search Item
Message(s)
------------------------------------------------------------------------
CUSTOMER M
Userlabel entry count does not match synonym chain count (CHK 570).
Record 6 is not linked into the proper synonym chain (CHK 360).
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).
Chainhead record 113 chain count mismatches entries on chain (CHK 450).
Record 3 contains bad backward pointer (CHK 440).
Record 14 contains bad backward pointer (CHK 440).
Record 15 is not linked into the proper chain (CHK 460).
Record 16 contains bad forward pointer (CHK 430).
STOCK# (Path 2; linked to master PRODUCT, path 1)
Path Chain inconsistencies detected (CHK 400).
Chainhead record 267 contains bad forward pointer (CHK 410).
Chainhead record 267 contains bad backward pointer (CHK 420).
Chainhead record 267 chain count mismatches entries on chain (CHK 450).
Record 15 is not linked into the proper chain (CHK 460).
FIX INFORMATION
------------------------------------------------------------------------
New Key value added for dataset CUSTOMER (FIX 170). Key value:
INTEGER(I4/J4)=>> 1482184792 / 1482184792
New Key value added for dataset PRODUCT (FIX 170). Key value:
ASCII( 8)==>> XXXXXXXX
All problems detected have been fixed.
HP36386 (A.00.00) DBCHANGE (c) COPYRIGHT Hewlett-Packard Co. 1985
>
The FIX BASE command first checks the entire database. (For a
description of the CHECK BASE output, refer to "CHECK BASE" earlier in
this chapter). After checking the database, any problems that are
detected are fixed and described in the FIX INFORMATION section of the
output. In the above example, DBChange Plus adds new key values to the
data sets CUSTOMER and PRODUCT. A message is returned verifying the
status of the fix process.