Seagate ST43401N/ND Guide d'installation Page 1

Migrating to Adaptive ServerEnterprise 12.5Adaptive Server Enterprise12.5

Relating Documentation to Migration Phase 2 The chapters in this manual are described in the following table:Relating Documentation to Migration Phas

Test Cycle: Testing for Performance 92 Untimed BenchmarksIn multi-user mode, run untimed benchmarks as often as necessary, capturing response time an

93APPENDIX AWorksheets for Your Current EnvironmentThis appendix provides guidelines and sample worksheets for gathering information that will help yo

Adaptive Server Operational Worksheets 94 Backup and Restore ProceduresThis worksheet is helpful for a general survey of your backup and restore proc

APPENDIX A Worksheets for Your Current Environment95Database Dump DetailsDetailed backup and restore information is helpful for defining success cr

Adaptive Server Operational Worksheets 96 Maintenance Procedure DetailsUse the following worksheet to record detailed maintenance information:Databa

APPENDIX A Worksheets for Your Current Environment97Data Architecture WorksheetDocumenting the flow of information is discussed in Chapter 2, “Anal

Data Architecture Worksheet 98 Production Performance MetricsMeasure current production performance metrics, using operating system monitors, for the

APPENDIX A Worksheets for Your Current Environment99• Measure I/Os per second per disk and controller, and I/O queue lengths per “time window” per

Adaptive Server Infrastructure Worksheets 100 Note To quickly identify response time problems, save showplan output for all critical transactions.Ad

APPENDIX A Worksheets for Your Current Environment101Record this information for both the production and development environments. Host Configurati

CHAPTER 1 Introduction and Guide to Resources3For additional information about Sybase database products, go to product manuals at http://manuals.sy

Adaptive Server Infrastructure Worksheets 102 Physical Memory UsageList all the major processes and memory requirements running on each server. Other

APPENDIX A Worksheets for Your Current Environment103Disk I/O ConfigurationGeneral disk information can help with firmware incompatibilities and ca

Adaptive Server Infrastructure Worksheets 104 The following disk layout information can help in case redistribution is required, for load balancing,

APPENDIX A Worksheets for Your Current Environment105Network ConfigurationNetwork layout information can help with firmware incompatibilities, MTBF

Adaptive Server Infrastructure Worksheets 106 Tape ConfigurationTape layout information can help with firmware incompatibilities, MTBF, and capacity

APPENDIX A Worksheets for Your Current Environment107Adaptive Server ConfigurationDocument general information about the ASE configuration. Technic

Adaptive Server Infrastructure Worksheets 108 Run dbcc memusage on ASE during an off-peak time or in single-user mode. Database DevicesDatabase devic

APPENDIX A Worksheets for Your Current Environment109Databases and SegmentsDatabase and segment information can help with load balancing and capaci

Adaptive Server Infrastructure Worksheets 110 Dump DevicesDump device information can help with load balancing and capacity planning.Database Device

111APPENDIX BSample Migration Task ListsThis appendix provides the following samples:• Sample Task List Template• General Migration Task List Example•

