disk resize syntax  Specifying a logical device name with disk resize

Chapter 7: Initializing Database Devices

Disk resize example

For example, the configuration of the device testdev from isql:

sp_helpdevice testdev
device_name  physical_name          description
  status  cntrltype  vdevno          vpn_low           vpn_high
-----------  -------------------    -------------
  ------- ---------  -------------   -------------     --------------
testdev      /sybase/dev/testdev.dat   special, dsync on, directio off, physical disk, 10.00MB   16386    0           1                     0              5119

To increase the size of testdev by 4MB using disk resize, enter:

disk resize 
name = "test_dev", 
size = "4M"

testdev.dat is now 14MB:

sp_helpdevice testdev
device_name  physical_name          description
  status  cntrltype  vdevno          vpn_low           vpn_high
-----------  -------------------    -------------
  ------- ---------  -------------   -------------     --------------
testdev      /sybase/dev/testdev.dat   special, dsync on, directio off, physical disk, 14.00MB   
  16386           0         1          0                  7167




Copyright © 2005. Sybase Inc. All rights reserved. Specifying a logical device name with disk resize

View this book as PDF