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:
- Ensure that you are logged into the machine with superuser (root) privileges.
- 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.
- Invoke the System Management Interface Tool (SMIT) to enable Asynchronous I/O by
entering the following command:
# smit devices
The Devices window opens
- On the Devices window, select Asynchronous I/O.
- On the Asynchronous I/O window, select Change/Show Characteristics of Asynchronous
I/O.
- On the Change/Show Characteristics of Asynchronous I/O window, perform the following steps:
- Set the value for the STATE to be configured at system restart field to
available .
- Set the value of the State of fast path field to
enable .
- Accept the default values for the other fields and click OK. When this process is complete, exit from SMIT.
- Restart your system for the updated settings to take effect.
- Ensure that the DISPLAY and TERM environment variables are set
correctly for your environment.
- Create a file system, logical volume, or directory
to hold the Sybase software. Ensure that the location you choose has sufficient
disk space.
- 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.
- Set the JAVA_HOME environment variable includes the full pathname of the directory where
Java is installed on the local machine.
- Invoke SMIT to create an administrative group for Sybase, named
sybase in this example, by entering the following command:
# smit mkgroup
- In the Add a Group window, perform the following steps:
- In the Group NAME field, type
sybase .
- Click OK. When this process is complete, exit from SMIT.
- 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.
- In the Add a User window, perform the following steps:
- In the User NAME field, type
sybase .
- In the Primary GROUP field, type
sybase .
- 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.
- Click OK. When this process is complete, exit from SMIT.
- Ensure that the user root is a member of the sybase group by entering the
following command:
# smit chuser
- In the Change / Show Characteristics of a User window, type
root
in the User NAME field, and click OK.
- In the Change / Show Characteristics of a User window, perform the following steps:
- 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.
- Click OK. When this process is complete, exit from SMIT.
- 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.
- 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.
- Insert the Sybase software CD-ROM into the machine's CD-ROM drive.
- 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.
- Invoke SMIT for configuring CD-ROM file systems by entering the following command:
# smit cdrfs
- From the CDROM File Systems menu, click Add a CDROM File System.
- In the Add a CDROM File System window, perform the following steps:
- 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.
- 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.
- 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.
- Click OK. The CD-ROM file system is added. When this process is
complete, exit from SMIT.
- Invoke SMIT for mounting a file system by entering the following command:
# smit mountfs
- In the Mount a File System window, perform the following steps:
- 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.
- 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.
- With the cursor in the TYPE of file system field, click the List
button and choose cdrfs.
- Set the Mount as READ-ONLY system field value to
Yes .
- 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.
- 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.
- 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.
- Navigate to the /cdrom directory.
- Start the Sybase installation program by entering the install command, as follows:
$ ./install
- 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.
- The Choose Directory window opens. Specify the installation directory
for Sybase, and click Next to continue.
- 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.
- The Installing window displayed. It tracks the status of the Sybase installation.
- After the components are installed, the Sybase License Management window opens.
Click No to exit from this window.
- The Sybase License Management window opens again. Click No to
exit from this window.
- The Sybase Installer window opens. Click No to exit from this
window.
- The Information window opens, informing you that installation is complete.
Click OK to exit from the Sybase installation program.
- Create a .profile file in the home directory of the user sybase, as follows:
- Ensure that you are in the home directory of the user sybase.
- Ensure that you are using the Bourne shell. If you are not, enter the following command:
$ sh
- Copy the file SYBASE.sh to the file .profile, as follows:
$ cp SYBASE.sh .profile
- 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
- 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.
- Configure the user root to execute the user sybase's .profile file on startup. This is required to install
and run WebSphere Application Server.
- Log out and log back in as the user sybase for your changes to take effect.
- 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.
- 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.
- 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.
- 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.
Perform the following steps to upgrade Sybase 12:
- 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.
- 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.
- Create a directory into which to download the patch file.
- Start a Web browser and go to the Sybase Downloads Web site at
www.sybase.com.
- Download the appropriate file to the local machine.
- Navigate to the directory containing the downloaded file.
- Uncompress and untar the downloaded file to extract the Sybase 12 files.
- Navigate to the install_directory/ASE-12_0 directory. The install_directory
represents the full pathname or the directory containing the base Sybase software.
- 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).
- Proceed to the article
Configuring and verifying installation of Sybase 12 to configure and
test your installation of Sybase.
|
|