sp_helpdb  sp_helpextendedproc

Chapter 1: System Procedures

sp_helpdevice

Description

Reports information about a particular device or about all Adaptive Server database devices and dump devices.

Syntax

sp_helpdevice [devname]

Parameters

devname

is the name of the device about which to report information. If you omit this parameter, sp_helpdevice reports on all devices.

Examples

Example 1

Displays information about all the devices on Adaptive Server:

sp_helpdevice
device_name   physical_name                 description            
-----------   --------------                ------------           
tapedump1     /dev/rmt4                     disk, dump device         16

tapedump2     /dev/rst0                     tape, 625MB, dump device   3

master       /work2/Devices/mart8K.dat      special, dsync on, 
     directio off,     defaultdisk, physical disk, 250.00MB

pubs_2_dev   /work2/Devices/pubs_2_dev.dat  special, dsync on, 
     directio off, physical disk, 10.00MB

status    cntrltype    vdevno    vpn_low    vpn_high
------    ---------    ------    -------    --------
    16            2         0          0       20000
    16            3         0          0       20000
     3            0         0          0      127999
 16386            0         1          0        5119
(4 rows affected)

Example 2

Reports information about the dump device named diskdump:

sp_helpdevice diskdump

Usage

Permissions

Any user can execute sp_helpdevice.

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

Commands disk init, dump database, dump transaction, load database, load transaction

System procedures sp_addumpdevice, sp_deviceattr, sp_diskdefault, sp_dropdevice, sp_logdevice





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

View this book as PDF