Home

	Expand Search

Installation Guide Adaptive Server Enterprise for IBM RISC System/6000 AIX

Chapter 8 Upgrading Sybase Servers

Pre-upgrade tasks

Turn off database options

Turn off database options

To turn off database options:

1. Run sp_helpdb to show the options that are set for each database.

2. Use sp_dboption and the results from sp_helpdb to turn off all options except select into/bulk copy on tempdb.

   For example, to turn off the trunc log on chkpt database option, enter:

   sp_dboption sybsystemprocs, 'trunc log on chkpt', false

   Turn off the trunc log on chkpt database option to avoid upgrade failure.

For more information about using these system procedures, see the Reference Manual.

The database options for master cannot be changed and are not disabled.

To upgrade a server that contains a database in which auditing is activated, make sure that auditing is disabled before starting the upgrade:

1. Turn off auditing before upgrading.

   1. Verify that all Adaptive Server users are logged off.

   2. Disable auditing with the following Transact-SQL command:

      sp_auditoption 'enable auditing', 'off'

2. Record system procedure audit options before upgrading.

   When upgrading, all previous versions of system procedures are overwritten when sybsystemprocs is populated. Record the audit options for all system procedures. After the upgrade is complete, shut down and restart the server. Reenable auditing using:

   sp_configure auditing, 1

   You can reenter the audit options, using sp_audit. For more information, see the System Administration Guide.

Use the disk unmirror command to disable disk mirroring for your current Adaptive Server. For more information about this command, see the Reference Manual.