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.

Transaction log is full or Segment is full/has no free extents...

4 posts in General Discussion Last posting was on 2012-05-02 14:54:38.0Z
Gerry Posted on 2012-05-01 17:59:00.0Z
Sender: 3bb9.4fa0238c.1804289383@sybase.com
From: Gerry
Newsgroups: sybase.public.ase.general
Subject: Transaction log is full or Segment is full/has no free extents...
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fa02464.3bdf.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 May 2012 10:59:00 -0700
X-Trace: forums-1-dub 1335895140 172.20.134.41 (1 May 2012 10:59:00 -0700)
X-Original-Trace: 1 May 2012 10:59:00 -0700, 172.20.134.41
Lines: 9
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31067
Article PK: 73956

We're running into a transaction log full or we "...can't
allocate space for object table name in database db name
because the default segment is full/has no free extents. Is
there a way to monitor the how full the transaction log is
getting, or a way to avoid the '...segment is full/has no
free extents', message?

Thanks,
Gerry


"Mark A. Parsons" <iron_horse Posted on 2012-05-02 00:25:54.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Transaction log is full or Segment is full/has no free extents...
References: <4fa02464.3bdf.1681692777@sybase.com>
In-Reply-To: <4fa02464.3bdf.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: <4fa07f12$1@forums-1-dub>
Date: 1 May 2012 17:25:54 -0700
X-Trace: forums-1-dub 1335918354 10.22.241.152 (1 May 2012 17:25:54 -0700)
X-Original-Trace: 1 May 2012 17:25:54 -0700, vip152.sybase.com
Lines: 15
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31070
Article PK: 73960

Write a script that periodically logs in and checks the space available in each segment of a database.

Another option is to setup multiple thresholds to print messages to the errorlog as the segment hits certain levels of
fullness; you then have a process that monitors the errorlog for such messages and sends out an email/page/alert.

On 05/01/2012 11:59, Gerry wrote:
> We're running into a transaction log full or we "...can't
> allocate space for object table name in database db name
> because the default segment is full/has no free extents. Is
> there a way to monitor the how full the transaction log is
> getting, or a way to avoid the '...segment is full/has no
> free extents', message?
>
> Thanks,
> Gerry


Cory Sane [TeamSybase] Posted on 2012-05-02 03:16:18.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4fa02464.3bdf.1681692777@sybase.com> <4fa07f12$1@forums-1-dub>
In-Reply-To: <4fa07f12$1@forums-1-dub>
Subject: Re: Transaction log is full or Segment is full/has no free extents...
Lines: 23
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fa0a702@forums-1-dub>
Date: 1 May 2012 20:16:18 -0700
X-Trace: forums-1-dub 1335928578 10.22.241.152 (1 May 2012 20:16:18 -0700)
X-Original-Trace: 1 May 2012 20:16:18 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31071
Article PK: 73961

Many sites use the multiple threshold idea..
I've seen a site where the threshold called a XP Server style utility to mailx the dba team.

--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in message news:4fa07f12$1@forums-1-dub...
> Write a script that periodically logs in and checks the space available in each segment of a database.
>
> Another option is to setup multiple thresholds to print messages to the errorlog as the segment hits certain levels of
> fullness; you then have a process that monitors the errorlog for such messages and sends out an email/page/alert.
>
> On 05/01/2012 11:59, Gerry wrote:
>> We're running into a transaction log full or we "...can't
>> allocate space for object table name in database db name
>> because the default segment is full/has no free extents. Is
>> there a way to monitor the how full the transaction log is
>> getting, or a way to avoid the '...segment is full/has no
>> free extents', message?
>>
>> Thanks,
>> Gerry


Michael Heaney Posted on 2012-05-02 14:54:38.0Z
From: Michael Heaney <mheaney@jcvi.org>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Transaction log is full or Segment is full/has no free extents...
References: <4fa02464.3bdf.1681692777@sybase.com> <4fa07f12$1@forums-1-dub>
In-Reply-To: <4fa07f12$1@forums-1-dub>
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: <4fa14aae@forums-1-dub>
Date: 2 May 2012 07:54:38 -0700
X-Trace: forums-1-dub 1335970478 10.22.241.152 (2 May 2012 07:54:38 -0700)
X-Original-Trace: 2 May 2012 07:54:38 -0700, vip152.sybase.com
Lines: 28
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31075
Article PK: 73967

You can also install threshold procedures to automatically
increase the size of the default and/or log segments, up
to a predefined limit. They've been a tremendous productivity
booster for my shop.

Michael Heaney
JCVI

>On 5/1/2012 8:25 PM, Mark A. Parsons wrote:
> ...
> Another option is to setup multiple thresholds to print messages to the
> errorlog as the segment hits certain levels of fullness; you then have a
> process that monitors the errorlog for such messages and sends out an
> email/page/alert.
>
> On 05/01/2012 11:59, Gerry wrote:
>> We're running into a transaction log full or we "...can't
>> allocate space for object table name in database db name
>> because the default segment is full/has no free extents. Is
>> there a way to monitor the how full the transaction log is
>> getting, or a way to avoid the '...segment is full/has no
>> free extents', message?
>>
>> Thanks,
>> Gerry