Adaptive Server Enterprise
Document ID
Contents
Connecting to Adaptive Server via Sybase Central
Post-Installation Tasks
Installing Sybase PC-Client Products
Upgrading Adaptive Server
Contents
101
119
123
124
126
131
135
How to use this book
Audience
Viii
Related documents
About This Book
Adaptive Server Enterprise
Other sources of information
Xii
Finding the latest information on component certifications
Conventions
Xiii
Accessibility features If you need help
Xiv
SQL syntax conventions
Key Definition
Overview
Topic
Product licensing with SySAM
Product licensing with SySAM
Adaptive Server Enterprise
Product components
Overview
Backup Server
Product components
Stored procedures
Adaptive Server editions
Client
Data
Small Business Edition
Enterprise Edition
Adaptive Server editions
Adaptive Server specifications
Adaptive Server specifications for HP-UX 64-bit PA Risc
Adaptive Server specifications on Windows
Developer Edition
Product descriptions and directory layout
Product descriptions and directory layout
Product description
Product Description
SDK
Sybase support for ADO.NET, OLE DB, and Odbc
Interactive SQL
PC-Client product descriptions and directory layout
Products and platforms
Separately installable PC-Client products
PC-Client product descriptions and directory layout
A P T E R 2 Installing Adaptive Server
Overview
System requirements
System requirements
Pre-installation tasks for SySAM
Installing Adaptive Server
Disk space requirements for Windows platforms
Product Disk space requirements
Accessing Spdc
Pre-installation tasks for SySAM
Getting your host ID
Enter
Generating licenses at Spdc
Generating a served license
Generating an unserved license
Installing a new license server
SYBASE%\%SYBASESYSAM%\bin
Pre-installation tasks for Adaptive Server
Pre-installation tasks for Adaptive Server
Adjust shared memory segments
Pre-installation tasks for Adaptive Server
Installation methods
Installing server components
Installing components with the Installer in GUI mode
Installing server components
Installing Sybase Central and Adaptive Server plugin in?
Installing server components
Small Business Edition Developers Edition Express Edition
Installing server components
Installing Adaptive Server
Installing server components
Monitor Server User’s Guide
Determining Adaptive Server version
Backing up Adaptive Server
Installing the Adaptive Server version 15.0.2 binary overlay
XML Services in Adaptive Server version
A P T E R 3 Post-Installation Tasks
Post installation instructions
Verifying that servers are running
Verifying that servers are running
Post-Installation Tasks
Verifying that you can connect to servers
Connecting to Adaptive Server via Sybase Central
Setting the System Administrator password
SAMreport
Installing sample databases
Default devices for sample databases
Installing sample databases
Sample database scripts
Running the database scripts
Installing the interpubs database
Interpubs database
Installing the jpubs database
Jpubs database
Maintaining the sample databases
Installing Sybase PC-Client Products
Installing PC-Client products
Before you install the PC-Client products
Before you install the PC-Client products
Installing Sybase PC-Client Products
Operating system Service pack level
Installing PC-Client Components on Windows
PC-Client system requirements
Installing PC-Client products
Installing PowerDesigner, PowerTransfer, and InfoMaker
Configuring network connections for client products
Configuring libtcl.cfg for Ldap
For example
Adding a server to the interfaces file
Machinename
Testing the Sybase Central installation
A P T E R 5 Upgrading Adaptive Server
Overview of the upgrade process
Overview of the upgrade process
System catalog changes during upgrade
Upgrading Adaptive Server
Pre-upgrade tasks
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
Increasing default database sizes
Create a sybsystemdb database
If you have a sybsystemdb database
Upgrading to Adaptive Server
If you do not have a sybsystemdb database
Upgrading the server
Testing the Adaptive Server upgrade
Post-upgrade tasks
Run the instmsgs.ebf script
Post-upgrade tasks
Restoring functionality in Adaptive Server
Spconfigure configuration file, 0, verify, fullpathtofile
Reenabling Replication Server
Removing old log records
Reenabling replication
Restoring replication after upgrade
Spaudit execprocedure, all, spaddlogin, on
Reenabling auditing
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Backup Server, Monitor Server, and XP Server
Upgrading Backup and Monitor Servers
Shutting down SySAM servers
Upgrading Job Scheduler
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Upgrading Job Scheduler
Upgrading Job Scheduler templates
Jstdumplog
SybDeleteStatsTemplate.xml
Template Modified file Change description From this template
Upgrading high availability
Upgrading high availability
Console output on primary server is similar to the following
Migrating from 32-bit to 64-bit versions
Migrating from 32-bit to 64-bit versions
Method #2 BCP data out Method #3 Replacing the binary
Recovering from a failed upgrade
Recovering from a failed upgrade
Isql alter database dbname on devicename = 2m
Recovering from a failed upgrade
A P T E R 6 Troubleshooting SySAM Issues
Calling Sybase technical support for SySAM-related issues
Where to look for SySAM-related errors
Where to look for SySAM-related errors
Troubleshooting SySAM
Troubleshooting SySAM Issues
Troubleshooting SySAM
Description What to do
Troubleshooting SySAM
Or use a different port number for the license server
Software Asset Management User’s Guide
Matches these settings
SySAM grace mode
SySAM grace mode
SySAM grace period
Enabling and changing e-mail notifications
Enabling and changing e-mail notifications
100
A P T E R 7 Troubleshooting
Problem Possible cause and solution
Troubleshooting guidelines for Windows
102
Error log locations
Troubleshooting
Error log locations for installation utilities for Windows
Utility Error log location
Solutions to common installation problems
Installer fails to start
Adaptive Server fails to start
Stopping Adaptive Server after a failure
If installation fails after files are created
Recovering from a failed installation
105
If Adaptive Server fails the pre-upgrade eligibility test
Recovering from a failed upgrade
Restoring from backup
106
Re-running the upgrade
107
If the cause of the failure is known
108
If the cause of the failure is unknown
Upgrading compiled objects with dbcc upgradeobject
109
Upgrading compiled objects with dbcc upgradeobject
Finding compiled object errors before production
110
Reserved word errors
Quoted identifier errors
Missing, truncated, or corrupted source text
111
Temporary table references
Select * potential problem areas
112
Using dbcc upgradeobject
113
View upgrades all views
114
Increasing the log segment size
115
Using database dumps in upgrades
Error reporting
Upgrading using dump and load
Upgrading compiled objects in database dumps
Determining whether a compiled object has been upgraded
117
118
Uninstalling Adaptive Server
Heading
Removing an old server
Removing an old server
120
Removing Adaptive Server
121
122
P E N D I X a Alternative Installation Methods
Installation on consoles non-GUI mode
Silent installation
Silent installation
124
Appendix a Alternative Installation Methods
125
Configuration using resource files
Configuring from a resource file
Configuration using resource files
Editing a sample resource file
127
Resource file variables
128
129
Running the sybatch utility
Variable, PUT-THE Description
130
Introduction
131
Suspending transaction processing and replication activities
132
Appendix B Upgrading Servers with Replicated Databases
Draining the transaction logs for primary databases
133
134
Draining the Rssd transaction log
135
Disabling the secondary truncation point
Disabling the secondary truncation point
136
P E N D I X C Using sybsystemprocs
137
Increasing the size of the sybsystemprocs database
Increasing the size of the sybsystemprocs database
138
Enlarging the sybsystemprocs database
Creating a larger system procedures device sysprocsdev
Appendix C Using sybsystemprocs
139
140
141
142
Index
143
Index
144
145
146