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.

ASA Size

2 posts in General Discussion Last posting was on 2008-05-04 18:00:02.0Z
H Posted on 2008-05-04 13:49:03.0Z
Sender: 306e.481dbe98.1804289383@sybase.com
From: H
Newsgroups: ianywhere.public.general
Subject: ASA Size
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <481dbecf.3072.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 May 2008 06:49:03 -0700
X-Trace: forums-1-dub 1209908943 10.22.241.41 (4 May 2008 06:49:03 -0700)
X-Original-Trace: 4 May 2008 06:49:03 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6840
Article PK: 5076

I had database its size is 5GB.
I deleted big amount of data from the tables.
The remaining data are less than the origin one almost half.
But its size still 5GB.

I would be glad if you can help me to decrease the size of
the remaining database.


Glenn Paulley [iablog.sybase.com/paulley] Posted on 2008-05-04 18:00:02.0Z
From: "Glenn Paulley [iablog.sybase.com/paulley]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA Size
References: <481dbecf.3072.1681692777@sybase.com>
In-Reply-To: <481dbecf.3072.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: <481df9a2$1@forums-1-dub>
Date: 4 May 2008 11:00:02 -0700
X-Trace: forums-1-dub 1209924002 10.22.241.152 (4 May 2008 11:00:02 -0700)
X-Original-Trace: 4 May 2008 11:00:02 -0700, vip152.sybase.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6841
Article PK: 5075

Please don't cross-post; it merely wastes bandwidth (human and machine).

I've answered your question in the other general group.

Glenn

H wrote:
> I had database its size is 5GB.
> I deleted big amount of data from the tables.
> The remaining data are less than the origin one almost half.
> But its size still 5GB.
>
> I would be glad if you can help me to decrease the size of
> the remaining database.

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport