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(TM) 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 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 virtually
unlimited dump devices (this is called dump striping) in
parallel to dump or load a single database or transaction log. Allows compressed dumps and loads to the local disk. 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 Configuring Adaptive Server Enterprise for
your platform. |
Language
Modules (Connectivity) | Provides messages and
support files for running Open Client(TM) applications in various
languages. |
jConnect 4.5 andjConnect
5.5 | Provides a Java database connectivity
(JDBC) driver that works with both Sun and Microsoft virtual machines
(VMs). 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 for JDBC, 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 Configuring Adaptive
Server Enterprise. | 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 Configuring
Adaptive Server Enterprise. | 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 | | X-Windows/Motif
GUI |
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. Both 32-bit and 64-bit libraries are shipped for 64-bit platforms. 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 databases to files and back Online help
files for Open Client routines Net-Library
drivers for connecting 32-bit and 64-bit client applications to
a server through most available network protocols. Default installation
includes: dsedit and dscp 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, 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 or 64-bit applications. The Standard Installation option
installs the character sets. |
Embedded SQL/C
version
12.5 | A superset of Transact-SQL that lets
you place Transact-SQL statements in application programs written
in languages such as C. |
Embedded 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 COBOL. |
jConnect 4.5 and jConnect
5.5 | Provides a Java database connectivity
(JDBC) driver that works with both Sun and Microsoft virtual machines
(VMs). 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 for JDBC, 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 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(TM) 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 Studio
Installer. Table 1-4 illustrates the installation directories
that you are likely to access during the installation, configuration
and administration of the Adaptive Server. This table is not comprehensive.
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)