Unused space

Hoosbruin · *nix forums beginner Joined: 21 Oct 2005 Posts: 2

I recently added another data device 200mb

disk init name="disk_dev_4", physname="<SYBASE_ROOT>\data\disk_dev_4" ,
vdevno=4,size=102400;

alter database dbmods on disk_dev_4=200;

I can see the space was increased with sp_spacesused db size increased but
why don't I see a greater unused column. The database was only 75mb before.

Is there some other command the will show me the this ?

Thanks

Michael Peppler · *nix forums Guru Wannabe Joined: 15 May 2005 Posts: 112

On Tue, 18 Jul 2006 20:46:58 -0400, Hoosbruin wrote:

Google