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:

1> sp_helpdevice
2> go
device_name physical_name         description
         status cntrltype vdevno       vpn_low         vpn_high
----------- --------------------- ----------------------------------------
         ------ --------- ----------- ----------- -----------
dev1        d:\sybdata\RV150.dev1 special, dsync off, directio on, physical
disk, 150.00 MB, Free: 0.00 MB
             2         0         2         0         76799 dev2        d:\sybdata\RV150.dev2 special, dsync on, directio off, physical
disk, 150.00 MB, Free: 130.00 MB
         16386         0         3         0         76799 master      d:\sybdata\RV150.mas  special, dsync on, directio off, default
disk, physical disk, 30.00 MB, Free: 0.50 MB
             3         0         0         0         15359
sysprocsdev d:\sybdata\RV150.ssp  special, dsync on, directio off, physical
disk, 120.00 MB, Free: 0.00 MB
         16386         0         1         0         61439
tapedump1  \\.\TAPE0             disk, dump device
            16         2         0         0         20000
tapedump2   \\.\TAPE1             tape,        625 MB, dump device            16         3         0         0         20000

(6 rows affected, return status = 0)

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