Seagate ST43401N/ND Guía de instalación Pagina 35
- Pagina / 146
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
CHAPTER 4 Plan: Writing a Plan and Getting Ready to Migrate
27
Special Cases: Migrating to 64-bit Operating System or Larger Page
Size
As of release 11.9.3, Adaptive Server runs on 64-bit operating systems. As of
12.5, ASE allows you to create a server that uses a logical page size larger than
2K in order to store more data per page. These changes are described in
What’s
New in Adaptive Server Enterprise at
http://manuals.sybase.com:80/onlinebooks/group-
as/asg1250e/whatsnew/@Generic__BookView
and the Performance and Tuning
Guide at http://manuals.sybase.com:80/onlinebooks/group-
as/asg1250e/perf/@Generic__BookView
.
If you wish to take advantage of these changes, you need to select the
appropriate migration method. These are the options currently available:
Type of
migration
Methods/tools available
Pre-12.5 32-bit
server to 12.5
64-bit server
You can use the sqlupgrade utility.
Note You can use the sqlupgrade utility only when you are
changing release levels. You cannot use it just to move from
a 32-bit to a 64-bit system.
12.5 32-bit
system to 12.5
64-bit system
Create a new 12.5 installation and use bcp or dump and load
to move data into the new server. You can also manually
replace the binary to change to a 64-bit system. See the
installation guide at
http://manuals.sybase.com:80/onlinebooks/group-
as/asp1250e/@Generic__CollectionView;pt=asp1250e
for
instructions.
Pre-12.5 2K
page server to
4K, 8K, or 16K
server
As of the release of this manual, an upgrade to a larger page
size is not supported. You need to rebuild the system using
the instructions for 32-bit to 64-bit migration in the
installation guide at
http://manuals.sybase.com:80/onlinebooks/group-
as/asp1250e/@Generic__CollectionView;pt=asp1250e
.
Watch the
ASE Migration Resources Web page at
http://sybase.com/support/techdocs/migration
for
developments on tools to aid data migration to larger page
size.
- Migrating to Adaptive Server 1
- Enterprise 12.5 1
- 34982-01-1250-01 2
- Oct 2001 2
- Contents 3
- Introduction and Guide to 9
- Resources 9
- Other Sources of Information 11
- Migration Web Page 13
- Consulting Services 13
- If You Need Help 14
- Requirements 15
- Diagramming the System 16
- Availability Requirements 17
- Database Change Metrics 18
- Maintenance Procedures 18
- Service Level Requirements 19
- Current Performance Metrics 20
- Analyze: Documenting Your 23
- General Server Hardware 24
- CPU Resources per Machine 24
- Disk Configuration 24
- Physical Memory Utilization 26
- Software Configuration 27
- Sybase Configuration 28
- General Information 29
- Adaptive Server Objects 31
- Query Sybase System Tables 32
- Use System Stored Procedures 32
- Use Sybase Tools 32
- Ready to Migrate 33
- Review the Upgrade Process 34
- Determine Migration Approach 36
- Parallel With Replication 37
- Cutover Without Replication 39
- Phased Cutover 41
- Write a Migration Plan 43
- Update Hardware Resources 44
- Products 45
- Create Migration Scripts 46
- Implement: Making Required 47
- Application Changes 47
- If Your Version is 11.5 48
- Changes to Error Checking 50
- Changes in Error Numbers 51
- New and Changed Statistics 54
- Aggregate Optimization 56
- Costing Large I/O 56
- The optdiag Utility 56
- Trace Flag 302 56
- ANSI Joins 58
- 12.0 Query Processing Changes 60
- 50 Tables in a Query 61
- Abstract Query Plans 61
- Increased Optimization Time 62
- Changes to Transact-SQL 63
- New Reserved Words 64
- Change in Truncation Behavior 66
- Administration Changes 69
- Implement: Making Database 69
- Optimizer Changes 71
- Trace Flag 326 72
- Documentation Changes 73
- Backup Server 73
- Network Connections 74
- File Descriptors 74
- Non-Rewinding Tapes 74
- Starting Backup Server 74
- Dump Format 75
- Changes to dbids 76
- CIS Proxy Databases 77
- The sybsyntax Utility 77
- Changes to Documentation 78
- System Database Sizes 78
- Changes to System Tables 79
- New Database and Table Limits 80
- Configuration Parameters 82
- 86016 (84K) - 64-bit 83
- Increased Memory 84
- Test: Ensuring Stability and 87
- Performance 87
- Make Backups 88
- Summary of Testing Techniques 91
- Writing Performance Scripts 93
- General Error Handling 94
- Deadlock Handling 94
- Result Handling 95
- Time Measurement 95
- Runtime Data Generation 95
- Test Cycle: Summary of Tests 96
- Pre-Upgrade Single-User Tests 97
- Pre-Upgrade Multi-User Tests 98
- Test System Upgrade 99
- Post-Upgrade Multi-User Tests 99
- Untimed Benchmarks 100
- Timed Benchmarks 100
- Worksheets for Your Current 101
- Environment 101
- Backup and Restore Procedures 102
- Database Dump Details 103
- Data Architecture Worksheet 105
- Transaction Profile 107
- Host Configuration 109
- Physical Memory Usage 110
- Disk I/O Configuration 111
- Network Configuration 113
- Tape Configuration 114
- Adaptive Server Configuration 115
- Database Devices 116
- Databases and Segments 117
- Dump Devices 118
- Sample Migration Task Lists 119
- Migration Analysis 120
- Gather Business Requirements 121
- Develop Migration Strategy 121
- Migration Preparation 122
- Create Target Environment 123
- Perform Server Migration 124
- Perform Database Migration 124
- Perform Data Migration 124
- Perform Application Migration 124
- Upgrade Adaptive Server 125
- Complete Migration 125
- Migration Quality Assurance 126
- Perform User Acceptance Tests 127
- Set Up Replication Server 129
- Run Regression Test Suites 129
- Upgrade Server B (Shadow) 130
- Other Testing 131
- Perform Final Steps 132
- Staged Cutover Task Overview 137
- Migration Issue Checklists 139
- Logical Support Architecture 141
- Migration Strategy Design 142
- Pre-Upgrade Checklist 143
- .cfg) file 145
Relacionado con productos y manuales para Software de base de Seagate ST43401N/ND
(172 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.043 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales