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.

Problems with threshold in ASE 11.5

4 posts in Windows NT Last posting was on 2001-02-17 00:27:28.0Z
Dimitar Kamenov Posted on 2001-02-13 07:05:03.0Z
From: "Dimitar Kamenov" <dimitar.kamenov@globalcons.com>
Subject: Problems with threshold in ASE 11.5
Date: Tue, 13 Feb 2001 09:05:03 +0200
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <T3WCy3YlAHA.90@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ns.global.bg 212.95.164.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1224
Article PK: 1088687

Hi All,

I have ASE 11.5/NT and I'm trying to use thresholds to clear log segment.
I've wrote stored procedure for this and register this stored procedure in
threshold property of logsegment but the procedure doesn't start when
logsegment size is less than size that I put in properties. No errors
appears in error log and messages in Application Log.

I'll appreciate your help!


Dimitar Kamenov


George Saylor Posted on 2001-02-13 12:28:04.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <T3WCy3YlAHA.90@forums.sybase.com>
Subject: Re: Problems with threshold in ASE 11.5
Date: Tue, 13 Feb 2001 07:28:04 -0500
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <F2GI0rblAHA.53@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust80.tnt1.baltimore.md.da.uu.net 63.24.126.80
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1222
Article PK: 1088682

please post the output from sp_helphreshold and the text of the procedure
you've added. It will be easier to figure out with that

George

Dimitar Kamenov <dimitar.kamenov@globalcons.com> wrote in message
news:T3WCy3YlAHA.90@forums.sybase.com...
> Hi All,
>
> I have ASE 11.5/NT and I'm trying to use thresholds to clear log segment.
> I've wrote stored procedure for this and register this stored procedure in
> threshold property of logsegment but the procedure doesn't start when
> logsegment size is less than size that I put in properties. No errors
> appears in error log and messages in Application Log.
>
> I'll appreciate your help!
>
>
> Dimitar Kamenov
>
>
>
>


Dimitar Kamenov Posted on 2001-02-16 13:50:15.0Z
From: "Dimitar Kamenov" <dimitar.kamenov@globalcons.com>
References: <T3WCy3YlAHA.90@forums.sybase.com> <F2GI0rblAHA.53@forums.sybase.com>
Subject: Re: Problems with threshold in ASE 11.5
Date: Fri, 16 Feb 2001 15:50:15 +0200
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <dBB9MICmAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ns.global.bg 212.95.164.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1214
Article PK: 1088688

Hi George,

Please find above the result from sp_helpthreshold and stored procedure
source.

sp_helpthreshold Result:
segment name free pages last chance? threshold procedure
------------ ----------- ------------ -------------------
logsegment 5136 1
usp_adm_backup_transaction_log
logsegment 12800 0
usp_adm_backup_transaction_log


Stored procedure source:
CREATE PROCEDURE dbo.usp_adm_backup_transaction_log


AS

BEGIN
declare @message char(30)
select @message = convert(char(30),getdate(),0)
print "Clear transaction log start on :%1!",@message
dump transaction RBB_GLOBAL WITH TRUNCATE_ONLY
select @message = convert(char(30),getdate(),0)
print "Clear transaction log finish on :%1!",@message
END

George Saylor <GMSAYLORIII@email.msn.com> wrote in message
news:F2GI0rblAHA.53@forums.sybase.com...
> please post the output from sp_helphreshold and the text of the procedure
> you've added. It will be easier to figure out with that
>
> George
>
>
> Dimitar Kamenov <dimitar.kamenov@globalcons.com> wrote in message
> news:T3WCy3YlAHA.90@forums.sybase.com...
> > Hi All,
> >
> > I have ASE 11.5/NT and I'm trying to use thresholds to clear log
segment.
> > I've wrote stored procedure for this and register this stored procedure
in
> > threshold property of logsegment but the procedure doesn't start when
> > logsegment size is less than size that I put in properties. No errors
> > appears in error log and messages in Application Log.
> >
> > I'll appreciate your help!
> >
> >
> > Dimitar Kamenov
> >
> >
> >
> >
>
>


George Saylor Posted on 2001-02-17 00:27:28.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <T3WCy3YlAHA.90@forums.sybase.com> <F2GI0rblAHA.53@forums.sybase.com> <dBB9MICmAHA.198@forums.sybase.com>
Subject: Re: Problems with threshold in ASE 11.5
Date: Fri, 16 Feb 2001 19:27:28 -0500
Lines: 84
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <wk4QzrHmAHA.199@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust48.tnt3.baltimore.md.da.uu.net 63.16.12.48
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1211
Article PK: 1088690

First thing, add the following input parameters to the procedure
@dbname varchar(30),
@segmentname varchar(30),
@space_left int,
@status int

and try it again, just fill the log and see what happens<on the development
machine of course>

Was there something else in the errorlog about not finding the procedure or
anything like that?

George

Dimitar Kamenov <dimitar.kamenov@globalcons.com> wrote in message
news:dBB9MICmAHA.198@forums.sybase.com...
> Hi George,
>
> Please find above the result from sp_helpthreshold and stored procedure
> source.
>
> sp_helpthreshold Result:
> segment name free pages last chance? threshold
procedure
> ------------ ----------- ------------ ------------------
-
> logsegment 5136 1
> usp_adm_backup_transaction_log
> logsegment 12800 0
> usp_adm_backup_transaction_log
>
>
> Stored procedure source:
> CREATE PROCEDURE dbo.usp_adm_backup_transaction_log
>
>
> AS
>
> BEGIN
> declare @message char(30)
> select @message = convert(char(30),getdate(),0)
> print "Clear transaction log start on :%1!",@message
> dump transaction RBB_GLOBAL WITH TRUNCATE_ONLY
> select @message = convert(char(30),getdate(),0)
> print "Clear transaction log finish on :%1!",@message
> END
>
>
> George Saylor <GMSAYLORIII@email.msn.com> wrote in message
> news:F2GI0rblAHA.53@forums.sybase.com...
> > please post the output from sp_helphreshold and the text of the
procedure
> > you've added. It will be easier to figure out with that
> >
> > George
> >
> >
> > Dimitar Kamenov <dimitar.kamenov@globalcons.com> wrote in message
> > news:T3WCy3YlAHA.90@forums.sybase.com...
> > > Hi All,
> > >
> > > I have ASE 11.5/NT and I'm trying to use thresholds to clear log
> segment.
> > > I've wrote stored procedure for this and register this stored
procedure
> in
> > > threshold property of logsegment but the procedure doesn't start when
> > > logsegment size is less than size that I put in properties. No errors
> > > appears in error log and messages in Application Log.
> > >
> > > I'll appreciate your help!
> > >
> > >
> > > Dimitar Kamenov
> > >
> > >
> > >
> > >
> >
> >
>
>