HP 3000 Manuals HP 3000 Manuals
PERFORM COMMANDS
Invokes the DBAPLUS program to copy, restructure, check, or maintain the
database depending on the commands stored in the current change file.
Syntax
PE[RFORM] COM[MANDS] [JOB] [ ParmValue]
Parameters
JOB creates a job file ( DatabaseNameJJ) to enable
running the DBAPLUS program at a later time.
For batch mode, this parameter is required. In
session mode, if you omit this option, DBChange
asks you if changes should be performed online or
if a job stream file should be created.
ParmValue is a parameter value from 0 to 15 that provides
instructions to DBAPLUS during execution. This
option is required for batch mode or if the JOB
parameter is used. In session mode, if you omit
this option, you are prompted for any necessary Y
or N responses.
PARM values can be determined by adding them
together. For example, if you want both PARM=1 and
PARM=4 to take effect, add them together and
specify PARM=5. Table 10-4 lists the questions
DBAPLUS may need answers to about parameter values.
Description
Use PERFORM COMMANDS to invoke DBAPLUS to copy, restructure, check, or
maintain the database according to the deferred commands stored in the
current change file. PERFORM COMMANDS should be the last command used
before the EXIT command or before the next BASE command if multiple
databases are being restructured.
In session mode, DBChange asks if changes should be performed online or
if a job stream file should be created. If you request a job stream file
to be created, DBChange creates FileNameJJ, which you can later modify
and stream. Note that the larger the database, the longer DBAPLUS takes
to perform the restructure. Therefore, depending on the size of the
database, you may want to create a batch job.
In batch mode, PERFORM COMMANDS only takes effect if the change file has
no errors. If errors are encountered since the most recent BASE command,
a message stating that the commands cannot be performed because previous
errors were encountered is displayed.
Refer to chapter 9, "Applying Changes to the Database Structure," for
more information about the DBAPLUS program.
Table 10-4. DBAPLUS Parameters
---------------------------------------------------------------------------------------------------
| | | | | |
| PARM | You do not have enough | The database | Your root file is | The change file is |
| Value | disk space to build all | has been | not in normal | normally purged |
| | necessary temporary data | modified since | DBSCHEMA format. | after successful |
| | sets before beginning | the last | Do you want DBAPLUS | completion of |
| | the restructure. Do you | DBSTORE. Do you | to fix it and | DBAPLUS. Do you |
| | want DBAPLUS to continue | wish to | continue with the | want to save the |
| | with the restructure | continue? | restructure? | change file? |
| | using an alternative | | | |
| | restructuring method? | | | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 1 | | | | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 2 | | | Y | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 3 | | | Y | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 4 | | Y | | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 5 | | Y | | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 6 | | Y | Y | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 7 | | Y | Y | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 8 | Y | | | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 9 | Y | | | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 10 | Y | | Y | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 11 | Y | | Y | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 12 | Y | Y | | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 13 | Y | Y | | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 14 | Y | Y | Y | |
| | | | | |
---------------------------------------------------------------------------------------------------
| | | | | |
| 15 | Y | Y | Y | Y |
| | | | | |
---------------------------------------------------------------------------------------------------
Example
>base orders
>fix base
Fix Base (Fix Root, Fix Set and Fix Path) issued for 6 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
THU, JAN 18, 1990, 7:15 AM
Database has been modified since last DBSTORE (DBA 220).
Continue [y/N] ? y
HP36386 (X.00.02) DBCHANGE (c) COPYRIGHT Hewlett-Packard Co. 1985
>
In this example, the BASE command is issued for the ORDERS database. The
FIX BASE command is issued, followed by PERFORM COMMANDS. DBChange asks
if changes should be performed online or if a job stream file should be
created. Because the database has been modified since the last DBSTORE,
DBAPLUS asks if you want to continue. When the database has been
successfully fixed, the DBChange prompt is returned.