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.

Logging DB size

2 posts in General Discussion Last posting was on 2009-03-31 22:01:54.0Z
Kenny Posted on 2009-03-31 15:45:07.0Z
Sender: 4f03.49d236b4.1804289383@sybase.com
From: Kenny
Newsgroups: ianywhere.public.remoteware.general
Subject: Logging DB size
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49d23a83.4f5e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Mar 2009 07:45:07 -0800
X-Trace: forums-1-dub 1238514307 10.22.241.41 (31 Mar 2009 07:45:07 -0800)
X-Original-Trace: 31 Mar 2009 07:45:07 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.remoteware.general:26
Article PK: 9863

Hello,
Does anyone know of a quick and safe way to remove old data
from the logging DB. Ours has grown to over 18 gig and when
the log viewer is used the query is taking a long time to
populate.


Willie Escaba Posted on 2009-03-31 22:01:54.0Z
From: "Willie Escaba" <escabaw@booksamillion.com>
Newsgroups: ianywhere.public.remoteware.general
References: <49d23a83.4f5e.1681692777@sybase.com>
Subject: Re: Logging DB size
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d292d2$1@forums-1-dub>
Date: 31 Mar 2009 14:01:54 -0800
X-Trace: forums-1-dub 1238536914 10.22.241.152 (31 Mar 2009 14:01:54 -0800)
X-Original-Trace: 31 Mar 2009 14:01:54 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.remoteware.general:27
Article PK: 9858

Have you tried using the LOGMAINT.EXE tool. This should allow you to reduce
the segment size (records).

You may also want to check what your threshold value for your logs is set
to.

<Kenny> wrote in message news:49d23a83.4f5e.1681692777@sybase.com...
> Hello,
> Does anyone know of a quick and safe way to remove old data
> from the logging DB. Ours has grown to over 18 gig and when
> the log viewer is used the query is taking a long time to
> populate.