User ManualTable of ContentsOverview1Product licensing with SySAM 2.02Product components3Adaptive Server Enterprise3Backup Server4Stored procedures5The client5Adaptive Server editions5Enterprise Edition6Small Business Edition6Developer Edition7Adaptive Server specifications7Product descriptions and directory layout8Sybase support for ADO.NET, OLE DB, and ODBC10PC-Client product descriptions and directory layout11Separately installable PC-Client products12Installing Adaptive Server13Overview13System requirements14Pre-installation tasks for SySAM15Accessing SPDC16Getting your host ID17Generating licenses at SPDC18Installing a new license server21Pre-installation tasks for Adaptive Server23Installing server components27Installation methods27Installing components with the Installer in GUI mode27Installing version 15.0.2 over an existing 15.x Adaptive Server36Determining Adaptive Server version36Backing up Adaptive Server36versions38XML Services in Adaptive Server version 15.0.238Post-Installation Tasks39Post installation instructions39Verifying that servers are running40Verifying that you can connect to servers41Connecting to Adaptive Server via Sybase Central42Setting the System Administrator password42The SAMreport43Installing sample databases44Default devices for sample databases44interpubs database46jpubs database47Maintaining the sample databases48Installing Sybase PC-Client Products49Overview49Before you install the PC-Client products50Installing PC-Client products50Installing PowerDesigner, PowerTransfer, and InfoMaker53Configuring network connections for client products54Configuring libtcl.cfg for LDAP54Adding a server to the interfaces file56Testing the Sybase Central installation58Upgrading Adaptive Server59Overview of the upgrade process60System catalog changes during upgrade61Pre-upgrade tasks62Checking system and upgrade requirements63Noting server and device names and locations64Procedure text is required for upgrade64Reserved words64Preparing the database and devices for the upgrade66Upgrading to Adaptive Server 15.0.268Upgrading the server69Testing the Adaptive Server upgrade70Post-upgrade tasks71Run the instmsgs.ebf script71Restoring functionality in Adaptive Server72Reenabling Replication Server74Reenabling auditing77Shutting down SySAM servers78Upgrading Backup Server, Monitor Server, and XP Server78Upgrading Job Scheduler79Upgrading Job Scheduler templates80Upgrading high availability84Migrating from 32-bit to 64-bit versions86Recovering from a failed upgrade88Troubleshooting SySAM Issues91Calling Sybase technical support for SySAM-related issues91Where to look for SySAM-related errors92Troubleshooting SySAM93SySAM grace mode98SySAM grace period99Enabling and changing e-mail notifications99Troubleshooting101Overview101Error log locations103Solutions to common installation problems104Adaptive Server fails to start104The Installer fails to start104Stopping Adaptive Server after a failure104Recovering from a failed installation105If Adaptive Server fails the pre-upgrade eligibility test106Recovering from a failed upgrade106Upgrading compiled objects with dbcc upgrade_object109Finding compiled object errors before production110Using dbcc upgrade_object113Using database dumps in upgrades116Removing Adaptive Server119Uninstalling Adaptive Server 15.0.2119Removing an old server120Alternative Installation Methods123Installation on consoles (non-GUI mode)123Silent installation124Configuration using resource files126Configuring from a resource file126Resource file variables128Running the sybatch utility129Upgrading Servers with Replicated Databases131Introduction131Suspending transaction processing and replication activities132Draining the transaction logs for primary databases133Draining the RSSD transaction log135Disabling the secondary truncation point136Using sybsystemprocs137Introduction137Increasing the size of the sybsystemprocs database138Index143Size: 661 KBPages: 160Open manual
