UNIX file system free space, used space, total spaceAnyone have an idea about getting UNIX file system free space, used space,
total space numbers without having to resort to something like the following
( which gets the percent of used space for a command-line supplied file
system name stored in the variable ${file_sys} ):
$per_used = `df -k | grep " ${file_sys}\$" | awk '{print \$5}'`;
> Anthony (Tony) Esposito
> Senior Technical Consultant
> Inovis(tm), formerly Harbinger and Extricity
> 2425 N. Central Expressway, Suite 900
> Richardson, TX 75080
> (972) 643-3115
> tony.esposito@ino...
space restriction (negative space in use)I have NW6.0 SP4 and have space restriction enabled on NSS volume. The
"space in use column" show negative numbers, any ideas how to fix this
issue? Thanks.
TID10074366 ?
Cheers Dave
--
Dave Parkes [NSCS]
Occasionally resident at http://support-forums.novell.com/
Dave Parkes wrote:
> 10074366
This TID takes me to
http://www.novell.com/coolsolutions/netware/qna/nss.html
There is a link "Wierd NSS Stats" which tells me to click on a link to
10074366. That link tells me:
The document /10074366.htm is no longer available at support.novell...
Great gap between Est. Temp Space Used and Act. Temp Space UsedHi all,
I have a question about the Est. Temp Space Used and Act. Temp Space Used,
from the query plan, I found the estimated temp space is 200% of the actual
temp space
Est. Temp Space Used (Mb) 4722.6
Act. Temp Space Used (Mb) 1948.6
This make it difficult to set QUERY_TEMP_SPACE_LIMIT as the resources is
very tight, do you have any idea to make the estimation of the temp space
used more accurate?
Version: 12.7.0/080707/P/ESD 5/MS/Windows 2003/64bit
Keith Ma wrote:
> Hi all,
>
> I have a question about the Est. Temp Space Used and Act. Temp Space Use...
Space in Use Negative with Space RestrictionsUsing Console 1.3.6 I seem to get quite a few users who have a Space in Use statistic with a negative value therefore allowing them to save a lot more info in their home directories than the restriction should allow.
Is there an issue in Console One or is it that the space restrictions on the volume are not working properly?
Thanks for any enlightenment on this subject.
Ben.
-----------------------------------------------------------------------------------------
Ben Davis - Computer Systems Manager
Christian Outreach College Brisbane
email: ben@brisbane.coc.edu.au
WWW: http://www....
Space used by tableHi,
Does anyone have script to get the total space used by each table and which
does not prvide header details?
I basically want something like
table 1 rows space
table 2 rows space
I need to be able to manipulate through SQL.
The ASE 12.5.3. db is on windows.
My thanks in advance for any assistance you may be able to provide.
Puvendran
Grab a copy of the source code for the sp_spaceused stored proc, figure out how it calculates space usage numbers, then
cut-n-paste-n-mutilate the appropriate parts from sp_spa...
space used by a table
When creating a clustered index, from the reference manual:
"To create a clustered index, Adaptive Server duplicates the existing data;
the server deletes the original data when the index is complete. Before
creating a clustered index, use sp_spaceused to make sure that the
database has at least 120 percent of the size of the table available as free
space."
However, which space is the "size" of the table? Is it data, or data + reserved
when accounting for free space on the database to allow a successful 'create clustered index' ?
Jesus M. Salvo Jr...
Line spacing, word spacing, char spacing
I already found out line , word and char spacing are not foreseen in GDI+.According to some websites, the MeasureString method does not work the way it should. (which I could use to manually change the X/Y positions etc.)Does anyone know of a component that will do the trick?And preferrably not one that will cost me hundreds of euros :)All I want to do is put some text on an image ...The only problem being is that line, word and char spacing are strict requirement.Seems easy, but I'm quite desperate so thank you for your early reply....
How do I Move a table to another table space ASA 9.02.3207 reclaim unused spaceWithout doing an unload reload is there a utility to move a table to another
table space?
How do I recover unused space from a table space?
Thanks.
Additionally, is there a setting to automatically over flow the system table
space to another space at a particular size?
I have noticed when a table space get above 30 Gb the Server becomes very
sluggish even though there are many tables that make up the table space.
"Gordon Johnson" <gjohnson@intellimed.com> wrote in message
news:4372c019$1@forums-2-dub...
> Without doing an unload reload is the...
Determine space used by a table and indexHi all,
i try to determine the space used by a table incl. its index space. I find
the pagecnt column in systabstats and know about the pagesize of 2K. So
memory used by data (or clustered index) can derive by (pagecnt x
pagesize).
But I do not know how to derive information about (non-clustered) indices
and the space reserved (not used by any data/index).
Thanks all
Use the sp_spaceused stored procedure, it can break out the usage
by index.
-bret
Thomas_H wrote:
>
> Hi all,
>
> i try to determine the space used by a table incl. its index space. I find...
How much disk space is a table using?How can I find out how much disk space a table is really using in SQL
Anywhere?
Thank you, Mark
One way to do this is to run "dbinfo -u -c <connection-parms>"
which will tell you how many pages are used to hold the data in
each table in your database, and the %used in those pages.
Multiply the number of pages by your page size time %used and that
tells use how much space is being used to hold your table data.
Read more about dbinfo at
http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1100en%2Fdbadmin_en11%2Fdbinfo.html%23d4e42186
--
Mark Culp
SQL...
Table in a DB space is corrupt (corrupt page). Reload only DB space ???Hi,
My question:
In case of an invalid corrupt table in a DB space (corrupt page). Have
I to rebuild the complete database or is it sufficient to reload only
the effected DB space?
Thanks, Carsten
SQL Anywhere has no mechanism to repair a single page or table. I would
restore from a backup and reapply the transaction logs.
Glenn
PleaseDoNotReply@elomagic.de wrote:
> Hi,
> My question:
> In case of an invalid corrupt table in a DB space (corrupt page). Have
> I to rebuild the complete database or is it sufficient to reload only
> the effected DB space?
>...
Using Regular Expression Validator for removing consecutive white spaces with single white space
Hi
I had a textbox feild in which I want to remove consecutive white spaces with single white spaces from beginning,end and middle of text
and I want to use Regular Expression Validator to do this
Looking out for some Help
Kartik
Hi,Regular Expression Validator will not remove the space.It will throw a client side validation.To remove space use Trim method on server side.Virendra (MCTS)My Site, Blog
Hi!
If you want to do it on server side then following is the vb.net code:
Imports System.Text.RegularExpressions
-----------------------------------------Dim r As Regex = New Reg...
I can't move a table from system dp space to another db space!help me ,thanks!
"strong" <nie.cs@163.net> wrote:
>help me ,thanks!
Unfortunately, ALTER TABLE doesn't let you change the dbspace name.
However, you can use ALTER TABLE to rename the current table, CREATE
TABLE to create a new table with the old name in the other dbspace,
INSERT INTO with SELECT to copy rows from the current table to the new
table, and then DROP TABLE to get rid of the current table.
Breck
You might want to consider rebuilding the database then. Use DBUNLOAD or
Sybase Central to unload the database and the structure. Once that ...
How can I know disk space used by a table and an index?How can I know disk space used by a table and an index?
ASE 11.9.2
TIA
sp_spaceused <tablename>
gives ballpark sizes for data and index. Update stats
updates this information but it is also updated periodically
as it grows as well.
HTH
Meg
> How can I know disk space used by a table and an index?
>
> ASE 11.9.2
>
> TIA
>
>
sp_spaceused <table_name> [ ,1 ]
The ',1' option will give you a breakdown by index.
Without the ',1' option all index space usage is rolled up into a single
number.
Manuel Esp...