Seagate ST43401N/ND Technical Information Seite 1

Migrating to Sybase®Adaptive Server™ Enterprise 11.5

x Table of ContentsAdaptive Server Enterprise 11.5Backup and Restore Procedures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B-3

6-20 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5MemoryYou

Migrating to Sybase Adaptive Server Enterprise 11.5 7-17Test: Ensuring Stability andPerformance 7.IntroductionThis chapter will help you evaluate test

7-2 Test: Ensuring Stability and PerformanceSetting Up the Test Environment Adaptive Server Enterprise 11.5Setting Up the Test EnvironmentIdeally, you

Migrating to Sybase Adaptive Server Enterprise 11.5 7-3Adaptive Server Enterprise 11.5 Prioritizing Applications to be Tested1. Create the database wi

7-4 Test: Ensuring Stability and PerformanceDeveloping Fallback Procedures Adaptive Server Enterprise 11.5- For an around-the-clock operation, you may

Migrating to Sybase Adaptive Server Enterprise 11.5 7-5Adaptive Server Enterprise 11.5 Summary of Testing Techniques• Production load captureTable 7-1

7-6 Test: Ensuring Stability and PerformanceWriting Performance Scripts Adaptive Server Enterprise 11.5Writing Performance ScriptsThis section discuss

Migrating to Sybase Adaptive Server Enterprise 11.5 7-7Adaptive Server Enterprise 11.5 Writing Performance Scripts• Add function to funcs.c for each t

7-8 Test: Ensuring Stability and PerformanceWriting Performance Scripts Adaptive Server Enterprise 11.5Deadlock HandlingYou have to resubmit deadlocke

Migrating to Sybase Adaptive Server Enterprise 11.5 7-9Adaptive Server Enterprise 11.5 Test Cycle: Summary of TestsUsing a separate file for each trans

Migrating to Sybase Adaptive Server Enterprise 11.5 xiAdaptive Server Enterprise 11.5Design and Develop Server Migration Scripts. . . . . . . . . . .

7-10 Test: Ensuring Stability and PerformanceTest Cycle: Testing for Performance Adaptive Server Enterprise 11.5➤NoteSybase recommends the use of Cyra

Migrating to Sybase Adaptive Server Enterprise 11.5 7-11Adaptive Server Enterprise 11.5 Test Cycle: Testing for Performance• Post-Upgrade Multi-User T

7-12 Test: Ensuring Stability and PerformanceTest Cycle: Testing for Performance Adaptive Server Enterprise 11.5Untimed BenchmarksIn multi-user mode,

Migrating to Sybase Adaptive Server Enterprise 11.5 7-13Adaptive Server Enterprise 11.5 Test Cycle: Testing for PerformancePost-Upgrade Single-User Te

7-14 Test: Ensuring Stability and PerformanceTest Cycle: Testing for Performance Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 A-1AThe Cyrano Migration Pack A.What is the Cyrano Migration Pack?The Cyrano Migration Pack (CMP)

A-2 The Cyrano Migration PackBenefits of the Cyrano Migration Pack Adaptive Server Enterprise 11.5• Provides deployment testing with an explanation of

Migrating to Sybase Adaptive Server Enterprise 11.5 A-3Adaptive Server Enterprise 11.5 For More InformationLooks for new reserved words, optimizer str

A-4 The Cyrano Migration PackFor More Information Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 B-1BWorksheets for Your CurrentEnvironment B.This appendix provides guidelines and sample workshee

xii Table of ContentsAdaptive Server Enterprise 11.5Cutover Migration Task List Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

B-2 Worksheets for Your Current EnvironmentSQL Server Operational Worksheets Adaptive Server Enterprise 11.5Operational Business RequirementsGeneral o

Migrating to Sybase Adaptive Server Enterprise 11.5 B-3Adaptive Server Enterprise 11.5 SQL Server Operational WorksheetsBackup and Restore ProceduresT

B-4 Worksheets for Your Current EnvironmentSQL Server Operational Worksheets Adaptive Server Enterprise 11.5Database Dump DetailsDetailed backup and r

