Sybase recommends installing products while logging in as a "sybase" user.
Sybase recommends installing products while logging in as a "sybase" user.
The installer creates the target directory (if necessary) and installs the selected components into that directory.
At the end of the installation, you can verify the product installation. You may need to perform additional configuration procedures before using some products.
To install server components:
Stop and shut down all programs before running the installer.
Insert the Adaptive Server CD or DVD in the appropriate drive, or download and extract the Adaptive Server install image from the Sybase Product Download Center (SPDC).
Launch the installer.
The installer should start automatically. If it does not, start the setup program manually by selecting Start | Run. Browse to setup.exe.
The Welcome screen displays. Click Next.
Select a directory for the installation. Click Next to accept the default directory, or enter a new directory path.
You can choose from four types of installations in the installation Type window:
Typical
Full
Custom
Update – This option only appears if you are installing over an older version. The installer provides a list of products, features, and version to be updated to the current version.
If you select Custom, the Products and Features Selection window displays.
Select the products to install by selecting the box next to the product name. Some features are dependent on other features; therefore, the installer prevents you from unselecting some items without first unselecting others.
Select the installation type for Adaptive Server . This step does not appear for some platforms on which you can only install a licensed copy of Adaptive Server. The available types to be selected are different for different platforms.
Licensed copy of Adaptive Server Suite – Choose this if you have a licensed copy of Adaptive Server.
Evaluation Edition of Adaptive Server Suite – Choose this if you would like to evaluate Adaptive Server.
Express Edition of Adaptive Server Suite – Choose this if you would like to install Express Edition.
Developers Edition – Choose this if you would like to install Developers Edition.
Click Next.
Select the most appropriate country, read the license terms, and then click “I agree.” Click Next.
If you chose Licensed installation, the installer prompts for the SySAM license. In this panel, you can specify the license file, use an existing license server, or proceed with the installation without license.
If you chose “unlicensed” installation, the software works for 30 days from the original installation date.
If you specified a served license, you are prompted to set up the license server. A summary screen appears. Click Next.
Select the edition for the license you have license:
Unknown – select this if you are unsure of the license type.
Enterprise Edition
Small Business Edition
Developers Edition
If you choose either Enterprise Edition or Small Business Edition, you must select the license type under which Adaptive Server is licensed. Select from the available options. Choose Unknown if you do not know this information.
Click Next.
The Sybase Software Asset Management Notification screen appears. Click Next.
The Product Selection Summary window displays the selections you have made.
Configuring your server for e-mail notification enables designated users receive information about license management events requiring attention.
Provide the following information:
SMTP server host name
SMTP server port number
E-mail Return Address
Recipient e-mail addresses
Message severity that triggers e-mail messages
Verify that you have selected the correct type of installation, and that you have enough disk space to complete the process. Click Next.
The installation Progress window shows the progress of the installation. Click Next.
The installation Status window displays the result of the installation process. Click Next.
Select Yes or No to enable or disthe remember passwords feature then click Next.
You are prompted to configure new servers depending upon the products you installed. A full or custom installation allows you to:
Configure a new Adaptive Server
Configure a new Backup Server
Configure a new Monitor Server
Configure a new XP Server
Configure an Unified Agent
Configure Job Scheduler
Enable Self Management
Configure Web Services
Select the servers you want to configure. If you do not want to configure the new servers at this point, unselect the item. Click Next.
A summary windows displays the servers and features you chose to configure. Click Next.
The Custom Configure New Server Options window allows you to select servers to custom configure. If you do not select any servers in this window, the installer configures all the servers using default values.
If you choose the default values, the installer chooses everything including the server name, port number, and master device location. It also installs Backup Server, Monitor Server, and the XP Server, choosing the name, port number, and error log.
If you accept the defaults, the server names are:
Adaptive Server – <host name>
Backup Server – <host name>_BS
Monitor Server – <host name>_MS
XP Server – <host name>_XP
Job Scheduler Agent – <host name>_JSAGENT
If you configure the servers with default values, the Configure Server Attributes Summary window appears.
Select the server or feature to custome configure. The choices are:
Custom configure new Adaptive Server
Custom configure new Backup Server
Custom configure new Monitor Server
Custom configure new XP Server
Custom configure new Job Schedule
Custom configure Self Management
Custom configure Web Services
The Custom Configure Input window displays next.
The Custom Configure Input window prompts you for the custom Adaptive Server configuration information.
Server name
Port number
Error log – name and location of the error log file.
Application type – the choices are:
MIXED – both OLTP & DSS. This is the default.
OLTP – online transaction Processing generally consists of smaller, less complex transactions.
DSS – decision Support dystems gnerally have less update activity with large complex queries.
Page size:
2KB
4KB – default
8KB
16KB
Master device – name of master device and the path where it should be located.
Master device. The default master device sizes are:
2KB page size – 30MB
4KB page size – 60MB
8KB page size – 120MB
16KB page size – 240MB
Master database . The default master database sizes are:
2KB page size – 13MB
4KB page size – 26MB
8KB page size – 52MB
16KB page size – 104MB
System procedure device path
System procedure device
System procedure device and database default size is 140MB.
System device. The default sizes are:
2KB page size server – 3MB
4KB page size server – 6MB
8KB page size server – 12MB
16KB page size server – 24MB
System database size (in MB) The default sizes are:
2KB page size server – 3MB
4KB page size server – 6MB
8KB page size server – 12MB
16KB page size server – 24MB
Temporary database device path
Temporary database device size:
2KB page size server – 100MB
4KB page size server – 100MB
8KB page size server – 100MB
16KB page size server – 100MB
Temporary database database size:
2KB page size server – 100MB
4KB page size server – 100MB
8KB page size server – 100MB
16KB page size server – 100MB
Enable PCI in Adaptive Server
PCI device and PCI database size are the same
2KB page size server – 24MB
4KB page size server – 48MB
8KB page size server – 96MB
16KB page size server – 192MB
Optimization configuration:
Available physical memory for Adaptive Server – 80% of RAM
Available CPU for Adaptive Server – round down 80% of the physical CPU.
The current default value for the above items are 80% of
the system physical memory and CPU number. Input the value based
on the system resource usage. If the value specified is larger than
the available resource for allocation to the server, then the optimize configuration
may fail causing the server to not start.
Once you have customized the Adaptive Server configuration, select Next to record the input fields.
The Custom Configure Backup Server Input window prompts you for the Backup Server information.
Once you have entered the appropriate information, click Next to record the information.
The Custom Configure Monitor Server Input window prompts you to enter the Monitor Server configuration information.
Once you have entered the appropriate information, click Next to record the information.
The Custom Configure XP Server Input window prompts you to enter the XP Server configuration information.
Once you have entered the appropriate information, click Next to record the information.
The Custom Configure New Job Scheduler Input window prompts you to enter Job Scheduler information:
Agent name
Port number
Management device
Management device size
Management database size
Once you have entered the appropriate information, click Next to record the information.
Custom configure Self Management by entering the following information:
Self Management user name
Self Management password
If you choose the default user name “sa,” you
cannot enter the password. The “sa” default password
is null.
Select the adaptor:
UDP
JINI
Security Login Modules – choose the security login modules for the Unified Agent. You can choose:
Simple Login Module
If you double-click Simple Login Module, a dialog asks
you to change the user name and password.
Adaptive Server Login Module
NT Proxy Login Module
Select the Enable box to enable a login module. To order the modules according to priority, select the module, and click Move up or Move down.
The Configure New Servers Summary window displays a summary of the values that are used to configure the servers. These values are either the default or custom values. After verifying the information, click Next, and the installer proceeds with the server configuration.
The Configure Server Progress window displays the progress of the server configuration.
The Restart window displays only when required. It reminds you to either log out or restart your machine to complete the installation process.
The Installation Complete window is the last window.
If you encounter any errors, see the Troubleshooting Guide.
At the end of a successful installation click Finish.
Adaptive Server and related products have been successfully installed, and minimally configured for use. See “Installing sample databases”, to begin experimenting with your servers, or see the System Administration Guide at Sybase Product Manuals for more advanced topics.
You have a running server, as well as various system databases and system tables. Some references that may help you get started using your new Adaptive Server include:
“Initializing Database Devices” and “Creating User Databases” in the System Administration Guide – information about creating an Adaptive Server user database and its devices.
Transact-SQL Users Guide – learn how to write queries.
For information on developing a backup and recovery plan and backing up and restoring user databases, see the System Administration Guide.
Monitor Server requires some additional configuration after installation. See the Monitor Server Users Guide.
For information on using extended stored procedures, see the Transact-SQL Users Guide.
For information on using Job Scheduler, see the Job Scheduler Users Guide.
Web Services Users Guide – explains how to configure, use, and troubleshoot Web Services for Adaptive Server.
Unified Agent and Agent Management Console – describes the Unified Agent, which provides runtime services to manage, monitor and control distributed Sybase resources.
