Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database space Alert

4 posts in General Discussion Last posting was on 2009-07-01 15:46:46.0Z
Rajasekhar Reddy Posted on 2009-06-23 23:58:47.0Z
Sender: 6938.4a402219.1804289383@sybase.com
From: Rajasekhar Reddy
Newsgroups: sybase.public.ase.general
Subject: Database space Alert
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a416c37.6ce8.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 23 Jun 2009 16:58:47 -0700
X-Trace: forums-3-dub.sybase.com 1245801527 10.22.241.188 (23 Jun 2009 16:58:47 -0700)
X-Original-Trace: 23 Jun 2009 16:58:47 -0700, forums-3-dub.sybase.com
Lines: 12
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27913
Article PK: 77161

Hello,
ASE Server is generating space warning messages in
errorlog almost everyday as my database used space is over
95%. I have disabled our own threshold procedures. I think
we can disbale system one as well with "no free space
acctng".But I dont want to do it.

I just want to know when AND how frequently the server
generates this alert ? Bcoz I can see this warning message
early time everyday.

Thanks in advance.


ThanksButNo Posted on 2009-06-26 14:10:08.0Z
From: ThanksButNo <no.no.thanks@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Database space Alert
Date: Fri, 26 Jun 2009 07:10:08 -0700 (PDT)
Organization: http://groups.google.com
Lines: 28
Message-ID: <4567b66c-0346-4307-b927-5d06edf52dbf@j9g2000vbp.googlegroups.com>
References: <4a416c37.6ce8.1681692777@sybase.com>
NNTP-Posting-Host: 71.165.35.183
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1246025408 12925 127.0.0.1 (26 Jun 2009 14:10:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 26 Jun 2009 14:10:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: j9g2000vbp.googlegroups.com; posting-host=71.165.35.183; posting-account=wjKAPwoAAABtEbTff5o9OO7GYdigbDts
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.11) Gecko/2009060215 Firefox/3.0.11 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!nlpi057.nbdc.sbc.com!prodigy.net!news.glorb.com!news2.glorb.com!postnews.google.com!j9g2000vbp.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27922
Article PK: 77169


On Jun 23, 4:58 pm, Rajasekhar Reddy wrote:
> Hello,
>    ASE Server is generating space warning messages in
> errorlog almost everyday as my database used space is over
> 95%. I have disabled our own threshold procedures. I think
> we can disbale system one as well with "no free space
> acctng".But I dont want to do it.
>
> I just want to know when AND how frequently the server
> generates this alert ? Bcoz I can see this warning message
> early time everyday.
>
> Thanks in advance.

You mean, you don't want advice on how to use LESS space?

You just want to know how often it generates the alert?

As opposed to, say, reclaiming wasted space? Or, say,
dropping tables that aren't being used anymore? Or, maybe,
adding additional disk partitions so there's more space?

So you're not interested is resolving the problem, just
finding out how often it kvetches about it?

Hmmm. Not sure how to answer that.

<:-(


Rajasekhar Reddy Posted on 2009-06-28 23:37:02.0Z
Sender: 376b.4a41d0b6.1804289383@sybase.com
From: Rajasekhar Reddy
Newsgroups: sybase.public.ase.general
Subject: Re: Database space Alert
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a47fe9e.387.1681692777@sybase.com>
References: <4567b66c-0346-4307-b927-5d06edf52dbf@j9g2000vbp.googlegroups.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 28 Jun 2009 16:37:02 -0700
X-Trace: forums-3-dub.sybase.com 1246232222 10.22.241.188 (28 Jun 2009 16:37:02 -0700)
X-Original-Trace: 28 Jun 2009 16:37:02 -0700, forums-3-dub.sybase.com
Lines: 33
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27927
Article PK: 77178


> On Jun 23, 4:58?pm, Rajasekhar Reddy wrote:
> > Hello,
> > ? ?ASE Server is generating space warning messages in
> > errorlog almost everyday as my database used space is
> > over 95%. I have disabled our own threshold procedures.
> > I think we can disbale system one as well with "no free
> > space acctng".But I dont want to do it.
> >
> > I just want to know when AND how frequently the server
> > generates this alert ? Bcoz I can see this warning
> > message early time everyday.
> >
> > Thanks in advance.
>
> You mean, you don't want advice on how to use LESS space?
>
> You just want to know how often it generates the alert?
>
> As opposed to, say, reclaiming wasted space? Or, say,
> dropping tables that aren't being used anymore? Or, maybe
> , adding additional disk partitions so there's more space?
>
> So you're not interested is resolving the problem, just
> finding out how often it kvetches about it?
>
> Hmmm. Not sure how to answer that.
>
> <:-(

We are about to extend the space. Forget about resolving the
issue. I just wanted to know when and how often it generates
this alert ?


Bret Halford [Sybase] Posted on 2009-07-01 15:46:46.0Z
From: "Bret Halford [Sybase]" <bret@sybase.com>
Organization: Sybase, Inc.
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Database space Alert
References: <4567b66c-0346-4307-b927-5d06edf52dbf@j9g2000vbp.googlegroups.com> <4a47fe9e.387.1681692777@sybase.com>
In-Reply-To: <4a47fe9e.387.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a4b84e6$2@forums-3-dub.sybase.com>
Date: 1 Jul 2009 08:46:46 -0700
X-Trace: forums-3-dub.sybase.com 1246463206 10.22.241.152 (1 Jul 2009 08:46:46 -0700)
X-Original-Trace: 1 Jul 2009 08:46:46 -0700, vip152.sybase.com
Lines: 43
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:27941
Article PK: 77187


Rajasekhar Reddy wrote:
>> On Jun 23, 4:58?pm, Rajasekhar Reddy wrote:
>>> Hello,
>>> ? ?ASE Server is generating space warning messages in
>>> errorlog almost everyday as my database used space is
>>> over 95%. I have disabled our own threshold procedures.
>>> I think we can disbale system one as well with "no free
>>> space acctng".But I dont want to do it.
>>>
>>> I just want to know when AND how frequently the server
>>> generates this alert ? Bcoz I can see this warning
>>> message early time everyday.
>>>
>>> Thanks in advance.
>> You mean, you don't want advice on how to use LESS space?
>>
>> You just want to know how often it generates the alert?
>>
>> As opposed to, say, reclaiming wasted space? Or, say,
>> dropping tables that aren't being used anymore? Or, maybe
>> , adding additional disk partitions so there's more space?
>>
>> So you're not interested is resolving the problem, just
>> finding out how often it kvetches about it?
>>
>> Hmmm. Not sure how to answer that.
>>
>> <:-(
>
>
> We are about to extend the space. Forget about resolving the
> issue. I just wanted to know when and how often it generates
> this alert ?

Is this the "last chance threshold" message? If so, it is
raised each time free space falls below the last chance threshold.
For the the log segment, it could be that each time the log is
truncated, free space increases enough above the last chance
threshold to arm it, and then activity causes free space to fall
below the threshold. With truncate log on ckpt set and steady
activity, that might be happening as often as once a minute.

-bret