Need help?Do you have a question about the Sybase Adaptive Server and is the answer not in the manual?
Describes the intended audience for the manual.
Explains how to navigate and use the manual's chapters.
Provides an overview of Adaptive Server's functions and capabilities.
Discusses platform-specific differences and considerations for Adaptive Server.
Details the different user roles and their responsibilities within Adaptive Server.
Explains the crucial system environment variables for Sybase products.
Describes the essential devices and system databases required by Adaptive Server.
Explains how Adaptive Server and clients communicate over a network.
Details how to modify Adaptive Server's configuration using sp_configure.
Discusses using Adaptive Server with languages other than U.S. English.
Lists technical specifications and limits for Adaptive Server.
Introduces the chapter on managing Sybase server lifecycle.
Lists prerequisites for starting Sybase servers.
Explains methods to start Adaptive Server, Backup Server, and Monitor Server.
Details the default start-up parameters for Adaptive Server.
How to modify default server start-up parameters.
Explains the usage of RUN_server_name files for server restarts.
Describes using the startserver utility from the command line.
Configures automatic server restarts on OS boot.
Details starting XP Server after installation.
Explains methods for shutting down Sybase servers.
Steps to gracefully shut down Adaptive Server.
Steps to gracefully shut down Backup Server.
Explains how to stop Monitor Server.
Describes using the kill command as a last resort.
Discusses shared memory files upon server shutdown.
Explains how to set and verify Sybase environment variables.
Guides on using srvbuild to configure new Sybase servers.
Discusses using the stty -tostop setting for terminal output.
How to restore Sybase file permissions using setperm_all.
Manages file descriptors and user connections for Adaptive Server.
Steps to enable asynchronous I/O for improved performance.
How to adjust TCP/IP client connection timeout settings.
Identifies hardware errors indicating potential database corruption.
Tools and methods for monitoring OS resource usage.
Provides a sample C shell script for database maintenance.
Lists default parameter settings for Adaptive Server.
Explains how Sybase servers find network locations.
Describes how clients use directory services to connect to servers.
How to create entries in directory services.
Lists the directory drivers supported by Sybase.
Details the structure and purpose of the interfaces file.
Discusses Sybase environments across different platforms.
Explains the syntax rules for interfaces file entries.
Details the elements that make up an interfaces file entry.
Steps to create a master interfaces file for consistency.
How to configure interfaces files for multiple network interfaces.
Setting up multiple network listeners for a server.
How clients connect using multiple network interfaces.
How to encrypt passwords for LDAP authentication.
Notes on performance when using LDAP servers.
Information on Sybase Adaptive Server's IPv6 capabilities.
Basic concepts of IPv6 addressing.
Describes the recommended infrastructure for IPv6 support.
How to enable IPv6 awareness in Adaptive Server.
Common issues and solutions for network configuration.
Diagnosing and resolving server startup failures.
Introduces Lightweight Directory Access Protocol (LDAP) for directory services.
Compares LDAP services with Sybase interfaces files.
Explains the libtcl*.cfg file for LDAP server configuration.
Steps to configure and enable LDAP directory services.
How to add server entries to the LDAP directory service.
Discusses configuring multiple directory services for failover.
Steps to migrate from interfaces files to LDAP services.
Explains Sybase localization support for international installations.
Details character set conversion between clients and servers.
Explains sort orders for character sets and data collation.
How Sybase manages localized software messages and language support.
Overview of Sybase localization configuration.
Describes the directory structure for Sybase localization files.
How to modify Sybase localization settings.
Explains how Adaptive Server writes information to a local error log file.
How to set and reset the location of the Adaptive Server error log file.
Controls user-defined messages and auditing events logging.
Specifies whether user-defined messages are logged to the error log.
Configures logging of auditing events like logins.
Defines database devices and their basic requirements.
Lists the limits for Adaptive Server device sizes.
How to create new database devices using disk init.
Explains the importance and process of auditing in database management.
Describes components of the audit system, including devices and databases.
Outlines two methods for installing auditing for the first time.
Tasks required before setting up auditing devices.
Steps to configure Adaptive Server for auditing using auditinit.
Instructions for installing the sybsyntax help database.
Describes how to use sp_syntax for Transact-SQL syntax help.
Explains the default device for the sybsyntax database.
Steps to execute sybsyntax installation scripts.
General| Type | Relational Database Management System |
|---|---|
| Initial release | 1987 |
| Version | 16.0 |
| Replication | Yes |
| Data Model | Relational |
| License | Commercial |
| Developer | SAP (originally Sybase) |
| Operating Systems | Linux, UNIX, Windows |
| Programming Languages Supported | C, C++, Java, SQL |
| Security Features | Encryption, Auditing |
| SQL Standard | ANSI SQL |
| Partitioning methods | Range, List, Hash |
| SQL | T-SQL |
| Storage engines | N/A (Proprietary) |
To Next Page