Installing Sybase 12

The steps below describe how to--

Installing Sybase 12

Note: The Sybase 12 installer requires Java to be installed on the local host.

The Sybase 12 product CD contains the files necessary to install and configure Sybase 12 on a local AIX machine. Perform the following steps to install Sybase 12:

  1. Ensure that you are logged into the machine with superuser privileges (that is, log in as root).
  2. You can need to change your system's settings for the following parameters:

    For details on settings required for running Sybase, refer to the Sybase installation documentation. See your System Administrator for advice on changing these parameters.

  3. Invoke SMIT to enable Asynchronous I/O by entering the command # smit devices
  4. On the Devices window, select Asynchronous I/O.
  5. On the Asynchronous I/O window, select Change/Show Characteristics of Asynchronous I/O.
  6. On the Change/Show Characteristics of Asynchronous I/O window, do the following:
    1. Set the value for the STATE to be configured at system restart field to available.
    2. Set the value of the State of fast path field to enable.
    3. Accept the default values for the other fields and click OK. When the process has completed, exit from SMIT.
  7. Restart your system to enable the new settings to take effect.
  8. Ensure that the DISPLAY and TERM environment variables are set correctly for your environment.
  9. Create a file system, logical volume, or directory to hold the Sybase software. Ensure that the location you choose has 460 MB of free disk space.
  10. If you plan to use Sybase 12 in a production environment, it is recommended that you create a file system on a separate partition to store the database files. Refer to the Sybase 12 installation documentation and your AIX system documentation for more information on creating and mounting a file system.
  11. Set the JAVA_HOME environment variable to the directory where Java is installed on the local machine.
  12. Invoke SMIT to create an administrative group for Sybase (named sybase in this example), by entering the command # smit mkgroup
  13. In the Add a Group window, do the following:
    1. In the Group NAME field, type sybase.
    2. Click OK. When this process is complete, exit from SMIT.
  14. Create a separate and distinct user to administer Sybase (named sybase in this example) by entering the command # smit mkuser

    This user must have permission privileges from the top (root) of the operating system directory or disk partition down to the specific physical device or operating system file. It is recommended that this user perform all unloading, installing, upgrading, and setup tasks. See your System Administrator for advice on how to configure this user with root privileges.

  15. In the Add a User window, do the following (the value that you add for the HOME directory field can differ from the example shown here):
    1. In the User NAME field, type sybase.
    2. In the Primary GROUP field, type sybase.
    3. In the HOME directory field, type /home/sybase. The HOME directory to which the Sybase files are installed. The default is shown, but you can set a different value for the HOME directory.
    4. Click OK. When this process is complete, exit from SMIT.
  16. Ensure that root is part of the sybase group by entering the command # smit user
  17. From the Users window menu, choose Change / Show Characteristics of a User.
  18. In the Change / Show Characteristics of a User pop-up window, beside the User NAME field, type root and click OK.
  19. In the Change / Show Characteristics of a User window, do the following:
    1. In the Group SET field, ensure that the group sybase is included by clicking the field and scrolling to the end of the entries. If it is not included, append it to the end of the entries.
    2. Click OK. When this process is complete, exit from SMIT.
  20. Change the ownership of the home directory to the group sybase, user sybase, by issuing the command
    # chown sybase:sybase <home_directory>
  21. Switch to user sybase by using the command below. Note that when you log in as user sybase, the command prompt changes from # to $ to indicate your login identity. # su - sybase
  22. Ensure that your DISPLAY, TERM, and JAVA_HOME environment variables are still set properly. Additionally, check that your PATH environment variable includes the path to your Java installation.
  23. Ensure that a CD-ROM drive is installed and configured on the machine. If a CD-ROM drive is not installed or configured on the machine, install and configure one according to the installation instructions provided with the drive.
  24. Insert the CD into the drive.
  25. As root, use the mkdir command to create a mount point for the CD. The following command creates a mount point for the CD at /cdrom; you can mount the CD at any location in the machine's local file system. $ mkdir /cdrom

    Note: The commands in this document assume the CD is mounted at /cdrom. If you mount the CD at a different location, use that location when issuing the commands in this document.

  26. As root, invoke SMIT for configuring CD-ROM file systems by entering the command $ smit cdrfs
  27. From the CDROM File Systems menu, choose Add a CDROM File System.
  28. In the Add a CDROM File System window, do the following:
    1. With the cursor in the DEVICE name field, click the List button and choose the name of the CD-ROM drive that contains the Sybase 12 software CD.
    2. In the MOUNT POINT field, type the full pathname of the mount point for the CD. Use the name of the directory that you created with the mkdir command in Step 25.
    3. In the Mount AUTOMATICALLY at system restart field, set the value to either yes (to specify that the CD is mounted automatically each time the machine is restarted) or no (to specify that the CD is not mounted automatically each time the machine is restarted).
    4. Click OK. The CD-ROM file system is added. When this process is complete, exit from SMIT.
  29. As root, invoke SMIT for mounting a file system by entering the command $ smit mountfs
  30. In the Mount a File System window, do the following:
    1. With the cursor in the FILE SYSTEM name field, click the List button and choose the appropriate CD-ROM file system that you want to mount.
    2. In the DIRECTORY over which to mount field, type the name of the mount point for the CD. Use the name of the directory that you created with the mkdir command in Step 25.
    3. With the cursor in the TYPE of file system field, click the List button and choose cdrfs.
    4. Set the Mount as READ-ONLY system field value to Yes.
    5. Verify or change the entries in the remaining fields, depending on how you want to mount the CD, and then click OK. The CD is mounted as a file system. When this process is complete, exit from SMIT.
  31. As sybase, navigate to the correct directory on the Sybase 12 CD by entering the command $ cd /cdrom
  32. As sybase, enter the following command to begin the Sybase installation process:
    $ ./install

    The Installation Type window displays.

  33. Ensure that the radio button beside the Standard Install option is selected and click Next. (A Standard installation requires 460 MB of disk space. Customized installations can require additional disk space. See the Sybase installation documentation for more information.) The Choose Directory window displays.
  34. Specify the installation location for the Sybase files (make the installation directory the home directory of the sybase user) and click Next. The Summary window displays, summarizing all of the installation choices you have made so far.
  35. Verify the information on the Summary window. When you have determined that it is correct, click Next. The Installing window displays; it tracks the status of the Sybase installation.
  36. After the components are installed, the Sybase License Management window displays. Click No to exit from this window for now.
  37. The Sybase License Management window displays again. Click No to exit from this window for now.
  38. The Sybase Installer window displays. Click No to exit from this window for now.
  39. An Information window displays, informing you that installation is complete. Click OK.
  40. Create a .profile file in the home directory for the user sybase, as follows:
    1. Ensure that you are in the home directory of user sybase.
    2. Ensure that you are in the Bourne shell. If you are not, enter the command $ sh
    3. Copy the file SYBASE.sh to the file .profile: $ cp SYBASE.sh .profile
    4. If necessary, enter the following commands. The need to enter these commands depends on how user sybase is configured on your system. Ensure that you are in the home directory of user sybase before entering these commands. Incorrect use of these commands can damage your server's configuration. $ chown -R sybase:sybase * $ chown sybase:sybase .profile
    5. Add the following information to the .profile file (where <server_name> is name of your server that you plan to create and <home_directory> is the installation directory of the Sybase software and, in this example installation, the home directory of user sybase):
      DSQUERY=<server_name>
      export DSQUERY
      PATH=<home_directory>/ASE-12_0/install:$PATH
      export PATH
      XACONFIGFILE=<home_directory>/xa_config
      export XACONFIGFILE

      DSQUERY defaults to your machine's host name, but you can change the value to any valid ASE server name.

  41. Configure root to execute this .profile file on startup. This is required to install and run WebSphere Application Server.
  42. Log out and log back in as user sybase to enable the changes to the environment.
  43. To add licenses to your installation, enter the following command (where <home_directory> is the installation directory of the Sybase software and, in this example installation, the home directory of user sybase):
    $ <home_directory>/SYSAM-1_0/bin/lmgr
  44. The Sybase License Management window displays, asking if you have a Sybase Software Asset Management Certificate to register. Click Yes.

    Note: Your license agreement can differ from the type of agreement demonstrated here. Check with your system administrator or refer to the Sybase installation documentation for more information on registering licenses.

  45. On the window that displays, enter information from the Sybase License Certificate for the feature you have purchased. Click More if you have more licensed features. This action prompts the installer to record the information you entered for the first feature in the license file and to prompt you to enter information for the next feature. For WebSphere Application Server, you must install and define jConnect 5.2 to use JDBC 2.0/JTA. For distributed transactions with the WebSphere Application Server Advanced Edition, a DTM license (ASE 12.0 DTM Option) is required. Click Done after you enter all of your license information.

