sp_helpdevice reports whether or not a device is private. If the device is private, sp_helpdevice prints the name of the instance in the cluster that owns the private device.
In this example, 'regular_dev'is
a regular shareable device, while 'private_dev1' is
a private device owned by instance 'cluster1_1'.
1> sp_helpdevice 2> go device_name physical_name description status cntrltype vdevno vpn_low vpn_high ------------------------ ---------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------ --------- ----------- ----------- ----------- master /remote/percy_dev/user1/sdc-DBs/master.dat file system device, special, dsync on, directio off, default disk, physical disk, 512.00 MB, Free: 351.00 MB 3 0 0 0 262143 private_dev1 /percy_dev/user1/sdc-DBs/private_dev1.dat file system device, special, private 'cluster1_1', MIRROR DISABLED, non serial writes, dsync off, directio on, physical disk, 2.00 MB 2050 0 1 0 1023 regular_dev1 /percy_dev/user1/sdc-DBs/dev1.dat file system device, special, dsync off, directio on, physical disk, 2.0 0 MB 2 0 2 0 1023 tapedump1 /dev/nst0 unknown device type, disk, dump device 16 2 0 0 20000 tapedump2 /dev/nst1 unknown device type, tape, 625 MB, dump device 16 3 0 0 20000(5 rows affected) (return status = 0)
If disk refit is pending on a device, sp_helpdevice reflects it in its output.
In this example,'regular_dev' is
a regular shareable device, while 'private_dev1' and 'private_dev2' are
private devices owned by instance 'cluster1_l'.
Further disk refit is pending on 'private_dev1'.
1> sp_helpdevice 2> go device_name physical_name description status cntrltype vdevno vpn_low vpn_high ------------------------ ---------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------ --------- ----------- ----------- ----------- master /remote/percy_dev/user1/sdc-DBs/master.dat file system device, special, dsync on, directio off, default disk, physical disk, 512.00 MB, Free: 351.00 MB 3 0 0 0 262143 private_dev1 /percy_dev/user1/sdc-DBs/private_dev1.dat file system device, special, private 'cluster1_1', REFIT PENDING, MIRROR DISABLED, nonserial writes, dsync off, directio on, physical disk, 2.00 MB 2050 0 1 0 1023 private_dev2 /percy_dev/user1/sdc-DBs/private_dev2.dat file system device, special, private 'cluster1_1', MIRROR DISABLED, non serial writes, dsync off, directio on, physical disk, 2.00 MB 2050 0 3 0 1023 regular_dev1 /percy_dev/user1/sdc-DBs/dev1.dat file system device, special, dsync off, directio on, physical disk, 2.00 MB 2 0 2 0 1023 tapedump1 /dev/nst0 unknown device type, disk, dump device 16 2 0 0 20000 tapedump2 /dev/nst1 unknown device type, tape, 625 MB, dump device 16 3 0 0 20000(6 rows affected) (return status = 0)