Migrating to Sybase Adaptive Server Enterprise 11.5 B-5Adaptive Server Enterprise 11.5 SQL Server Operational WorksheetsMaintenance Procedure Details

B-6 Worksheets for Your Current EnvironmentData Architecture Worksheet Adaptive Server Enterprise 11.5Data Architecture WorksheetDocumenting the flow o

Migrating to Sybase Adaptive Server Enterprise 11.5 B-7Adaptive Server Enterprise 11.5 Data Architecture WorksheetProduction Performance MetricsMeasur

B-8 Worksheets for Your Current EnvironmentData Architecture Worksheet Adaptive Server Enterprise 11.5Transaction ProfileRepeat this section for each d

Migrating to Sybase Adaptive Server Enterprise 11.5 B-9Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsSQL Server Infrastructure W

B-10 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5Record CPU resources:.Technical accoun

Migrating to Sybase Adaptive Server Enterprise 11.5 B-11Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsPhysical Memory UsageList

Migrating to Sybase Adaptive Server Enterprise 11.5 xiiiList of TablesTable 1-1: Chapters in this migration guide ...

B-12 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5Open ServersInclude:• Backup Server• s

Migrating to Sybase Adaptive Server Enterprise 11.5 B-13Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsDisk I/O ConfigurationGener

B-14 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5The following disk layout information

Migrating to Sybase Adaptive Server Enterprise 11.5 B-15Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsNetwork ConfigurationNetwor

B-16 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5Operating System ConfigurationDetail th

Migrating to Sybase Adaptive Server Enterprise 11.5 B-17Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsSQL Server ConfigurationDoc

B-18 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5Run dbcc memusage on SQL Server during

Migrating to Sybase Adaptive Server Enterprise 11.5 B-19Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsDatabase DevicesDatabase d

B-20 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5Databases and SegmentsDatabase and seg

Migrating to Sybase Adaptive Server Enterprise 11.5 B-21Adaptive Server Enterprise 11.5 SQL Server Infrastructure WorksheetsDump DevicesDump device in

xiv List of TablesAdaptive Server Enterprise 11.5Table B-4: Maintenance...

B-22 Worksheets for Your Current EnvironmentSQL Server Infrastructure Worksheets Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 C-1CSample Migration Plan Outline C.The following is a high-level migration plan produced by Sybas

C-2 Sample Migration Plan OutlineMigration Approach Outline Adaptive Server Enterprise 11.5After the successful compilation of all database objects, a

