HP 3000 Manuals HP 3000 Manuals
CHECK SET
Checks data sets for internal or pointer inconsistency and reports any
problems.
Syntax
CHE[CK] SET {DataSetName} [Quick]
{@ }
Parameters
DataSetName is the name of the data set which should be checked.
@ indicates that all data sets in the database should
be checked.
Quick is a fast method of checking data sets to validate
pointer integrity. If you specify the Quick
parameter, the data sets are examined using a serial
read. Using this option, the command reports if the
data sets have problems, but it does not indicate the
location.
Description
NOTE Before using the CHECK SET command, read chapter 8, "Maintaining
the Database."
Use this command to check data sets for internal or pointer
inconsistency. CHECK SET only checks for internal or pointer
inconsistency within the data set(s) specified. To check chain head
pointers in the associated master data set(s), use the CHECK PATH
command.
The database checking process begins only after you issue a PERFORM
COMMANDS.
Example 1
In the example below, the detail data set SALES in the ORDERS database is
checked using the CHECK SET command without the Quick parameter. A
description of the output follows the example.
>base orders
>check set sales
CHECK SET issued for 1 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, 12:57 PM
Database has been modified since last DBSTORE (DBA 220).
Continue [y/N] ? y
Starting data set serial reads.
Tabulating statistics.
CHECK SET (DETAIL)
Pct Highest Delete
Detail Set Name Entries Capacity Full Entry Used Chain Count
-----------------------------------------------------------------------
SALES 17 504 3 17 0
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).
HP36386 (A.00.00) DBCHANGE (c) COPYRIGHT Hewlett-Packard Co. 1985
>
Following is a description of the CHECK SET output for a detail data set:
Detail Set Name is the name of the detail data set being checked.
Entries is the number of entries the data set contains.
Capacity is the capacity of the data set.
Pct Full is the percentage of the data set capacity, rounded
to the nearest whole percentage, that is not
available.
Highest Entry Used is the record number of the highest entry ever used
in the data set.
Delete Chain Count is the number of records in the delete chain.
Example 2
In the example below, the master data set CUSTOMER in the ORDERS database
is checked using the CHECK SET command without the Quick parameter. A
description of the output follows the example.
>base orders
>check set customer
CHECK SET issued for 1 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, 12:57 PM
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
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)
Sum of chain counts in the related master set does not
match bitmap entry count for this set (CHK 580).
HP36386 (A.00.00) DBCHANGE (c) COPYRIGHT Hewlett-Packard Co. 1985
>
Following is a description of the CHECK SET output for a master data set:
Master Set Name is the name of the master data set being checked.
Type is the type of master data set being checked. A is
for automatic master; M is for manual master.
Entries is the number of entries the data set contains.
Capacity is the capacity of the data set.
Pct Full is the percentage of the data set capacity, rounded
to the nearest whole percentage, that is not
available.
Pct Sec is the percentage of secondary entries.
Longest Cluster is the longest number of TurboIMAGE/XL blocks that
must be read to find an open slot to place a synonym.
Average Cluster is the average number of TurboIMAGE/XL blocks that
must be read to find an open slot to place a synonym.
The output for the CHECK SET command using the Quick parameter is the
same as the standard CHECK SET command; however, a summary version of the
standard CHECK INFORMATION output is displayed. Problems are identified,
but the specific location and records that need fixing are not isolated.