|
|
|
|
|
|
| Author |
Message |
Michael Peppler *nix forums Guru Wannabe
Joined: 15 May 2005
Posts: 112
|
Posted: Wed Jul 19, 2006 5:01 pm Post subject:
Re: Unused space
|
|
|
On Tue, 18 Jul 2006 20:46:58 -0400, Hoosbruin wrote:
| Quote: | 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.
|
The unused space shown by sp_spaceused is the space that has been
allocated to tables or indexes, but is not yet used. It is NOT the amount
of free space in the database.
To see the amount of free space you can use sp_helpdb <dbname>
Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html |
|
| Back to top |
|
 |
Hoosbruin *nix forums beginner
Joined: 21 Oct 2005
Posts: 2
|
Posted: Wed Jul 19, 2006 12:46 am Post subject:
Unused space
|
|
|
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 |
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|
|
The time now is Sat Nov 22, 2008 12:27 am | All times are GMT
|
|
Credit Card | Credit Cards | Proxy | Free Ipod Nano | 0 Credit Cards
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|