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.



   >>

Respond to the prompts as in the following dialog. For DBEName, enter hpsql/sampledb/PartsDBE in HP-UX, or PartsDBE in MPE/iX.

   >> 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.