Installing Sybase 12
The steps below describe how to--
- Install and configure Sybase 12 on a local AIX machine
- Upgrade Sybase 12 with an Electronic Software Distribution (ESD) fix
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:
- Ensure that you are logged into the machine with superuser privileges
(that is, log in as root).
- You can need to change your system's settings for the following parameters:
- Shared memory size
- Shared memory segment sizes
For details on settings required for running Sybase, refer to the Sybase
installation documentation. See your System Administrator for advice on changing these parameters.
- Invoke SMIT to enable Asynchronous I/O by entering the command
# smit devices
- 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, do the following:
- 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 the process has completed, exit from SMIT.
- Restart your system to enable the new 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 460 MB
of free 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 to 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 command
# smit mkgroup
- In the Add a Group window, do the following:
- In the Group NAME field, type
sybase
.
- Click OK. When this process is complete, exit from SMIT.
- 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.
- 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):
- In the User NAME field, type
sybase
.
- In the Primary GROUP field, type
sybase
.
- 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.
- Click OK. When this process is complete, exit from SMIT.
- Ensure that root is part of the sybase group by entering the
command # smit user
- From the Users window menu, choose Change / Show Characteristics of a User.
- In the Change / Show Characteristics of a User pop-up window, beside the
User NAME field, type
root
and click OK.
- In the Change / Show Characteristics of a User window, do the following:
- 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.
- Click OK. When this process is complete, exit from SMIT.
- Change the ownership of the home directory to the group sybase, user sybase,
by issuing the command
# chown sybase:sybase <home_directory>
- 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
- 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.
- 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.
- Insert the CD into the drive.
- 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.
- As root, invoke SMIT for configuring CD-ROM file systems by entering the command
$ smit cdrfs
- From the CDROM File Systems menu, choose Add a CDROM File System.
- In the Add a CDROM File System window, do the following:
- 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.
- 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.
- 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).
- Click OK. The CD-ROM file system is added. When this process is
complete, exit from SMIT.
- As root, invoke SMIT for mounting a file system by entering the command
$ smit mountfs
- In the Mount a File System window, do the following:
- 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.
- 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.
- 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, and then click OK. The CD is mounted as
a file system. When this process is complete, exit from SMIT.
- As sybase, navigate to the correct directory on the Sybase 12 CD by
entering the command $ cd /cdrom
- As sybase, enter the following command to begin the Sybase installation
process:
$ ./install
The Installation Type window displays.
- 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.
- 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.
- 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.
- After the components are installed, the Sybase License Management window displays.
Click No to exit from this window for now.
- The Sybase License Management window displays again. Click No to
exit from this window for now.
- The Sybase Installer window displays. Click No to exit from this
window for now.
- An Information window displays, informing you that installation is complete.
Click OK.
- Create a .profile file in the home directory for the user sybase, as follows:
- Ensure that you are in the home directory of user sybase.
- Ensure that you are in the Bourne shell. If you are not, enter the command
$ sh
- Copy the file SYBASE.sh to the file .profile:
$ cp SYBASE.sh .profile
- 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
- 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.
- Configure root to execute this .profile file on startup. This is required to install
and run WebSphere Application Server.
- Log out and log back in as user sybase to enable the changes to the environment.
- 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
- 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.
- 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."
To upgrade Sybase 12 with an ESD, do the following:
- 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.
- 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.
- Create a directory into which to download the patch file.
- 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.
- On the host machine, navigate to the directory containing the downloaded file.
- Uncompress and untar the downloaded file to extract the Sybase 12 files.
- 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
- 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."