SyBooks Help Introduction
Help Basics
SyBooks Installation Guide
About this book
SyBooks for Windows Installation
Preinstallation requirements
Preparing the installation environment
Software requirements
Installing SyBooks for Windows
Reviewing subdirectories
Tracking product installation information
Launching SyBooks for Windows
SyBooks for Linux Installation
Preinstallation requirements
Preparing the installation environment
Software requirements
Installing SyBooks for Linux
Launching SyBooks for Linux
SyBooks for Mac OS X Installation
Preinstallation requirements
Preparing the installation environment
Software requirements
Installing SyBooks for Mac OS X
Launching SyBooks for Mac OS X
SyBooks Uninstallation
Uninstalling SyBooks for Windows
Uninstalling SyBooks for Linux
Uninstalling SyBooks for Mac OS X
Adaptive Server Enterprise 15.0.2
Release Bulletin for HP-UX
Accessing current release bulletin information
Product summary
Installation kit
Operating system requirements
Special installation instructions
JRE patch for daylight saving time and Sybase products
Installing both OpenServer and Adaptive Server on the same machine
Installing Adaptive Server interim releases on top of existing installations
Using SySAM 2.0
Monitoring and Diagnostic (MDA) tables
Special uninstallation instruction
Multiple Sybase products installed in same $SYBASE directory
Special upgrade instructions
Upgrading using allrows_dss in parallel
Disabling High Availability during upgrade
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading Adaptive Server configured with high availability
Changes that affect existing applications
Syntax updates for sysquerymetrics
Merge existing lib config files manually
Support for certain traceflags has been removed from Adaptive Server
Directory changes
Changes to ODBC and OLE DB Driver support
PC-Client CD
Changes that affect application behavior
Long-identifier changes
Query changes
Component Integration Services changes
Error message changes
jConnect version 6.05 ships with Adaptive Server Enterprise
SQL Remote no longer ships on the PC-Client CD
Table changes
Changes that affect database administration operations
Usage of system built-in functions
DDL and DML changes
System stored procedure changes
Common diagnostics changes including trace flag usage
System resource changes
Unpartitioning of user tables during upgrade
Space management changes
Changes to transaction dump content
Open Client and Open Server changes
Known problems
Column join issue with no case sort order and others
Error message: “ks_falloc() memory allocation failed”
Syntax error for Queries containing certain clauses
Current process infected with 4 message appears on HP IA platform
Error 15432
Source code text in syscomments corruption
Error 2708
syconfig cannot execute preupgrade
Deallocated sysindexes page is deleted
Maximum password length for Adaptive Server
Password error message with encrypted columns key with user password
Owner of a key copy can be made the new owner of the key
Wrong or no error message with set encryption password
sp_engine fails under certain scenarios
Sybase Central Plug-in failure
Connection deadlock with two or more concurrent connections and LDAP authentication
Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese
Configuring Job Scheduler Self Management for Simplified Chinese
Installing an ESD overlay with Unified Agent
Highlighted known installation issues
Installing correct fonts when displaying Chinese characters
Formatting the options file during a silent installation
Installing Adaptive Server 15.0.2 on top of Workspace
Uninstalling from HP-UX 11.23
EAServer manager and Security manager
Interactive SQL and Adaptive Server Enterprise plug-in issues
Connecting Adaptive Server Enterprise plug-in to RepConnector
Query support in Interactive SQL
Monitor GUI does not start when the LDAP server is used
allow backward scan does not work
set statistics io does not display I/O generated by worker processes
IPv6 support causes Adaptive Server to stop responding
Replication Server compatibility issues
Handling multibyte character sets during migration
Sybase Central
File names
sp_configure current audit table
Product compatibilities
Adaptive Server interoperability
Adaptive Server Replicator 15.0 support of Adaptive Server Enterprise 15.0.2 datatypes
Known compatibility issues
RTDS 4.0 incompatibility with 15.0.2
Password compatibility with Replicator Server
Installing Enterprise Connect Data Access (ECDA) or MainframeConnect DirectConnect for z/OS with other Sybase software
Installing Replication Server with other Sybase software
Using Job Scheduler templates
Copy menu
Documentation updates and clarifications
Messaging Services User's Guide
System Administration Guide
o/s file descriptors Summary and Information
@@max_connections stored number of file descriptors
enable metrics capture
Transact SQL User’s Guide
Range-partitioned tables and sort order change
Reference Manual: Building Blocks
Corrections to global variables
Correction to example in curunreservedpgs
Update in derived_stat
Correction in xa_bqual example
Reference Manual: Commands
Clarification in alter table
Correction in create table
Correction in create trigger
Clarification in dbcc
Correction in grant set proxy
Additional usage information for reorg
Correction in select
Correction in set proc_output_params off
setuser
Reference Manual: Procedures
sp_dbcc_deletehistory
sp_helpconstraint truncates keys
sp_monitorconfig example updated with new parameters
sp_poolconfig
sp_sproc_columns column_type description
Change in xp_cmdshell
Reference Manual: Tables
syscomments
sysdatabases
Installation Guide
Run installmaster script when performing binary overlay
Determining devices for a database
Incorrect syntax for running uninstmsgs.ebf and instmsgs.ebf after upgrade:
If you downgraded back to original installation after upgrading to 15.0.2
Performance and Tuning Guide: Monitoring
Technical support
Other sources of information
Sybase certifications on the Web
Sybase EBFs and software maintenance
Accessibility features
Release Bulletin for IBM AIX
Accessing current release bulletin information
Product summary
Installation kit
Operating system requirements
Special installation instructions
JRE patch for daylight saving time and Sybase products
Installing both OpenServer and Adaptive Server on the same machine
Installing Adaptive Server interim releases on top of existing installations
Using SySAM 2.0
Monitoring and Diagnostic (MDA) tables
Special uninstallation instruction
Multiple Sybase products installed in same $SYBASE directory
Special upgrade instructions
Upgrading using allrows_dss in parallel
Disabling High Availability during upgrade
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading Adaptive Server configured with high availability
Changes that affect existing applications
Syntax updates for sysquerymetrics
Merge existing lib config files manually
Support for certain traceflags has been removed from Adaptive Server
Directory changes
Changes to ODBC and OLE DB Driver support
PC-Client CD
Changes that affect application behavior
Long-identifier changes
Query changes
Component Integration Services changes
Error message changes
jConnect version 6.05 ships with Adaptive Server Enterprise
SQL Remote no longer ships on the PC-Client CD
Table changes
Changes that affect database administration operations
Usage of system built-in functions
DDL and DML changes
System stored procedure changes
Common diagnostics changes including trace flag usage
System resource changes
Unpartitioning of user tables during upgrade
Space management changes
Changes to transaction dump content
Open Client and Open Server changes
Known problems
Column join issue with no case sort order and others
Error message: “ks_falloc() memory allocation failed”
Syntax error for Queries containing certain clauses
Error 15432
Source code text in syscomments corruption
Error 2708
syconfig cannot execute preupgrade
Deallocated sysindexes page is deleted
Maximum password length for Adaptive Server
Password error message with encrypted columns key with user password
Owner of a key copy can be made the new owner of the key
Wrong or no error message with set encryption password
sp_engine fails under certain scenarios
Stack trace may be reported when using XML features
Sybase Central Plug-in failure
Connection deadlock with two or more concurrent connections and LDAP authentication
Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese
Configuring Job Scheduler Self Management for Simplified Chinese
Installing an ESD overlay with Unified Agent
Highlighted known installation issues
Installing correct fonts when displaying Chinese characters
Formatting the options file during a silent installation
Installing Adaptive Server 15.0.2 on top of Workspace
EAServer manager and Security manager
Interactive SQL and Adaptive Server Enterprise plug-in issues
Connecting Adaptive Server Enterprise plug-in to RepConnector
Query support in Interactive SQL
Monitor GUI does not start when the LDAP server is used
allow backward scan does not work
set statistics io does not display I/O generated by worker processes
Replication Server compatibility issues
Handling multibyte character sets during migration
Sybase Central
File names
sp_configure current audit table
Product compatibilities
Adaptive Server interoperability
Adaptive Server Replicator 15.0 support of Adaptive Server Enterprise 15.0.2 datatypes
Known compatibility issues
RTDS 4.0 incompatibility with 15.0.2
Password compatibility with Replicator Server
Installing Enterprise Connect Data Access (ECDA) or MainframeConnect DirectConnect for z/OS with other Sybase software
Installing Replication Server with other Sybase software
Using Job Scheduler templates
Copy menu
Documentation updates and clarifications
Messaging Services User's Guide
System Administration Guide
o/s file descriptors Summary and Information
@@max_connections stored number of file descriptors
enable metrics capture
Transact SQL User’s Guide
Range-partitioned tables and sort order change
Reference Manual: Building Blocks
Corrections to global variables
Correction to example in curunreservedpgs
Update in derived_stat
Correction in xa_bqual example
Reference Manual: Commands
Clarification in alter table
Correction in create table
Correction in create trigger
Clarification in dbcc
Correction in grant set proxy
Additional usage information for reorg
Correction in select
Correction in set proc_output_params off
setuser
Reference Manual: Procedures
sp_dbcc_deletehistory
sp_helpconstraint truncates keys
sp_monitorconfig example updated with new parameters
sp_poolconfig
sp_sproc_columns column_type description
Change in xp_cmdshell
Reference Manual: Tables
syscomments
sysdatabases
Installation Guide
Run installmaster script when performing binary overlay
Determining devices for a database
Incorrect syntax for running uninstmsgs.ebf and instmsgs.ebf after upgrade:
If you downgraded back to original installation after upgrading to 15.0.2
Performance and Tuning Guide: Monitoring
Technical support
Other sources of information
Sybase certifications on the Web
Sybase EBFs and software maintenance
Accessibility features
Release Bulletin for Linux
Accessing current release bulletin information
Product summary
Installation kit
Operating system requirements
Special installation instructions
JRE patch for daylight saving time and Sybase products
Installing both OpenServer and Adaptive Server on the same machine
Installing Adaptive Server interim releases on top of existing installations
Using SySAM 2.0
Runtime libraries required for Linux on Power installation
Monitoring and Diagnostic (MDA) tables
Special uninstallation instruction
Multiple Sybase products installed in same $SYBASE directory
Special upgrade instructions
Upgrading using allrows_dss in parallel
Upgrading compiled objects
Disabling High Availability during upgrade
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading Adaptive Server configured with high availability
Changes that affect existing applications
Web Service not supported for this release on Linux Itanium
db2 server class no longer supported
Syntax updates for sysquerymetrics
Merge existing lib config files manually
Support for certain traceflags has been removed from Adaptive Server
Direct I/O support
Directory changes
Changes to ODBC and OLE DB Driver support
PC-Client CD
Changes that affect application behavior
Long-identifier changes
Query changes
Component Integration Services changes
Error message changes
jConnect version 6.05 ships with Adaptive Server Enterprise
SQL Remote no longer ships on the PC-Client CD
Table changes
Changes that affect database administration operations
Usage of system built-in functions
DDL and DML changes
System stored procedure changes
Common diagnostics changes including trace flag usage
System resource changes
Unpartitioning of user tables during upgrade
Space management changes
Changes to transaction dump content
Open Client and Open Server changes
Known problems
Installer image fails to run
Unaligned access messages on Linux Itanium platform
Column join issue with no case sort order and others
Error message: “ks_falloc() memory allocation failed”
Syntax error for Queries containing certain clauses
Error 15432
Source code text in syscomments corruption
Error 2708
syconfig cannot execute preupgrade
Deallocated sysindexes page is deleted
Maximum password length for Adaptive Server
Password error message with encrypted columns key with user password
Owner of a key copy can be made the new owner of the key
Wrong or no error message with set encryption password
sp_engine fails under certain scenarios
Stack trace may be reported when using XML features
Sybase Central Plug-in failure
Connection deadlock with two or more concurrent connections and LDAP authentication
Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese
Configuring Job Scheduler Self Management for Simplified Chinese
Installing an ESD overlay with Unified Agent
Highlighted known installation issues
Installing correct fonts when displaying Chinese characters
Formatting the options file during a silent installation
Installing Adaptive Server 15.0.2 on top of Workspace
EAServer manager and Security manager
Running on RH3.0 64-bit distribution occasionally stops responding
Interactive SQL and Adaptive Server Enterprise plug-in issues
Connecting Adaptive Server Enterprise plug-in to RepConnector
Query support in Interactive SQL
Monitor GUI does not start when the LDAP server is used
allow backward scan does not work
set statistics io does not display I/O generated by worker processes
Replication Server compatibility issues
Handling multibyte character sets during migration
Sybase Central
File names
sp_configure current audit table
Product compatibilities
Adaptive Server interoperability
Adaptive Server Replicator 15.0 support of Adaptive Server Enterprise 15.0.2 datatypes
Known compatibility issues
RTDS 4.0 incompatibility with 15.0.2
Password compatibility with Replicator Server
Installing Enterprise Connect Data Access (ECDA) or MainframeConnect DirectConnect for z/OS with other Sybase software
jConnect 6.0 and sqldbgr
Installing Replication Server with other Sybase software
Using Job Scheduler templates
Copy menu
Documentation updates and clarifications
Utility Guide
incorrect example description for sp_modifylogin
Messaging Services User's Guide
System Administration Guide
o/s file descriptors Summary and Information
@@max_connections stored number of file descriptors
enable metrics capture
Transact SQL User’s Guide
Range-partitioned tables and sort order change
Reference Manual: Building Blocks
Corrections to the Usage section
Corrections to global variables
Correction to example in curunreservedpgs
Update in derived_stat
Correction in xa_bqual example
Reference Manual: Commands
alter table command
set forceplan
disk init
Clarification in alter table
Correction in create table
Correction in create trigger
Clarification in dbcc
Correction in grant set proxy
Additional usage information for reorg
Correction in select
Correction in set proc_output_params off
setuser
Reference Manual: Procedures
sp_recompile
sp_dbcc_deletehistory
sp_helpconstraint truncates keys
sp_monitorconfig example updated with new parameters
sp_poolconfig
sp_sproc_columns column_type description
Change in xp_cmdshell
Reference Manual: Tables
syscomments
sysdatabases
Installation Guide
Run installmaster script when performing binary overlay
Determining devices for a database
Incorrect syntax for running uninstmsgs.ebf and instmsgs.ebf after upgrade:
If you downgraded back to original installation after upgrading to 15.0.2
Performance and Tuning Guide: Monitoring
Preallocating Log Pages to Reduce Contention
Technical support
Other sources of information
Sybase certifications on the Web
Sybase EBFs and software maintenance
Accessibility features
Release Bulletin for Sun Solaris
Accessing current release bulletin information
Product summary
Installation kit
Operating system requirements
Special installation instructions
JRE patch for daylight saving time and Sybase products
Installing both OpenServer and Adaptive Server on the same machine
Installing Adaptive Server interim releases on top of existing installations
Using SySAM 2.0
Monitoring and Diagnostic (MDA) tables
Special uninstallation instruction
Multiple Sybase products installed in same $SYBASE directory
Special upgrade instructions
Upgrading using allrows_dss in parallel
Disabling High Availability during upgrade
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading Adaptive Server configured with high availability
Changes that affect existing applications
Syntax updates for sysquerymetrics
Merge existing lib config files manually
Support for certain traceflags has been removed from Adaptive Server
Directory changes
Changes to ODBC and OLE DB Driver support
PC-Client CD
Changes that affect application behavior
Long-identifier changes
Query changes
Component Integration Services changes
Error message changes
jConnect version 6.05 ships with Adaptive Server Enterprise
SQL Remote no longer ships on the PC-Client CD
Table changes
Changes that affect database administration operations
Usage of system built-in functions
DDL and DML changes
System stored procedure changes
Common diagnostics changes including trace flag usage
System resource changes
Unpartitioning of user tables during upgrade
Space management changes
Changes to transaction dump content
Open Client and Open Server changes
Known problems
Column join issue with no case sort order and others
Error message: “ks_falloc() memory allocation failed”
Syntax error for Queries containing certain clauses
Error 15432
Source code text in syscomments corruption
Error 2708
syconfig cannot execute preupgrade
Deallocated sysindexes page is deleted
Maximum password length for Adaptive Server
Password error message with encrypted columns key with user password
Owner of a key copy can be made the new owner of the key
Wrong or no error message with set encryption password
sp_engine fails under certain scenarios
Sybase Central Plug-in failure
Connection deadlock with two or more concurrent connections and LDAP authentication
Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese
Configuring Job Scheduler Self Management for Simplified Chinese
Installing an ESD overlay with Unified Agent
Highlighted known installation issues
Installing correct fonts when displaying Chinese characters
Formatting the options file during a silent installation
Installing Adaptive Server 15.0.2 on top of Workspace
EAServer manager and Security manager
Interactive SQL and Adaptive Server Enterprise plug-in issues
Connecting Adaptive Server Enterprise plug-in to RepConnector
Query support in Interactive SQL
Monitor GUI does not start when the LDAP server is used
allow backward scan does not work
set statistics io does not display I/O generated by worker processes
Replication Server compatibility issues
Handling multibyte character sets during migration
Sybase Central
File names
sp_configure current audit table
Product compatibilities
Adaptive Server interoperability
Adaptive Server Replicator 15.0 support of Adaptive Server Enterprise 15.0.2 datatypes
Known compatibility issues
RTDS 4.0 incompatibility with 15.0.2
Password compatibility with Replicator Server
Installing Enterprise Connect Data Access (ECDA) or MainframeConnect DirectConnect for z/OS with other Sybase software
Installing Replication Server with other Sybase software
Using Job Scheduler templates
Copy menu
Documentation updates and clarifications
Messaging Services User's Guide
System Administration Guide
o/s file descriptors Summary and Information
@@max_connections stored number of file descriptors
enable metrics capture
Transact SQL User’s Guide
Range-partitioned tables and sort order change
Reference Manual: Building Blocks
Corrections to global variables
Correction to example in curunreservedpgs
Update in derived_stat
Correction in xa_bqual example
Reference Manual: Commands
Clarification in alter table
Correction in create table
Correction in create trigger
Clarification in dbcc
Correction in grant set proxy
Additional usage information for reorg
Correction in select
Correction in set proc_output_params off
setuser
Reference Manual: Procedures
sp_dbcc_deletehistory
sp_helpconstraint truncates keys
sp_monitorconfig example updated with new parameters
sp_poolconfig
sp_sproc_columns column_type description
Change in xp_cmdshell
Reference Manual: Tables
syscomments
sysdatabases
Installation Guide
Run installmaster script when performing binary overlay
Determining devices for a database
Incorrect syntax for running uninstmsgs.ebf and instmsgs.ebf after upgrade:
If you downgraded back to original installation after upgrading to 15.0.2
Performance and Tuning Guide: Monitoring
Technical support
Other sources of information
Sybase certifications on the Web
Sybase EBFs and software maintenance
Accessibility features
Release Bulletin for Windows
Accessing current release bulletin information
Product summary
Installation kit
Operating system requirements
Special installation instructions
JRE patch for daylight saving time and Sybase products
Installing Adaptive Server 15.0.2 with previous versions of Adaptive Server
Installing both OpenServer and Adaptive Server on the same machine
Installing Adaptive Server interim releases on top of existing installations
Using SySAM 2.0
Monitoring and Diagnostic (MDA) tables
Special uninstallation instruction
Multiple Sybase products installed in same $SYBASE directory
Special upgrade instructions
Upgrading using allrows_dss in parallel
Disabling High Availability during upgrade
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading Adaptive Server configured with high availability
Changes that affect existing applications
Syntax updates for sysquerymetrics
dbisql.bat launcher is no longer supported
Merge existing lib config files manually
Support for certain traceflags has been removed from Adaptive Server
SSL support
Cipher Suites not supported by OpenSSL
Cipher Suites supported by OpenSSL
Directory changes
Changes to ODBC and OLE DB Driver support
PC-Client CD
Changes that affect application behavior
Long-identifier changes
Query changes
Component Integration Services changes
Error message changes
jConnect version 6.05 ships with Adaptive Server Enterprise
SQL Remote no longer ships on the PC-Client CD
Table changes
Changes that affect database administration operations
Usage of system built-in functions
DDL and DML changes
System stored procedure changes
Common diagnostics changes including trace flag usage
System resource changes
Unpartitioning of user tables during upgrade
Space management changes
Changes to transaction dump content
Open Client and Open Server changes
Known problems
Column join issue with no case sort order and others
Error message: “ks_falloc() memory allocation failed”
Syntax error for Queries containing certain clauses
Error 15432
Source code text in syscomments corruption
Error 2708
syconfig cannot execute preupgrade
Deallocated sysindexes page is deleted
Maximum password length for Adaptive Server
Password error message with encrypted columns key with user password
Owner of a key copy can be made the new owner of the key
Wrong or no error message with set encryption password
sp_engine fails under certain scenarios
Sybase Central Plug-in failure
Connection deadlock with two or more concurrent connections and LDAP authentication
Installing PC-Client on 64-bit Windows platforms
Creating Job Scheduler schedules for Adaptive Server with Simplified Chinese
Configuring Job Scheduler Self Management for Simplified Chinese
Installing an ESD overlay with Unified Agent
Highlighted known installation issues
Formatting the options file during a silent installation
Warning message when installing ODBC Driver from or SDK 15.0
Installing Adaptive Server 15.0.2 on top of Workspace
EAServer manager and Security manager
Installing Adaptive Server Anywhere with Adaptive Server Enterprise
Interactive SQL and Adaptive Server Enterprise plug-in issues
Connecting Adaptive Server Enterprise plug-in to RepConnector
Query support in Interactive SQL
Monitor GUI does not start when the LDAP server is used
allow backward scan does not work
set statistics io does not display I/O generated by worker processes
Replication Server compatibility issues
Handling multibyte character sets during migration
Sybase Central
File names
Running syconfig with LANG variable set
sp_configure current audit table
Error while executing SQL for migration
Product compatibilities
Adaptive Server interoperability
Adaptive Server Replicator 15.0 support of Adaptive Server Enterprise 15.0.2 datatypes
Known compatibility issues
RTDS 4.0 incompatibility with 15.0.2
Password compatibility with Replicator Server
Installing Enterprise Connect Data Access (ECDA) or MainframeConnect DirectConnect for z/OS with other Sybase software
Installing Replication Server with other Sybase software
Using Job Scheduler templates
Copy menu
Documentation updates and clarifications
Messaging Services User's Guide
System Administration Guide
o/s file descriptors Summary and Information
@@max_connections stored number of file descriptors
enable metrics capture
Transact SQL User’s Guide
Range-partitioned tables and sort order change
Reference Manual: Building Blocks
Corrections to global variables
Correction to example in curunreservedpgs
Update in derived_stat
Correction in xa_bqual example
Reference Manual: Commands
Clarification in alter table
Correction in create table
Correction in create trigger
Clarification in dbcc
Correction in grant set proxy
Additional usage information for reorg
Correction in select
Correction in set proc_output_params off
setuser
Reference Manual: Procedures
sp_dbcc_deletehistory
sp_helpconstraint truncates keys
sp_monitorconfig example updated with new parameters
sp_poolconfig
sp_sproc_columns column_type description
Change in xp_cmdshell
Reference Manual: Tables
syscomments
sysdatabases
Installation Guide
Run installmaster script when performing binary overlay
Determining devices for a database
Incorrect syntax for running uninstmsgs.ebf and instmsgs.ebf after upgrade:
If you downgraded back to original installation after upgrading to 15.0.2
Performance and Tuning Guide: Monitoring
Technical support
Other sources of information
Sybase certifications on the Web
Sybase EBFs and software maintenance
Accessibility features
Installation Guide for HP-UX
About this book
Overview
Product licensing with SySAM 2.0
Product components
Adaptive Server Enterprise
Backup Server
Stored procedures
The client
Adaptive Server editions
Enterprise Edition
Small Business Edition
Developer Edition
Adaptive Server specifications
Product descriptions and directory layout
PC-Client product descriptions and directory layout
Separately installable PC-Client products
Installing Adaptive Server
Overview
System requirements
Pre-installation tasks for SySAM
Accessing SPDC
Getting your host ID
Generating licenses at SPDC
Generating a served license
Generating an unserved license
Installing a new license server
Pre-installation tasks for Adaptive Server
Installing server components
Installation methods
Installing components with the Installer in GUI mode
Installing version 15.0.2 over an existing 15.x Adaptive Server
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.2 binary overlay
Post-Installation Tasks
Verifying that servers are running
Verifying that you can connect to servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
The SAMreport
Installing sample databases
Default devices for sample databases
interpubs database
jpubs database
Maintaining the sample databases
Installing Sybase PC-Client Products
Overview
Before you install the PC-Client products
Installing PC-Client products
Installing PowerDesigner, PowerTransfer, and InfoMaker
Configuring network connections for client products
Configuring libtcl.cfg for LDAP
Adding a server to the interfaces file
Testing the Sybase Central installation
Upgrading Adaptive Server
Overview of the upgrade process
System catalog changes during upgrade
Pre-upgrade tasks
Checking system and upgrade requirements
Checking RUN_server file location
Procedure text is required for upgrade
Reserved words
Running a reserved word check
Addressing reserved words conflicts
Using quoted identifiers
Preparing the database and devices for the upgrade
Create a sybsystemdb database
If you have a sybsystemdb database
If you do not have a sybsystemdb database
sybsystemprocs
Upgrading to Adaptive Server 15.0.2
Using sqlupgrade
Using sqlupgraderes
Resource file attributes for upgrading Adaptive Server
Upgrading using sqlupgraderes
Post-upgrade tasks
Run the instmsgs.ebf script
Restoring functionality in Adaptive Server
Reenabling Replication Server
Removing old log records
Reenabling replication
Restoring replication after upgrade
Reenabling auditing
Special considerations for threshold procedures for audit segments
Shutting down SySAM servers
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading high availability
Migrating from 32-bit to 64-bit versions on Different Computers
Recovering from a failed upgrade
Downgrading from Adaptive Server 15.0.2
Downgrading from 15.0.2 release
Basic downgrade steps
Post-downgrade tasks
System stored procedures
System messages
Unrecognized tokens or objects
System tables
Configuration parameters
Keywords
Additional steps required if you used 15.0.2 features before downgrading
Real-Time Messaging
New sort orders
Native XML
Instead of trigger
SQL user defined functions
Automatic database expansion
Replication issues with downgrade
Downgrading Job Scheduler
Returning to Adaptive Server version 15.0.2
Troubleshooting SySAM Issues
Calling Sybase technical support for SySAM-related issues
Where to look for SySAM-related errors
Troubleshooting SySAM
SySAM grace mode
SySAM grace period
Enabling and changing e-mail notifications
Troubleshooting
Overview
Error log locations
Solutions to common installation problems
Cannot use X-Windows
Cannot eject the CD from the drive