![]() |
![]() |
|
|
![]() |
![]() |
ALLBASE/SQL Release G3.37 Release Notes: HP 9000 Computer Systems > Chapter 3 Compatibility
and Installation Requirements ![]() Installation Information and Recommendations |
|
Before upgrading or installing ALLBASE/SQL, ensure that your system meets the requirements described in this section:
These release notes are specifically for ALLBASE/SQL Release G3.37 on HP-UX release 11.11. Please make sure that your version of ALLBASE/SQL is appropriate for your version of HP-UX. If not, you must install the appropriate version of HP-UX on your system in addition to ALLBASE/SQL Release G3.37. When running ALLBASE/SQL with a large number of users, increase
the configurable parameters accordingly. You can do this when you
first create the DBEnvironment or by using SQLUtil. Refer to the "Maintenance" chapter
in the ALLBASE/SQL Database Administration Guide for more information setting ALLBASE/SQL parameters.
See the ALLBASE/SQL Performance and Monitoring Before creating or connecting to an ALLBASE/SQL DBEnvironment, make sure there is a special user named hpdb with a user id number of 27 and a group id number of 2 on your system. If necessary, add the following line to the /etc/passwd file before invoking the HP-UX SWINSTALL utility to install the ALLBASE/SQL product:
In addition, add user hpdb to the group bin in the /etc/group file, as in the following example:
The user id number 27 is reserved for the user name hpdb, which is required to execute the ALLBASE/SQL program files. It is not required that the hpdb user belong to the group bin; however, all of the ALLBASE/SQL files are associated with bin. If the user id number 27 does not exist on your system, or if a user other than hpdb is assigned to this user id number, the security and integrity of your DBEnvironments cannot be guaranteed. The ALLBASE/SQL program files are owned by the user hpdb. Several of the ALLBASE/SQL program files have set the file mode to 4555 which causes the "switch user id bit" to be turned on. Any users executing these ALLBASE/SQL program files have their effective user name changed to hpdb while these program files are executing. The user's group name remains the same as the group name the user is associated with in the file /etc/group. All files that are created as part of the database have the file permissions of 600, are owned by hpdb, and have the file creator's group association. For example, if user peter, who is a member of group dbsupport, creates a DBEnvironment named PartsDBE, the HP-UX file permissions and ownership for the DBECon file (DBEnvironment configuration file) will appear as follows:
The number of filesets on your installation tape depends on which bundle of ALLBASE/SQL you have purchased. ALLBASE/SQL Development bundle has the following filesets:
ALLBASE/SQL Runtime bundle has the following filesets:
You do not need to load the SAMPLEDB fileset. SAMPLEDB is provided as an educational example and is not required for either the runtime or development version of ALLBASE. With Release G3, you have the option of installing a runtime version of ALLBASE/SQL. If you are installing only the runtime system, and if you have previously installed a complete earlier version of ALLBASE/SQL on your system, you should remove pre-Release G3 ALLBASE/SQL files from your system to ensure that all database files are consistent. Before removing the ALLBASE/SQL pre-Release G3 files, you may want to make a backup copy of them. If the database files are in their original directories, you may have to remove all previously installed ALLBASE/SQL files. For example, assume that your system currently has ALLBASE/SQL F0.00. Installing the runtime version of ALLBASE/SQL G3 would result in an F0.00 version of the ALLBASE/SQL preprocessors coexisting with a Release G3 version of the runtime system. In this case the preprocessors will not work correctly. After removing the old files, install your new ALLBASE/SQL package as shown in the section "HP-UX SWINSTALL Utility." The AB-NET fileset contains ALLBASE/NET, which is required for remote database access. If you desire a runtime client-only configuration, this is the only fileset you need to install. The kill -9 command, commonly used by a superuser to abort a process, may cause an undetected deadlock condition to occur or other processes connected to the same DBEnvironment to terminate or hang if it is used to abort a database process in a multiuser environment. You should never use the kill -9 command to abort an ALLBASE/SQL database process in a multi-user environment. Instead, use the TERMINATE USER command in ISQL to terminate a specific SessionID or all sessions for a DBEUserID. Refer to the ALLBASE/ISQL Reference Manual for further details. The swinstall utility is used by system administrator to add optional software to the system and to update the entire system when necessary. For detailed instructions on the use of swinstall, refer to the appropriate HP-UX Installation manual for your series.
The swinstall command installs the software-selections from a software source (tape) to the local host (root filesystem). The software is configured for use on the target after it is installed. There are three main steps in the installation process namely:
Type swinstall at the command line. You will be first asked to specify the target or destination of the software. Then you will be asked for the source from where the software will be installed. Fill up the details for Source Host Name and the Source Depot Path from where the software has to be installed. Press OK. You will get the message saying "Reading the Software source." The Software Selection Window then displays the Software bundle that is available with the tape. ALLBASE/SQL is available on both S800 and S700 platforms and is bundled as follows:
Select the software bundle that you need to install.
The Analysis Phase lets you determine if the software can be successfully installed on the system BEFORE it is actually installed. A series of checks are performed on the process and the results are displayed in the window or written to a log file.
The Install Phase is when the actual installation takes place. The Install window allows you to monitor the progress of the operation as the software is loaded and configured. This completes the process of Installation of ALLBASE/SQL on HP-UX System. To confirm that the installation is successful and no files are missing, refer to "Using SQLVer" below. |
![]() |
||
![]() |
![]() |
![]() |
|||||||||
|