Sybase Certifications on the Web 4 • Technical Library CD contains product manuals and is included with your software. The DynaText browser (download

General Migration Task List Example 112 General Migration Task List ExampleThe following general task list shows typical migration tasks, with differ

APPENDIX B Sample Migration Task Lists11313 Update configuration document.Gather Business Requirements1 Define business requirements.2 Define const

General Migration Task List Example 114 5 Define migration downtime impact.6 Notify affected departments.7 Revise implementation plan.8 Obtain user s

APPENDIX B Sample Migration Task Lists1152 Design and develop file system configuration for devices.3 Create database device scripts.4 Prepare secu

General Migration Task List Example 116 3 Configure file system.4 Complete installation/upgrade preparation from installation guide.5 Install Adaptiv

APPENDIX B Sample Migration Task Lists1173 Analyze and correct application changes.4 Configure applications to access new server.5 Perform prelimin

General Migration Task List Example 118 Migration Quality AssurancePerform System Tests1 Perform functional tests.2 Compare functional test results t

APPENDIX B Sample Migration Task Lists119Perform User Acceptance Tests1 Perform acceptance tests.2 Compare acceptance test results to baseline.3 An

Parallel Migration Task List Example 120 • Define Test/Acceptance Criteria—Regression Test Suites• Set Up Target Production Environment• Set Up Repli

APPENDIX B Sample Migration Task Lists121Set Up Target Production Environment1 Identify physical drive configuration for Server A (production) and

CHAPTER 1 Introduction and Guide to Resources55 Click an EBF/Update title to display the report.❖ To create a personalized view of the Sybase Web s

Parallel Migration Task List Example 122 2 Iteratively perform back-end regression testing.3 Monitor and capture system dynamics (sp_who, sp_lock, st

APPENDIX B Sample Migration Task Lists12310 Recycle ASE.Run Post-upgrade Regression Test Suites on ASE 12.5 (Server B)Back-end regression test suit

Cutover Migration Task List Example 124 Shift Production Users to Adaptive Server 12.5 (Server B)1 Ensure that there is no production activity.2 Perf

APPENDIX B Sample Migration Task Lists125• Run Regression Test Suites on Older Release Test System• Upgrade Test System to Release 12.5• Run Regres

Cutover Migration Task List Example 126 2 Capture and map SQL for target user functions.3 Encapsulate SQL for user functions.4 Create front-end simul

APPENDIX B Sample Migration Task Lists1273 Make the “go/no go” call for the test system.4 Verify and document the regression test.5 Verify performa

Cutover Migration Task List Example 128 Front-End Regression Test Suite1 Perform user regression testing.2 Monitor and capture system dynamics (sp_wh

APPENDIX B Sample Migration Task Lists1293 Alter the sybsystemprocs database.4 Perform a pre-upgrade verification.5 Upgrade the production system t

Staged Cutover Task Overview 130 1 Configure ASE 12.5 on the development system, duplicating the earlier release development configuration.2 Migrate

131APPENDIX CMigration Issue ChecklistsThe following checklists were produced by Sybase Consulting to use in writing migration plans for customers. Th

If You Need Help 6 If You Need HelpEach Sybase installation that has purchased a support contract has one or more designated people who are authorize

Logical Application Architecture 132 Logical Application ArchitectureDoes the logical application architecture include:• A list and brief description

APPENDIX C Migration Issue Checklists133• Vendor-independent description (functions and features) and graphical representation of hardware and soft

Migration Strategy Design 134 • Disaster recovery • Production approval and access control• New support organization, including roles and responsibil

135APPENDIX DPre-Upgrade ChecklistThis checklist can be used in addition to that found in the installation guide. It lists steps to prepare for upgrad

Pre-Upgrade Checklist 136 7 Record size and device fragment information for all databases. You can query the sysdevices and sysusages tables for this

APPENDIX D Pre-Upgrade Checklist1375 On NT, if server is an automatic service, change the service type for ASE to manual. 6 Stop mirroring.7 Disabl

Pre-Upgrade Checklist 138

7CHAPTER 2Analyze: Documenting Business RequirementsIn This ChapterIn this chapter you begin the first phase of migration planning, documenting your e

Diagramming the System 8 • Protocols• Gateways• Routers, brouters, bridgesFor example, you can create a diagram like the this high-level view of the

CHAPTER 2 Analyze: Documenting Business Requirements9You can write a high-level business description in addition to or instead of a diagram.Operati

Operational Business Requirements 10 Database Change MetricsFor all databases, record:• Database size• Transaction log growth• Table rowcounts and da

CHAPTER 2 Analyze: Documenting Business Requirements11Service Level RequirementsDocument application details and service requirements, as in this e

DOCUMENT ID: 34982-01-1250-01LAST REVISED: Oct 2001Copyright © 1989-2001 by Sybase, Inc. All rights reserved.This publication pertains to Sybase datab

Current Performance Metrics 12 Note If you are upgrading from ASE 12.0, you can save abstract query plans for your critical queries. For more inform

CHAPTER 2 Analyze: Documenting Business Requirements13•Disk I/O:• Use operating system monitors to measure I/Os per second per disk and controller,

Additional Business Requirements 14 • Should the upgrade take place over the weekend• What staff is available: DBAs, system administrators?• What res

15CHAPTER 3Analyze: Documenting Your EnvironmentIn This ChapterThis chapter provides guidelines for documenting system hardware and software in the Ad

Hardware Configuration 16 General Server HardwareList the following hardware information for every server machine:• Make and model• Your customer ID

CHAPTER 3 Analyze: Documenting Your Environment171 Sun Sparc 20 1.00 6 10000Controller Number Make and ModelFirmware RevisionMonths in ServiceTrans

Physical Memory Utilization 18 Network ConfigurationUse a worksheet like the one in the following example to show network interface card information

CHAPTER 3 Analyze: Documenting Your Environment19Software ConfigurationDocument your software environment as described in the following sections:•

Sybase Configuration 20 • High availability software installedYou may need to contact your operating system vendor to get system upgrades, recent pat

CHAPTER 3 Analyze: Documenting Your Environment21General InformationRecord the following Sybase information:• Adaptive Servers and their SYBASE hom

ContentsIntroduction and Guide to Resources 1In This Chapter 1Chapters in the Migration Guide 1Relating Documentation to Migration Phase 2Other Source

Sybase Configuration 22 Databases and SegmentsList of all segments and the objects on them. Use a worksheet like that in the following example:Dump D

CHAPTER 3 Analyze: Documenting Your Environment23Adaptive Server ObjectsDocument the objects in your current Adaptive Server as described in the fo

Adaptive Server Objects 24 Query Sybase System TablesThe following system tables contain object information that you can use to create installation s

25CHAPTER 4Plan: Writing a Plan and Getting Ready to MigrateIn this ChapterNow that you have collected data about your current system, you can write a

Review the Upgrade Process 26 •The Release Bulletin at http://manuals.sybase.com:80/onlinebooks/group-as/asp1250e/@Generic__CollectionView;pt=asp1250

CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate27Special Cases: Migrating to 64-bit Operating System or Larger Page SizeAs of release 1

Determine Migration Approach 28 Determine Migration ApproachThe best migration strategy for you depends on such factors as the cost of the effort, th

CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate29• Phased CutoverNote This migration guide does not cover other parallel migration app

Determine Migration Approach 30 • The earlier server cannot read release 12.5 backup files. You need to create bcp or other scripts to move tables ba

CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate31Be sure to account for any increased release 12.5 memory requirements that apply to yo

iv Database Devices 7Databases and Segments 8Dump Devices 8Adaptive Server Objects 9Gather Scripts to Create Objects 9If You Don’t Have Scripts 9Plan

Determine Migration Approach 32 You can use dump database or bcp out before an upgrade to prepare for fallback. Plan a way to capture transactions af

CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate33• Information on how to configure memory for performance in the Performance and Tuning

Determine Migration Approach 34 See Chapter 7, “Test: Ensuring Stability and Performance” for more information on testing.BridgingThere should not be

CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate35Write a Migration PlanProduce a project plan which documents:• Migration strategy—Whic

Build the Adaptive Server Environment 36 • Update Applications and System Administration Procedures• Create Migration Scripts• Create a test environm

CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate37Note If you need to perform an operating system upgrade, do so before migrating. Test

Build the Adaptive Server Environment 38 Create Migration ScriptsUsing the scripts you located, wrote, or reverse engineered in Chapter 2, “Analyze:

39CHAPTER 5Implement: Making Required Application ChangesIn This ChapterThis chapter and Chapter 6, “Implement: Making Database Administration Changes

If Your Version is 11.5 40 If Your Version is 11.5This sections covers the following topics: • Changes to Locking• Changes to Error Checking• 11.9.2

CHAPTER 5 Implement: Making Required Application Changes41• Bulk copy into data-only-locked tables requires the version of bcp and the bulk copy li

ChaptervWide Columns and Data Truncation 19Implement: Making Database Administration Changes 1In This Chapter 1If Your Version is 11.5 2New Rollback R

If Your Version is 11.5 42 WorkaroundsIf deadlocks are creating problems, consider converting the table to use datarows locking.If deadlocks or exces

CHAPTER 5 Implement: Making Required Application Changes43as select * from mary.sales_prospects However, this user cannot execute the procedure; th

If Your Version is 11.5 44 • Those permissions set with the grant command• Permissions that depend on roles (such as sa_role or SSO_role) or on statu

CHAPTER 5 Implement: Making Required Application Changes453004 10302 Permission failure for dump database command3110 10302 Permission failure for

If Your Version is 11.5 46 11.9.2 Query Processing ChangesRelease 11.9.2 introduced extensive changes in query processing and optimization. Statistic

CHAPTER 5 Implement: Making Required Application Changes47• Table/Index Level Statistics• Changes to the update statistics CommandColumn Level Stat

If Your Version is 11.5 48 Aggregate OptimizationAggregate optimization was introduced in ASE 11.9.x. This allows the optimizer to factor in an index

CHAPTER 5 Implement: Making Required Application Changes49This trace flag is well-documented in New Functionality in 11.9.2 at http://manuals.sybas

If Your Version is 11.5 or 11.9.x 50 indid 2scan selectivity 0.983249, filter selectivity 0.983249590512 rows, 45991 pages, index height 2,Data Row C

CHAPTER 5 Implement: Making Required Application Changes51• Inner joins, in which the joined table includes only the rows of the inner and outer t

vi Developing Fallback Procedures 5Summary of Testing Techniques 5Writing Performance Scripts 7Write Benchmark Scripts 7Drivers 8Test Cycle: Summary

If Your Version is 11.5 or 11.9.x 52 See the section New Unix File System Device Support in Chapter 6 of this manual. See also the sections on disk i

CHAPTER 5 Implement: Making Required Application Changes53select * from lineitem, partwhere ((p_partkey = l_partkey and l_quantity >= 10)or (p_

If Your Version is 11.5 or 11.9.x 54 Adaptive Server can capture query text and save an abstract plan for a query in a new system table called sysque

CHAPTER 5 Implement: Making Required Application Changes55If a pattern match is found in the cell boundaries then the selectivity is estimated to b

If Your Version is 11.5, 11.9.x, or 12.0 56 New Reserved WordsReserved words can only be used by ASE. New ASE objects and commands result in new rese

CHAPTER 5 Implement: Making Required Application Changes57Note The Sybase procedures for detecting reserved words in object names cannot be used t

If Your Version is 11.5, 11.9.x, or 12.0 58 • Using New Wide Data Sizes with Open Client• Wide Columns and Optimizer Statistics• Wide Columns with co

CHAPTER 5 Implement: Making Required Application Changes59To see whether you can enable wide data sizes for your client software, go to the section

If Your Version is 11.5, 11.9.x, or 12.0 60 Wide Columns with col_length() and datalength()The commands col_length() and datalength() are “built-in”

61CHAPTER 6Implement: Making Database Administration ChangesIn This ChapterThis chapter discusses changes to Adaptive Server system administration tha

ContentsParallel Migration Task List Example 9Define Test/Acceptance Criteria—Regression Test Suites 10Set Up Target Production Environment 11Set Up R

If Your Version is 11.5 62 If Your Version is 11.5This section covers the following topics:• New Rollback Records• Optimizer Changes• Trace Flag 326N

CHAPTER 6 Implement: Making Database Administration Changes63Optimizer ChangesASE 11.9.2 introduced major changes in the way the server keeps stati

If Your Version is 11.5 or 11.9.x 64 However, be cautious about adding new statistics to the production environment until you have determined your ne

CHAPTER 6 Implement: Making Database Administration Changes65Documentation ChangesASE 12.0 includes several new manuals that describe separately-li

If Your Version is 11.5 or 11.9.x 66 StripesIn earlier versions, Backup Server could dump to a maximum of 32 stripes, either disk or tape. In 12.0, m

CHAPTER 6 Implement: Making Database Administration Changes67You must configure the local and remote Backup Servers at startup by providing the app

If Your Version is 11.5 or 11.9.x 68 New Unix File System Device SupportIn release 12.0, Sybase introduced the dsync option of the disk init command.

CHAPTER 6 Implement: Making Database Administration Changes69CIS Proxy DatabasesIn 12.0, HA creates databases with names like “__pxy”. As a result,

If Your Version is 11.5, 11.9.x, or 12.0 70 • New Reserved Words• Configuration Parameters• Increased Memory• New Storage for text and image DataChan

CHAPTER 6 Implement: Making Database Administration Changes71sybsystemdbThe sybsystemdb database is used for the spt_values table and two-phase com

viii

If Your Version is 11.5, 11.9.x, or 12.0 72 New Database and Table LimitsThis section covers changes in table and database limits:• Maximum Number of

CHAPTER 6 Implement: Making Database Administration Changes73New Reserved WordsReserved words, or ASE keywords, can only be used by ASE and cannot

If Your Version is 11.5, 11.9.x, or 12.0 74 You must change all object names that contain reserved words before you upgrade. You must also change tho

CHAPTER 6 Implement: Making Database Administration Changes75stack sizeThe default value of the stack size parameter has increased over the last se

If Your Version is 11.5, 11.9.x, or 12.0 76 Increased MemoryASE 12.5 uses more memory than previous releases. ASE now allocates more memory for the d

CHAPTER 6 Implement: Making Database Administration Changes77buildmaster Command ObsoleteASE 12.5 no longer uses the buildmaster command. Instead,

If Your Version is 11.5, 11.9.x, or 12.0 78

79CHAPTER 7Test: Ensuring Stability and PerformanceIn This ChapterThis chapter will help you evaluate testing methods and develop a testing plan. It c

Setting Up the Test Environment 80 • The test and production systems are stable and the data is safe.• The upgrade is successful and does not adverse

CHAPTER 7 Test: Ensuring Stability and Performance81Use backups or the bcp scripts to populate your test databases. Note When you create a new dat

1CHAPTER 1Introduction and Guide to ResourcesIn This ChapterThis chapter gives an overview of the topics covered in this manual. In addition, it point

Prioritizing Applications to be Tested 82 You need to make adjustments when you have less disk space or memory in the test system. Scale down databas

CHAPTER 7 Test: Ensuring Stability and Performance83•A phased cutover is subject to the highest performance expectations. Some performance tuning o

Summary of Testing Techniques 84 Technique Description Advantages DisadvantagesAd hoc testingManually walk through important application processes, s

CHAPTER 7 Test: Ensuring Stability and Performance85Writing Performance ScriptsThis section discusses the basics of writing performance scripts:• W

Writing Performance Scripts 86 • Write code to process result set(s)• Name each transaction explicitly (for example, “begin tran cust_update”) to mak

CHAPTER 7 Test: Ensuring Stability and Performance87Result HandlingYou can capture query results by fetching the entire result set back to the clie

Test Cycle: Summary of Tests 88 Test Cycle: Summary of TestsThis section summarizes a complete test cycle, with tests that target specific issues, in

CHAPTER 7 Test: Ensuring Stability and Performance89Test Cycle: Testing for PerformanceThis section expands on performance benchmarking before and

Test Cycle: Testing for Performance 90 • Data and data distribution problems. Check data layout and be sure that these match the productions system.

CHAPTER 7 Test: Ensuring Stability and Performance91Test System UpgradePerform the upgrade on the test system following the instructions in the ins