To install and operate ALLBASE/SQL, you need at least 4 megabytes
of memory and 10 megabytes of swap space for a single-user DBEnvironment.
Allow 3.5 megabytes of swap space for each additional concurrent
ALLBASE/SQL user in a multiuser DBEnvironment.
The following is an estimate of the amount of disk space required
in /opt to install each fileset in the ALLBASE/SQL product (figures
are approximate):
Table 3-1 Disk
Space Required by ALLBASE/SQL FileSets
Fileset | Name | 700/800 Space |
---|
RunTime | AB-RUN | 25.2 Mbytes |
Development | AB-DEV | 8.0 Mbytes |
AB-NET | AB-NET | 0.75 Mbytes |
AB-SAMPLEDB | AB-SAMPLEDB | 1.2 Mbytes |
About two thirds of the total is in /opt/allbase/bin and one
third is in /opt/allbase/lib.
The following space is required in a local directory ($local)
to create a copy of the sample DBEnvironment PartsDBE and to preprocess,
compile, and link the sample programs:
Table 3-2 Disk
Space Required for Copies of Sample DBEnvironment
Pathname | 700/800 Space |
---|
$local/hpsql/sampledb | 2.6 Mbytes |
$local/hpsql/programs | 15 Mbytes |
Files in the ALLBASE/SQL Filesets: |
 |
