SyBooks Online Infocenter Help
Navigating the Content
Searching for Content
Searching all Content Collections
Narrowing a Search
Search Keyboard Shortcuts
Navigating the Content
Searching for Content
Searching all Content Collections
Narrowing a Search
Search Keyboard Shortcuts
Adaptive Server Enterprise 15.0.3
Adaptive Server Enterprise Release Bulletin 15.0.3 for HP-UX
Product Summary
Adaptive Server Interoperability
Product Compatibility
Changes that Affect Existing Applications
Installation, Upgrade and Configuration
Known Issues
Known Installation Issues
Known Issues with Interactive SQL and ASEP
Documentation Updates and Clarifications
Obtaining Help and Additional Information
Technical Support
Finding EBFs and Software Maintenance
Sybase Product and Component Certifications
Web Links to Certification Information
Creating a MySybase Profile
Accessibility Features
Adaptive Server Enterprise Release Bulletin 15.0.3 for IBM AIX
Product Summary
Adaptive Server Interoperability
Product Compatibility
Changes that Affect Existing Applications
Installation, Upgrade and Configuration
Known Issues
Known Installation Issues
Known Issues with Interactive SQL and ASEP
Documentation Updates and Clarifications
Obtaining Help and Additional Information
Technical Support
Finding EBFs and Software Maintenance
Sybase Product and Component Certifications
Web Links to Certification Information
Creating a MySybase Profile
Accessibility Features
Adaptive Server Enterprise Release Bulletin 15.0.3 for Linux
Product Summary
Adaptive Server Interoperability
Known Compatibility Issues
Changes that Affect Existing Applications
Installation, Upgrade and Configuration
Known Issues
Known Installation Issues
Known Issues with Interactive SQL and ASEP
Documentation Updates and Clarifications
Obtaining Help and Additional Information
Technical Support
Finding EBFs and Software Maintenance
Sybase Product and Component Certifications
Web Links to Certification Information
Creating a MySybase Profile
Accessibility Features
Adaptive Server Enterprise Release Bulletin 15.0.3 for Sun Solaris
Product Summary
Adaptive Server Interoperability
Known Compatibility Issues
Changes that Affect Existing Applications
Installation, Upgrade and Configuration
Known Issues
Known Installation Issues
Known Issues with Interactive SQL and ASEP
Documentation Updates and Clarifications
Obtaining Help and Additional Information
Technical Support
Finding EBFs and Software Maintenance
Sybase Product and Component Certifications
Web Links to Certification Information
Creating a MySybase Profile
Accessibility Features
Adaptive Server Enterprise Release Bulletin 15.0.3 for Windows
Product Summary
Adaptive Server Interoperability
Known Compatibility Issues
Changes that Affect Existing Applications
Installation, Upgrade and Configuration
Known Issues
Known Installation Issues
Known Issues with Interactive SQL and ASEP
Documentation Updates and Clarifications
Obtaining Help and Additional Information
Technical Support
Finding EBFs and Software Maintenance
Sybase Product and Component Certifications
Web Links to Certification Information
Creating a MySybase Profile
Accessibility Features
Release Bulletin Adaptive Server Enterprise Cluster Edition for HP-UX
Product Summary
Version Contents
New Features and Support
Changes In This Version
Changed Functionality in This Version
Changes That Affect Database Administration Operations
Features and Utilities Not Supported In This Version
Installation and Upgrade
Special Installation Instructions
Special Configuration Instructions
Special Upgrade Instructions
Upgrading to a private installation
Known Problems
Known Problems for Adaptive Server Plug-In
Known Problems With Cluster Feature
Product Compatibility
Documentation Changes
Documentation Changes for Clusters Users Guide
Documentation Changes for Performance and Tuning Guide
Documentation Changes for Reference Manual: Procedures
Obtaining Help and Additional Information
Technical Support
Sybase EBFs and Software Maintenance
Sybase Product and Component Certifications
Creating a MySybase Profile
Accessibility Features
Release Bulletin Adaptive Server Enterprise Cluster Edition for IBM AIX
Product Summary
Version Contents
New Features and Support
Changes In This Version
Changed Functionality in This Version
Changes That Affect Database Administration Operations
Features and Utilities Not Supported In This Version
Installation and Upgrade
Special Installation Instructions
Special Configuration Instructions
Special Upgrade Instructions
Upgrading to a private installation
Known Problems
Known Problems for Adaptive Server Plug-In
Known Problems With Cluster Feature
Product Compatibility
Documentation Changes
Documentation Changes for Clusters Users Guide
Documentation Changes for Performance and Tuning Guide
Documentation Changes for Reference Manual: Procedures
Obtaining Help and Additional Information
Technical Support
Sybase EBFs and Software Maintenance
Sybase Product and Component Certifications
Creating a MySybase Profile
Accessibility Features
Release Bulletin Adaptive Server Enterprise Cluster Edition for Linux
Product Summary
Version Contents
New Features and Support
Changes In This Version
Changed Functionality in This Version
Changes That Affect Database Administration Operations
Features and Utilities Not Supported In This Version
Installation and Upgrade
Special Installation Instructions
Special Configuration Instructions
Special Upgrade Instructions
Upgrading to a private installation
Known Problems
Known Problems for Adaptive Server Plug-In
Known Problems With Cluster Feature
Product Compatibility
Documentation Changes
Documentation Changes for Clusters Users Guide
Documentation Changes for Performance and Tuning Guide
Documentation Changes for Reference Manual: Procedures
Obtaining Help and Additional Information
Technical Support
Sybase EBFs and Software Maintenance
Sybase Product and Component Certifications
Creating a MySybase Profile
Accessibility Features
Release Bulletin Adaptive Server Enterprise Cluster Edition for Sun Solaris
Product Summary
Version Contents
New Features and Support
Changes In This Version
Changed Functionality in This Version
Changes That Affect Database Administration Operations
Features and Utilities Not Supported In This Version
Installation and Upgrade
Special Installation Instructions
Special Configuration Instructions
Special Upgrade Instructions
Upgrading to a private installation
Known Problems
Known Problems for Adaptive Server Plug-In
Known Problems With Cluster Feature
Product Compatibility
Documentation Changes
Documentation Changes for Clusters Users Guide
Documentation Changes for Performance and Tuning Guide
Documentation Changes for Reference Manual: Procedures
Obtaining Help and Additional Information
Technical Support
Sybase EBFs and Software Maintenance
Sybase Product and Component Certifications
Creating a MySybase Profile
Accessibility Features
Installation Guide for HP-UX
About this book
Before You Start
Adaptive Server Enterprise architecture
Backup Server
Stored procedures
The client
Adaptive Server editions
Overview of installation steps
System requirements
Operating system patches for HP-UX
Adaptive Server product descriptions and directory layout
Sybase support for OLE DB and ODBC
PC-Client product descriptions and directory layout
Separately installable PC-Client products
Installing Adaptive Server
Contents
Preinstallation 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
Preinstallation tasks
Installing server components
Installation methods
Installing server components in GUI mode
Installing version 15.0.3 over an existing 15.x Adaptive Server
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.3 binary overlay
Upgrading an Adaptive Server configured with high availability
Monitoring and Diagnostic (MDA) tables
New Monitoring and Diagnostic tables in Adaptive Server 15.0.3
Postinstallation Tasks
Verifying that servers are running
Verifying your connection to the servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
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
Testing the Sybase Central installation
Upgrading Adaptive Server
Overview
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
Enabling PCI in Adaptive Server
Upgrading to Adaptive Server 15.0.3
Using sqlupgrade
Using sqlupgraderes
Resource file attributes for upgrading Adaptive Server
Upgrading using sqlupgraderes
Post-upgrade tasks
Installing 15.0.3 stored procedures after upgrade
Running the instmsgs.ebf script
Restoring functionality in Adaptive Server
Reenabling Replication Server after the dataserver upgrade
Removing old log records
Restoring Replication on destination databases
Restoring replication on primary databases
Reenabling auditing
Special considerations for threshold procedures for audit segments
Shutting down SySAM servers
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Java in database
Enabling Java in database feature in a high availability system
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading high availability
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Migrating from 32-bit to 64-bit versions on different computers
Upgrading using allrows_dss in parallel
Recovering from a failed upgrade
If you downgraded back to original installation after upgrading to 15.0.3
Downgrading from Adaptive Server 15.0.3
Downgrading from 15.0.3 release
Basic downgrade steps
Post-downgrade tasks
Component Integration Services compatibility
System stored procedures
System messages
Unrecognized tokens or objects
System tables
Configuration parameters
Keywords
Reenabling Replication activities
Additional steps required if you used new features
Downgrading Adaptive Server with replicated databases
Downgrading Job Scheduler
Returning to Adaptive Server version 15.0.3
If you downgraded back to original installation after upgrading to 15.0.3
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 or DVD from the drive
DISPLAY environment variable not set correctly
Client not authorized to connect to server
Address already in use
Adaptive Server fails to start
The installer fails to start
Cannot start XP Server
Stopping Adaptive Server after a failure
Recovering from a failed installation
If installation fails after files are created
Troubleshooting resource file installations
If Adaptive Server fails the pre-upgrade eligibility test
Recovering from a failed upgrade
Restoring from backup
Re-running the upgrade
If the cause of the failure is known
If the cause of the failure is unknown
Upgrading compiled objects with dbcc upgrade_object
Finding compiled object errors before production
Reserved word errors
Missing, truncated, or corrupted source text
Quoted identifier errors
Temporary table references
select * potential problem areas
Using dbcc upgrade_object
Increasing the log segment size
Error reporting
Using database dumps in upgrades
Upgrading using dump and load
Upgrading compiled objects in database dumps
Determining whether a compiled object has been upgraded
Removing Adaptive Server
Uninstalling Adaptive Server 15.0.3
Removing an existing Adaptive Server
Alternative Installation Methods
Installation on consoles (non-GUI mode)
Silent installation
Configuring servers using resource files
Configuring from a resource file
Editing the sample resource file
Editing a resource file created by srvbuild
Resource file attributes for Adaptive Server
Resource file attributes for Backup Server
Using srvbuildres
Installer Changes from Adaptive Server 12.5.4 to Adaptive Server 15.0.3
Installer response file change
Directory changes
Impacted directories
Upgrading Servers with Replicated Databases
Overview
Suspending transaction processing and replication activities
Draining the transaction logs for primary databases
Draining the RSSD transaction log
Disabling the secondary truncation point
Using sybsystemprocs
Introduction
Increasing the size of the sybsystemprocs database
Increasing device and database capacity for system procedures
Installation Guide for IBM AIX
About this book
Before You Start
Adaptive Server Enterprise architecture
Backup Server
Stored procedures
The client
Adaptive Server editions
Overview of installation steps
System requirements
Operating system patches for IBM
Adaptive Server product descriptions and directory layout
Sybase support for OLE DB and ODBC
PC-Client product descriptions and directory layout
Separately installable PC-Client products
Installing Adaptive Server
Contents
Preinstallation 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
Preinstallation tasks
Installing server components
Installation methods
Installing server components in GUI mode
Installing version 15.0.3 over an existing 15.x Adaptive Server
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.3 binary overlay
Upgrading an Adaptive Server configured with high availability
Monitoring and Diagnostic (MDA) tables
New Monitoring and Diagnostic tables in Adaptive Server 15.0.3
Postinstallation Tasks
Verifying that servers are running
Verifying your connection to the servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
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
Testing the Sybase Central installation
Upgrading Adaptive Server
Overview
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
Enabling PCI in Adaptive Server
Upgrading to Adaptive Server 15.0.3
Using sqlupgrade
Using sqlupgraderes
Resource file attributes for upgrading Adaptive Server
Upgrading using sqlupgraderes
Post-upgrade tasks
Installing 15.0.3 stored procedures after upgrade
Running the instmsgs.ebf script
Restoring functionality in Adaptive Server
Reenabling Replication Server after the dataserver upgrade
Removing old log records
Restoring Replication on destination databases
Restoring replication on primary databases
Reenabling auditing
Special considerations for threshold procedures for audit segments
Shutting down SySAM servers
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Java in database
Enabling Java in database feature in a high availability system
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading high availability
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Migrating from 32-bit to 64-bit versions on different computers
Upgrading using allrows_dss in parallel
Recovering from a failed upgrade
If you downgraded back to original installation after upgrading to 15.0.3
Downgrading from Adaptive Server 15.0.3
Downgrading from 15.0.3 release
Basic downgrade steps
Post-downgrade tasks
Component Integration Services compatibility
System stored procedures
System messages
Unrecognized tokens or objects
System tables
Configuration parameters
Keywords
Reenabling Replication activities
Additional steps required if you used new features
Downgrading Adaptive Server with replicated databases
Downgrading Job Scheduler
Returning to Adaptive Server version 15.0.3
If you downgraded back to original installation after upgrading to 15.0.3
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 or DVD from the drive
DISPLAY environment variable not set correctly
Client not authorized to connect to server
Address already in use
Adaptive Server fails to start
The installer fails to start
Cannot start XP Server
Configuration failed
Stopping Adaptive Server after a failure
Recovering from a failed installation
If installation fails after files are created
Troubleshooting resource file installations
If Adaptive Server fails the pre-upgrade eligibility test
Recovering from a failed upgrade
Restoring from backup
Re-running the upgrade
If the cause of the failure is known
If the cause of the failure is unknown
Upgrading compiled objects with dbcc upgrade_object
Finding compiled object errors before production
Reserved word errors
Missing, truncated, or corrupted source text
Quoted identifier errors
Temporary table references
select * potential problem areas
Using dbcc upgrade_object
Increasing the log segment size
Error reporting
Using database dumps in upgrades
Upgrading using dump and load
Upgrading compiled objects in database dumps
Determining whether a compiled object has been upgraded
Removing Adaptive Server
Uninstalling Adaptive Server 15.0.3
Removing an existing Adaptive Server
Alternative Installation Methods
Installation on consoles (non-GUI mode)
Silent installation
Configuring servers using resource files
Configuring from a resource file
Editing the sample resource file
Editing a resource file created by srvbuild
Resource file attributes for Adaptive Server
Resource file attributes for Backup Server
Using srvbuildres
Installer Changes from Adaptive Server 12.5.4 to Adaptive Server 15.0.3
Installer response file change
Directory changes
Impacted directories
Upgrading Servers with Replicated Databases
Overview
Suspending transaction processing and replication activities
Draining the transaction logs for primary databases
Draining the RSSD transaction log
Disabling the secondary truncation point
Using sybsystemprocs
Introduction
Increasing the size of the sybsystemprocs database
Increasing device and database capacity for system procedures
Installation Guide for Linux
About this book
Before You Start
Adaptive Server Enterprise architecture
Backup Server
Stored procedures
The client
Adaptive Server editions
Overview of installation steps
System requirements
Operating system patches for Linux
Large memory support and POSIX Asynchronous I/O
Adaptive Server product descriptions and directory layout
Sybase support for OLE DB and ODBC
PC-Client product descriptions and directory layout
Separately installable PC-Client products
Installing Adaptive Server
Contents
Preinstallation 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
Preinstallation tasks
Installing server components
Installation methods
Installing server components in GUI mode
Installing version 15.0.3 over an existing 15.x Adaptive Server
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.3 binary overlay
Upgrading an Adaptive Server configured with high availability
Monitoring and Diagnostic (MDA) tables
New Monitoring and Diagnostic tables in Adaptive Server 15.0.3
Postinstallation Tasks
Verifying that servers are running
Verifying your connection to the servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
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
Testing the Sybase Central installation
Upgrading Adaptive Server
Overview
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
Enabling PCI in Adaptive Server
Upgrading to Adaptive Server 15.0.3
Using sqlupgrade
Using sqlupgraderes
Resource file attributes for upgrading Adaptive Server
Upgrading using sqlupgraderes
Post-upgrade tasks
Installing 15.0.3 stored procedures after upgrade
Running the instmsgs.ebf script
Restoring functionality in Adaptive Server
Reenabling Replication Server after the dataserver upgrade
Removing old log records
Restoring Replication on destination databases
Restoring replication on primary databases
Reenabling auditing
Special considerations for threshold procedures for audit segments
Shutting down SySAM servers
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Java in database
Enabling Java in database feature in a high availability system
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading high availability
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading compiled objects
Migrating from 32-bit to 64-bit versions on different computers
Upgrading using allrows_dss in parallel
Upgrading compiled objects
Recovering from a failed upgrade
If you downgraded back to original installation after upgrading to 15.0.3
Downgrading from Adaptive Server 15.0.3
Downgrading from 15.0.3 release
Basic downgrade steps
Post-downgrade tasks
Component Integration Services compatibility
System stored procedures
System messages
Unrecognized tokens or objects
System tables
Configuration parameters
Keywords
Reenabling Replication activities
Additional steps required if you used new features
Downgrading Adaptive Server with replicated databases
Downgrading Job Scheduler
Returning to Adaptive Server version 15.0.3
If you downgraded back to original installation after upgrading to 15.0.3
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 or DVD from the drive
DISPLAY environment variable not set correctly
Client not authorized to connect to server
Address already in use
Adaptive Server fails to start
The installer fails to start
Cannot start XP Server
Stopping Adaptive Server after a failure
Recovering from a failed installation
If installation fails after files are created
Troubleshooting resource file installations
If Adaptive Server fails the pre-upgrade eligibility test
Recovering from a failed upgrade
Restoring from backup
Re-running the upgrade
If the cause of the failure is known
If the cause of the failure is unknown
Upgrading compiled objects with dbcc upgrade_object
Finding compiled object errors before production
Reserved word errors
Missing, truncated, or corrupted source text
Quoted identifier errors
Temporary table references
select * potential problem areas
Using dbcc upgrade_object
Increasing the log segment size
Error reporting
Using database dumps in upgrades
Upgrading using dump and load
Upgrading compiled objects in database dumps
Determining whether a compiled object has been upgraded
Removing Adaptive Server
Uninstalling Adaptive Server 15.0.3
Removing an existing Adaptive Server
Alternative Installation Methods
Installation on consoles (non-GUI mode)
Silent installation
Configuring servers using resource files
Configuring from a resource file
Editing the sample resource file
Editing a resource file created by srvbuild
Resource file attributes for Adaptive Server
Resource file attributes for Backup Server
Using srvbuildres
Installer Changes from Adaptive Server 12.5.4 to Adaptive Server 15.0.3
Installer response file change
Directory changes
Impacted directories
Creating Raw Partitions
Overview
Creating the partitions
Red Hat Raw device administration
SuSE raw device administration
Accessing raw devices from Adaptive Sever
Upgrading Servers with Replicated Databases
Overview
Suspending transaction processing and replication activities
Draining the transaction logs for primary databases
Draining the RSSD transaction log
Disabling the secondary truncation point
Using sybsystemprocs
Introduction
Increasing the size of the sybsystemprocs database
Increasing device and database capacity for system procedures
Quick Installation Guide
Installation Workflows
Adaptive Server Editions
Express Edition
Developer Edition
Enterprise Edition Evaluation
Planning Your Installation
System Requirements for Servers
System Requirements for Clients
Preinstallation tasks
Preinstallation for a New Installation
Preinstallation for an Overlay Installation
Installing the Server
Installing the Server with the Sybase Installer
Installing from the Command Line
Installing in Unattended Mode
Uninstalling
Postinstallation
Preinstallation for an Overlay Installation
installmaster script
installcommit script
installsecurity script
instmsgs.ebf script
installjsdb script
Upgrading Job Scheduler Templates
installmontables script
installpcidb script
Reverting to the previously installed release
Configuration tasks
Changing default character set, sort order or language
Changing the default language
Changing defaults
Obtaining Help and Additional Information
Installation Guide for Sun Solaris
About this book
Before You Start
Adaptive Server Enterprise architecture
Backup Server
Stored procedures
The client
Adaptive Server editions
Overview of installation steps
System requirements
Operating system patches for Sun Solaris
Adaptive Server product descriptions and directory layout
Sybase support for OLE DB and ODBC
PC-Client product descriptions and directory layout
Separately installable PC-Client products
Installing Adaptive Server
Contents
Preinstallation 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
Preinstallation tasks
Installing server components
Installation methods
Installing server components in GUI mode
Installing version 15.0.3 over an existing 15.x Adaptive Server
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.3 binary overlay
Upgrading an Adaptive Server configured with high availability
Monitoring and Diagnostic (MDA) tables
New Monitoring and Diagnostic tables in Adaptive Server 15.0.3
Postinstallation Tasks
Verifying that servers are running
Verifying your connection to the servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
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
Testing the Sybase Central installation
Upgrading Adaptive Server
Overview
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
Enabling PCI in Adaptive Server
Upgrading to Adaptive Server 15.0.3
Using sqlupgrade
Using sqlupgraderes
Resource file attributes for upgrading Adaptive Server
Upgrading using sqlupgraderes
Post-upgrade tasks
Installing 15.0.3 stored procedures after upgrade
Running the instmsgs.ebf script
Restoring functionality in Adaptive Server
Reenabling Replication Server after the dataserver upgrade
Removing old log records
Restoring Replication on destination databases
Restoring replication on primary databases
Reenabling auditing
Special considerations for threshold procedures for audit segments
Shutting down SySAM servers
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Java in database
Enabling Java in database feature in a high availability system
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading high availability
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Migrating from 32-bit to 64-bit versions on different computers
Upgrading using allrows_dss in parallel
Recovering from a failed upgrade
If you downgraded back to original installation after upgrading to 15.0.3
Downgrading from Adaptive Server 15.0.3
Downgrading from 15.0.3 release
Basic downgrade steps
Post-downgrade tasks
Component Integration Services compatibility
System stored procedures
System messages
Unrecognized tokens or objects
System tables
Configuration parameters
Keywords
Reenabling Replication activities
Additional steps required if you used new features
Downgrading Adaptive Server with replicated databases
Downgrading Job Scheduler
Returning to Adaptive Server version 15.0.3
If you downgraded back to original installation after upgrading to 15.0.3
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 or DVD from the drive
DISPLAY environment variable not set correctly
Client not authorized to connect to server
Address already in use
Adaptive Server fails to start
The installer fails to start
Cannot start XP Server
Configuration failed
Stopping Adaptive Server after a failure
Recovering from a failed installation
If installation fails after files are created
Troubleshooting resource file installations
If Adaptive Server fails the pre-upgrade eligibility test
Recovering from a failed upgrade
Restoring from backup
Re-running the upgrade
If the cause of the failure is known
If the cause of the failure is unknown
Upgrading compiled objects with dbcc upgrade_object
Finding compiled object errors before production
Reserved word errors
Missing, truncated, or corrupted source text
Quoted identifier errors
Temporary table references
select * potential problem areas
Using dbcc upgrade_object
Increasing the log segment size
Error reporting
Using database dumps in upgrades
Upgrading using dump and load
Upgrading compiled objects in database dumps
Determining whether a compiled object has been upgraded
Removing Adaptive Server
Uninstalling Adaptive Server 15.0.3
Removing an existing Adaptive Server
Alternative Installation Methods
Installation on consoles (non-GUI mode)
Silent installation
Configuring servers using resource files
Configuring from a resource file
Editing the sample resource file
Editing a resource file created by srvbuild
Resource file attributes for Adaptive Server
Resource file attributes for Backup Server
Using srvbuildres
Installer Changes from Adaptive Server 12.5.4 to Adaptive Server 15.0.3
Installer response file change
Directory changes
Impacted directories
Upgrading Servers with Replicated Databases
Overview
Suspending transaction processing and replication activities
Draining the transaction logs for primary databases
Draining the RSSD transaction log
Disabling the secondary truncation point
Using sybsystemprocs
Introduction
Increasing the size of the sybsystemprocs database
Increasing device and database capacity for system procedures
Installation Guide for Windows
About this book
Before You Start
Adaptive Server Enterprise architecture
Backup Server
Stored procedures
The client
Adaptive Server editions
Overview of installation steps
System requirements
Operating system patches required for Windows
Memory requirements
Java in database feature
Upgrading Windows to 3GB
Adaptive Server product descriptions and directory layout
Sybase support for OLE DB and ODBC
PC-Client product descriptions and directory layout
Separately installable PC-Client products
Installing Adaptive Server
Contents
Preinstallation 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
Preinstallation tasks
Installing server components
Installation methods
Installing server components in GUI mode
Installing version 15.0.3 over an existing 15.x Adaptive Server
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.3 binary overlay
Upgrading an Adaptive Server configured with high availability
Monitoring and Diagnostic (MDA) tables
New Monitoring and Diagnostic tables in Adaptive Server 15.0.3
Postinstallation Tasks
Post installation instructions
Verifying that servers are running
Verifying your connection to the servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
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
System catalog changes during upgrade
Pre-upgrade tasks
Checking system and upgrade requirements
Noting server and device names and locations
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
Enabling PCI in Adaptive Server
Upgrading to Adaptive Server 15.0.3
Upgrading the server
Testing the Adaptive Server upgrade
Post-upgrade tasks
Installing 15.0.3 stored procedures after upgrade
Running the instmsgs.ebf script
Restoring functionality in Adaptive Server
Reenabling Replication Server after the dataserver upgrade
Removing old log records
Restoring Replication on destination databases
Restoring replication on primary databases
Reenabling auditing
Special considerations for threshold procedures for audit segments
Shutting down SySAM servers
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Java in database
Enabling Java in database feature in a high availability system
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading high availability
Upgrading High Availability and cluster support
Upgrading the cluster subsystem
Upgrading using allrows_dss in parallel
Recovering from a failed upgrade
If you downgraded back to original installation after upgrading to 15.0.3
Downgrading from Adaptive Server 15.0.3
Downgrading from 15.0.3 release
Basic downgrade steps
Post-downgrade tasks
Component Integration Services compatibility
System stored procedures
System messages
Unrecognized tokens or objects
System tables
Configuration parameters
Keywords
Reenabling Replication activities
Additional steps required if you used new features
Downgrading Adaptive Server with replicated databases
Downgrading Job Scheduler
Returning to Adaptive Server version 15.0.3
If you downgraded back to original installation after upgrading to 15.0.3
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
Adaptive Server fails to start
The installer fails to start
Stopping Adaptive Server after a failure
Recovering from a failed installation
If installation fails after files are created
If Adaptive Server fails the pre-upgrade eligibility test
Recovering from a failed upgrade
Restoring from backup
Re-running the upgrade
If the cause of the failure is known
If the cause of the failure is unknown
Upgrading compiled objects with dbcc upgrade_object
Finding compiled object errors before production
Reserved word errors
Missing, truncated, or corrupted source text
Quoted identifier errors
Temporary table references
select * potential problem areas
Using dbcc upgrade_object
Increasing the log segment size
Error reporting
Using database dumps in upgrades
Upgrading using dump and load
Upgrading compiled objects in database dumps
Determining whether a compiled object has been upgraded
Removing Adaptive Server
Uninstalling Adaptive Server 15.0.3
Removing an old server
Alternative Installation Methods
Installation on consoles (non-GUI mode)
Silent installation
Configuring servers using resource files
Configuring from a resource file
Editing the sample resource file
Resource file variables
Running the sybatch utility
Installer Changes from Adaptive Server 12.5.4 to Adaptive Server 15.0.3
Installer response file change
Directory changes
Impacted directories
Upgrading Servers with Replicated Databases
Overview
Suspending transaction processing and replication activities
Draining the transaction logs for primary databases
Draining the RSSD transaction log
Disabling the secondary truncation point
Using sybsystemprocs
Introduction
Increasing the size of the sybsystemprocs database
Increasing device and database capacity for system procedures
Installation Guide Adaptive Server Enterprise Cluster Edition for HP-UX
Adaptive Server Enterprise Cluster Edition Overview
Options for Adaptive Server Editions
Installation Workflows
Style Conventions
Server Component Descriptions and Directory Layout
PC-Client Product Descriptions and Directory Layout
Separately Installable PC-Client Products
Planning the Installation
Obtaining a License
Accessing SPDC
Generating a License at SPDC
Generating a Served License
Generating an Unserved License
System Requirements for Servers
System Requirements for Using Private Interconnect Technology
System Requirements for Clients
Preinstallation tasks for the Server Installation
Adjusting the Operating System Shared Memory Parameters
Obtaining Your Host ID
Installing the Server
Installing the Server With the Installer
Installing From the Command Line
Installing Server in Unattended (silent) Mode
Writing Out a Template File
Uninstalling the Cluster Server
Uninstalling an Existing Adaptive Server
Creating and Starting the Cluster
Overview of the Basic Configuration Steps
Overview of a Shared Installation
Overview of a Private Installation
Before you Begin
Creating a Simulated Cluster on a Single Node
Setting the Environment and Starting the Unified Agents
Shutting Down the Unified Agent
About Creating a Cluster
Worksheet for Creating a Cluster
Creating a Cluster Using ASE Plug-in
Starting and Stopping Sybase Central
Registering the Adaptive Server Plug-in
Adding an Instance to a Cluster
Adding Logical Clusters
Connecting to a Cluster
Changing Server Discovery Settings
Creating a Cluster Using sybcluster
Configuring the Cluster
Verifying the Cluster Configuration
Starting and Stopping a Cluster Using sybcluster
Starting the Cluster When the Operating System Starts
Cleaning up After Failed Installation
Auxiliary Servers
Configuring Backup Server Using sybcluster
Configuring Backup Server Using ASE Plug-in
Installing Job Scheduler
Configuring XP Server Using sybcluster
Configuring Monitor Server Using Sybcluster
Postinstallation Tasks
Setting the System Administrator Password
Installing Sample Databases
Default Devices for Sample Databases
Running the Database Scripts
Installing the Interpubs Database
Installing the Jpubs Database
Maintaining Sample Databases
PC-Client Overview
Installing the Client
Installing the Client in Unattended (Silent) Mode
Getting Started After Installing
Creating a Testing Environment
Configuring libtcl.cfg for LDAP
Using a Directory Service
Adding a Server to the Interfaces File
Upgrading the Server
Preupgrade Tasks
Statistics in System Tables
System Catalog Changes During Upgrade
Checking System and Upgrade Requirements
Checking the runserver File Location
Procedure text is required For Upgrade
Reserved Words
Addressing Reserved Words Conflicts
Using Quoted Identifiers
Running a Reserved Word Check
Manually Upgrade Overview
Manually Upgrading the Old Server
Preparing the Database and Devices for the Upgrade
Increasing Default Database Sizes
Upgrading the Server Using ASE Plug-in
Upgrading the Old Server with ASE Plug-in
Upgrading the Server Using sybcluster
Verifying the Server for Upgrade
Upgrading the Old Server Using an Input File
Upgrading the Old Server Interactively
Postupgrade Tasks
Deploying a Cluster Agent Server
Recovering From a Failed Upgrade
Upgrading Java in Database
Migrating
Migrating From Version 15.0.x or Earlier Version Using BCP
Migrating a High Availability-Configured Server
Downgrading
Basic Downgrade Steps
Postdowngrade Tasks
Additional Steps If You Used 15.0.3 Cluster Edition Features Before Downgrading
Downgrading Job Scheduler
I/O Fencing
Enabling I/O Fencing
Setting Up I/O Fencing
Troubleshoot SySAM
Where to Look For SySAM Related Errors
Troubleshooting SySAM
Enabling and Changing E-mail Notifications
Calling Sybase Technical Support
Troubleshoot the Server
Error Log Locations
Logs For Installation Utilities
Logs For Sybase Servers
Solutions to Common Installation Problems
If the Configuration Fails
Stopping the Server After a failure
Troubleshooting Resource File Installations
If Adaptive Server Fails the Pre-upgrade Eligibility Test
Recovering From a Failed Installation or After the Files are Created
Recovering From a Failed Upgrade
Re-running the Upgrade
If the Cause of the Failure is Known
Upgrading compiled objects with dbcc upgrade_object
Determining whether a compiled Object Has Been Upgraded
Finding compiled object errors Before Production
Reserved Word Errors
Missing, Truncated, or Corrupted Source Text
Quoted Identifier Errors
Temporary table references
select * Potential Problem Areas
Determining Whether select * Should Be Changed in Views
Using dbcc upgrade_object
Syntax
Parameters
Permissions
Increasing the log segment size
Error reporting
Examples
Using Database Dumps in Upgrades
Upgrading Compiled Objects in Database Dumps
Manually Setting Up and Managing the Cluster
Before You Begin
Setting the Environment
Creating the Raw Devices
Configuring the Cluster Manually
Create The Cluster Input File
Configuring the Interfaces File
Building the Master and Quorum Devices
Initializing and Creating sybsystemprocs
Installing the System Stored Procedures
Creating Runserver Files
Setting Up Local System and Temporary Databases
Configuring the Cluster for Automatic Takeover
Starting the Cluster
Starting the Cluster After a System Failure
Postconfiguration Tasks
Shutting Down the Cluster or the Instance
Shutting Down an Instance
Reconfiguring the Cluster
Enabling Sybcluster and the Plug-in After a Manual Configuration
A sybcluster Sample Session
Configuration Values
Sample Session
Configuring the Cluster Using an Input File
Upgrading Servers With Replicated Databases
Determining If Existing Servers Contain Replicated Databases
Suspending Transaction Processing and Replication Activities
Draining the Transaction Logs for Primary Databases
Draining the RSSD Transaction Log
Disabling the Secondary Truncation Point
Using sybsystemprocs
Increasing the Size of the sybsystemprocs Database
Increasing Device and Database Capacity for System Procedures
Obtaining Help and Additional Information
Installation Guide Adaptive Server Enterprise Cluster Edition for IBM AIX
Adaptive Server Enterprise Cluster Edition Overview
Options for Adaptive Server Editions
Installation Workflows
Style Conventions
Server Component Descriptions and Directory Layout
PC-Client Product Descriptions and Directory Layout
Separately Installable PC-Client Products
Planning the Installation
Obtaining a License
Accessing SPDC
Generating a License at SPDC
Generating a Served License
Generating an Unserved License
System Requirements for Servers
System Requirements for Using Private Interconnect Technology
System Requirements for Clients
Preinstallation tasks for the Server Installation
Adjusting the Operating System Shared Memory Parameters
Obtaining Your Host ID
Installing the Server
Installing the Server With the Installer
Installing From the Command Line
Installing Server in Unattended (silent) Mode
Writing Out a Template File
Uninstalling the Cluster Server
Uninstalling an Existing Adaptive Server
Creating and Starting the Cluster
Overview of the Basic Configuration Steps
Overview of a Shared Installation
Overview of a Private Installation
Before you Begin
Creating a Simulated Cluster on a Single Node
Setting the Environment and Starting the Unified Agents
Shutting Down the Unified Agent
About Creating a Cluster
Worksheet for Creating a Cluster
Creating a Cluster Using ASE Plug-in
Starting and Stopping Sybase Central
Registering the Adaptive Server Plug-in
Adding an Instance to a Cluster
Adding Logical Clusters
Connecting to a Cluster
Changing Server Discovery Settings
Creating a Cluster Using sybcluster
Configuring the Cluster
Verifying the Cluster Configuration
Starting and Stopping a Cluster Using sybcluster
Starting the Cluster When the Operating System Starts
Cleaning up After Failed Installation
Auxiliary Servers
Configuring Backup Server Using sybcluster
Configuring Backup Server Using ASE Plug-in
Installing Job Scheduler
Configuring XP Server Using sybcluster
Configuring Monitor Server Using Sybcluster
Postinstallation Tasks
Setting the System Administrator Password
Installing Sample Databases
Default Devices for Sample Databases
Running the Database Scripts
Installing the Interpubs Database
Installing the Jpubs Database
Maintaining Sample Databases
PC-Client Overview
Installing the Client
Installing the Client in Unattended (Silent) Mode
Getting Started After Installing
Creating a Testing Environment
Configuring libtcl.cfg for LDAP
Using a Directory Service
Adding a Server to the Interfaces File
Upgrading the Server
Preupgrade Tasks
Statistics in System Tables
System Catalog Changes During Upgrade
Checking System and Upgrade Requirements
Checking the runserver File Location
Procedure text is required For Upgrade
Reserved Words
Addressing Reserved Words Conflicts
Using Quoted Identifiers
Running a Reserved Word Check
Manually Upgrade Overview
Manually Upgrading the Old Server
Preparing the Database and Devices for the Upgrade
Increasing Default Database Sizes
Upgrading the Server Using ASE Plug-in
Upgrading the Old Server with ASE Plug-in
Upgrading the Server Using sybcluster
Verifying the Server for Upgrade
Upgrading the Old Server Using an Input File
Upgrading the Old Server Interactively
Postupgrade Tasks
Deploying a Cluster Agent Server
Recovering From a Failed Upgrade
Upgrading Java in Database
Migrating
Migrating From Version 15.0.x or Earlier Version Using BCP
Migrating a High Availability-Configured Server
Downgrading
Basic Downgrade Steps
Postdowngrade Tasks
Additional Steps If You Used 15.0.3 Cluster Edition Features Before Downgrading
Downgrading Job Scheduler
I/O Fencing
Enabling I/O Fencing
Setting Up I/O Fencing
Setting Up Raw Disks For Multi-node Access and I/O Fencing
Troubleshoot SySAM
Where to Look For SySAM Related Errors
Troubleshooting SySAM
Enabling and Changing E-mail Notifications
Calling Sybase Technical Support
Troubleshoot the Server
Error Log Locations
Logs For Installation Utilities
Logs For Sybase Servers
Solutions to Common Installation Problems
If the Configuration Fails
Stopping the Server After a failure
Troubleshooting Resource File Installations
If Adaptive Server Fails the Pre-upgrade Eligibility Test
Recovering From a Failed Installation or After the Files are Created
Recovering From a Failed Upgrade
Re-running the Upgrade
If the Cause of the Failure is Known
Upgrading compiled objects with dbcc upgrade_object
Determining whether a compiled Object Has Been Upgraded
Finding compiled object errors Before Production
Reserved Word Errors
Missing, Truncated, or Corrupted Source Text
Quoted Identifier Errors
Temporary table references
select * Potential Problem Areas
Determining Whether select * Should Be Changed in Views
Using dbcc upgrade_object
Syntax
Parameters
Permissions
Increasing the log segment size
Error reporting
Examples
Using Database Dumps in Upgrades
Upgrading Compiled Objects in Database Dumps
Manually Setting Up and Managing the Cluster
Before You Begin
Setting the Environment
Creating the Raw Devices
Configuring the Cluster Manually
Create The Cluster Input File
Configuring the Interfaces File
Building the Master and Quorum Devices
Initializing and Creating sybsystemprocs
Installing the System Stored Procedures
Creating Runserver Files
Setting Up Local System and Temporary Databases
Configuring the Cluster for Automatic Takeover
Starting the Cluster
Starting the Cluster After a System Failure
Postconfiguration Tasks
Shutting Down the Cluster or the Instance
Shutting Down an Instance
Reconfiguring the Cluster
Enabling Sybcluster and the Plug-in After a Manual Configuration
A sybcluster Sample Session
Configuration Values
Sample Session
Configuring the Cluster Using an Input File
Upgrading Servers With Replicated Databases
Determining If Existing Servers Contain Replicated Databases
Suspending Transaction Processing and Replication Activities
Draining the Transaction Logs for Primary Databases
Draining the RSSD Transaction Log
Disabling the Secondary Truncation Point
Using sybsystemprocs
Increasing the Size of the sybsystemprocs Database
Increasing Device and Database Capacity for System Procedures
Obtaining Help and Additional Information
Installation Guide Adaptive Server Enterprise Cluster Edition for Linux
Adaptive Server Enterprise Cluster Edition Overview
Options for Adaptive Server Editions
Installation Workflows
Style Conventions
Server Component Descriptions and Directory Layout
PC-Client Product Descriptions and Directory Layout
Separately Installable PC-Client Products
Planning the Installation
Obtaining a License
Accessing SPDC
Generating a License at SPDC
Generating a Served License
Generating an Unserved License
System Requirements for Servers
System Requirements for Using Private Interconnect Technology
System Requirements for Clients
Preinstallation tasks for the Server Installation
Adjusting the Operating System Shared Memory Parameters
Obtaining Your Host ID
Installing the Server
Installing the Server With the Installer
Installing From the Command Line
Installing Server in Unattended (silent) Mode
Writing Out a Template File
Uninstalling the Cluster Server
Uninstalling an Existing Adaptive Server
Creating and Starting the Cluster
Overview of the Basic Configuration Steps
Overview of a Shared Installation
Overview of a Private Installation
Before you Begin
Creating a Simulated Cluster on a Single Node
Setting the Environment and Starting the Unified Agents
Shutting Down the Unified Agent
About Creating a Cluster
Worksheet for Creating a Cluster
Creating a Cluster Using ASE Plug-in
Starting and Stopping Sybase Central
Registering the Adaptive Server Plug-in
Adding an Instance to a Cluster
Adding Logical Clusters
Connecting to a Cluster
Changing Server Discovery Settings
Creating a Cluster Using sybcluster
Configuring the Cluster
Verifying the Cluster Configuration
Starting and Stopping a Cluster Using sybcluster
Starting the Cluster When the Operating System Starts
Cleaning up After Failed Installation
Auxiliary Servers
Configuring Backup Server Using sybcluster
Configuring Backup Server Using ASE Plug-in
Installing Job Scheduler
Configuring XP Server Using sybcluster
Configuring Monitor Server Using Sybcluster
Postinstallation Tasks
Setting the System Administrator Password
Installing Sample Databases
Default Devices for Sample Databases
Running the Database Scripts
Installing the Interpubs Database
Installing the Jpubs Database
Maintaining Sample Databases
PC-Client Overview
Installing the Client
Installing the Client in Unattended (Silent) Mode
Getting Started After Installing
Creating a Testing Environment
Configuring libtcl.cfg for LDAP
Using a Directory Service
Adding a Server to the Interfaces File
Upgrading the Server
Preupgrade Tasks
Statistics in System Tables
System Catalog Changes During Upgrade
Checking System and Upgrade Requirements
Checking the runserver File Location
Procedure text is required For Upgrade
Reserved Words
Addressing Reserved Words Conflicts
Using Quoted Identifiers
Running a Reserved Word Check
Manually Upgrade Overview
Manually Upgrading the Old Server
Preparing the Database and Devices for the Upgrade
Increasing Default Database Sizes
Upgrading the Server Using ASE Plug-in
Upgrading the Old Server with ASE Plug-in
Upgrading the Server Using sybcluster
Verifying the Server for Upgrade
Upgrading the Old Server Using an Input File
Upgrading the Old Server Interactively
Postupgrade Tasks
Deploying a Cluster Agent Server
Recovering From a Failed Upgrade
Upgrading Java in Database
Migrating
Migrating From Version 15.0.x or Earlier Version Using BCP
Migrating a High Availability-Configured Server
Downgrading
Basic Downgrade Steps
Postdowngrade Tasks
Additional Steps If You Used 15.0.3 Cluster Edition Features Before Downgrading
Downgrading Job Scheduler
I/O Fencing
Enabling I/O Fencing
Setting Up I/O Fencing
Troubleshoot SySAM
Where to Look For SySAM Related Errors
Troubleshooting SySAM
Enabling and Changing E-mail Notifications
Calling Sybase Technical Support
Troubleshoot the Server
Error Log Locations
Logs For Installation Utilities
Logs For Sybase Servers
Solutions to Common Installation Problems
If the Configuration Fails
Stopping the Server After a failure
Troubleshooting Resource File Installations
If Adaptive Server Fails the Pre-upgrade Eligibility Test
Recovering From a Failed Installation or After the Files are Created
Recovering From a Failed Upgrade
Re-running the Upgrade
If the Cause of the Failure is Known
Upgrading compiled objects with dbcc upgrade_object
Determining whether a compiled Object Has Been Upgraded
Finding compiled object errors Before Production
Reserved Word Errors
Missing, Truncated, or Corrupted Source Text
Quoted Identifier Errors
Temporary table references
select * Potential Problem Areas
Determining Whether select * Should Be Changed in Views
Using dbcc upgrade_object
Syntax
Parameters
Permissions
Increasing the log segment size
Error reporting
Examples
Using Database Dumps in Upgrades
Upgrading Compiled Objects in Database Dumps
Manually Setting Up and Managing the Cluster
Before You Begin
Setting the Environment
Creating the Raw Devices
Configuring the Cluster Manually
Create The Cluster Input File
Configuring the Interfaces File
Building the Master and Quorum Devices
Initializing and Creating sybsystemprocs
Installing the System Stored Procedures
Creating Runserver Files
Setting Up Local System and Temporary Databases
Configuring the Cluster for Automatic Takeover
Starting the Cluster
Starting the Cluster After a System Failure
Postconfiguration Tasks
Shutting Down the Cluster or the Instance
Shutting Down an Instance
Reconfiguring the Cluster
Enabling Sybcluster and the Plug-in After a Manual Configuration
A sybcluster Sample Session
Configuration Values
Sample Session
Configuring the Cluster Using an Input File
Raw Partitions on Linux
Choosing a Raw Partition
Creating Raw Partitions
Red Hat Raw Device Administration
SuSE Raw Device Administration
Accessing Raw Devices From the Server
Upgrading Servers With Replicated Databases
Determining If Existing Servers Contain Replicated Databases
Suspending Transaction Processing and Replication Activities
Draining the Transaction Logs for Primary Databases
Draining the RSSD Transaction Log
Disabling the Secondary Truncation Point
Using sybsystemprocs
Increasing the Size of the sybsystemprocs Database
Increasing Device and Database Capacity for System Procedures
Obtaining Help and Additional Information
Installation Guide Adaptive Server Enterprise Cluster Edition for Sun Solaris
Adaptive Server Enterprise Cluster Edition Overview
Options for Adaptive Server Editions
Installation Workflows
Style Conventions
Server Component Descriptions and Directory Layout
PC-Client Product Descriptions and Directory Layout
Separately Installable PC-Client Products
Planning the Installation
Obtaining a License
Accessing SPDC
Generating a License at SPDC
Generating a Served License
Generating an Unserved License
System Requirements for Servers
System Requirements for Using Private Interconnect Technology
System Requirements for Clients
Preinstallation tasks for the Server Installation
Adjusting the Operating System Shared Memory Parameters
Obtaining Your Host ID
Installing the Server
Installing the Server With the Installer
Installing From the Command Line
Installing Server in Unattended (silent) Mode
Writing Out a Template File
Uninstalling the Cluster Server
Uninstalling an Existing Adaptive Server
Creating and Starting the Cluster
Overview of the Basic Configuration Steps
Overview of a Shared Installation
Overview of a Private Installation
Before you Begin
Creating a Simulated Cluster on a Single Node
Setting the Environment and Starting the Unified Agents
Shutting Down the Unified Agent
About Creating a Cluster
Worksheet for Creating a Cluster
Creating a Cluster Using ASE Plug-in
Starting and Stopping Sybase Central
Registering the Adaptive Server Plug-in
Adding an Instance to a Cluster
Adding Logical Clusters
Connecting to a Cluster
Changing Server Discovery Settings
Creating a Cluster Using sybcluster
Configuring the Cluster
Verifying the Cluster Configuration
Starting and Stopping a Cluster Using sybcluster
Starting the Cluster When the Operating System Starts
Cleaning up After Failed Installation
Auxiliary Servers
Configuring Backup Server Using sybcluster
Configuring Backup Server Using ASE Plug-in
Installing Job Scheduler
Configuring XP Server Using sybcluster
Configuring Monitor Server Using Sybcluster
Postinstallation Tasks
Setting the System Administrator Password
Installing Sample Databases
Default Devices for Sample Databases
Running the Database Scripts
Installing the Interpubs Database
Installing the Jpubs Database
Maintaining Sample Databases
PC-Client Overview
Installing the Client
Installing the Client in Unattended (Silent) Mode
Getting Started After Installing
Creating a Testing Environment
Configuring libtcl.cfg for LDAP
Using a Directory Service
Adding a Server to the Interfaces File
Upgrading the Server
Preupgrade Tasks
Statistics in System Tables
System Catalog Changes During Upgrade
Checking System and Upgrade Requirements
Checking the runserver File Location
Procedure text is required For Upgrade
Reserved Words
Addressing Reserved Words Conflicts
Using Quoted Identifiers
Running a Reserved Word Check
Manually Upgrade Overview
Manually Upgrading the Old Server
Preparing the Database and Devices for the Upgrade
Increasing Default Database Sizes
Upgrading the Server Using ASE Plug-in
Upgrading the Old Server with ASE Plug-in
Upgrading the Server Using sybcluster
Verifying the Server for Upgrade
Upgrading the Old Server Using an Input File
Upgrading the Old Server Interactively
Postupgrade Tasks
Deploying a Cluster Agent Server
Recovering From a Failed Upgrade
Upgrading Java in Database
Migrating
Migrating From Version 15.0.x or Earlier Version Using BCP
Migrating a High Availability-Configured Server
Downgrading
Basic Downgrade Steps
Postdowngrade Tasks
Additional Steps If You Used 15.0.3 Cluster Edition Features Before Downgrading
Downgrading Job Scheduler
I/O Fencing
Enabling I/O Fencing
Setting Up I/O Fencing
Troubleshoot SySAM
Where to Look For SySAM Related Errors
Troubleshooting SySAM
Enabling and Changing E-mail Notifications
Calling Sybase Technical Support
Troubleshoot the Server
Error Log Locations
Logs For Installation Utilities
Logs For Sybase Servers
Solutions to Common Installation Problems
If the Configuration Fails
Stopping the Server After a failure
Troubleshooting Resource File Installations
If Adaptive Server Fails the Pre-upgrade Eligibility Test
Recovering From a Failed Installation or After the Files are Created
Recovering From a Failed Upgrade
Re-running the Upgrade
If the Cause of the Failure is Known
Upgrading compiled objects with dbcc upgrade_object
Determining whether a compiled Object Has Been Upgraded
Finding compiled object errors Before Production
Reserved Word Errors
Missing, Truncated, or Corrupted Source Text
Quoted Identifier Errors
Temporary table references
select * Potential Problem Areas
Determining Whether select * Should Be Changed in Views
Using dbcc upgrade_object
Syntax
Parameters
Permissions
Increasing the log segment size
Error reporting
Examples
Using Database Dumps in Upgrades
Upgrading Compiled Objects in Database Dumps
Manually Setting Up and Managing the Cluster
Before You Begin
Setting the Environment
Creating the Raw Devices
Configuring the Cluster Manually
Create The Cluster Input File
Configuring the Interfaces File
Building the Master and Quorum Devices
Initializing and Creating sybsystemprocs
Installing the System Stored Procedures
Creating Runserver Files
Setting Up Local System and Temporary Databases
Configuring the Cluster for Automatic Takeover
Starting the Cluster
Starting the Cluster After a System Failure
Postconfiguration Tasks
Shutting Down the Cluster or the Instance
Shutting Down an Instance
Reconfiguring the Cluster
Enabling Sybcluster and the Plug-in After a Manual Configuration
A sybcluster Sample Session
Configuration Values
Sample Session
Configuring the Cluster Using an Input File
Upgrading Servers With Replicated Databases
Determining If Existing Servers Contain Replicated Databases
Suspending Transaction Processing and Replication Activities
Draining the Transaction Logs for Primary Databases
Draining the RSSD Transaction Log
Disabling the Secondary Truncation Point
Using sybsystemprocs
Increasing the Size of the sybsystemprocs Database
Increasing Device and Database Capacity for System Procedures
Obtaining Help and Additional Information
Installation and Release Bulletin Enhanced Full-Text Search Specialty Data Store
Product Summary
Installing Enhanced Full-Text Search
Installing Enhanced Full-Text Search using Installer
Installing in a non-GUI mode
Postinstallation
Configuring EFTS on Windows
Known Issues
Configuration Guide for UNIX
About this book
Introduction
About Adaptive Server
System-specific issues
System user roles
Environment variables
Adaptive Server devices and system databases
The master device
The sybsystemdb device
The sysprocsdev device
Optional devices and databases
Using UNIX operating system files as database devices
Using the directio parameter
Using the dsync option
Determining the location, type, and size of a database device
For Solaris, HP-UX, IBM AIX, and Linux
For All Platforms
Client/server communication
Changing Adaptive Server configuration
Languages other than U.S. English
Adaptive Server specifications
Starting and Stopping Servers
Overview
Requirements for starting servers
Starting servers
Server start-up parameters
Changing start-up parameters
Using a RUN_server_name file
Using the startserver command
Using the monserver and backupserver commands
Starting servers when the operating system restarts
For HP-UX
For IBM RS/6000
For Sun Solaris and Linux
Starting XP Server after initial installation
Stopping servers
Stopping Adaptive Server
Stopping Backup Server
Stopping Monitor Server
Using the kill command
Shutdown and shared memory files
Configuring the Operating System
Verifying environment variables
Configuring new servers with srvbuild
Using the stty setting
Restoring correct permissions
File descriptors and user connections
For HP-UX
For AIX
For Linux
For Sun Solaris
Displaying current soft and hard limits
Increasing the soft limit
Increasing the hard limit
Sample program
Enabling asynchronous disk I/O
Adjusting the client connection timeout period
For HP-UX
For IBM RS/6000
For Sun Solaris
For Linux
Checking for hardware errors
For HP-UX
For IBM RS/6000
For Sun Solaris
For Linux
Monitoring the use of operating system resources
For HP-UX
For IBM RS/6000
For Sun Solaris and Linux
A sample C shell maintenance script
Adaptive Server Default Configuration
Default settings
Setting Up Communications Across the Network
How Adaptive Server determines which directory service entry to use
How a client uses directory services
Creating a directory services entry
Supported directory drivers
Contents of an interfaces file
Heterogeneous and homogeneous environments
Understanding the format of the interfaces file
Components of an interfaces file entry
Creating a master interfaces file
Using dsedit or dscp to create a master interfaces file
Using a text editor to create a master interfaces file
Configuring interfaces files for multiple networks
Configuring the server for multiple network handlers
Sample interfaces files for multiple network handlers
Configuring the client connections
Using one network-independent DSQUERY name
Using different DSQUERY names
Configuring for query port backup
IPv6 support
IPv6 infrastructure
Troubleshooting
Server fails to start
Error when executing an ESP
Using the Lightweight Directory Access Protocol as a Directory Service
Overview
LDAP directory services versus the Sybase interfaces file
The libtcl*.cfg file
Enabling LDAP directory services
Adding a server to the directory services
Multiple directory services
Encrypting the password
Performance
Migrating from the interfaces file to LDAP
Customizing Localization for Adaptive Server
Overview of localization support
Language modules
Default character sets for servers
Changing the default language and character set
Changing the default character set for servers
Supported character sets
Character set conversion
Conversions between server and client
Sort orders
Available sort orders
Language modules
Installing a new language module
Message languages
Localization
Localization directories
About the directory
About the charsets directory
About the locales.dat file
Format of locales.dat file entries
How client applications use locales.dat
Editing the locales.dat file
Changing the localization configuration
Adaptive Server localization
Backup Server localization
Configuring Adaptive Server for other character sets
Sort orders
Character sets
charset utility
Logging Error Messages and Events
Adaptive Server error logging
Enabling and disabling error logging
Setting error log paths
Setting the Adaptive Server error log path
Managing messages
Logging user-defined messages
New messages
Existing messages
Logging auditing events
Managing Adaptive Server Databases
Managing database devices
Device requirements
Creating files for database devices
Adding Optional Functionality to Adaptive Server
Adding auditing
Audit system devices and databases
Overview of audit installation
Preinstallation tasks for auditing devices
Installing auditing
Installing online help for Transact-SQL syntax
Online syntax help: sp_syntax
Default device for the sybsyntax database
Installing sybsyntax
Configuration Guide for Windows
About this book
Introduction
About Adaptive Server
System-specific issues
Definition of terms
User roles
Environment variables
Adaptive Server devices and system databases
The master device
The sybsystemdb device
The sysprocsdev device
Optional devices and databases
Client/server communication (the interfaces file)
Changing Adaptive Server configuration
Support for high-availability products
Languages other than U.S. English
Adaptive Server specifications
Starting and Stopping Servers
Overview
Requirements for starting servers
Starting servers
Server start-up parameters
Changing start-up parameters
Starting and stopping servers using Unified Agent
Starting and stopping servers using the Control Panel
Starting servers as an automatic service
Starting, stopping, and pausing servers manually
Stopping servers
Stopping Adaptive Server
Stopping Backup Server
Stopping Monitor Server
Monitoring servers
Unified Agent
The Control Panel
Default Adaptive Server Configuration
Starting Server Config for Adaptive Server
Configuring Adaptive Server
Setting Adaptive Server parameters
Changing the default Backup Server
Changing the default XP Server
Configuring Backup Server
Configuring Monitor Server
Supporting access to large memory
Configuring Job Scheduler and Self Management
Network Communications Using sql.ini
How clients connect to Adaptive Server
How Adaptive Server listens for client connections
How a client accesses Adaptive Server
Enabling client access to a server
Changing the server entries in sql.ini
Components in the sql.ini file
Server name
Network driver
Service type
Server address
Address format
IP address
Named Pipes format
Windows Sockets format
NWLink IPX/SPX format
Sharing network configuration information
Creating a master sql.ini file
Using Windows Registry as a directory service
Verifying server connections
Configuring ODBC connections
Configuring the ODBC driver
IPv6 support
Understanding IPv6
IPv6 infrastructure
Lightweight Directory Access Protocol in Adaptive Server
Overview
LDAP directory services versus the Sybase interfaces file
The libtcl.cfg file
Enabling LDAP directory services
Adding a server to the directory services
Multiple directory services
Encrypting the password
Performance
Migrating from the sql.ini file to LDAP
Customizing Localization for Adaptive Server
Overview of localization support
Language modules
Default character sets for servers
Changing the default character set for servers
Supported character sets
Character set conversion
Conversions between server and client
Sort orders
Available sort orders
Language modules
Installing a new language module
Message languages
Localization
Localization directories
About the directory
About the charsets directory
About the locales.dat file
Format of locales.dat file entries
How client applications use locales.dat
Editing the locales.dat file
Changing the localization configuration
For Adaptive Server
For Backup Server
Configuring Adaptive Server for other character sets
Sort orders
Character sets
charset utility
Logging Error Messages and Events
Logging errors and events
Adaptive Server error logging
Enabling and disabling error logging
Types of information logged
Windows event-logging
Setting up Windows event-logging for use by Adaptive Server
Types of information logged
Managing the logs
Setting error log paths
Setting the Adaptive Server error log path
Setting the Backup Server error log path
Setting the Monitor Server error log path
Enabling and disabling Windows event logging
Using Server Config
Using sp_configure
Managing messages
Logging user-defined messages
New messages
Existing messages
Logging auditing events
Logging user-defined events
Using a remote log
Using a central logging site
Logging messages from multiple Adaptive Servers
Setting up a local central logging site
To create and define a Registry key
Viewing the messages
In the Windows event log
In the Adaptive Server error log
Using Security Services with Windows LAN Manager
Security services with Windows LAN Manager
How login authentication works
Administering security services using LAN Manager
Modifying configuration files for a unified login
Setting up drivers for network-based security
Entries for network drivers
Entries for Directory Services
Entries for security drivers
Checking the LAN Manager’s local name
Specifying security information for Adaptive Server
Identifying users and servers to LAN Manager
Configuring Adaptive Server for LAN Manager security
Enabling and disabling external security services
Managing unified login
Requiring unified login
Establishing a secure default login
Mapping LAN Manager login names to server names
Requiring data integrity check
Ensuring adequate memory for security services
Initiating the new security services
Adding logins to support unified login
General procedure for adding logins
Defining the connection to a server for security services
Specifying the principal name
Specifying network-based user authentication
Specifying the name assigned to LAN Manager
Determining the status of security services
Configuration parameters used in security services
Checking data integrity
Checking message sequence
Detecting interception or replay
Specifying a login
Controlling user authentication
Managing login security on an Windows computer
Overview of security features
Adaptive Server security
Combined Adaptive Server and Windows login security
Standard mode
Integrated mode
Mixed mode
Managing the login security features
Permitting trusted connections
Windows Registry parameters
Administering login security using system procedures
Assigning trusted connection permissions
Displaying the current Registry values
Displaying permissions and user names
Revoking permissions granted with sp_grantlogin
Configuring login security
Create Windows users and groups
Configure mapping and default domain values
Set login security mode
Add network login names to syslogins
Assign roles
Changing login security options
Using E-mail with Adaptive Server
Sybmail messages
Sending messages
Receiving messages
Preparing Windows Mail for Sybmail
Connecting to a post office
Creating a mailbox for Adaptive Server
Creating a mail profile for Adaptive Server
Creating an Adaptive Server login for Sybmail
Sybmail and extended stored procedures
Managing a mail session
Starting a session
Starting Sybmail without parameters
Stopping a mail session
Stored and extended procedures for handling messages
Sending messages
Text messages
Query result messages
Receiving messages
Finding the next message
Reading a specific message
Deleting a message
Processing incoming mail
Using Sybmail security
Setting execution privileges
Setting the execution context
Naming both the user and the database
Naming the user but not the database
Naming the database but not the user
Naming neither the user nor the database
Managing Adaptive Server Databases
Managing database devices
Device requirements
Creating .dat files for database devices
Backing up and restoring data
Using a tape drive
Windows tape drive names
Setting the maximum capacity for a tape drive
Using a hard disk
Dumping across a network
Examples of backing up and restoring databases
User databases
System databases
Optimizing Adaptive Server performance and tuning
Using dedicated Adaptive Server operation
Using disk drives
Monitoring disk usage
Monitoring Adaptive Server statistics with Windows Performance Monitor
Adding Optional Functionality to Adaptive Server
Installing auditing
Audit system devices and databases
The sybsecurity device and database
Tables and devices for the audit trail
Device for syslogs systems table
Pre-installation tasks for auditing devices
Installing Auditing
Installing online help for Transact-SQL syntax
Online syntax help: sp_syntax
Default device for the sybsyntax database
Installing sybsyntax
Troubleshooting Network Connections
The dsedit Server Ping Utility
Running Server Ping
Troubleshooting connection failures
When a test fails
Using returned messages to diagnose a failure
Failure to connect to Adaptive Server
Failure to load Net-Library DLLs
Failure of other applications
Before calling Sybase Technical Support
Adaptive Server Registry Keys
New Features Guide
About this book
Feature and platform compatibility
Adaptive Server features and platforms
SQL Statement Replication
Performance issues with log-based replication
Stored procedure replication
How Replication Server topologies affect SQL statement replication
Exceptions to using SQL statement replication
Changes to replication configuration
Database level
sp_setrepdbmode
sp_reptostandby
Table level
sp_setrepdefmode
Session level
Scope of SQL statement replication
Batch processing
Stored procedures
Triggers
Recompilation of stored procedures and triggers
Cross-database transactions
Issues resolved by SQL statement replication
Replicating select into in warm standby configurations
Replicating deferred updates on primary keys
New monitoring tables
Downgrades
Downgrading Adaptive Server
Downgrading Replication Server
Security Enhancements
LDAPS user authentication enhancements
Automatic LDAP user authentication and failback
Setting the LDAP failback time interval
Examples
Login mapping of external authentication
Using SSL to specify a common name
Specifying a common name with sp_listener
Stored procedure sp_addserver changed
Concurrent Kerberos authentication
Virtually-hashed tables
Structure of a virtually-hashed table
Creating a virtually-hashed table
Limitations for virtually-hashed tables
Changes to commands
Changes to the query processor
Changes to monitor counters
Changes to system procedures
Huge Pages
Miscellaneous Features
Extended permissions for MonLicense table
Encrypted Columns for Windows 64-bit platform
PC-Client for Windows 64-bit platforms
Out-of-the-box Configurator
QPTune
Compatibility Mode for the Query Processor
Character Sets
Kazakh character set
Upgrading during a high availability configuration
Distributed Transaction Management (DTM)
Adaptive Server plug-In and command line updates
Chinese Pinyin sort order
IPv6 support
Java Virtual Machine
Adaptive Server Java interface
Installing the JVM
System Changes
New sp_configure options in 15.0.3
sp_configure
'enable compatibility mode'
New stored procedures
sp_compatmode
sp_tab_suspectptn
sp_jreconfig
sp_ldapadmin
Changed stored procedures
sp_addserver
IPV6 changes
sp_listener
sp_passwordpolicy
validate password options
sp_pciconfig
sp_setrepdefmode
sp_setreptable
sp_sysmon
New command
set repmode
Changed commands
create table
update statistics
New configuration parameters
enable pci
maximum nesting level
mnc_full_index_filter
pci memory size
New monitoring tables
monSQLRepActivity
monSQLRepMisses
Changes in monitoring tables
Changed system tables
Deferred Compilation
Overview
Deferred compilation in stored procedure
Using with recompile
Troubleshooting
Clusters Users Guide
About this book
An Overview of the Cluster Edition
What is the Cluster Edition?
Adaptive Server integrated clusterware
The cluster coordinator
The quorum device
Database devices in the Cluster Edition
Private installation versus shared installation
Backup Server in the Cluster Edition
How the Cluster Edition enhances the non-clustered edition
Using interconnected networks in the cluster
Monitoring links between instances
Suggested deployment scenarios
HA failover for OLTP applications
Horizontal scalability for DSS reporting applications
Horizontal scalability for OLTP applications
New client technologies in the Cluster Edition
Support for replication
Client Applications and Client/ Server Interaction
Open Client
Enabling failover in Client-Library applications
Client/server interaction
Login redirection
Connection properties for login redirection
Connection migration
Difference between migration and failover
When can migration occur?
Migrated contexts
Criteria for migration
Context migration
Configuring a client migration
Extended high-availability failover
Differences between HA failover and failover in clusters
Using isql in a clustered environment
Using remote procedure calls in a clustered environment
RPCs where the remote server is a cluster
RPCs where the local server is a cluster
RPCs where local and remote servers are instances in the same cluster
sp_serveroption
Reconnecting clients when a node loses power
Using Security with a Clustered Environment
Using encrypted columns in a clustered environment
Using SSL in a clustered environment
Specifying a common name with sp_listener
Using LDAP as a directory service
LDAP directory services versus the Sybase interfaces file
The libtcl*.cfg file
Enabling LDAP directory services
Adding a server to the directory services
Multiple directory services
Encrypting the password
Performance
Migrating from the interfaces file to LDAP
Using LDAP directory services with the shared-disk cluster
Using Monitoring Tables in a Clustered Environment
Changes for clusters
Configuring the system view
Configuring monitoring tables
Managing the message pipe
Changes for RPCs
InstanceID added to monitor instances
New and changed tables for the cluster cache manager
New tables
monClusterCacheManager
Changed tables
monOpenObjectActivity and monOpenPartitionActivity
monState
monCachedProcedures
Monitoring tables added for PCM
monPCM
Monitoring tables added for recovery
monDBRecovery
monDBRecoveryLRTypes
monCMSFailover
monFailoverRecovery
Monitoring table added for cluster lock manager (CLM)
monCLMObjectActivity
Monitoring tables added for CIPC
monCIPC
monCIPCEndpoints
monCIPCLinks
monCIPCMesh
Monitoring tables added for temporary databases
monTempdbActivity
Tables added or changed for general statistics
New tables
monSysLoad
Changed tables
monEngine
Monitoring tables added for workload manager
monLogicalCluster
monLogicalClusterInstance
monLogicalClusterRoute
monLogicalClusterAction
monProcessMigration
monWorkloadProfile
monWorkload
monWorkloadRaw
monWorkloadPreview
Using Backup Server in a Clustered Environment
Nodes joining cluster during a dump
Multiple Backup Servers
Configuring Cluster Edition to use multiple Backup Servers
Using the dedicated method
Using the round-robin method
Starting and stopping Backup Servers
Backing up to media
Changes to stored procedures
sp_addserver
sp_dumpoptimize and sp_helpserver
sp_volchanged
Managing the Workload
Logical cluster resources
The system logical cluster
Setting up a logical cluster
Creating a logical cluster
Adding instances to a logical cluster
Adding routes to a logical cluster
Starting a logical cluster
Assigning routing rules
Routing rules
Configuring logical cluster attributes
Open logical cluster
Down-routing mode
System-view attribute
Start-up mode
Failover mode
Fail_to_any attribute
Load profile attribute
Login distribution mode
Configuring failover
Adding failover resources
Managing logical clusters
User tasks and logical clusters
Managing the workload manager thread
Setting memory requirements for the workload manager
Viewing information about a logical cluster
Querying the monitor tables
Using sp_cluster logical, "show"
Creating and dropping a logical cluster
Adding resources to a logical cluster
Dropping resources from a logical cluster
Adding, moving, and dropping routes
Migrating connections
Administering failover, failback, and planned downtime
Cluster and instance states
How states change
Asynchronous commands and logical cluster states
Using action descriptors
An example: scheduling and rescheduling a failover
Using failover, failback, online, offline, and deactivate
failover
failback
online
offline
deactivate
Distributing the workload
Workload metrics
Creating a user metric
Weighting the workload metrics
Load thresholds
Load profiles
Using the sample load profiles
Creating and configuring your own load profile
Creating the load profile
Building the load profile
Specifying weights for load profile metrics
Specifying load distribution thresholds
Associating the load profile with a logical cluster
Changing a load profile
Troubleshooting
Cluster Cache Configuration
Global caches
Local caches
Creating and configuring named data caches
Getting information about named caches
Creating a new cache
sp_cacheconfig
Configuring and using multiple buffer pools
sp_poolconfig
Moving memory between buffer pools
Changing the wash size of a pool
Changing a pool’s local asynchronous prefetch percentage
Asynchronous writes during allpages page split
Dropping a buffer pool
Binding objects to named caches
Syntax for binding objects
Getting information about bound caches
Dropping cache bindings
Modifying the configuration file
Format of a local named cache
Extra line in local cache entries
Deleted named cache with global configuration
Named cache with local configuration
Deleted entries with valid configuration
Creating a local configuration in the presence of a global configuration
Limitations
Using Temporary Databases
Types of temporary databases
Local temporary databases
Local user temporary databases
Local system temporary databases
Global temporary databases
Summary information
Creating temporary databases
Creating local system temporary databases
Creating local and global user temporary databases
Binding users and applications to temporary databases
Creating and managing temporary database groups
What you can bind
How the session binding is determined
Creating and managing bindings
Displaying group and binding information
Dropping temporary databases
Dropping all but the last local system temporary database
Dropping the last local system temporary database
Restrictions for temporary databases
Private device support for local databases
Using private devices for temporary data
Creating private devices using disk init
Reinitializing private devices using disk reinit
Dropping private devices using sp_dropdevice
Displaying private device information using sp_helpdevice
Using create database and alter database with a private device
Using disk refit
Running Job Scheduler in a Clustered Environment
Installing and configuring Job Scheduler
Running Job Scheduler in a clustered environment
Shutting down Job Scheduler
Redirecting scheduled jobs
Additional Topics
Locks
Deadlocks
Retention locks
Memory
Thresholds
dbcc thresholds output
dbcc dbtable output
dbcc dbrepair with remap option
dbcc dbrepair with newthreshold option
Cluster interprocess communication
Recovery
Recovery algorithm
Single transaction log
Distributed checkpoints
Quorum device heartbeat
Configuring the quorum device heartbeat
Using InfiniBand
Setting the buffer space
Configuring buffer space
Configuring InfiniBand in a cluster
Private installation mode
Maintaining the server configuration files
Changing configuration options at runtime
Manually changing the configuration file
If the version numbers do not match at start-up
Recommended configurations
Using Java in a clustered environment
Using the Cluster Edition with the Veritas Cluster Server
Supported platforms, requirements, and limitations
Installing and configuring the Cluster Edition on VCS
Installing the Cluster Edition
Creating a new Adaptive Server cluster for Storage Foundation integration
Converting an existing cluster to use SF for Sybase CE
Relocating database storage
Reconfiguring interconnects
Managing a cluster under VCS control
Starting and stopping instances
Adding and removing instances
Membership modes
Determining the membership mode
Changing membership mode
Understanding failure scenarios
VCS troubleshooting
Cluster Edition fails to start
Veritas log: “Sybase home directory does not exist”
Instance log: “failed to bind to socket”
Instance log: “Membership service failed to receive initial message from Veritas cluster membership after 301 seconds. Exiting...”
Instance log: “Failed to open quorum device 'device_path'. OS error 13, 'Permission denied'”
Instance log: “basis_dsizecheck: attempt to open device 'device_path' failed, system error is: Permission denied”
Instance log: “The configuration area in master device appears to be corrupt.”
Veritas log: “Path not found”
VCS shuts down the instance after it starts and issues resource faults
VCS cannot shutdown the instance resource
Resource faults for VCS groups
VCS fails to start
Troubleshooting
Verifying the cluster environment
Restarting the cluster using a dataserver binary from an earlier version
Errors accessing disk devices
Verifying the cluster is down
Creating cluster using sybcluster fails with error -131
Cluster creation fails leaving files in $SYBASE directory
Unified Agent starts but sybcluster connect fails
Disk devices in use
Instances fail to join the cluster
Private interconnect failure
Client connection failover fails
Client fails to reconnect to alternate high availability servers
sybcluster cannot connect if all connections use SSL
jConnect sample disables HA
PC-Client installation – java.lang.NoClassDefFound Error
The cluster entry “name” did not contain any servers
After password change, sybcluster cannot manage the cluster
Agent “cannot be found”
Sybase Central cannot register the AMCP plug-in
UAF plug-in register error
Data on disk unavailable: problems affecting database creation
Access permission to devices is denied after enabling I/O fencing
sybcluster cannot find interfaces file
IBM errors
Asynchronous I/O not enabled
Incorrect permissions on device
Another machine using device
Error running chdev
Administering Clusters with the Adaptive Server Plug-in
Managing a shared-disk cluster
Connecting to a cluster
Disconnecting from a cluster with the toolbar
Enabling Unified Agent functions in the Adaptive Server plug-in
Changing server discovery settings
Displaying cluster properties
General properties tab
Cluster tab
Configuration tab
Log Space tab
Job Scheduler Server tab
Localization tab
Starting a cluster
Shutting down a cluster
Dropping a cluster
Removing a server group
Displaying the status of a cluster
Managing a clustered instance
Adding an instance to a cluster
Dropping an instance from a cluster
Displaying instance properties
Starting an instance
Shutting down an instance
Creating shared database devices
Managing multiple temporary databases
Managing the local temporary databases
System temporary databases
Adding a user-created global temporary database
Adding a user-created local temporary database
Adding temporary databases to a group
Adding a group
Group properties
Managing the workload
Load profiles
Deleting load profiles
Associating a load profile with a logical cluster
General tab for load profiles
Metric Weights tab
Thresholds tab
Managing logical clusters
Adding a logical cluster
Dropping a logical cluster
Logical cluster properties
General tab
Base Instances tab
Failover Instances tab
Load Profile tab
Routes tab
Viewing workload status
Viewing workload status of an instance
Managing routes
Route properties
Creating a route
Administering Clusters Using sybcluster
Using sybcluster
sybcluster and the Unified Agent Framework
Starting sybcluster
Creating a cluster
Connecting to the cluster
Authenticating the user
Setting the user name and password
Identifying the Unified Agents
Starting the cluster
Managing the cluster
Creating a cluster
Verifying the cluster
Displaying information about available Unified Agents
Displaying cluster information
Changing cluster configuration values
Changing user names or passwords
Changing localization values
Changing the membership mode
Disconnecting from the cluster
Shutting the cluster down
Dropping a cluster
Managing an instance
Displaying information about the instance
Adding an instance
Verifying the instance
Changing the default instance
Changing instance properties
Shutting an instance down
Dropping an instance
Enabling sybcluster after manually creating the cluster
Creating and managing auxiliary servers
Creating auxiliary servers
Dropping auxiliary servers
Displaying listening port information
Changing listening port information
Upgrading the server
System Changes
Commands
alter table
create database
create schema
create table
New and changed dbcc commands
New dbcc commands
Changed dbcc command
disk init
disk reinit
grant
quiesce database
revoke
set system_view
shutdown
Stored procedures
New stored procedures
sp_clusterlockusage
sp_cluster connection, migrate
sp_cluster connection, migrate_cancel
sp_cluster connection, migrate_status
sp_cluster logical, action
sp_cluster logical, add
sp_cluster logical, alter
sp_cluster logical, create
sp_cluster logical, deactivate
sp_cluster logical, drop
sp_cluster logical, failback
sp_cluster logical, failover
sp_cluster logical, [ gather | set ]
sp_cluster logical, help
sp_cluster logical, offline
sp_cluster logical, online
sp_cluster logical, set
sp_cluster logical, show
sp_cluster profile
sp_tempdb_markdrop
sp_refit_admin
Changed stored procedures
Configuration changes
sp_audit
sp_addengine
sp_addexeclass
sp_addserver
sp_addlogin
sp_dbcc_updateconfig
sp_configure
sp_dropengine
sp_encryption
sp_helpconfig
sp_helpdb
sp_lock
sp_modifylogin
sp_sysmon
instance_name parameter added
sp_tempdb
Configuration parameters
New configuration parameters
cluster heartbeat interval
cluster heartbeat retries
cluster vote timeout
idle migration timeout
session migration timeout
quorum heartbeat interval
quorum heartbeat retries
automatic cluster takeover
enable i/o fencing
enable backupserver HA
CIPC large message pool size
CIPC regular message pool size
DMA object pool size
workload manager cache size
Changed configuration parameters
cis_rpc_handling
number of open databases
number of pre-allocated extents
runnable process search count
Utilities
New utilities
sybcluster
qrmutil
Changes to utility programs
bcp
dataserver
ddlgen
isql
System tables
timestamp columns
Changed identity values
Changed system tables
dbcc_types
sysinstances
nodeid renamed
Columns added
sysservers.srvnetname length change
spid columns change from smallint to int
Controlling fake-table materialization
Monitor tables
Global variables
Functions
New functions
spid_instance_id
instance_id
instance_name
lc_name
lc_id
workload_metric
sys_tempdbid
sdc_intempdbconfig
db_instanceid
db_recovery_status
The sybcluster Utility
sybcluster
sybcluster interactive commands
Configuring the Operating System
Using the stty setting
Restoring correct permissions
File descriptors and user connections
For Linux
For Sun Solaris
For HP-UX
Displaying current soft and hard limits
Increasing the soft limit
Increasing the hard limit
Sample program
Adjusting the client connection timeout period
For Sun Solaris
For Linux
For HP-UX
Checking for hardware errors
For Sun Solaris
For Linux
For HP-UX
Monitoring the use of operating system resources
A sample C shell maintenance script
Customizing Localization for the Cluster Edition
Overview of localization support
Language modules
Default character sets for servers
Changing the default language and character set
Changing the default character set for servers
Supported character sets
Character set conversion
Conversions between server and client
Sort orders
Available sort orders
Language modules
Installing a new language module
Message languages
Localization
Localization directories
About the directory
About the charsets directory
About the locales.dat file
Format of locales.dat file entries
How client applications use locales.dat
Editing the locales.dat file
Changing the localization configuration
Cluster Edition localization
Backup Server localization
Configuring the Cluster Edition for other character sets
Sort orders
Character sets
charset utility
Adding Optional Functionality to the Cluster Edition
Adding auditing
Audit system devices and databases
Running auditinit with the Cluster Edition
Preinstallation tasks for auditing devices
Installing auditing
Installing online help for Transact-SQL syntax
Online syntax help: sp_syntax
Default device for the sybsyntax database
Installing sybsyntax
Logging Error Messages and Events
Cluster Edition error logging
Enabling and disabling error logging
Setting error log paths
Setting the Cluster Edition error log path
Managing messages
Logging user-defined messages
New messages
Existing messages
Logging auditing events
Setting Up Communications Across the Network
How the Cluster Edition determines which directory service entry to use
How a client uses directory services
Creating a directory services entry
Supported directory drivers
Contents of an interfaces file
Heterogeneous and homogeneous environments
Understanding the format of the interfaces file
Components of an interfaces file entry
Creating a master interfaces file
Using dsedit or dscp to create a master interfaces file
Using a text editor to create a master interfaces file
Configuring interfaces files for multiple networks
Configuring the server for multiple network handlers
Sample interfaces files for multiple network handlers
Configuring the client connections
Using one network-independent DSQUERY name
Using different DSQUERY names
Configuring for query port backup
IPv6 support
Understanding IPv6
IPv6 infrastructure
Starting the Cluster Edition as IPv6-aware
Troubleshooting
Server fails to start
Error when executing an ESP
Glossary
Java in Adaptive Server Enterprise
About this book
An Introduction to Java in the Database
Advantages of Java in the database
Capabilities of Java in the database
Invoking Java methods in the database
Storing Java classes as datatypes
Storing and querying XML in the database
Java components
Functional changes in Adaptive Server 15.0.3 and later
Changes in class distribution
The PCA/JVM runs in headless mode
Changes in memory management
Changes in ClassLoader behavior
Standards
Java in the database: questions and answers
What are the key features?
How are Java instructions stored in the database?
How is Java executed in the database?
Which Java Virtual Machines (JVMs) are supported?
What is headless mode?
What about JDBC?
How can Java and SQL be used together?
What is the Java API?
Which Java classes are supported in the Java API?
Can user-defined classes be installed in the database?
Can data be accessed using Java?
Can the same classes be used on the client and the server?
How to use Java classes in SQL
Where can information about Java in the database be found?
What you cannot do with Java in the database
Managing the Java Environment
Components of the Java environment
The JVM pluggable component
Pluggable component adapter JVM (PCA/JVM)
Pluggable component interface (PCI) and the PCI Bridge
The PCI memory pool
The sybpcidb database
How configuration values are organized in sybpcidb
When to change configuration values
Server-level options
Configuration options for the PCI Bridge
Configuration options for the PCA/JVM
Changing configuration values in a running server
Changing configuration values by restarting Adaptive Server
Changing configuration values before the JVM is initialized
Changing configuration values after the JVM is initialized
Restoring default configuration values to sybpcidb
Using monitor tables to display information about the PCI Bridge
Preparing for and Maintaining Java in the Database
The Java runtime environment
Java classes in the database
Sybase runtime Java classes
User-defined Java classes
JDBC drivers
The JVM
Enabling Java
Installing Java classes in the database
Using installjava
Installing uncompressed JARs
Retaining the JAR file
Updating installed classes
Referencing other Java-SQL classes
Viewing information about installed classes and JARs
Downloading installed classes and JARs
Removing classes and JARs
Retaining classes
Using Java Classes in SQL
General concepts
Java considerations
Java-SQL names
Using Java classes as datatypes
Creating and altering tables with Java-SQL columns
Altering partitioned tables
Selecting, inserting, updating, and deleting Java objects
Invoking Java methods in SQL
Sample methods
Exceptions in Java-SQL methods
Representing Java instances
Assignment properties of Java-SQL data items
Datatype mapping between Java and SQL fields
Character sets for data and identifiers
Subtypes in Java-SQL data
Widening conversions
Narrowing conversions
Runtime versus compile-time datatypes
Treatment of nulls in Java-SQL data
References to fields and methods of null instances
Null values as arguments to Java-SQL methods
Null values when using the SQL convert function
Java-SQL string data
Zero-length strings
Type and void methods
Java void instance methods
Java void static methods
Equality and ordering operations
Evaluation order and Java method calls
Columns
Variables and parameters
Deterministic Java functions in expressions
Static variables in Java-SQL classes
Changes for static variables for Adaptive Server 15.0.3 and later
Changes for static variables for the Cluster Edition
Java classes in multiple databases
Scope
Cross-database references
Inter-class transfers
Passing inter-class arguments
Temporary and work databases
Java classes
Data Access Using JDBC
Overview
JDBC concepts and terminology
Differences between client- and server-side JDBC
Permissions
Using JDBC to access data
Overview of the JDBCExamples class
The main( ) and serverMain( ) methods
Using main( )
Using serverMain( )
Obtaining a JDBC connection: the Connecter( ) method
Routing the action to other methods: the doAction( ) method
Executing imperative SQL operations: the doSQL( ) method
Executing an update statement: the updater( ) method
Executing a select statement: the selecter( ) method
Calling a SQL stored procedure: the caller( ) method
Error handling in the native JDBC driver
The JDBCExamples class
The main( ) method
The serverMain( ) method
The connecter( ) method
The doAction( ) method
The doSQL( ) method
The updater( ) method
The selecter( ) method
The caller( ) method
SQLJ Functions and Stored Procedures
Overview
Compliance with SQLJ Part 1 specifications
General issues
Security and permissions
SQLJ Examples