disk refit

Rebuilds the master database’s sysusages and sysdatabases system tables from information contained in sysdevices.

Syntax

disk refit

Usage

The SAP ASE server automatically shuts down after disk refit rebuilds the system tables.

Use disk refit after disk reinit as part of the procedure to restore the master database.

Note: You must start the SAP ASE server with trace flag 3608 before you run disk refit. However, make sure you read the information in the Troubleshooting and Error Messages Guide before you start the SAP ASE server with any trace flag.
See also:
  • System Administration Guide.

  • sp_addumpdevice, sp_helpdevice in Reference Manual: Procedures

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

The permission checks for disk refit differ based on your granular permissions settings. You must be using the master database to use disk refit.

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage disk privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

disk refit permission is not transferable.

Auditing

Values in event and extrainfo columns of sysaudits are:

InformationValues
Event

21

Audit option

disk

Command or access audited

disk refit

Information in extrainfo
  • Roles – current active roles

  • Keywords or optionsdisk refit

  • Previous value – NULL

  • Current value – NULL

  • Other information – Name of the disk

  • Proxy information – original login name, if set proxy is in effect

Related reference
disk reinit
disk init