HP 3000 Manuals HP 3000 Manuals
Examining Startup Parameters with SQLUtil
Use the SQLUtil program to examine the startup parameters of PartsDBE or
any other DBEnvironment. Run the program as follows (if you are using
HP-UX, first make sure you are in the same working directory from which
you created PartsDBE):
sqlutil Return
SQLUtil displays a banner like the following (some details can be
different on your system):
______________________________________________________________________________
| |
| |
| WED, AUG 08, 1990, 11:30 AM |
| HP36217-02A.07.00.17 DBE Utility/9000 HP SQL/HP-UX |
| (C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988, |
| 1989. ALL RIGHTS RESERVED. |
| |
| >> |
| |
______________________________________________________________________________
Figure 4-9. SQLUtil Banner
Respond to the prompts as in the following dialog. For DBEName, enter
hpsql/sampledb/PartsDBE in HP-UX, or PartsDBE in MPE XL.
>> SHOWDBE Return
DBEnvironment Name: DBEName
Maintenance Word: Return
Output File Name (opt): Return
-> ALL Return
The following display should appear (some details can vary on your
system):
Maintenance word:
DBEnvironment Language: n-computer
AutoStart: ON
User Mode: MULTI
DBEFile0 Name: PartsF0
DDL Enabled: YES
No. of Runtime Control Block Pages: 37
No. of Data Buffer Pages: 100
No. of Log Buffer Pages: 24
Max. Transactions: 5
>> E Return
Use the E command to exit from SQLUtil and return to your operating
system.
The parameters shown above describe the configuration of the sample
DBEnvironment immediately after setting it up with SQLSetup. All of them
are described in the "DBEnvironment Configuration and Security" chapter
of the ALLBASE/SQL Database Administration Guide, so they are not
described further here. Many of them can be adjusted by the database
administrator to meet the needs of a particular system.