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.

File Size Limit Anywhere 7.0.4 Win 2000

2 posts in General Discussion Last posting was on 2003-07-30 16:58:42.0Z
GDurniak Posted on 2003-07-30 16:38:19.0Z
Sender: 1a97.3f27f257.1804289383@sybase.com
From: GDurniak
Newsgroups: ianywhere.public.general
Subject: File Size Limit Anywhere 7.0.4 Win 2000
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f27f47b.1aef.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Jul 2003 09:38:19 -0700
X-Trace: forums-1-dub 1059583099 10.22.241.41 (30 Jul 2003 09:38:19 -0700)
X-Original-Trace: 30 Jul 2003 09:38:19 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1484
Article PK: 3716

A simple question ...
I am building a database approx 20G in size
We have SQL Anywhere 7.0.4

What is the file size limit for SQL Anywhere 7.0.4 on
Windows 2000, NTFS?
(I thought there was a 2G limit under Windows)

The help file says "1T limit for NTFS, with 4K pages, but
limited by the OS". This is not quite clear

Do I need to upgrade to ASEnterprise?
thanks


Greg Fenton Posted on 2003-07-30 16:58:42.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: File Size Limit Anywhere 7.0.4 Win 2000
References: <3f27f47b.1aef.846930886@sybase.com>
In-Reply-To: <3f27f47b.1aef.846930886@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <3f27f942$1@forums-1-dub>
Date: 30 Jul 2003 09:58:42 -0700
X-Trace: forums-1-dub 1059584322 172.31.140.253 (30 Jul 2003 09:58:42 -0700)
X-Original-Trace: 30 Jul 2003 09:58:42 -0700, gfenton-xp.sybase.com
Lines: 37
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1485
Article PK: 3715


GDurniak wrote:
>
> The help file says "1T limit for NTFS, with 4K pages, but
> limited by the OS". This is not quite clear
>
> Do I need to upgrade to ASEnterprise?

For NTFS, the filesystem limitation is very large (well in excess of 1TB).

For ASA, assuming the filesystem can handle the size, the limit is 256
million pages per database file. For a database using 4kB page size,
then you have (256M * 4k) which is 1TB.

You can have up to 12 dbspaces in addition to the main db file and
*each* dbspace has the above maximum. So 20GB is not a problem on NTFS,
even at only 1K page size (which has a maximum of 256GB per dbspace).

I think the following page in the ASA 7.0.x docs confirms this:

ASA Adaptive Server Anywhere Reference Manual
CHAPTER 13. Physical Limitations
- Size and number limitations

Realize that ASE and ASA are not related database technologies. There
are compatabilities built into our products, but ASA and ASE have been
developed independently.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/