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.

Any where size after deleting

2 posts in QAnywhere Last posting was on 2008-05-05 01:20:50.0Z
Haitham Refaay Posted on 2008-05-04 13:50:46.0Z
Sender: 306e.481dbe98.1804289383@sybase.com
From: Haitham Refaay
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Any where size after deleting
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <481dbf36.307a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 4 May 2008 06:50:46 -0700
X-Trace: forums-1-dub 1209909046 10.22.241.41 (4 May 2008 06:50:46 -0700)
X-Original-Trace: 4 May 2008 06:50:46 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:263
Article PK: 18783

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.


Chris Keating (Sybase iAnywhere) Posted on 2008-05-05 01:20:50.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Re: Any where size after deleting
References: <481dbf36.307a.1681692777@sybase.com>
In-Reply-To: <481dbf36.307a.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: <481e60f2$1@forums-1-dub>
Date: 4 May 2008 18:20:50 -0700
X-Trace: forums-1-dub 1209950450 10.22.241.152 (4 May 2008 18:20:50 -0700)
X-Original-Trace: 4 May 2008 18:20:50 -0700, vip152.sybase.com
Lines: 26
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:264
Article PK: 10489

There is a response to your post in the sqlanywhere general newsgroup.

Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

Haitham Refaay 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.