Installing Adaptive Server Enterprise on Siemens

Home

Chapter 3: Unloading Server Products from Distribution Media

Installing Adaptive Server Enterprise on Siemens

Chapter 2: Installation Requirements

Chapter 2

Installation Requirements

This chapter covers:

For easier installation, make a copy of this chapter, so you have the requirements information available as you perform the pre-installation, installation, or upgrade procedures.

System Requirements

Table 2-1 shows the required release-level, RAM, and network-protocol requirements for Adaptive Server.

Table 2-1: System requirements for Adaptive Server
Platform and Operating System
Release Level
RAM Required
Network Protocol
Siemens Reliant Unix
(Certified on Siemens Reliant Unix 5.44 C10)
5.44C
(X-Windows X11R6)
128MB
TCP

**Table 2-1: System requirements for Adaptive Server**
Platform and Operating System	Release Level	RAM Required	Network Protocol
Siemens Reliant Unix (Certified on Siemens Reliant Unix 5.44 C10)	5.44C (X-Windows X11R6)	128MB	TCP

Table 2-2 lists the RAM required for client products.

Table 2-2: System requirements for client products
Product
RAM Required
Adaptive Server plug-in for Sybase Central
12MB (Windows 95)
16MB (Windows NT)
Monitor Client Library
16MB (32MB recommended)
Open Client/C
16MB
SQL Advantage
8MB

**Table 2-2: System requirements for client products**
Product	RAM Required
Adaptive Server plug-in for Sybase Central	12MB (Windows 95) 16MB (Windows NT)
Monitor Client Library	16MB (32MB recommended)
Open Client/C	16MB
SQL Advantage	8MB

Product Disk Space Requirements

Table 2-3 lists the disk space requirements for each product.

Table 2-3: Product disk space requirements
Product and Version Level
Disk Space Required
Adaptive Server 11.9.2
194MB
Open Client/C 11.1.1
n/a or separate product
Language Modules (Server 11.9.2)
2-7MB per language
Language Modules (Open Client 11.1.1)
n/a or separate product
Monitor Server 11.9.2
1.6MB
Monitor Server 11.5.1 for SQL Server 11.0.x
n/a or separate product
Monitor Historical Server 11.9.2
n/a or separate product
Monitor Client Library 11.9.2
n/a or separate product

**Table 2-3: Product disk space requirements**
Product and Version Level	Disk Space Required
Adaptive Server 11.9.2	194MB
Open Client/C 11.1.1	n/a or separate product
Language Modules (Server 11.9.2)	2-7MB per language
Language Modules (Open Client 11.1.1)	n/a or separate product
Monitor Server 11.9.2	1.6MB
Monitor Server 11.5.1 for SQL Server 11.0.x	n/a or separate product
Monitor Historical Server 11.9.2	n/a or separate product
Monitor Client Library 11.9.2	n/a or separate product

Table 2-4 shows the installation requirements for the Adaptive Server plug-in for Sybase Central.

Table 2-4: Installation requirements for plug-in
Operating System
Disk Space
Windows NT 4.0 or Windows 95
12MB

**Table 2-4: Installation requirements for plug-in**
Operating System	Disk Space
Windows NT 4.0 or Windows 95	12MB

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

**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

Adaptive Server Specifications

This section provides Adaptive Server specifications for Siemens Reliant Unix.

Table 2-6: Adaptive Server specifications for Siemens Reliant UNIX
Hardware
Processor
64-bit (min R4400)
Minimum RAM required for Adaptive Server
64MB
32,000 2K pages
Minimum RAM per additional user
80K
With default stack size, packet size, and user log cache size
Default user stack size
64 Kbytes
Minimum 34 Kbytes
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 * 128 devices per database
Maximum size of a database device (disk partition)
2³⁵(32GB)
2GB maximum device size if using operating system files
32GB device size with raw partitions
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 index)
Rows per table
Limited by available storage
Maximum 2³²
Maximum user data per row
1960 bytes
Maximum number of data bytes per text/image page
1800 bytes
Columns per composite index
31
Bytes per index key
600
Creation of clustered index
Free space needed on segment is
1.2 * (size of table)
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 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
16
Includes all worktables, result tables, tables referenced by views (the view itself is not counted), correlations, and self-joins.
Maximum number of tables with referential integrity constraints for a query
192
Procedure 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-6: Adaptive Server specifications for Siemens Reliant UNIX**
Hardware
Processor	64-bit (min R4400)
Minimum RAM required for Adaptive Server	64MB	32,000 2K pages
Minimum RAM per additional user	80K	With default stack size, packet size, and user log cache size
Default user stack size	64 Kbytes	Minimum 34 Kbytes
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 * 128 devices per database
Maximum size of a database device (disk partition)	2³⁵(32GB)	2GB maximum device size if using operating system files 32GB device size with raw partitions
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 index)
Rows per table	Limited by available storage	Maximum 2³²
Maximum user data per row	1960 bytes
Maximum number of data bytes per text/image page	1800 bytes
Columns per composite index	31
Bytes per index key	600
Creation of clustered index	Free space needed on segment is 1.2 * (size of table)	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 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	16	Includes all worktables, result tables, tables referenced by views (the view itself is not counted), correlations, and self-joins.
Maximum number of tables with referential integrity constraints for a query	192
Procedure 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

What's Next?

To unload Adaptive Server software to your system, see Chapter 3, "Unloading Server Products from Distribution Media."


	Expand Search