HP 3000 Manuals HP 3000 Manuals
REVIEW BLOCKS
Displays information about the blocking factor of one or more data sets.
Syntax
REV[IEW] BLOCK[S] [DataSetName]
[@ ]
Parameters
DataSetName is the name of the data set to be reviewed.
@ indicates you want to review the blocking factor of
all data sets in the database. This parameter is the
default.
Description
Use this command to review the following information about one or more
data sets:
Data Set Name is the name of the master or detail data set being
reviewed.
Type is the type of data set being reviewed. Valid data
set types are as follows:
A is for automatic master data set.
M is for manual master data set.
D is for detail data set.
Fld Cnt is the number of fields in the data set.
Pth Cnt is the number of paths connecting the data set to
other data sets.
Entr Len is the total length of the data set entries in
16-bit words excluding chain counters and pointers.
Med Rec is the total length of the data set entries
including chain counters and pointers.
Capacity is the capacity of the data set.
Blk Fac is the blocking factor of the data set.
Blk Len is the block length of the data set.
Blk Max is the maximum physical block length of the data
set or the default to block length. Note that this
column can be the same as the Blk Len column.
However, if $CONTROL BLOCKMAS is need for DBSCHEMA,
or if the CHANGE BLOCKMAX command is used, the Blk
Max number is automatically checked, and, if
necessary, changed by the DBCPLUS program.
In addition to the above information, error messages for incorrect
blocking factor, block length, or block maximum are displayed. All
changes stored in the the current change file are included in the REVIEW
BLOCKS output. Any pending CHECK SET and FIX SET messages are also
displayed.
Example
>review blocks @
REVIEW BLOCKS:
Fld Pth Entr Med Blk Blk Blk
Data Set Name Type Cnt Cnt Len Rec Capacity Fac Len Max
-----------------------------------------------------------------
CUSTOMER M 9 1 43 54 221 10 541 640
DATE-MASTER A 1 3 3 26 211 19 496 496
PRODUCT M 2 2 14 31 307 16 498 498
SALES D 8 4 21 37 504 14 519 640
SUP-MASTER M 5 1 31 42 211 12 505 505
INVENTORY D 6 3 20 32 450 15 481 481
>
In this example, all the data sets in the ORDERS database are reviewed
using the REVIEW BLOCKS command.