Migrating to Sybase Adaptive Server Enterprise 11.5 C-3Adaptive Server Enterprise 11.5 Migration Approach OutlineExample:update tableA set field1 =(se

C-4 Sample Migration Plan OutlineMigration Approach Outline Adaptive Server Enterprise 11.5 PHASE 5: Other Issues Not Checked For or ChangedSome issue

Migrating to Sybase Adaptive Server Enterprise 11.5 D-1DSample Migration Task Lists D.In This AppendixThis appendix provides the following samples:Sam

D-2 Sample Migration Task ListsGeneral Migration Task List Example Adaptive Server Enterprise 11.5Migration AnalysisThe following tasks are related to

Migrating to Sybase Adaptive Server Enterprise 11.5 D-3Adaptive Server Enterprise 11.5 General Migration Task List Example3. Analyze other Sybase soft

D-4 Sample Migration Task ListsGeneral Migration Task List Example Adaptive Server Enterprise 11.5Prepare Applications For Migration1. Search for new

Migrating to Sybase Adaptive Server Enterprise 11.5 D-5Adaptive Server Enterprise 11.5 General Migration Task List Example4. Set up source code contro

Migrating to Sybase Adaptive Server Enterprise 11.5 1-11Introduction and Guide toResources 1.In This ChapterThis chapter gives an overview of the topi

D-6 Sample Migration Task ListsGeneral Migration Task List Example Adaptive Server Enterprise 11.5Complete Server and Data Migration1. Create indexes

Migrating to Sybase Adaptive Server Enterprise 11.5 D-7Adaptive Server Enterprise 11.5 General Migration Task List Example4. Configure applications to

D-8 Sample Migration Task ListsParallel Migration Task List Example Adaptive Server Enterprise 11.55. Retest as necessary.6. Document capacity test re

Migrating to Sybase Adaptive Server Enterprise 11.5 D-9Adaptive Server Enterprise 11.5 Parallel Migration Task List ExampleDefine Test/Acceptance Crite

D-10 Sample Migration Task ListsParallel Migration Task List Example Adaptive Server Enterprise 11.510. Synchronize user IDs.11. Runcheckpoint.Set Up

Migrating to Sybase Adaptive Server Enterprise 11.5 D-11Adaptive Server Enterprise 11.5 Parallel Migration Task List Example5. Verify and document SQL

D-12 Sample Migration Task ListsParallel Migration Task List Example Adaptive Server Enterprise 11.5Front-End Phase 1 and 2 Regression Test Suite1. Pe

Migrating to Sybase Adaptive Server Enterprise 11.5 D-13Adaptive Server Enterprise 11.5 Cutover Migration Task List ExampleCutover Migration Task List

D-14 Sample Migration Task ListsCutover Migration Task List Example Adaptive Server Enterprise 11.5Define Test/Acceptance Criteria—Regression Test Suit

Migrating to Sybase Adaptive Server Enterprise 11.5 D-15Adaptive Server Enterprise 11.5 Cutover Migration Task List ExampleFront-end Regression Test S

1-2 Introduction and Guide to ResourcesRelating Documentation to Migration Phase Adaptive Server Enterprise 11.5Relating Documentation to Migration Ph

D-16 Sample Migration Task ListsCutover Migration Task List Example Adaptive Server Enterprise 11.5Front-End Regression Test Suite1. Perform user regr

Migrating to Sybase Adaptive Server Enterprise 11.5 D-17Adaptive Server Enterprise 11.5 Staged Cutover Task Overview5. Upgrade the production system t

D-18 Sample Migration Task ListsStaged Cutover Task Overview Adaptive Server Enterprise 11.56. Configure a duplicate Adaptive Server 11.5 on the test p

Migrating to Sybase Adaptive Server Enterprise 11.5 E-1EMigration Plan Checklist E.The following checklist, produced by Sybase Professional Services,c

E-2 Migration Plan ChecklistLogical Technology Architecture Adaptive Server Enterprise 11.5• A description of how the new IT architecture applications

Migrating to Sybase Adaptive Server Enterprise 11.5 E-3Adaptive Server Enterprise 11.5 Logical Support ArchitectureLogical Support ArchitectureDoes th

E-4 Migration Plan ChecklistMigration Strategy Design Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 Index-1IndexAApplicationsdocumenting 3-7Applications, changing 5-1 to 5-25from version 4.x 5-1 to

Index-2Adaptive Server Enterprise 11.5DDatabase administration, changes 6-1 to6-20from version 4.x 6-1 to 6-20Backup Server 6-5create table permission

Migrating to Sybase Adaptive Server Enterprise 11.5 Index-3Adaptive Server Enterprise 11.5LLast chance threshold 6-5 to 6-7and bulk copy 6-7open trans

Migrating to Sybase Adaptive Server Enterprise 11.5 1-3Adaptive Server Enterprise 11.5 SyBooksSyBooksUse the SyBooks™ and SyBooks-on-the-Web online re

Index-4Adaptive Server Enterprise 11.5system stored procedures 3-11system tables 3-11third-party tools 3-12server object creation 3-10 to 3-12to build

Migrating to Sybase Adaptive Server Enterprise 11.5 Index-5Adaptive Server Enterprise 11.5disk and firmware use B-13disk I/O B-13disk partitions B-14du

Index-6Adaptive Server Enterprise 11.5

1-4 Introduction and Guide to ResourcesTechnical Information Library Adaptive Server Enterprise 11.5To use SyBooks-on-the-Web, go to http://www.sybase

Migrating to Sybase Adaptive Server Enterprise 11.5 1-5Adaptive Server Enterprise 11.5 Migration Web Page• A Web browser that supports the Secure Sock

1-6 Introduction and Guide to ResourcesSybase Press Books Adaptive Server Enterprise 11.5Migration Resource Guide on the Web(http://www.sybase.com/mig

Migrating to Sybase Adaptive Server Enterprise 11.5 1-7Adaptive Server Enterprise 11.5 Third-Party Toolsuses the Sybase-developed and recommended meth

1-8 Introduction and Guide to ResourcesIf You Need Help Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 2-12Analyze: Documenting BusinessRequirements 2.In This ChapterIn this chapter you begin the first

2-2 Analyze: Documenting Business RequirementsDiagramming the System Adaptive Server Enterprise 11.5Figure 2-1: High-level system diagramYou can write

Migrating to Sybase Adaptive Server Enterprise 11.5 2-3Adaptive Server Enterprise 11.5 Operational Business RequirementsOperational Business Requireme

2-4 Analyze: Documenting Business RequirementsOperational Business Requirements Adaptive Server Enterprise 11.5• Table rowcounts and daily change rate

Migrating to Sybase Adaptive Server Enterprise 11.5 2-5Adaptive Server Enterprise 11.5 Operational Business RequirementsService Level RequirementsDocu

2-6 Analyze: Documenting Business RequirementsCurrent Performance Metrics Adaptive Server Enterprise 11.5Transaction ProfileUsing statistics io, showpl

Migrating to Sybase Adaptive Server Enterprise 11.5 2-7Adaptive Server Enterprise 11.5 Additional Business Requirements- Use operating system monitors

Document ID: 34982-01-1150-02December 1997Copyright InformationCopyright © 1989–1997 by Sybase, Inc. All rights reserved.Sybase, Inc., 6475 Christie A

2-8 Analyze: Documenting Business RequirementsAdditional Business Requirements Adaptive Server Enterprise 11.5• Application and data server dependenci

Migrating to Sybase Adaptive Server Enterprise 11.5 3-13Analyze: Documenting YourEnvironment 3.This chapter provides guidelines for documenting system

3-2 Analyze: Documenting Your EnvironmentHardware Configuration Adaptive Server Enterprise 11.5- Telephone number- Support hours- Name of your account

Migrating to Sybase Adaptive Server Enterprise 11.5 3-3Adaptive Server Enterprise 11.5 Hardware ConfigurationTable 3-2: Disk layout mapPhysicalDevicen

3-4 Analyze: Documenting Your EnvironmentHardware Configuration Adaptive Server Enterprise 11.5Network ConfigurationUse a worksheet like the one in the

Migrating to Sybase Adaptive Server Enterprise 11.5 3-5Adaptive Server Enterprise 11.5 Physical Memory UtilizationPhysical Memory UtilizationList all

3-6 Analyze: Documenting Your EnvironmentSoftware Configuration Adaptive Server Enterprise 11.5Software ConfigurationDocument your software environment

Migrating to Sybase Adaptive Server Enterprise 11.5 3-7Adaptive Server Enterprise 11.5 Sybase Configuration• Web page if applicableApplicationsMake a

3-8 Analyze: Documenting Your EnvironmentSybase Configuration Adaptive Server Enterprise 11.5• SQL Server Runtime Memory Map- Rundbcc memusage during

Migrating to Sybase Adaptive Server Enterprise 11.5 3-9Adaptive Server Enterprise 11.5 Sybase ConfigurationDatabases and SegmentsList of all segments

3-10 Analyze: Documenting Your EnvironmentSQL Server Objects Adaptive Server Enterprise 11.5Dump DevicesRecord dump device information as in the follo

Migrating to Sybase Adaptive Server Enterprise 11.5 3-11Adaptive Server Enterprise 11.5 SQL Server Objects- Other database objects such as triggers an

3-12 Analyze: Documenting Your EnvironmentSQL Server Objects Adaptive Server Enterprise 11.5Use Sybase ToolsYou can reverse engineer server objects us

Migrating to Sybase Adaptive Server Enterprise 11.5 4-14Prepare: Writing a Plan and GettingReady to Migrate 4.In this ChapterNow that you’ve collected

4-2 Prepare: Writing a Plan and Getting Ready to MigrateDetermine Migration Approach Adaptive Server Enterprise 11.5The Table 4-1 highlights the advan

Migrating to Sybase Adaptive Server Enterprise 11.5 4-3Adaptive Server Enterprise 11.5 Determine Migration Approach➤NoteThis migration guide does not

4-4 Prepare: Writing a Plan and Getting Ready to MigrateDetermine Migration Approach Adaptive Server Enterprise 11.5Fallback Plan for all users to rec

Migrating to Sybase Adaptive Server Enterprise 11.5 4-5Adaptive Server Enterprise 11.5 Determine Migration ApproachCutover Without ReplicationThe issu

4-6 Prepare: Writing a Plan and Getting Ready to MigrateDetermine Migration Approach Adaptive Server Enterprise 11.5Fallback Base fallback on the amou

Migrating to Sybase Adaptive Server Enterprise 11.5 4-7Adaptive Server Enterprise 11.5 Determine Migration ApproachPhased CutoverThe issues for a phas

Migrating to Sybase Adaptive Server Enterprise 11.5 vTable of Contents1. Introduction and Guide to ResourcesIn This Chapter . . . . . . . . . . . . .

4-8 Prepare: Writing a Plan and Getting Ready to MigrateWrite a Migration Plan Adaptive Server Enterprise 11.5Write a Migration PlanProduce a project

Migrating to Sybase Adaptive Server Enterprise 11.5 4-9Adaptive Server Enterprise 11.5 Build the Adaptive Server Environmentrequirements you gathered

4-10 Prepare: Writing a Plan and Getting Ready to MigrateBuild the Adaptive Server Environment Adaptive Server Enterprise 11.5See the installation gui

Migrating to Sybase Adaptive Server Enterprise 11.5 4-11Adaptive Server Enterprise 11.5 Update Applications and System Administration ProceduresUpdate

4-12 Prepare: Writing a Plan and Getting Ready to MigrateUpdate Applications and System Administration Procedures Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 5-15Implement: Making RequiredApplication Changes 5.This chapter discusses changes to Transact-SQL

5-2 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5• New Reserved Words in Version 10.0

Migrating to Sybase Adaptive Server Enterprise 11.5 5-3Adaptive Server Enterprise 11.5 If Your Current Version is 4.xNew Login and Password ProtocolsL

5-4 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5Adaptive Server now defaults to the nu

Migrating to Sybase Adaptive Server Enterprise 11.5 5-5Adaptive Server Enterprise 11.5 If Your Current Version is 4.xDatatype HierarchyThe datatype hi

vi Table of ContentsAdaptive Server Enterprise 11.5Physical Memory Utilization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5-6 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5ExampleIn release 4.x, money was above

Migrating to Sybase Adaptive Server Enterprise 11.5 5-7Adaptive Server Enterprise 11.5 If Your Current Version is 4.xscale, the results are truncated

5-8 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5arithignore arith_overflowThe command:s

Migrating to Sybase Adaptive Server Enterprise 11.5 5-9Adaptive Server Enterprise 11.5 If Your Current Version is 4.xnot inSQL Server 4.x returned “tr

5-10 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5or...exists/in/anySubqueries that con

Migrating to Sybase Adaptive Server Enterprise 11.5 5-11Adaptive Server Enterprise 11.5 If Your Current Version is 4.xselect titlefrom titles t1where

5-12 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5Aggregates with existsSQL Server 4.x

Migrating to Sybase Adaptive Server Enterprise 11.5 5-13Adaptive Server Enterprise 11.5 If Your Current Version is 4.xIn release 4.x, this query retur

5-14 Implement: Making Required Application ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5In version 4.x, SQL Server switched e

Migrating to Sybase Adaptive Server Enterprise 11.5 5-15Adaptive Server Enterprise 11.5 If Your Current Version is 4.xselect columns from table1 t1, t

Migrating to Sybase Adaptive Server Enterprise 11.5 viiAdaptive Server Enterprise 11.5Datatype Hierarchy . . . . . . . . . . . . . . . . . . . . . . .

5-16 Implement: Making Required Application ChangesIf Your Current Version is 4.x or 10.x Adaptive Server Enterprise 11.5select title_id, avg_advance

Migrating to Sybase Adaptive Server Enterprise 11.5 5-17Adaptive Server Enterprise 11.5 If Your Current Version is 4.x or 10.xSubquery Processing Chan

5-18 Implement: Making Required Application ChangesIf Your Current Version is 4.x or 10.x Adaptive Server Enterprise 11.5version 10.0 and is now obsol

Migrating to Sybase Adaptive Server Enterprise 11.5 5-19Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x, or 11.0.x• Aggregate fun

5-20 Implement: Making Required Application ChangesIf Your Current Version is 4.x, 10.x, or 11.0.x Adaptive Server Enterprise 11.5Changing Reserved Wo

Migrating to Sybase Adaptive Server Enterprise 11.5 5-21Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x, or 11.0.xFor more inform

5-22 Implement: Making Required Application ChangesIf Your Current Version is 4.x, 10.x, or 11.0.x Adaptive Server Enterprise 11.5• Avoid mathematical

Migrating to Sybase Adaptive Server Enterprise 11.5 5-23Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x, or 11.0.xselect ship_to_

5-24 Implement: Making Required Application ChangesIf Your Current Version is 4.x, 10.x, or 11.0.x Adaptive Server Enterprise 11.5General Tips• Try to

Migrating to Sybase Adaptive Server Enterprise 11.5 5-25Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x, or 11.0.xquery such as t

viii Table of ContentsAdaptive Server Enterprise 11.5Login and Password Changes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5-26 Implement: Making Required Application ChangesIf Your Current Version is 4.x, 10.x, or 11.0.x Adaptive Server Enterprise 11.5

Migrating to Sybase Adaptive Server Enterprise 11.5 6-16Implement: Making RequiredDatabase Administration Changes 6.In this ChapterThis chapter discus

6-2 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5• System Stored Procedure

Migrating to Sybase Adaptive Server Enterprise 11.5 6-3Adaptive Server Enterprise 11.5 If Your Current Version is 4.x• You need not change existing pa

6-4 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5• Procedures that affect t

Migrating to Sybase Adaptive Server Enterprise 11.5 6-5Adaptive Server Enterprise 11.5 If Your Current Version is 4.xNew Backup ServerAs of 10.0, Back

6-6 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x Adaptive Server Enterprise 11.5To learn how to manage fre

Migrating to Sybase Adaptive Server Enterprise 11.5 6-7Adaptive Server Enterprise 11.5 If Your Current Version is 4.x or 10.xTroubleshootingWhensp_who

6-8 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x or 10.x Adaptive Server Enterprise 11.5Configuration Inter

Migrating to Sybase Adaptive Server Enterprise 11.5 6-9Adaptive Server Enterprise 11.5 If Your Current Version is 4.x or 10.xNew Names for Existing Pa

Migrating to Sybase Adaptive Server Enterprise 11.5 ixAdaptive Server Enterprise 11.5Create Your Databases by Loading Backups . . . . . . . . . . . .

6-10 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5Databases

Migrating to Sybase Adaptive Server Enterprise 11.5 6-11Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.x• isnull Functio

6-12 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5procedure

Migrating to Sybase Adaptive Server Enterprise 11.5 6-13Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.xSpace in your ma

6-14 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5I/O the s

Migrating to Sybase Adaptive Server Enterprise 11.5 6-15Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.xThe following ta

6-16 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5Use maste

Migrating to Sybase Adaptive Server Enterprise 11.5 6-17Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.x➤NoteWhen you in

6-18 Implement: Making Required Database Administration ChangesIf Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5which to

Migrating to Sybase Adaptive Server Enterprise 11.5 6-19Adaptive Server Enterprise 11.5 If Your Current Version is 4.x, 10.x or 11.0.x➤NoteParallel pr