Installing Adaptive Server Enterprise on Windows NT

Home

Installing Adaptive Server Enterprise on Windows NT

Chapter 2: Installation Requirements

Chapter 2

Installation Requirements

This chapter covers:

System Specifications

Table 2-1 shows system requirements for Adaptive Server.

Table 2-1: System requirements for Adaptive Server
Component
Requirement
Processor
32-bit
Operating system
Adaptive Server requires Windows NT version 4.0 with Service Pack 3 or later.
The installation program and some Sybase tools can be run at an earlier version.
Connectivity
Your system must have network hardware and network protocol software as well as the Sybase Open Client software to allow you to connect to an Adaptive Server elsewhere on a network. You can install Open Client with Adaptive Server.
TCP/IP protocol stack
Your system must have TCP/IP networking software installed to use a browser or other Web client with the PowerDynamo software.
Java Runtime Environment for Sybase Central Plug-in for Adaptive Server
To use the plug-in's monitoring features, you need the Java Runtime Environment (JRE) 1.1.5 (certified to 1.1.6 for Adaptive Server) or the Java Development Kit 1.1.5, which includes the JRE, but requires additional disk space. The JRE is shipped with the Adaptive Server plug-in.

**Table 2-1: System requirements for Adaptive Server**
Component	Requirement
Processor	32-bit
Operating system	Adaptive Server requires Windows NT version 4.0 with Service Pack 3 or later. The installation program and some Sybase tools can be run at an earlier version.
Connectivity	Your system must have network hardware and network protocol software as well as the Sybase Open Client software to allow you to connect to an Adaptive Server elsewhere on a network. You can install Open Client with Adaptive Server.
TCP/IP protocol stack	Your system must have TCP/IP networking software installed to use a browser or other Web client with the PowerDynamo software.
Java Runtime Environment for Sybase Central Plug-in for Adaptive Server	To use the plug-in's monitoring features, you need the Java Runtime Environment (JRE) 1.1.5 (certified to 1.1.6 for Adaptive Server) or the Java Development Kit 1.1.5, which includes the JRE, but requires additional disk space. The JRE is shipped with the Adaptive Server plug-in.

RAM Requirements

Table 2-2 shows RAM requirements for Sybase products. For Powersoft requirements, see the Powersoft documentation.

Table 2-2: RAM requirements for Sybase products
Product
RAM Required
Adaptive Server
32MB
Open Client/C
16MB
OmniConnect
32MB
Monitor Client Library
16MB
Monitor Server
32MB
Monitor Historical Server
32MB
SQL Advantage
8MB
Adaptive Server plug-in for Sybase Central
12MB

**Table 2-2: RAM requirements for Sybase products**
Product	RAM Required
Adaptive Server	32MB
Open Client/C	16MB
OmniConnect	32MB
Monitor Client Library	16MB
Monitor Server	32MB
Monitor Historical Server	32MB
SQL Advantage	8MB
Adaptive Server plug-in for Sybase Central	12MB

Server and Client Requirements

Table 2-3 shows installation requirements for Sybase products.

Table 2-3: Installation requirements for Sybase products
Product
Operating System
Disk Space
Comments
Adaptive Server
Windows NT 4.0 and Service Pack 3 or later
70MB minimum
Requires Open Client/C 11.1.1. plus EBF #8021.
master.dat default size is 30MB. The minimum required size is 25MB.
sybprocs.dat default size is 60MB with a minimum of 45MB. Specify a higher setting if you plan to add your own stored procedures.
Monitor Server
Windows NT 4.0
0.14MB
Requires Open Client/C 11.1.1. plus EBF #8021.
Sybase tools such as dsedit are recommended for configuration purposes.
Automatically installed with Adaptive Server.
To enable monitoring by non-sa_role users, you must install two-phase commit in syconfig.
Monitor Historical Server
Windows NT 4.0
Power Dynamo
0.9MB
Requires Open Client/C 11.1.1 plus EBF #8021.
Sybase tools such as dsedit are recommended.
For best performance, install Monitor Historical Server on a separate computer from Adaptive Server.
Monitor Client Library
Windows NT 4.0
3.1MB
Requires Open Client/C 11.1.1 plus EBF #8021.
For best performance, install Monitor Client Library on a computer that is not running Adaptive Server.
Sybase Central Plug-in for Adaptive Server
Windows NT 4.0
Windows 95
12MB
Requires Open Client/C 11.1.1 plus EBF #8021.
Installation on one computer lets you manage all Adaptive Server installations on the network. Installation on the same system as Adaptive Server lets you stop, start, and pause Adaptive Server from Sybase Central.
Requires the Java Runtime Environment 1.1.5 or later or the Java Development Kit 1.1.5 or later.
SQL Advantage
Windows NT 4.0
Windows 95
3.2MB
Requires Open Client/C version 11.1.1 and EBF #7729 or later.
Monitor Server for SQL Server 11.0.x
Windows NT 3.51 or later
0.1MB
Requires Open Client 10.0.4.
Enables you to use the new functionality in the Adaptive Server plug-in monitoring and the new Monitor Client Library 11.5. (Be sure to install in your existing SQL Server 11.0.x directory.)
Note: Do not install Open Client/C 11.1.1 with this product.
Language Modules
(client and server)
Windows NT 4.0
2-6.5MB per language
English, German, French, Spanish, Chinese (simplified), Japanese, Korean, Portuguese
Server language modules:
3-6MB
Client language modules:
2-6.5MB
The character set used to install Adaptive Server products must be supported by U.S. English.
InfoMaker
Windows NT 4.0
Windows 95
10MB minimum
Requires additional database space for subscriptions, publications, and transactions.

