Installing Sybase 12

This article describes how to do the following:

  • Install Sybase 12 on a local AIX machine.
  • Upgrade Sybase 12 with an Electronic Software Distribution (ESD) fix.

These instructions assume the following:

  • Your machine has enough memory and disk space for your installation. See the Sybase Product Manuals Web site at sybooks.sybase.com/asp1200e.html for the requirements.
  • You do not have a previous version of Sybase already installed on your machine. If a previous version of Sybase is installed, you can need to migrate databases, depending on the version installed. In this case, do not follow these instructions. Instead, refer to the Sybase Product Manuals Web site at sybooks.sybase.com/asp1200e.html.
  • Your Sybase database server will reside on the same machine as WebSphere Application Server. This configuration and the use of the default settings documented in these instructions are appropriate only for development and small production environments.

Note: Install Sybase before installing WebSphere Application Server. The Sybase installer requires Java to be installed on the local machine.

Installing Sybase 12

Perform the following steps to install Sybase from the product CD-ROM:

  1. Ensure that you are logged into the machine with superuser (root) privileges.
  2. Ensure that you have set the shared memory and shared memory segments parameters properly. Refer to the Sybase installation documentation for more information about setting these parameters.
  3. Invoke the System Management Interface Tool (SMIT) to enable Asynchronous I/O by entering the following command:
    # smit devices

    The Devices window opens

  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, perform the following steps:
    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 this process is complete, exit from SMIT.
  7. Restart your system for the updated 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 sufficient 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 includes the full pathname of 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 following command:
    # smit mkgroup
  13. In the Add a Group window, perform the following steps:
    1. In the Group NAME field, type sybase.
    2. Click OK. When this process is complete, exit from SMIT.
  14. Create a user to administer Sybase, named sybase in this example, by entering the following command:
    # smit mkuser

    The sybase user must have permissions to access the directory structure from the root operating system directory or disk partition down to the specific physical device or operating system file containing the Sybase software. It is recommended that the user named sybase perform all unloading, installing, upgrading, and setup tasks.

  15. In the Add a User window, perform the following steps:
    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. Note that the value you enter in the HOME directory field can be different than the example shown here.
    4. Click OK. When this process is complete, exit from SMIT.
  16. Ensure that the user root is a member of the sybase group by entering the following command:
    # smit chuser
  17. In the Change / Show Characteristics of a User window, type root in the User NAME field, and click OK.
  18. In the Change / Show Characteristics of a User window, perform the following steps:
    1. In the Group SET field, ensure that the group sybase is included by clicking in 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.
  19. Change the ownership of the installation directory to the group sybase and the user sybase, respectively, by using the chown command, as follows:
    # chown sybase:sybase install_directory

    In this command, install_directory indicates the directory or the full path name of the file system or logical volume you have created to contain the Sybase software.

  20. 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 instructions provided with the drive.
  21. Insert the Sybase software CD-ROM into the machine's CD-ROM drive.
  22. Use the mkdir command to create a mount point for the CD-ROM drive. The following command creates a mount point for the CD-ROM at /cdrom; you can mount the CD-ROM at any location in the machine's local file system.
    # mkdir /cdrom

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

  23. Invoke SMIT for configuring CD-ROM file systems by entering the following command:
    # smit cdrfs
  24. From the CDROM File Systems menu, click Add a CDROM File System.
  25. In the Add a CDROM File System window, perform the following steps:
    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-ROM.
    2. In the MOUNT POINT field, type the full pathname of the mount point for the CD-ROM drive. 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 yes to specify that the CD-ROM drive is mounted automatically each time the machine is restarted, or no to specify that the CD-ROM drive 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.
  26. Invoke SMIT for mounting a file system by entering the following command:
    # smit mountfs
  27. In the Mount a File System window, perform the following steps:
    1. With the cursor in the FILE SYSTEM name field, click the List button and choose the 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-ROM drive. 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-ROM drive, and then click OK. The drive is mounted as a file system. When this process is complete, exit from SMIT.
  28. Authenticate as the user sybase by using the su command, as follows:
    # su - sybase

    Note that when you log in as the user sybase, the command prompt changes from # to $ to indicate a change in your login identity.

  29. Ensure that the DISPLAY, TERM, and JAVA_HOME environment variables are still set properly. In addition, ensure that the PATH environment variable includes the full pathname of the directory in which Java is installed.
  30. Navigate to the /cdrom directory.
  31. Start the Sybase installation program by entering the install command, as follows:
    $ ./install
  32. The Installation Type window opens. Ensure that the Standard Install radio button 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.
  33. The Choose Directory window opens. Specify the installation directory for Sybase, and click Next to continue.
  34. The Summary window opens. It summarizes all of the installation choices you have made so far. Verify that the information and when you have determined that it is correct, click Next to continue.
  35. The Installing window displayed. It tracks the status of the Sybase installation.
  36. After the components are installed, the Sybase License Management window opens. Click No to exit from this window.
  37. The Sybase License Management window opens again. Click No to exit from this window.
  38. The Sybase Installer window opens. Click No to exit from this window.
  39. The Information window opens, informing you that installation is complete. Click OK to exit from the Sybase installation program.
  40. Create a .profile file in the home directory of the user sybase, as follows:
    1. Ensure that you are in the home directory of the user sybase.
    2. Ensure that you are using the Bourne shell. If you are not, enter the following command:
      $ sh
    3. Copy the file SYBASE.sh to the file .profile, as follows:
      $ cp SYBASE.sh .profile
    4. If necessary, modify the ownership of the .profile file by entering the following commands. The need to enter these commands depends on how the user sybase is configured on your system.
      $ cd /home_directory
      $ chown -R sybase:sybase *
      $ chown sybase:sybase .profile
    5. Add the following information to the .profile file. In this example, server_name is the name of the server that you will create, and install_directory is the installation directory of the Sybase software:
      DSQUERY=server_name
      export DSQUERY
      PATH=install_directory/ASE-12_0/install:$PATH
      export PATH
      XACONFIGFILE=install_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 the user root to execute the user sybase's .profile file on startup. This is required to install and run WebSphere Application Server.
  42. Log out and log back in as the user sybase for your changes to take effect.
  43. To add licenses to your installation, enter the following command:
    $ install_directory/SYSAM-1_0/bin/lmgr

    In this command, install_directory is the installation directory of the Sybase software.

  44. The Sybase License Management window opens, 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 used in this example. Refer to the Sybase installation documentation for more information about registering licenses.

  45. 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 prompts 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 have entered all of your license information.
  46. See the WebSphere Application Server Supported Software and APIs Web site at www.ibm.com/software/webservers/appserv/doc/latest/prereq.html to determine if it is necessary to install a Sybase ESD for your version of WebSphere Application Server.

