Manuals / Sybase / Computer Equipment / Server

Sybase 15.0.2 manual 118

Models: 15.0.2

1 160

Download 160 pages 32.42 Kb

Page 132

Upgrading compiled objects with dbcc upgrade_object

118	Adaptive Server Enterprise

Image 132

Sybase 15.0.2 manual 118

Contents

Adaptive Server Enterprise Document ID Contents Connecting to Adaptive Server via Sybase Central Post-Installation TasksInstalling Sybase PC-Client Products Upgrading Adaptive ServerContents 101119 123124 126131 135How to use this book AudienceViii Related documentsAbout This Book Adaptive Server Enterprise Other sources of information Xii Finding the latest information on component certificationsConventions XiiiAccessibility features If you need help XivSQL syntax conventions Key DefinitionOverview TopicProduct licensing with SySAM Product licensing with SySAMProduct components Adaptive Server EnterpriseOverview Backup Server Product componentsStored procedures Adaptive Server editionsClient DataEnterprise Edition Small Business EditionAdaptive Server editions Adaptive Server specifications Adaptive Server specifications for HP-UX 64-bit PA RiscAdaptive Server specifications on Windows Developer EditionProduct descriptions and directory layout Product descriptions and directory layoutProduct description Product DescriptionSDK Sybase support for ADO.NET, OLE DB, and Odbc Interactive SQLPC-Client product descriptions and directory layout Products and platformsSeparately installable PC-Client products PC-Client product descriptions and directory layoutA P T E R 2 Installing Adaptive Server OverviewSystem requirements System requirementsPre-installation tasks for SySAM Installing Adaptive ServerDisk space requirements for Windows platforms Product Disk space requirementsAccessing Spdc Pre-installation tasks for SySAMGetting your host ID EnterGenerating 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 Installing server components Installation methodsInstalling 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 ServerInstalling 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 instructionsVerifying that servers are running Verifying that servers are runningPost-Installation Tasks Verifying that you can connect to serversConnecting to Adaptive Server via Sybase Central Setting the System Administrator passwordSAMreport Installing sample databases Default devices for sample databasesInstalling sample databases Sample database scriptsRunning the database scripts Installing the interpubs database Interpubs databaseInstalling the jpubs database Jpubs databaseMaintaining the sample databases Installing Sybase PC-Client Products Before you install the PC-Client products Installing PC-Client productsBefore you install the PC-Client products Installing Sybase PC-Client Products Operating system Service pack levelInstalling PC-Client Components on Windows PC-Client system requirementsInstalling PC-Client products Installing PowerDesigner, PowerTransfer, and InfoMaker Configuring network connections for client products Configuring libtcl.cfg for LdapFor 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 processSystem catalog changes during upgrade Upgrading Adaptive ServerPre-upgrade tasks Pre-upgrade tasksChecking system and upgrade requirements Procedure text is required for upgrade Noting server and device names and locationsReserved words Running a reserved word check Addressing reserved words conflictsUsing quoted identifiers Increasing default database sizesCreate a sybsystemdb database If you have a sybsystemdb databaseUpgrading to Adaptive Server If you do not have a sybsystemdb databaseUpgrading the server Testing the Adaptive Server upgrade Post-upgrade tasks Run the instmsgs.ebf scriptPost-upgrade tasks Restoring functionality in Adaptive ServerSpconfigure configuration file, 0, verify, fullpathtofile Reenabling Replication Server Removing old log recordsReenabling replication Restoring replication after upgrade Spaudit execprocedure, all, spaddlogin, on Reenabling auditingUpgrading Backup Server, Monitor Server, and XP Server Upgrading Backup Server, Monitor Server, and XP ServerUpgrading Backup and Monitor Servers Shutting down SySAM serversUpgrading Job Scheduler Upgrading Job SchedulerUpgrading Job Scheduler templates Upgrading Job SchedulerUpgrading Job Scheduler templates JstdumplogSybDeleteStatsTemplate.xml Template Modified file Change description From this template Upgrading high availability Upgrading high availabilityConsole output on primary server is similar to the following Migrating from 32-bit to 64-bit versions Migrating from 32-bit to 64-bit versionsMethod #2 BCP data out Method #3 Replacing the binary Recovering from a failed upgrade Recovering from a failed upgradeIsql 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 issuesWhere to look for SySAM-related errors Where to look for SySAM-related errorsTroubleshooting SySAM Troubleshooting SySAM IssuesTroubleshooting SySAM Description What to doTroubleshooting 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 modeSySAM grace period Enabling and changing e-mail notificationsEnabling and changing e-mail notifications 100A P T E R 7 Troubleshooting Troubleshooting guidelines for Windows Problem Possible cause and solution102 Error log locations TroubleshootingError log locations for installation utilities for Windows Utility Error log locationSolutions to common installation problems Installer fails to startAdaptive Server fails to start Stopping Adaptive Server after a failureRecovering from a failed installation If installation fails after files are created105 If Adaptive Server fails the pre-upgrade eligibility test Recovering from a failed upgradeRestoring from backup 106Re-running the upgrade 107If the cause of the failure is known 108Upgrading compiled objects with dbcc upgradeobject If the cause of the failure is unknown109 Finding compiled object errors before production Upgrading compiled objects with dbcc upgradeobject110 Reserved word errors Quoted identifier errorsMissing, truncated, or corrupted source text 111Select * potential problem areas Temporary table references112 Using dbcc upgradeobject 113View upgrades all views 114Increasing the log segment size 115Using database dumps in upgrades Error reportingUpgrading using dump and load Upgrading compiled objects in database dumpsDetermining whether a compiled object has been upgraded 117118 Uninstalling Adaptive Server HeadingRemoving an old server Removing an old server120 Removing Adaptive Server 121122 P E N D I X a Alternative Installation Methods Installation on consoles non-GUI modeSilent installation Silent installation124 Appendix a Alternative Installation Methods 125Configuration using resource files Configuring from a resource fileConfiguration using resource files Editing a sample resource file127 Resource file variables 128Running the sybatch utility 129Variable, PUT-THE Description 130 Introduction 131Suspending transaction processing and replication activities 132Draining the transaction logs for primary databases Appendix B Upgrading Servers with Replicated Databases133 Draining the transaction logs for primary databases 134Draining the Rssd transaction log 135Disabling the secondary truncation point Disabling the secondary truncation point136 P E N D I X C Using sybsystemprocs 137Increasing the size of the sybsystemprocs database Increasing the size of the sybsystemprocs database138 Enlarging the sybsystemprocs databaseAppendix C Using sybsystemprocs Creating a larger system procedures device sysprocsdev139 140 141 142 Index 143Index 144145 146