Sybase 15.0.2 User Manual download pdf (Page 103)

CHAPTER 5 Upgrading Adaptive Server

Installation Guide 89

isql> alter database dbname on device_name = "2m"

Note In 15.0.2 Adaptive Server, alter database allows you to specify the

size to alter the database with the unit-specifier ‘m’, or ‘M’.

1 2 ... 98 99 100 101 102 103 104 105 106 107 108 ... 159 160

Adaptive Server 1
Enterprise 1
35890-01-1502-01 2
April 2007 2
Contents 3
Installation Guide v 5
About This Book 7
Related documents 8
Adaptive Server Enterprise 10
About This Book 11
Adaptive Server Enterprise 12
Product components 17
Backup Server 18
Adaptive Server editions 19
Enterprise Edition 20
Small Business Edition 20
Developer Edition 21
CHAPTER 1 Overview 23
Installing Adaptive Server 27
System requirements 28
Accessing SPDC 30
Getting your host ID 31
Generating licenses at SPDC 32
Generating a served license 33
Installation Guide 21 35
Installation Guide 25 39
Installing server components 41
Installation Guide 31 45
Installation Guide 33 47
Backing up Adaptive Server 50
Installation Guide 37 51
Post-Installation Tasks 53
The SAMreport 57
Installing sample databases 58
Installing Sybase PC-Client 63
Products 63
Installing PC-Client products 64
InfoMaker 67
Upgrading Adaptive Server 73
Installation Guide 61 75
Pre-upgrade tasks 76
Installation Guide 63 77
Reserved words 78
Running a reserved word check 79
Using quoted identifiers 80
Create a sybsystemdb database 81
Upgrading the server 83
Post-upgrade tasks 85
Installation Guide 73 87
Reenabling Replication Server 88
Reenabling replication 89
Reenabling auditing 91
Shutting down SySAM servers 92
Upgrading Job Scheduler 93
Upgrading high availability 98
Method #1: Dump and 100
Installation Guide 89 103
Troubleshooting SySAM Issues 105
Troubleshooting SySAM 107
SySAM grace mode 112
SySAM grace period 113
Troubleshooting 115
Overview 116
Error log locations 117
The Installer fails to start 118
CHAPTER 7 Troubleshooting 119
Restoring from backup 120
Re-running the upgrade 121
program 122
Reserved word errors 125
Quoted identifier errors 125
Temporary table references 126
Using dbcc upgrade_object 127
Error reporting 130
Upgrading using dump and load 130
Removing Adaptive Server 133
Removing an old server 134
Installation Guide 121 135
Alternative Installation 137
Silent installation 138
Installation Guide 125 139
Installation Guide 127 141
Resource file variables 142
Running the sybatch utility 143
Upgrading Servers with 145
Replicated Databases 145
1> dbcc gettrunc 146
2> go 146
Using sybsystemprocs 151

Comments to this Manuals

No comments

Sybase 15.0.2 User Manual Page 103

Comments to this Manuals

Related products and manuals for Computers Sybase 15.0.2