Seagate ST43401N/ND Installation Guide download pdf (Page 68)

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

Wide Columns with col_length() and datalength()

The commands col_length() and datalength() are “built-in” Transact-SQL

functions that return database information. These functions can now return

values greater than 225. If you use one of these functions in a query and assign

the result to a variable, be sure to make the variable large enough to hold the

value.

1 2 ... 63 64 65 66 67 68 69 70 71 72 73 ... 145 146

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

Comments to this Manuals

No comments

Seagate ST43401N/ND Installation Guide Page 68

Comments to this Manuals

Related products and manuals for Database software Seagate ST43401N/ND