Properties

Device Number	9
Physical File Name	/dev/rdsk/c9t4d0s3
Is Default Device	No
Is Physical Disk	Yes
Is Logical Disk	No
Is Mirrored	No
Physical Mirror Name

Size

Device Size

1000.00 MB

Space Used

1000.00 MB

Space Free

0.00 MB

Database Fragments

Database Name	Size	Database Usage
icsa_tmp	500	data only
udf	100	data only
publications	10	data only
speval	390	data only

DDL

USE master
go
DISK INIT
    NAME='data_dev5',
    PHYSNAME='/dev/rdsk/c9t4d0s3',
    VDEVNO=9,
    SIZE=512000,
    VSTART=0,
    CNTRLTYPE=0
go
EXEC sp_diskdefault 'data_dev5',defaultoff
go