sp_depends  sp_diskdefault

Chapter 1: System Procedures

sp_deviceattr

Description

UNIX platforms only Changes the device parameter settings of an existing database device file.

Syntax

sp_deviceattr  logicalname, optname, optvalue

Parameters

logicalname

is the logical name of an existing database device. The device can be stored on either an operating system file or a raw partition, but the dsync setting is ignored for raw partitions.

optname

name of the attribute to change. Valid values are directio or dsync:

optvalue

can be either “true” or “false.”

Examples

Example 1

Sets dsync on for the device named “file_device1”:

sp_deviceattr file_device1, dsync, true

Usage

Permissions

The user executing sp_deviceattr must have permission to update the sysdevices table.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

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

See also

System procedures sp_helpdevice





Copyright © 2005. Sybase Inc. All rights reserved. sp_diskdefault

View this book as PDF