Seagate ST43401N/ND Guida di Installazione Scaricare il pdf (Pagina 79)

CHAPTER 6 Implement: Making Database Administration Changes

sybsystemdb

The sybsystemdb database is used for the spt_values table and two-phase

commits. Before ASE 12.5, this database was not required. The database is

automatically created on the master device by the configuration utility.

Because this database may have a lot of activity and use a lot of log space, we

strongly recommended that you create

sybsystemdb on another device prior to

upgrade or move it to another device after upgrade. This protects the master

device in case the

sybsystemdb log fills up.

If you will not use the features that require this database, you can keep it at the

minimum size.

Changes to System Tables

There are no new system tables in ASE 12.5. However, two types of changes

could cause trouble if you do not adjust your scripts to account for them:

• Additional columns in some system tables

• Change to larger datatypes in some columns

If you have scripts that refer to system tables, make appropriate changes.

BCP with syslogins

If you try to bcp data into the syslogins system table from an earlier version of

the server,

bcp will fail. This is because in 12.0 and 12.5, two additional

columns were added to

syslogins. If you need to bcp into syslogins, you can

work around the problem by creating a dummy table to hold the data, altering

the table to add two columns, and then copying the data into the 12.5

syslogins.

Note This issue could occur with other system tables that have added columns.

You might encounter the problem first with

syslogins if you need to copy this

data as part of the upgrade.

See

What’s New in Adaptive Server Enterprise at

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

as/asg1250e/whatsnew/@Generic__BookView

for changes to system tables in

ASE 12.0 and 12.5.

1 2 ... 74 75 76 77 78 79 80 81 82 83 84 ... 145 146

Nessun commento

Seagate ST43401N/ND Guida di Installazione Pagina 79