Upgrading Sybase 12 with an ESD

Perform the following steps to upgrade Sybase 12:

  1. If you have not already done so, see the WebSphere Application Server Supported Software and APIs Web site at www.ibm.com/software/webservers/appserv/doc/latest/prereq.html to learn whether you need to install a Sybase ESD fix for your level of WebSphere Application Server. Note the ESD fix level required.
  2. Ensure that you are logged into the machine as the user sybase. Note that when you log in as the 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. Start a Web browser and go to the Sybase Downloads Web site at www.sybase.com.
  5. Download the appropriate file to the local machine.
  6. Navigate to the directory containing the downloaded file.
  7. Uncompress and untar the downloaded file to extract the Sybase 12 files.
  8. Navigate to the install_directory/ASE-12_0 directory. The install_directory represents the full pathname or the directory containing the base Sybase software.
  9. Recursively copy the download directory contents to the install_directory/ASE-12_0 directory by entering the following command:
    $ cp -R /download_directory/fix_directory/* .
    In this command, download_directory represents the directory you created to contain the downloaded file and fix_directory represents a directory that is created when you uncompress and untar the downloaded file. The fix_directory usually bears the name of the fix level (ebf8774, for example).
  10. Proceed to the article Configuring and verifying installation of Sybase 12 to configure and test your installation of Sybase.