HP 3000 Manuals HP 3000 Manuals
CONTROL
Specifies the setting of several options controlling the way DBChange
operates. Automatically adjusts data set capacities.
Syntax
[LIST ]
CON[TROL] [NOLIST ]
[PERCENTFULL DataSet MinFull MaxFull [NewFull]]
Parameters
LIST writes all commands, their parameters, and any messages
to $STDLIST or the designated output device according to
the file equation that is set for DBCOUT. This parameter
is the default.
NOLIST displays messages and program output only. Commands and
their parameters are not written to $STDLIST. For
security reasons, CONTROL NOLIST can be used before the
PASSWORD command to prevent passwords from being
displayed on batch output.
PERCENTFULL indicates how full a data set can get before DBChange
Plus flags it as needing a capacity change. The
following options can be used with the PERCENTFULL
parameter:
DataSet identifies the name of the data set(s) to
be flagged for expansion. The DataSet can
be specified in one of the following ways:
DataSetName is the name of a specific
data set to which the
CONTROL PERCENTFULL command
applies.
@MASTERS indicates that the CONTROL
PERCENTFULL command applies
to all master data sets in
the database.
@DETAILS indicates that the CONTROL
PERCENTFULL command applies
to all detail data sets in
the database.
@ indicates that the CONTROL
PERCENTFULL command applies
to all data sets in the
database.
MinFull is the percent of the data set capacity at
which the specified data set(s) is flagged
for reduction. If the data set capacity
falls below the MinFull amount, DBChange
Plus immediately prints a warning. Zero
is a valid value.
MaxFull is the percent of the data set capacity at
which the specified data set(s) is flagged
for expansion. If the data set exceeds
the MaxFull value, a warning message is
printed.
NewFull is the desired percent of capacity for the
specified data set(s).
If the data set capacity falls below the
MinFull parameter or exceeds the MaxFull
parameter, the data set capacity within
the current change file is automatically
adjusted to the NewFull value. DBChange
avoids two's complement values and prime
numbers for master data sets and rounds to
the nearest block for detail data sets.
If the capacity is expanded, the specified
data set file is enlarged. Conversely, if
the data set capacity is decreased, the
specified data set file is reduced. When
reducing detail data set capacity, a
serial repack is used.
If this parameter is omitted, the percent
of capacity is set at 60 percent for
master data sets and 70 percent for detail
data sets.
Description
Use this command to control the following DBChange operations:
* To suppress commands and their parameters to $STDLIST during
DBChange command execution, whether interactively or batch.
* To determine minimum and maximum data set capacity for reduction
or expansion.
* To determine user access to the database while checking is in
progress.
The CONTROL command can be issued multiple times. However, each command
overrides the previous command. Therefore, you should first specify the
most inclusive group of sets being controlled, then the next most
inclusive group, and so on. For example, if you want all detail data
sets in the ORDERS database to be flagged for expansion at 60 percent of
capacity, except the INVENTORY data set, which should be flagged at 80
percent of capacity, use the following command sequence:
>control percentfull @ details 0 60
>control percentfull inventory 0 80
Because the second CONTROL statement overrides the first, every detail
data set, including the INVENTORY data set, is flagged for expansion at
60 percent of capacity. Only the INVENTORY data set is flagged for
expansion at 80 percent of capacity. Note that the CONTROL PERCENTFULL
parameter used with the NewFull option overrides any previous CHANGE
CAPACITY commands stored in the change file.
NOTE Because the most recent DBChange Plus command always takes
precedence over the previous command, you should issue the CONTROL
command immediately after issuing the BASE command.
To verify data set capacity in the current change file, use the
REVIEW SETS command.
Example
>base orders
>control nolist
>control percentfull @ details 55 85 65
>
In this example, the CONTROL command is used to control the ORDERS
database. Only messages and program output are sent to $STDLIST. The
percent of the data set capacity at which all the detail data sets are
flagged for reduction is 55 percent. The percent of the data set
capacity at which all the detail data sets are flagged for expansion is
85 percent. The desired percent of capacity is 65 percent.