Additional AAI Installation Tasks
There are a number of additional tasks you have to take care of after the installation.
Create the Database - Include Devices, Logins, Tables, and Indices
The AAI installer places createDevices.sql
and createJawsDB.sql
in the scripts directory installation_dir/scripts
. These SQL scripts are intended to be edited and modified by a DBA to suit your environment. Parameters that might be edited include:
- Physname: The physicalname of the database device gives the name of a raw disk partition (UNIX) or foreign device (OpenVMS) or the name of an operating system file. On PC platforms, you can use only operating system file names for physicalname.
- Size: The size of the database device must be given in 2K blocks. There are 512 2K blocks in 1MB. The maximum size of a database device is 1,048,576 2K blocks (2GB). The size in the
createDevices.sql
file for the data device is set at 870,400 blocks. The size in thecreateDevices.sql
file for the log device is 153,600 blocks. This file can be modified if necessary and these settings changed then executed using sql. - Login: The Login section in the
createDevices.sql
creates a default login user. For SQL Server using Kerberos login, this section can be removed if you do not plan to use this default user. - Create the AAI Database: If you have modified the
createDevices.sql
script to change the sizes specified for the log and/or data devices, you will need to modify the on clause to change the size of the data and log segments used. The on the clause specifies the names of one or more database devices and the space allocation, in megabytes, for each database device.
Notes:
- The createJawsDB.sql script should be run by the user-specified, in and created by, the createDevices.sql script.
- The createDevices.sql script must be run by a DB administrator account.
Database Cleanup Script
In the event you already have a database and want to start with a fresh install, there is an SQL script (deleteJawsDB.sql) located in the scripts directory installation_dir/scripts
for cleaning up an existing AAI database. The script drops the database, database devices, and user definition that was created in the create script.
See also: