This chapter introduces important concepts about the
installation of Adaptive Server and Adaptive Server products.
The Adaptive Server installation and setup process defines
various user roles. Different user roles have different responsibilities
and privileges. These user roles clarify the way Adaptive Server
is to be integrated into your system:
Product descriptionsProduct | Description |
Adaptive Server | The relational database
server. The default unloading process includes: |
Adaptive Server
Plug-In to Sybase Central Java Edition | Sybase Central is a common
framework for managing servers. It allows you to manage Adaptive
Server installations using the Sybase Central graphical management
tool. For information on how to use Sybase Central to manage Adaptive
Server, see the online help. |
Sybase Monitor Server
for Adaptive Server | An Open
Server(TM) application that obtains performance statistics
on Adaptive Server and makes those statistics available to Monitor
Server client applications. Sybase Monitor Server includes: Monitor Server for Adaptive Server Enterprise 12.5 - an
Open Server application that obtains performance statistics on Adaptive
Server and makes those statistics available to monitors in Monitor
Historical Servers, and applications built with Monitor Client-Library. Monitor Client-Library - a programming
interface that provides access to Adaptive Server performance data. Monitor
Historical Server - an Open Server application that obtains
performance statistics for many Adaptive Servers via Monitor Servers
and records the data to specified file locations.
|
Backup Server | Backup
Server is an Open Server-based application that manages all database
backup (dump) and restore (load) operations for Adaptive Server.
Backup Server: Allows you to use up
to 32 dump devices (this is called dump striping)
in parallel to dump or load a single database or transaction log. Allows one dump to span multiple tapes or allows
multiple dumps to be made to a single tape. Allows dumping and loading over the network to or
from a device on another machine. Provides automated determination of tape device
characteristics, by using operating system commands, for a dump
operation. Supports dump and load command syntax specification
for volume naming, dismount and load control, tape density, block
size, tape capacity, days to retain, initialization, file naming
for multi-dump volumes, and listing header or file information.
Install Backup Server if you plan to back up and restore databases
in Adaptive Server. Backup Server is installed, by default, when
you install Adaptive Server software. |
Language
Modules (Server) | Provides system messages
and date/time formats to help you localize your applications.
Default installation includes the us_english language module
and the following character sets: cp437 - IBM CP437, U.S. code set cp850 - IBM CP850, European code set iso_1 - ISO 8859-1, Latin-1 mac - Standard Macintosh coding roman8 - HP Roman-8
Other languages for Adaptive Server and Sybase client products
are French, German, and Japanese. Language modules for Spanish,
Korean, Brazilian Portuguese, and Simplified Chinese are also available
for Adaptive Server only. For more information on server language modules and character
sets, see the Sybase Adaptive Server Enterprise Configuration
Guide for your platform. |
Language
Modules (Connectivity) | Provides messages and
support files for running Open Client(TM) applications in various
languages. |
jConnect 4.5 and jConnect 5.5 | Provides a Java database connectivity
(JDBC) driver that works with both Sun and Microsoft virtual machines
(VM). Provides support for Adaptive Server 12.5 extended limits
by requesting support for wide tables. This request is ignored by
servers other than Adaptive Server 12.5 and higher. For more information on jConnect(TM) for JDBC(TM),
see the jConnect product page . |
jConnect Documentation | Contains the Sybase jConnect
for JDBC Programmer's Reference. |
Java utilities | Includes: The Cascade
Gateway - A gateway that acts as a proxy to provide a path
to the database server if it is running on a different host from
the Web Server. jisql - A graphical
Transact-SQL editor written in Java that replaces SQL Advantage. Ribo - A utility that
captures, translates, and displays the Tabular Data Stream (TDS)
protocol flowing between a TDS client and a TDS server.
|
ODBC
Driver | Allows Windows NT client
applications to access Adaptive Server data. |
Open Client | Provides libraries and
utilities for developing any Open Client application. |
XP Server | An Open Server application
that manages and executes extended stored procedures (ESPs) from
within Adaptive Server. ESPs provide a method for calling procedural language
functions from within Adaptive Server. XP Server is unloaded, by default, when you unload Adaptive
Server software from the distribution media. Use the srvbuild utility
to set up XP Server and to connect XP Server and Adaptive Server
through the interfaces file. |
Installation and setup utilities Utility | Use to | Environment |
asecfg | Utility to access dsedit,
svrbuild, sqlupgrade, sqlloc. | X-Windows/Motif GUI |
dscp | Modify the
interfaces file. | Interactive, text-based
interface |
dsedit | Modify the
interfaces file. | X-Windows/Motif
GUI |
sqlloc | Modify localization
settings, such as language and character set. For information on using sqlloc, see the Adaptive
Server Configuration Guide. | X-Windows/Motif
GUI |
sqllocres | Modify localization
settings, such as language and character set, using a resource file. Use of this utility is not described in this installation guide.
For information on using sqllocres, see Adaptive Server
Enterprise Configuration Guide. | Noninteractive, file-based
interface |
sqlupgrade | Upgrade Adaptive
Server. | X-Windows/Motif
GUI |
sqlupgraderes | Upgrade Adaptive
Server using a resource file. | Noninteractive, file-based
interface |
srvbuild | Build a functional
server. | X-Windows/Motif
GUI |
srvbuildres | Build a functional
server using a resource file. | Noninteractive, file-based
interface |
Studio Installer | Provide an
interface from which to enter Sybase Server features. | Java 1.2.2 |
Products and platformsProduct and
Platforms | Description |
Open
Client version 12.5 | Used to develop and deploy
C language-based applications that access Adaptive Server data. Default installation includes: Client-Library(TM) DB-Library CS-Library Bulk Library bcp utility
used to transfer data between files and Adaptive Server databases isql utility used to connect
to Adaptive Server for SQL queries. defncopy utility used to copy
stored procedure definitions from one database to another Online help
files for Open Client routines Net-Library
drivers for connecting 32-bit client applications to a server through
most available network protocols. Default installation includes: dsedit for
editing the sql.ini and interfaces files
and testing client-server connections Drivers for Named Pipes
and Windows Sockets Drivers for Named Pipes, Windows Sockets, Novell
LAN Workplace, and Microsoft TCP/IP
Additional options include: Programmer support (include files and libraries) for compiling
and linking Client-Library and DB-Library applications Sample programs for Client-Library and DB-Library Net-Library driver protocols: TCP/IP, SPX/IPX,
Named Pipes, DECNet. TCP/IP and SPX/IPX require the
WinSock API. DECNet requires DEC PathWorks.
Monitor Client Library - an application
programming interface that provides access to Adaptive Server performance data.
|
Language
modules
version 12.5 | Display system messages
and datetime formats to help you localize your 32-bit applications.
The Standard Installation option installs all of the character sets. |
Embedded SQL/C andEmbedded
SQL/COBOL
version 12.5 | A superset of Transact-SQL® that
lets you place Transact-SQL statements in application programs written
in languages such as C and COBOL. |
jConnect 4.5 and jConnect
5.5 | Provides a Java database connectivity
(JDBC) driver that works with both Sun and Microsoft virtual machines
(VM). Provides support for Adaptive Server 12.5 extended limits
by requesting support for wide tables. This request is ignored by servers
other than Adaptive Server 12.5 and higher. For more information on jConnect(TM) for JDBC(TM),
see the jConnect product page . |
jutils (Cascade
Gateway, jisql, Ribo) | Includes: The Cascade
Gateway - a gateway that acts as a proxy to provide a path
to the database server if it is running on a different host from
the Web Server. jisql - a graphical
Transact-SQL editor written in Java that replaces SQL Advantage®. Ribo - a utility that
captures, translates, and displays the Tabular Data Stream (TDS)(TM) protocol
flowing between a TDS client and a TDS server.
|
jConnect Documentation | Contains the Sybase jConnect
for JDBC Programmer's Reference. |
Sybase Central
ASE plug-in Java edition | The Java-based, graphical administration
utility for Adaptive Server. |
Sybase
Central(TM) ASE plug-in C++version
12.0 | SQL Remote and the Monitor
Server GUI require the C++ version of this plug-in. Warning! Do not use the Adaptive Server C++ plug-in
for general administrative purposes. |
Sybase ODBC drivers
version
3.5 | ODBC drivers have support
for extended limits. |
PowerDynamoversion
3.5.2 | A suite of tools for building
and managing database-hosted Web sites with dynamic content. |
InfoMaker
version
7.0.3 | A tool for personal data
access, management, and reporting, for developers and end users.
InfoMaker allows you to create presentation-quality reports and
powerful queries without the complexities of programming. It complements
client/server business applications and development tools
as well as desktop productivity suites. |
SQL Remote
version
7.0.2 | SQL Remote enables two-way
replication between a database server and multiple portable computer
databases through E-mail or dial-up connections. |
Physical
Architect
version 8.0 | A tool for data modeling,
including database design, generation, maintenance, reverse engineering,
and documentation for database architects. |
The Sybase installation
directory structure is created by the installation process. Adaptive
Server is placed in the directory you indicate when you run the the
Red Hat Package Manager. Table 1-4 illustrates part of the Adaptive Server installation
directory structure.
The Adaptive Server installation directory contains executable
files and administrative tools, which are added as each product
is installed.
![[Table of Contents]](/dwicons/b_toc.gif)
![[-]](/dwicons/i_colpse.gif)