Seagate ST43401N/ND Guide d'installation télécharger pdf (Page 144)

Pre-Upgrade Checklist

136

7 Record size and device fragment information for all

databases. You can query the sysdevices and sysusages

tables for this information.

8 Make a note of the default character set and sort

order. See the System Administration Guide at

http://manuals.sybase.com:80/onlinebooks/group-

as/asg1200e/asesag/@Generic__BookView?

for information

about character sets and sort order.

9 Verify that

sybsystemprocs is large enough and that all

device fragments, if there are multiple fragments,

contain both log and data segments. See the section

“sybsystemdb”in Chapter 6, “Implement: Making

Database Administration Changes”.

Just before upgrading, be sure to do the following:

1Set master as the default database for “sa”.

2 If the locations of your error log and configuration

file are not the default locations, change them to the

default location.

3 Back up the following:

• All databases

• NT Devices

• Sybase directory

•(NT) Sybase registry

4 bcp out critical system tables:

• Syslogins

• Sysloginroles

• Sysdatabases

• Sysusages

• Sysdevices

1 2 ... 139 140 141 142 143 144 145 146

Pas de commentaire

Seagate ST43401N/ND Guide d'installation Page 144