Table 3-3 AB-DEV
Fileset
MODE | OWNER | GROUP | FILENAME | DESCRIPTION |
---|
4555 | hpdb | bin | /opt/allbase/bin/dumpshm | support tool |
555 | bin | bin | /opt/allbase/bin/isql | ISQL program file |
4555 | hpdb | bin | /opt/allbase/bin/sqlgen | SQLGEN program file |
4555 | hpdb | bin | /opt/allbase/bin/sqlmig | SQLMigrate program file |
4555 | hpdb | bin | /opt/allbase/bin/sqlutil | SQLUtil program file |
555 | bin | bin | /opt/allbase/bin/sqlver | SQLVER program file |
4555 | hpdb | bin | /opt/allbase/bin/sqlmon | SQLMON program file |
4555 | hpdb | bin | /opt/allbase/bin/sqlcheck | SQLCheck program file |
555 | bin | bin | /opt/allbase/bin/sqlaudit | SQLAudit program file |
444 | bin | bin | /opt/allbase/lib/hppcapi | MS-DOS self-extracting file for PC API |
444 | bin | bin | /opt/allbase/lib/hpsqlcat | message catalog file |
4555 | hpdb | bin | /opt/allbase/lbin/hpsqlproc | ALLBASE/SQL program file |
444 | bin | bin | /opt/allbase/lib/isqlwel | welcome message banner |
444 | bin | bin | /opt/allbase/lib/libsql.a | ALLBASE/SQL library file |
444 | bin | bin | /opt/allbase/lib/nls/C | sqlver message catalog |
| | | /sqlver.cat | file |
444 | bin | bin | /opt/allbase/lib/nls/n-computer/hpsqlcat | message catalog file |
444 | bin | bin | /opt/allbase/lib/nls/n-computer/isqlwel | welcome message banner |
4555 | hpdb | bin | /opt/allbase/lbin/sqldaemon | process cleanup daemon |
Table 3-4 AB-RUN
Fileset
MODE | OWNER | GROUP | FILENAME | DESCRIPTION |
---|
555 | bin | bin | /opt/allbase/bin/psqlc | C preprocessor program file |
555 | bin | bin | /opt/allbase/bin/psqlcbl | COBOL preprocessor program file |
555 | bin | bin | /opt/allbase/bin/psqlfor | FORTRAN preprocessor program file |
555 | bin | bin | /opt/allbase/bin/psqlpas | Pascal preprocessor program file |
444 | bin | bin | /opt/allbase/include/sqlcall.c | COBOL preprocessor interface source file |
444 | bin | bin | /opt/allbase/include/sqlcall.cbl | COBOL preprocessor system file |
444 | bin | bin | /opt/allbase/include/sqlcall.h | COBOL preprocessor interface header file |
Table 3-5 AB-NET
Fileset
MODE | OWNER | GROUP | FILENAME | DESCRIPTION |
---|
4544 | root | bin | /opt/allbase/bin/hpdaARPA | listener daemon for ARPA |
444 | bin | bin | /opt/allbase/lib/hpsqlcat | message catalog file |
555 | bin | bin | /opt/allbase/bin/isql | ISQL program file |
444 | bin | bin | /opt/allbase/lib/isqlwel | welcome message banner |
444 | bin | bin | /opt/allbase/lib/libsql.a | ALLBASE/SQL library file |
555 | bin | bin | /opt/allbase/bin/netutil | ALLBASE/NET utility program file |
444 | bin | bin | /usr/lib/nls/ | message catalog file |
| | | n-computer/hpsqlcat | |
444 | bin | bin | /usr/lib/nls/ | welcome message banner |
| | | n-computer/isqlwel | |
Table 3-6 AB-SAMPLEDB
Fileset
MODE | OWNER | GROUP | FILENAME | DESCRIPTION |
---|
444 | bin | bin | /opt/allbase/lib/readme | text file |
Files installed
in /opt/allbase/lib/hpsql/ |
444 | bin | bin | readme | text file |
555 | bin | bin | setup | executable script |
555 | bin | bin | sqlsetup | executable script |
| | | | |
444 | bin | bin | sampledb/Album | data file |
444 | bin | bin | sampledb/CREAINDX | command file |
444 | bin | bin | sampledb/CREASEC | command file |
444 | bin | bin | sampledb/CREATABS | command file |
444 | bin | bin | sampledb/Clubs | data file |
444 | bin | bin | sampledb/Events | data file |
444 | bin | bin | sampledb/Inventor | data file |
444 | bin | bin | sampledb/LOADTABS | command file |
444 | bin | bin | sampledb/Members | data file |
444 | bin | bin | sampledb/OrderIte | data file |
444 | bin | bin | sampledb/Orders | data file |
444 | bin | bin | sampledb/Parts | data file |
444 | bin | bin | sampledb/Report1 | data file |
444 | bin | bin | sampledb/STARTDBE | command file |
444 | bin | bin | sampledb/SupplyBa | data file |
444 | bin | bin | sampledb/SupplyPr | data file |
444 | bin | bin | sampledb/TestData | data file |
444 | bin | bin | sampledb/Title | data file |
444 | bin | bin | sampledb/Vendors | data file |
| | | | |
444 | bin | bin | sampledb/creajob | creation script |
444 | bin | bin | sampledb/gengen | command file |
| | | | |
444 | bin | bin | programs/TMPLC1 | Up and Running template |
444 | bin | bin | programs/TMPLC2 | Up and Running template |
444 | bin | bin | programs/TMPLC3 | Up and Running template |
444 | bin | bin | programs/TMPLCA | Up and Running template |
444 | bin | bin | programs/TMPLCB | Up and Running template |
| | | | |
444 | bin | bin | programs/cex10a | C program |
444 | bin | bin | programs/cex10b | C program |
444 | bin | bin | programs/cex12 | C program |
444 | bin | bin | programs/cex2 | C program |
444 | bin | bin | programs/cex5 | C program |
444 | bin | bin | programs/cex7 | C program |
444 | bin | bin | programs/cex8 | C program |
444 | bin | bin | programs/cex8a | C program |
444 | bin | bin | programs/cex9 | C program |
| | | | |
444 | bin | bin | programs/cobex10a | COBOL program |
444 | bin | bin | programs/cobex10b | COBOL program |
444 | bin | bin | programs/cobex12 | COBOL program |
444 | bin | bin | programs/cobex2 | COBOL program |
444 | bin | bin | programs/cobex5 | COBOL program |
444 | bin | bin | programs/cobex7 | COBOL program |
444 | bin | bin | programs/cobex8 | COBOL program |
444 | bin | bin | programs/cobex8a | COBOL program |
444 | bin | bin | programs/cobex9 | COBOL program |
| | | | |
444 | bin | bin | programs/forex12 | FORTRAN program |
444 | bin | bin | programs/forex2 | FORTRAN program |
444 | bin | bin | programs/forex5 | FORTRAN program |
444 | bin | bin | programs/forex7 | FORTRAN program |
444 | bin | bin | programs/forex8 | FORTRAN program |
444 | bin | bin | programs/forex8a | FORTRAN program |
444 | bin | bin | programs/forex9a | FORTRAN program |
444 | bin | bin | programs/forex9b | FORTRAN program |
| | | | |
444 | bin | bin | programs/pasex10a | Pascal program |
444 | bin | bin | programs/pasex10b | Pascal program |
444 | bin | bin | programs/pasex12 | Pascal program |
444 | bin | bin | programs/pasex2 | Pascal program |
444 | bin | bin | programs/pasex5 | Pascal program |
444 | bin | bin | programs/pasex7 | Pascal program |
444 | bin | bin | programs/pasex7l | Pascal program |
444 | bin | bin | programs/pasex8 | Pascal program |
444 | bin | bin | programs/pasex8a | Pascal program |
444 | bin | bin | programs/pasex9 | Pascal program |
System Configuration |
 |
