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 the createDevices.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: