Redimensionar Device no Sybase

Um Device no Sybase pode ser aumentado, mas não reduzido.

[sybase@nerv00 ~]$ isql -SNERV00 -Usa -w999 -PNerv2011
1> sp_helpdevice users_disk_01
2> GO
device_name physical_name description status cntrltype vdevno vpn_low vpn_high
-------------------------- -------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ ------------------ ------------ -------------- ----------------
users_disk_01 /opt/sybase/data/users_disk_01.dat file system device, special, dsync off, directio on, default disk, physical disk, 1024.00 MB, Free: 1020.00 MB 3 0 5 0 524287
(1 row affected)
dbname size allocated vstart lstart
------------ -------------------------- -------------------------------------- ------------ ------------
pubs3 4.00 MB Apr 28 2011 4:35PM 0 0
(1 row affected)
(return status = 0)
1> disk resize name = "users_disk_01", size = "1G"
2> GO
1> sp_helpdevice users_disk_01
2> GO
device_name physical_name description status cntrltype vdevno vpn_low vpn_high
-------------------------- -------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ ------------------ ------------ -------------- ----------------
users_disk_01 /opt/sybase/data/users_disk_01.dat file system device, special, dsync off, directio on, default disk, physical disk, 2048.00 MB, Free: 2044.00 MB 3 0 5 0 1048575
(1 row affected)
dbname size allocated vstart lstart
------------ -------------------------- -------------------------------------- ------------ ------------
pubs3 4.00 MB Apr 28 2011 4:35PM 0 0
(1 row affected)
(return status = 0)
1>

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.