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.

schedule time of DBDiskSpace-Event

2 posts in General Discussion Last posting was on 2005-06-11 04:21:17.0Z
AHeitmann Posted on 2005-06-10 14:13:37.0Z
From: "AHeitmann" <test@test.de>
Newsgroups: ianywhere.public.general
Subject: schedule time of DBDiskSpace-Event
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
NNTP-Posting-Host: 212.105.206.29
X-Original-NNTP-Posting-Host: 212.105.206.29
Message-ID: <42a9a011@forums-1-dub>
Date: 10 Jun 2005 07:13:37 -0700
X-Trace: forums-1-dub 1118412817 212.105.206.29 (10 Jun 2005 07:13:37 -0700)
X-Original-Trace: 10 Jun 2005 07:13:37 -0700, 212.105.206.29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4548
Article PK: 8355

Hello group,

i like to define a event which uses the Type DBDISKSPACE event type
I also use the event_condition Interval . my event looks like this

create event lowDBSpace
TYPE dbdiskspace
where event_condition('DBFreePercent')) < 10
and event_condition('Intervall') >= 14400
Handler
Beginn
...
end

In the documentation i read that the use of a Event with type Diskspace
cause that the DB Server will look every 30 sec for the diskspace.
Now my question:
does the db server also look every 30 sec for the diskspace even if i use
the Interval condition so that the interval only mean that the event
lowDBSpace look within this periode or does that interval mean that the db
server will look every 14400 sec for diskspace?
Because i think that it would be enough if the db server interval for
diskspace can be near every 2-3 hour to reduce db action / trafic

Thanks for your help
greetings andi


Greg Fenton Posted on 2005-06-11 04:21:17.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: schedule time of DBDiskSpace-Event
References: <42a9a011@forums-1-dub>
In-Reply-To: <42a9a011@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <42aa66bd$1@forums-1-dub>
Date: 10 Jun 2005 21:21:17 -0700
X-Trace: forums-1-dub 1118463677 69.198.107.137 (10 Jun 2005 21:21:17 -0700)
X-Original-Trace: 10 Jun 2005 21:21:17 -0700, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 20
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4551
Article PK: 8359


AHeitmann wrote:
>
> In the documentation i read that the use of a Event with type Diskspace
> cause that the DB Server will look every 30 sec for the diskspace.

I believe that the DB checks the diskspace every 30 seconds, but it
won't call your event until all event_condition's are met.

BTW: I'm quite sure that checking the amount of free diskspace is a very
light-weight operation. Once every 30 seconds might seem like a lot,
but 30 seconds it 6 lifetimes to a computer.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/