Seagate ST43401N/ND manuals

Seagate ST43401N/ND Installation Guide (146 pages)

Brand: Seagate | Category: Database software | Size: 1.78 MB |

English

Table of contents

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

Seagate ST43401N/ND Technical Information (172 pages)

Brand: Seagate | Category: Database software | Size: 0.40 MB |

English

Table of contents

Migrating to Sybase®

1

Table of Contents

5

A. The Cyrano Migration Pack

9

E. Migration Plan Checklist

12

List of Tables

13

Introduction and Guide to

15

Resources 1

15

Chapter Title Contents

16

Technical Information Library

18

Migration Web Page

19

Migration Courses

19

Sybase Press Books

20

Third-Party Books

20

Consulting Services

20

Third-Party Tools

21

If You Need Help

21

Analyze: Documenting Business

23

Requirements 2

23

Acme Brokerage Company

24

System Architecture

24

Availability Requirements

25

Database Change Metrics

25

Maintenance Procedures

26

Service Level Requirements

27

Current Performance Metrics

28

• Vendor issues

30

Analyze: Documenting Your

31

Environment 3

31

CPU Resources per Machine

32

Disk Conﬁguration

32

Network Conﬁguration

34

Tape Conﬁguration

34

Physical Memory Utilization

35

Software Conﬁguration

36

Sybase Conﬁguration

37

SQL Server Objects

40

If You Don’t Have Scripts

41

Ready to Migrate 4

43

Parallel With Replication

45

Cutover Without Replication

47

Phased Cutover

49

Write a Migration Plan

50

Update Hardware Resources

51

Create Migration Scripts

52

Implement: Making Required

55

Application Changes 5

55

Datatype Changes

57

Table 5-3: Datatype hierarchy

59

Name Hierarchy

59

Subquery Processing Changes

62

NULL Algodata Infosystems

64

NULL New Age Books

67

Binnet & Hardley

67

Algodata Infosystems

67

250 no rows returned

68

Enterprise 11.5

73

Login and Password Changes

82

RUN File Renamed

83

New create table Permission

84

New Backup Server

85

Last Chance Threshold

85

Reference Supplement

86

Conﬁguration Interface

88

Old Name New Name

89

Databases Online / Ofﬂine

90

Increased Memory Requirements

92

Figure 6-1: Areas of memory

93

4.x 125%

96

10.x 50%

96

11.0.x 25%

96

Optional Space Considerations

98

Test: Ensuring Stability and

101

Performance 7

101

Make Backups

102

Summary of Testing Techniques

104

• Production load capture

105

Writing Performance Scripts

106

Test Cycle: Summary of Tests

109

Stage Purpose Best Technique

110

Pre-Upgrade Single-User Tests

111

Pre-Upgrade Multi-User Tests

111

Test System Upgrade

112

Post-Upgrade Multi-User Tests

113

The Cyrano Migration Pack A

115

For More Information

117

A-4 The Cyrano Migration Pack

118

Worksheets for Your Current

119

Environment B

119

Backup and Restore Procedures

121

Database Dump Details

122

Data Architecture Worksheet

124

Transaction Proﬁle

126

Host Conﬁguration

127

Record CPU resources:

128

Physical Memory Usage

129

Operating System Conﬁguration

134

Detail the operating system

134

SQL Server Conﬁguration

135

Table B-18: dbcc output

136

Usage MB 2K Pages Bytes

136

Database Devices

137

Databases and Segments

138

Dump Devices

139

Migration Approach Outline

141

In This Appendix

145

Sample Task List Template

145

Migration Analysis

146

Migration Preparation

147

Migration Quality Assurance

151

Set Up Replication Server

154

Run Regression Test Suites

154

Perform Final Steps

156

Staged Cutover Task Overview

161

Migration Plan Checklist E

163

Logical Support Architecture

165

Migration Strategy Design

165

E-4 Migration Plan Checklist

166

ST973401SS - Savvio 73.4 GB Hard Drive User Manual English

English

OLTP performance comparison: Solid-state drives vs. hard disk drives, 16 pages

Seagate devices