**Table 2-3: Installation requirements for Sybase products**
Product	Operating System	Disk Space	Comments
Adaptive Server	Windows NT 4.0 and Service Pack 3 or later	70MB minimum	Requires Open Client/C 11.1.1. plus EBF #8021. master.dat default size is 30MB. The minimum required size is 25MB. sybprocs.dat default size is 60MB with a minimum of 45MB. Specify a higher setting if you plan to add your own stored procedures.
Monitor Server	Windows NT 4.0	0.14MB	Requires Open Client/C 11.1.1. plus EBF #8021. Sybase tools such as dsedit are recommended for configuration purposes. Automatically installed with Adaptive Server. To enable monitoring by non-sa_role users, you must install two-phase commit in syconfig.
Monitor Historical Server	Windows NT 4.0 Power Dynamo	0.9MB	Requires Open Client/C 11.1.1 plus EBF #8021. Sybase tools such as dsedit are recommended. For best performance, install Monitor Historical Server on a separate computer from Adaptive Server.
Monitor Client Library	Windows NT 4.0	3.1MB	Requires Open Client/C 11.1.1 plus EBF #8021. For best performance, install Monitor Client Library on a computer that is not running Adaptive Server.
Sybase Central Plug-in for Adaptive Server	Windows NT 4.0 Windows 95	12MB	Requires Open Client/C 11.1.1 plus EBF #8021. Installation on one computer lets you manage all Adaptive Server installations on the network. Installation on the same system as Adaptive Server lets you stop, start, and pause Adaptive Server from Sybase Central. Requires the Java Runtime Environment 1.1.5 or later or the Java Development Kit 1.1.5 or later.
SQL Advantage	Windows NT 4.0 Windows 95	3.2MB	Requires Open Client/C version 11.1.1 and EBF #7729 or later.
Monitor Server for SQL Server 11.0.x	Windows NT 3.51 or later	0.1MB	Requires Open Client 10.0.4. Enables you to use the new functionality in the Adaptive Server plug-in monitoring and the new Monitor Client Library 11.5. (Be sure to install in your existing SQL Server 11.0.x directory.) Note: Do not install Open Client/C 11.1.1 with this product.
Language Modules (client and server)	Windows NT 4.0	2-6.5MB per language	English, German, French, Spanish, Chinese (simplified), Japanese, Korean, Portuguese Server language modules: 3-6MB Client language modules: 2-6.5MB The character set used to install Adaptive Server products must be supported by U.S. English.
InfoMaker	Windows NT 4.0 Windows 95	10MB minimum	Requires additional database space for subscriptions, publications, and transactions.

Adaptive Server Specifications

Table 2-4 provides Adaptive Server system specifications for Windows NT.

Table 2-4: System specifications
Hardware and Server
Minimum RAM required for Adaptive Server
32MB
9000 2K pages
32MB is the recommended minimum.
Minimum RAM per additional user
32MB
With default stack size, packet size, and user log cache size. This value depends on the connection needs. See the System Administration Guide for information about configuring memory.
Database Specifications
Databases per Adaptive Server
32,767
Practical limit is approximately 100.
Default database size
2MB
Minimum 2MB.
Maximum database size
2⁴²(4TB)
Maximum device size times 128 devices per database.
Maximum size of a database device
2³⁵32GB
Maximum number of database devices per server
256
Maximum number of devices or device pieces per database
128
Maximum number of segments per database
31
master database
5MB

7MB
Minimum required for a new installation
Minimum required for an upgrade
model database
2MB

3MB
Minimum required for a new installation
Minimum required for an upgrade
tempdb database
2MB

3MB
Minimum required for a new installation
Minimum required for an upgrade
sybsystemprocs database
45MB

60MB
Minimum required for an upgrade
Recommended for an upgrade
pubs2 database
2MB

3MB
Minimum required for a new installation
Minimum required for an upgrade
pubs3 database
2MB

3MB
Minimum required for a new installation
Minimum required for an upgrade
interpubs database
2MB

