Installing Sybase 12

This article describes the following:

  • Installing and configuring Sybase on a local Solaris SPARC machine
  • Upgrading Sybase with an Electronic Software Distribution (ESD) fix

These instructions assume the following:

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

Note: Install Sybase before installing WebSphere Application Server. Also, the Sybase installer requires Java to be installed on the local host.

Installing Sybase

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

  1. Ensure that you are logged onto the machine with superuser (root) privileges.
  2. Ensure that you have set the following UNIX shared memory parameters properly:
    • SHMMAX
    • SHMSEG

    Further, ensure that the Asynchronous I/O parameter is set to the value enable.

    After setting these values, enter the command # touch /reconfigure and restart your system so that the new settings can take effect. For more information on setting values for these parameters, refer to the Sybase installation documentation.

  3. Ensure that the DISPLAY and TERM environment variables are set correctly for your environment.
  4. Create a file system, logical volume, or directory to hold the Sybase software. If you plan to use Sybase 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 installation documentation and your Solaris system documentation for more information on creating and mounting a file system.
  5. Set the JAVA_HOME environment variable to the directory where Java is installed on the local machine.
  6. Use operating system utilities to create the group sybase:
    # groupadd sybase
  7. Use operating system utilities to create the user sybase. Use the location you created in Step 4 as the user's home directory.
    # useradd -d home_directory -g sybase sybase
  8. Edit the /etc/group file to do the following:
    • Add the user sybase to the group sybase.
    • Add the user root to the group sybase.
  9. Change the ownership of the home directory to the group sybase with the user sybase:
    # chown sybase:sybase home_directory
  10. Log in as the user sybase, by using the following command. Note that when you log in as the user sybase, the command prompt changes in appearance to indicate your login identity.
    # su - sybase
  11. Ensure that the DISPLAY, TERM, and JAVA_HOME environment variables are still set properly.
  12. Insert the Sybase CD-ROM and, if necessary, mount the CD-ROM drive. On most Solaris systems, the Volume Management daemon (vold) mounts the CD-ROM automatically and immediately, as well as each time the machine is restarted. If the vold process is not running on your machine, see your Solaris documentation for instructions on how to mount the CD-ROM drive.

    The steps that follow assume that the CD-ROM is mounted at /cdrom.

  13. Enter the following commands to begin the Sybase installation process:
    $ cd /cdrom/sybase
    $ ./install

    The Installation Type window opens.

  14. Ensure that the radio button for Standard Install is selected and click Next. The Choose Directory window opens.
  15. Specify the installation location for the Sybase files (make the installation directory the home directory of the user sybase) and click Next. The Summary window opens, summarizing all of the installation choices you have made so far.
  16. Verify the information in the Summary window. When you have determined that it is correct, click Next. The Installing window opens; it tracks the status of the Sybase installation.
  17. After the components are installed, the Sybase License Management window opens. Click No to close this window for now.
  18. The Sybase License Management window opens again. Click No to close this window for now.
  19. The Sybase Installer window opens. Click No to close this window for now.
  20. An Information window opens, informing you that installation is complete. Click OK.
  21. Create a .profile file in the home directory for the user sybase, as follows:
    1. Ensure that you are in the Bourne shell in the home directory of user sybase.
    2. Copy the file SYBASE.sh to the file .profile by entering the following command:
      $ cp SYBASE.sh .profile
    3. Enter the following commands to change directory and file ownerships:
      $ chown -R sybase:sybase *
      $ chown sybase:sybase .profile
    4. Add the following information to the .profile file. The environment variable DSQUERY defaults to your machine's host name, but you can change the value to any valid Adaptive Server Enterprise (ASE) server name. The server_name is the name of the server that you will create in the article "Configuring Sybase 12 for use with WebSphere Application Server", and home_directory is the installation directory of the Sybase software and, in this example installation, the home directory of the user sybase.
      DSQUERY=server_name
      export DSQUERY
      PATH=home_directory/ASE-12_0/install:$PATH
      export PATH
      XACONFIGFILE=home_directory/xa_config
      export XACONFIGFILE
  22. Log out and log back in as user sybase to enable the changes to the environment.
  23. To add licenses to your installation, enter the following command. The 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
  24. The Sybase License Management window opens, asking whether you have a Sybase Software Asset Management Certificate to register. Click Yes.

    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.

  25. In the window that opens, enter information from the Sybase License Certificate for the feature you have purchased. Click More if you have more than one licensed feature. This action prompts the installer to record the information from the current feature in the license file and prompts you to enter information for the next additional 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, 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 WebSphere Application Server Supported Hardware, Software, and APIs Web site at www.ibm.com/software/webservers/appserv/doc/latest/prereq.html. If you must install a fix, note the fix level and proceed to the section "Upgrading Sybase with an ESD fix."

Upgrading Sybase with an ESD fix

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

  1. If you have not already done so, see the WebSphere Application Server Supported Hardware, 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 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 changes in appearance to indicate your login identity.
  3. Create a directory into which to download the file.
  4. Open a Web browser window and go to www.sybase.com/downloads. Move to the product 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 files.
  7. Navigate to the home_directory/ASE-12_0 directory by entering the following command. The 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 home_directory/ASE-12_0 directory by entering the following command. The 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 check the installation, proceed to "Configuring Sybase 12 for use with WebSphere Application Server."