Determine whether you need to update the basic Sybase installation with an ESD fix by reviewing the information on the Software prerequisites Web site. If you must install a fix, note the fix level and proceed to the section "Upgrading Sybase 12 with an ESD."

Upgrading Sybase 12 with an ESD

To upgrade Sybase 12 with an ESD, do the following:

  1. If you have not already done so, see the Software prerequisites Web site to learn whether you need to install a Sybase ESD fix for your level of WebSphere Application Server. Note the ESD fix level needed.
  2. Ensure that you are logged into the machine as user sybase. Note that when you log in as user sybase, the command prompt appears as $, rather than #, to indicate your login identity.
  3. Create a directory into which to download the patch file.
  4. Open a Web browser window and go to http://www.sybase.com. Move to the downloading site, which can be restricted to registered users, and download the appropriate file. Check with your System Administrator if you cannot access this site.
  5. On the host machine, navigate to the directory containing the downloaded file.
  6. Uncompress and untar the downloaded file to extract the Sybase 12 files.
  7. Navigate to the <home_directory>/ASE-12_0 directory by entering the following command (where <home_directory> is the installation directory of the Sybase software and, in this example installation, the home directory of user sybase):
    $ cd <home_directory>/ASE-12_0
  8. Recursively copy the download directory contents to the <home_directory>/ASE-12_0 directory by entering the command below. <fix_directory> is the directory containing the fix files. It usually bears the name of the fix level (such as ebf8774, for example):
    $ cp -R /<download_directory>/<fix_directory>/* .

To test your installation, proceed to "Configuring and verifying installation of Sybase 12."