Document Outline

• Installation Guide
  • APPENDIX A Alternative Installation Methods 121
  • APPENDIX B Upgrading Servers with Replicated Databases 129
  • APPENDIX C Using sybsystemprocs 135
  • About This Book
  • CHAPTER 1 Overview
    • Product licensing with SySAM 2.0
    • Product components
      • Adaptive Server Enterprise
      • Backup Server
      • Stored procedures
      • The client
    • Adaptive Server editions
      • Enterprise Edition
      • Small Business Edition
      • Developer Edition
    • Adaptive Server specifications
    • Product descriptions and directory layout
    • PC-Client product descriptions and directory layout
      • Separately installable PC-Client products
  • CHAPTER 2 Installing Adaptive Server
    • Overview
    • System requirements
    • Pre-installation tasks for SySAM
      • Accessing SPDC
      • Getting your host ID
      • Generating licenses at SPDC
        • Generating a served license
        • Generating an unserved license
      • Installing a new license server
    • Pre-installation tasks for Adaptive Server
    • Installing server components
      • Installation methods
      • Installing components with the Installer in GUI mode
    • Installing version 15.0.2 over an existing 15.x Adaptive Server
      • Determining Adaptive Server version
      • Backing up Adaptive Server
      • Installing the Adaptive Server version 15.0.2 binary overlay
      • Backward compatibility with previous Adaptive Server 15.x versions
      • XML Services in Adaptive Server version 15.0.2
  • CHAPTER 3 Post-Installation Tasks
    • Verifying that servers are running
    • Verifying that you can connect to servers
    • Connecting to Adaptive Server via Sybase Central
    • Setting the System Administrator password
    • The SAMreport
    • Installing sample databases
      • Default devices for sample databases
      • interpubs database
      • jpubs database
      • Maintaining the sample databases
  • CHAPTER 4 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
  • CHAPTER 5 Upgrading Adaptive Server
    • Overview of the upgrade process
      • System catalog changes during upgrade
    • Pre-upgrade tasks
      • Checking system and upgrade requirements
      • Checking RUN_server file location
      • Procedure text is required for upgrade
      • Reserved words
        • Running a reserved word check
        • Addressing reserved words conflicts
        • Using quoted identifiers
      • Preparing the database and devices for the upgrade
        • Create a sybsystemdb database
        • If you have a sybsystemdb database
        • If you do not have a sybsystemdb database
        • sybsystemprocs
      • Using sqlupgrade
      • Using sqlupgraderes
        • Resource file attributes for upgrading Adaptive Server
        • Upgrading using sqlupgraderes
    • Post-upgrade tasks
      • Run the instmsgs.ebf script
      • Restoring functionality in Adaptive Server
      • Reenabling Replication Server
        • Removing old log records
        • Reenabling replication
        • Restoring replication after upgrade
      • Reenabling auditing
        • Special considerations for threshold procedures for audit segments
      • Shutting down SySAM servers
    • Upgrading Backup Server, Monitor Server, and XP Server
    • Upgrading Job Scheduler
      • Upgrading Job Scheduler templates
    • Upgrading high availability
    • Migrating from 32-bit to 64-bit versions
    • Recovering from a failed upgrade
  • CHAPTER 6 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
  • CHAPTER 7 Troubleshooting
    • Overview
    • Error log locations
    • Solutions to common installation problems
      • Cannot use X-Windows
      • Cannot eject the CD 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
  • CHAPTER 8 Removing Adaptive Server
    • Uninstalling Adaptive Server 15.0.2
    • Removing an existing Adaptive Server
  • APPENDIX A Alternative Installation Methods
    • Installation on consoles (non-GUI mode)
    • Silent installation
    • Configuration using resource files
      • Configuring from a resource file
        • Editing a sample resource file
        • Editing a resource file created by srvbuild
        • Resource file attributes for Adaptive Server
        • Resource file attributes for Backup Server
      • Using srvbuildres
  • APPENDIX B Upgrading Servers with Replicated Databases
    • Introduction
    • Suspending transaction processing and replication activities
    • Draining the transaction logs for primary databases
    • Draining the RSSD transaction log
    • Disabling the secondary truncation point
  • APPENDIX C Using sybsystemprocs
    • Introduction
    • Increasing the size of the sybsystemprocs database
    • Increasing device and database capacity for system procedures
      • Index
        • A
        • B
        • C
        • D
        • E
        • G
        • H
        • I
        • J
        • K
        • L
        • M
        • N
        • O
        • P
        • R
        • S
        • T
        • U
        • W
        • X