3MB
Minimum required for a new installation
Minimum required for an upgrade
jpubs database
2MB

3MB
Minimum required for a new installation
Minimum required for an upgrade
Table Specifications
User objects per database
2³¹ - 100
Columns per table
250
Indexes per table
250 (one clustered)
Rows per table
Limited by available storage
Maximum 2³¹ - 1
Maximum user data per row
1960 bytes
Maximum number of data bytes per text/image page
1800 bytes
Columns per composite index
16
Bytes per index key
256
Creation of clustered index
Free space needed on segment is
1.2 times table size
For sorted data, approximately 20% of the table size needed.
Characters per database object name
30
Query Specifications
Maximum number of tables in a "union" query
256
Maximum number of databases participating in one transaction
16
Includes database where transaction began, all databases changed during the transaction, and tempdb, if it is used for results or worktables.
Practical number of databases participating in one query
16
Includes each occurrence of each database queried and tempdb, if it is used for results or worktables.
Maximum number of tables participating in a query
192
Includes all worktables, result tables, tables referenced by views (the view itself is not counted), correlations, and self-joins.
System Specifications
Number of buffers and procedure buffers
Configurable
Limited by amount of RAM and maximum size of shared memory segment.
Minimum memory required per stored procedure
2K
Maximum number of parameters per stored procedure
255

**Table 2-4: System specifications**
Hardware and Server
Minimum RAM required for Adaptive Server	32MB	9000 2K pages 32MB is the recommended minimum.
Minimum RAM per additional user	32MB	With default stack size, packet size, and user log cache size. This value depends on the connection needs. See the System Administration Guide for information about configuring memory.
Database Specifications
Databases per Adaptive Server	32,767	Practical limit is approximately 100.
Default database size	2MB	Minimum 2MB.
Maximum database size	2⁴²(4TB)	Maximum device size times 128 devices per database.
Maximum size of a database device	2³⁵32GB
Maximum number of database devices per server	256
Maximum number of devices or device pieces per database	128
Maximum number of segments per database	31
master database	5MB 7MB	Minimum required for a new installation Minimum required for an upgrade
model database	2MB 3MB	Minimum required for a new installation Minimum required for an upgrade
tempdb database	2MB 3MB	Minimum required for a new installation Minimum required for an upgrade
sybsystemprocs database	45MB 60MB	Minimum required for an upgrade Recommended for an upgrade
pubs2 database	2MB 3MB	Minimum required for a new installation Minimum required for an upgrade
pubs3 database	2MB 3MB	Minimum required for a new installation Minimum required for an upgrade
interpubs database	2MB 3MB	Minimum required for a new installation Minimum required for an upgrade
jpubs database	2MB 3MB	Minimum required for a new installation Minimum required for an upgrade
Table Specifications
User objects per database	2³¹ - 100
Columns per table	250
Indexes per table	250 (one clustered)
Rows per table	Limited by available storage	Maximum 2³¹ - 1
Maximum user data per row	1960 bytes
Maximum number of data bytes per text/image page	1800 bytes
Columns per composite index	16
Bytes per index key	256
Creation of clustered index	Free space needed on segment is 1.2 times table size	For sorted data, approximately 20% of the table size needed.
Characters per database object name	30
Query Specifications
Maximum number of tables in a "union" query	256
Maximum number of databases participating in one transaction	16	Includes database where transaction began, all databases changed during the transaction, and tempdb, if it is used for results or worktables.
Practical number of databases participating in one query	16	Includes each occurrence of each database queried and tempdb, if it is used for results or worktables.
Maximum number of tables participating in a query	192	Includes all worktables, result tables, tables referenced by views (the view itself is not counted), correlations, and self-joins.
System Specifications
Number of buffers and procedure buffers	Configurable	Limited by amount of RAM and maximum size of shared memory segment.
Minimum memory required per stored procedure	2K
Maximum number of parameters per stored procedure	255

Language Module Sizes

Table 2-5 lists the sizes for the Adaptive Server and Open Client Language Modules.

Table 2-5: Language module sizes
Language
Size of Adaptive Server Language Module
Size of Open Client Language Module
Brazilian Portuguese
6.5MB
1.2MB
Chinese (simplified)
2MB
1.2MB
French
6.5MB
1.5MB
German
6.5MB
1.5MB
Japanese
4.5MB
1.2MB
Korean
2MB
1.2MB
Spanish
6.5MB
1.2MB

Language	Size of Adaptive Server Language Module	Size of Open Client Language Module
Brazilian Portuguese	6.5MB	1.2MB
Chinese (simplified)	2MB	1.2MB
French	6.5MB	1.5MB
German	6.5MB	1.5MB
Japanese	4.5MB	1.2MB
Korean	2MB	1.2MB
Spanish	6.5MB	1.2MB


	Expand Search