ISA 1.5 contains the following new features:
ISA 1.5 contains the following new or enhanced utilities:
Utility Name | Function |
onstat -g ses |
Displays SQSCB information: the values of the scb (session configuration block), sqscb (session configuration block for the sql context), optofc (open fetch close optimization), pdqpriority (degree of parallelism used by server), sqlstats (primary thread statistics), optcompid (when indices may be compared with other scan and join methods), and directives (whether optimization directives are ON or OFF). |
oncheck |
When viewing tblspace information for an entire database or for a single table or table fragment, user can specify the number of pages to display and to print headers only. |
IMPORTANT: |
See 3. What You Need to Install and Run ISA for important information on using the Server Setup and Remote Monitoring features. |
For a list of known issues, see the Known Issues file.
IMPORTANT: | You must install ISA 1.5 on each machine (ISA node) that hosts
an Informix database server instance that you plan to manage.
For Informix XPS database servers, install ISA on the same node as coserver 1. |
To install and run ISA:
NOTE: | You can install ISA anywhere you have enough free disk space. However, we recommend that you do not install ISA in $INFORMIXDIR (do not associate ISA with a particular database server instance). |
The installation automatically verifies that the port that you specify is free.
When you install ISA, the installation script installs and configures the Perl and the Apache HTTP server. (This server runs as user informix.) If you do not want the installer to configure the Perl environment, please consult the PERL-CONFIG file for details on how to configure Perl.
NOTE: | You can install ISA anywhere you have enough free disk space. However, we recommend that you do not install ISA in %INFORMIXDIR% (do not associate ISA with a particular database server instance). |
The installation cannot detect that the port that you select is free.
To use the Remote Monitoring feature, you must:
To use the Server Setup feature, you must:
NOTE: | Server Setup supports Informix database server versions 7.30, 7.31, 9.20, 9.21, 9.30, and 9.40. |
You need the following information to respond to prompts during ISA installation. For convenience, you can print out this checklist separately from this README file.
UNIX Installation Checklist | ||||
1. ISA Apache HTTP server |
|
If yes, ISA installs Apache in <isadir> and configures it automatically. ISA does not overwrite any existing Apache environments currently on your system. | ||
|
If no, installation will discontinue. | |||
2. ISA Perl environment |
|
If yes, ISA installs Perl in <isadir> and configures it automatically. ISA does not overwrite any existing Perl environments currently on your system. | ||
|
If no, see "Using Your Own Perl Server". | |||
3. Hostname | _________________________ | This is the name of the computer (ISA node) on which you are installing ISA. | ||
4. Port number for ISA server | _________________________ | ISA checks your services file for available
port numbers and provides an available default port number.
If you do not use the default, make sure that port number is between 1025 and 65535 inclusive and is available for use on the machine on which you are installing ISA. If your environment does not use the services file for port numbers, check with your system administrator. Make sure that you add this port number to the services file. |
||
5. Email address | _________________________ | This must be a valid email address.
ISA sends problem reports to this email address. We recommend that you create an alias isa-admin for this purpose. ISA stores this information in the ServerAdmin parameter in the <isadir>/httpd/etc/httpd.conf file. |
||
5a. Confirm email address |
|
If yes, the installer tests the email address by sending the README file. You must verify that the email address received the test email. | ||
|
If no, the installer does not send a test message. You must use another method to verify that the email address is correct. | |||
6. HTTP server password for user "informix" | ****
(For security, do not write the password in the checklist.) |
When a user accesses ISA through the web browser, the browser
prompts for a username and password. The user logs in as user informix
with the password that you supply here.
This password does not have to be the same as the system password for user informix. However, anyone who can access ISA with this username and password can do anything that user informix can do from the database server command line. ISA stores the username and password in the file <isadir>/httpd/etc/passwd. |
||
7. Read-only users |
|
Read-only users can monitor the server using ISA,
but cannot perform administrative tasks, such as changing the mode of the
server or adding storage spaces.
ISA user accounts are not related to operating system user accounts; they exist only in the ISA server. |
||
|
||||
8. Java-enabled features |
|
To use the Java-enabled ISA features (Server Setup and Remote
Monitoring), you must have a Java Runtime Environment (JRE) version 1.2.2
or higher already installed.
If yes, fill out the steps 8a and 8b. The installation will configure ISA to use the JRE. |
||
|
If no, skip to step 9.
If you continue the installation without the JRE and later want to access the Remote Monitoring or Server Setup features, you must install the JRE, stop the Apache HTTP server, and reinstall ISA. |
|||
8a. JRE executable path | _________________________ | Specify the complete file path to the JRE executable (java). For example, /usr/java/bin. | ||
8b. Port number for ISA servlet engine | _________________________ | ISA checks your services file for available
port numbers and provides an available default port number.
If you do not use the default, make sure that port number is between 1025 and 65535 inclusive, different from the ISA Apache HTTP server port number, and is available for use on the machine on which you are installing ISA. Make sure that you add this port number to the services file. |
||
9. Update /etc/services file |
|
We recommend that you update the /etc/services with the port numbers for the ISA server and the ISA servlet engine (if applicable) to prevent accidental reuse of these port numbers. | ||
|
||||
9a. Configure ISA to manage a database server instance |
|
If your UNIX environment includes the following
valid INFORMIX variables for a database server instance, the installer prompts
you to configure ISA to manage that server:
If yes, the installer adds these values to the <isadir>/etc/isacfg file. If INFORMIXSQLHOSTS is also present in the environment, the installer adds it to <isadir>/etc/isacfg. |
||
|
||||
10. Start the ISA Apache HTTP Server |
|
You must start the ISA Apache HTTP server before
you can access ISA.
To start the server manually as user informix, run the <isadir>/sbin/isactl start command. |
||
|
||||
11. Run ISA | To run ISA, open a web browser, access http://hostname:port_number/, and log in as user informix (or as a read-only user) using the password you provided during the installation. |
You need the following information to respond to prompts during ISA installation. For convenience, you can print out the checklist separately from this README file.
Windows Installation Checklist | ||
1. Directory for ISA temporary files | _________________________ | Specify the location for the ISA temporary files. |
2. Destination for ISA installation | _________________________ | Specify the location for the ISA installation. |
3. Program Folder | _________________________ | Specify the Program Folder to which to add ISA. |
4. ISA Apache HTTP server |
|
If yes, ISA installs Apache in the destination directory and configures it automatically. ISA does not overwrite any existing Apache environments currently on your system. |
|
If no, installation will discontinue. | |
5. Specify Apache Port Number | _________________________ | Make sure that the port number you specify is between 1025
and 65535 inclusive and is available for use on the machine on which you
are installing ISA.
If your environment does not use the services file for port numbers, check with your system administrator. Make sure that you add this port number to the services file. |
6. Specify ISA Administrator Email | _________________________ | This must be a valid email address.
ISA sends problem reports to this email address. We recommend that you create an alias isa-admin for this purpose. ISA stores this information in the ServerAdmin parameter in the <isadir>\httpd\Apache\conf\httpd.conf file. |
7. Java-enabled features |
|
To use the Java-enabled ISA features (Server Setup and Remote
Monitoring), you must have a Java Runtime Environment (JRE) version 1.2.2
or higher already installed.
If yes, fill out the steps 7a and 7b. The installation will configure ISA to use the JRE. |
|
If no, skip to step 8.
If you continue the installation without the JRE and later want to access the Remote Monitoring or Server Setup features, you must install the JRE, stop the Apache HTTP server, and reinstall ISA. |
|
7a. Specify Apache JServ Port Number | _________________________ |
Make sure that port number you choose is between 1025 and 65535 inclusive, different from the ISA Apache HTTP server port number, and is available for use on the machine on which you are installing ISA. Make sure that you add this port number to the services file. |
7b. Specify Location of JVM | _________________________ | Specify the complete file path to the JRE executable (java). For example, C:\Informix\ISA\java\bin. |
8. Run ISA | To run ISA, open a web browser, access http://hostname:port_number/,
and log in as user informix.
Before you can run ISA, you must complete step 4 in 4. Installing ISA for the First Time. |
For disk space requirements, see "3. What You Need to Install and Run ISA".
This file is the README file in the installation directory.
NOTE: | To use the Java-enabled features (Remote Monitoring and Server Setup), follow the steps in "12. Installing the Java Runtime Environment" before continuing with step 3. |
IMPORTANT: | You must run installisa on the machine that will run the ISA server. Installation onto network mounted drives might fail if the root user does not have permission to change ownership and mode of files. |
NOTE: During installation, the C API files are installed in the following directories:
|
<isadir>/lib |
|
<isadir>/incl |
|
<isadir>/test |
If you select to not start the ISA server during the installation process, you must start the ISA server manually. The ISA server must be running for users to access ISA.
IMPORTANT: | Although you can start the ISA server as either root or informix, We recommend that you start the ISA server as user informix. If you initially start the ISA server as root, you must always start it as root because the httpd log files will be owned by root. |
You might want to configure your operating system to start and stop the ISA server automatically whenever the machine is rebooted. The procedure for starting and stopping ISA automatically when the machine reboots depends on your operating system. See your system documentation for details. On many systems, the <isadir>/sbin/isactl file is suitable as a startup/shutdown script.
The HTTP server produces log files in <isadir>/httpd/var/log. Consult these files if you have difficulty starting the ISA server.
IMPORTANT: | The Perl distribution bundled with ISA 1.5 requires a libdb.so.3 shared library. The Redhat 8 Linux distribution does not include this shared library. In order to successfully install ISA 1.5 using the bundled Perl you will need to create a symbolic link named /usr/lib/libdb.so.3 which points to the /lib/libdb-4.0.so shared library. For example, ln -s /lib/libdb-4.0.so /usr/lib/libdb.so.3 |
a. Double-click isa.zip to extract the installation files.b. Change to the directory where you extracted the files and double-click setup.exe.
For disk space requirements, see "3. What You Need to Install and Run ISA".
NOTE: During installation, the C API files are installed in the following directories:
|
<isadir>\lib |
|
<isadir>\incl |
|
<isadir>\test |
To add the informix user account, open a Command Prompt window and follow these steps:
Provide the password you choose (twice).
To add read-only users, repeat the command without the -c
option, specifying the username.
For example, to add a user named guest,
you might enter the following command:
bin\htpasswd conf\passwd guest
Windows 2000 | Select the Services item from Computer Management. |
Windows NT | Open the Services item in the Control Panel. |
Windows 2000 | Click the Log On tab. |
Windows NT | Skip to step e. |
You can also add "read-only" users.
NOTE: |
If you are using an Apache HTTP server from an earlier ISA installation, you must uninstall your existing server. Follow the steps in "10. Uninstalling the Apache Service (Windows NT)". |
If you are upgrading from a previous version, you can install ISA 1.5 into the ISA directory for the previous version. (See the "Windows" section in the Known Issues file.)
IMPORTANT: |
|
IMPORTANT: | To perform administrative tasks, you must use the informix username and password. |
NOTE: | The ISA HTTP server user informix is different than the database server user informix. If you set environment variables for user informix at the command line, this environment is not set for the ISA HTTP server user informix. To set up the environment for the ISA HTTP server user informix, add the environment variables when you set up ISA. |
The browser displays the Informix Servers page.
To set up ISA, from the database server-selection page:
NOTE: | Add any environment variables that apply to each database server instance that you manage with ISA. |
NOTE: | ISA 1.5 is not supported on the following platforms:
|
NOTE: | The Server Setup and Remote Monitoring features are only supported on platforms which support the JRE version 1.2.2 or 1.3. For more information, see "12. Installing the Java Runtime Environment". |
Send suggestions and comments regarding ISA improvement to smtools@us.ibm.com.
To uninstall the Apache service:
NOTE: | The JRE is included with the JDK (also known as Java 2 SDK). |
For those platforms which support the JRE, ISA 1.5 is certified to work with JRE versions 1.2.2 and higher. If you do not already have the JRE 1.2.2 or higher installed on the ISA node, we recommend that you download the latest 1.2.2 or higher JRE from your platform vendor's website. You can also use the version included with your ISA distribution.
NOTE: | You can install the JRE required by ISA 1.5 regardless of any other versions of the JRE already installed. For example, you might want to install this JRE in <isadir>/etc/jre. |
IMPORTANT: | Although IBM makes every effort to ensure a high quality release, IBM is not responsible for problems or bugs associated with the JRE. For technical support on the JRE, contact the appropriate platform vendor. |