This section discusses the system configurable parameters
which directly affect the execution of ALLBASE/SQL. These parameters
are part of the system configuration and can be modified using SAM.
Please refer to the System Administration Tasks HP 9000
for more information. You may need to increase parameter values
to meet your needs.
The system parameters namely semmni, semmns, shmmni and shmseg
and their uses by ALLBASE/SQL are explained in the following table:
Table 3-7 Table
7. System Parameters Used By ALLBASE/SQL
Parameter | 700/800 Default | Purpose |
---|
maxuprc | 50 | Specifies the maximum number of processes
that a user may have. When an application connects to a DBEnvironment,
a process is spawned. In addition, each active DBEnvironment has
one database daemon process running. |
semmni | 64 | Specifies the number of sets (identifiers)
of semaphores available to the users. The semmni should be set to: semmni = NDBE + (2 * NCON) where: NDBE = number of distinct DBEnvironments NCON = number of DBEnvironment connections (maximum of 32 per user application)
|
See
the System Administration Tasks HP 9000 for
the interactions of the semmni parameter with other system parameters. |
semmap | formula at right | Specifies the maximum number of semaphore
maps. The system default is: semmap = ((semmni + 1) / 2 + 2) where: semmni = number of semaphore identifiers
|
Note:
If semmap is set too low, the following message will appear on the
console: danger: mfree map overflow
|
|
semmns | 64 | Specifies the maximum number of semaphores.
To determine the maximum number of semaphores allowed, use the following
formula: semmns = (2 * NDBE) + (3 * NCON) where: NDBE = number of distinct DBEnvironments NCON = number of DBEnvironment connections (maximum of 32 per user application)
|
|
shmseg | 12 | Specifies the maximum number of shared
memory segments to which one process can simultaneously attach.
An ALLBASE/SQL user application will be attached one shared memory
segment for every connection to a DBEnvironment. The maximum number
of DBEnvironment connections for a user application is 32. This
shared memory segment allows communication between the user application
and the ALLBASE/SQL DBCore process. |
shmmni | 100 | Specifies the maximum number of shared
memory segments that can be allocated by the system. To determine
how many shared memory segments you will need, use the following
formula: shmmni = NDBE + NCON where: NDBE = number of distinct DBEnvironments NCON = number of DBEnvironment connections (maximum of 32 per user application)
|
|
shmmax | 64 Mbytes | Specifies in hexadecimal the maximum
number of bytes in a shared memory segment. (Decimal values are
given in parentheses). The total size of the shared memory segment
specified by the parameters of the SQL START DBE command or the
SQLUtil ALTDBE command cannot exceed this maximum. For ALLBASE/SQL,
the shared memory used by a particular DBEnvironment comprises the
Number of Runtime Control Block Pages, the Number of Log Buffer
Pages, the Number of Data Buffer Pages, and the Number of Transaction
Block Buffer Pages. |
There are several other system parameters which are not directly
affected by the execution of ALLBASE/SQL, but may be indirectly
affected by an ALLBASE/SQL user's application. Refer to the System
Administration Tasks HP 9000 for information on memory
allocation and system reconfiguration. Refer also to "Estimating
Shared Memory Requirements" in the "Physical Design"
chapter of the ALLBASE/SQL Database Administration Guide
for further information on system parameters.