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.

Database Size

2 posts in General Discussion Last posting was on 2007-10-11 15:01:24.0Z
Herman Miller Posted on 2007-10-11 14:23:08.0Z
Sender: 2b41.470e3010.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Database Size
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470e31cc.2b73.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Oct 2007 07:23:08 -0700
X-Trace: forums-1-dub 1192112588 10.22.241.41 (11 Oct 2007 07:23:08 -0700)
X-Original-Trace: 11 Oct 2007 07:23:08 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6403
Article PK: 2874

Is there a max ASA9 Database size? With RAID 5 and 1 dbspace
how large can I go before recreating the db, creating
multiple dbspaces and creating tables on seperate dbspaces?
Can I go to 1TB? Given this might effect performance.


Mark Culp Posted on 2007-10-11 15:01:24.0Z
Message-ID: <470E3AC3.3624ACB1@iAnywhere.com>
From: Mark Culp <reply_to_newsgroups_only_please_nospam_mark.culp@iAnywhere.com>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Database Size
References: <470e31cc.2b73.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: mculp-pc.sybase.com
X-Original-NNTP-Posting-Host: mculp-pc.sybase.com
Date: 11 Oct 2007 08:01:24 -0700
X-Trace: forums-1-dub 1192114884 10.25.106.138 (11 Oct 2007 08:01:24 -0700)
X-Original-Trace: 11 Oct 2007 08:01:24 -0700, mculp-pc.sybase.com
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6404
Article PK: 2875

The size of a single dbspace is dependent on the page size that
you are using. Basically, each dbspace can have up to 2^28 pages
so a single dbspace using a page size of 4K would be able to grow
to 2^28 * 4096 which is 1TB.

File sizes, are of course, limited by the OS and file system constraints.

A database can have up to 13 dbspaces.

See
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbdaen9/00000789.htm
for more information.
--
Mark Culp
SQLAnywhere Research and Development
iAnywhere Solutions Engineering
-------------------------------------------------------------------------
** Whitepapers, TechDocs, bug fixes are all available through the **
** iAnywhere Developer Community at http://www.ianywhere.com/developer **
-------------------------------------------------------------------------

Herman, Miller wrote:
>
> Is there a max ASA9 Database size? With RAID 5 and 1 dbspace
> how large can I go before recreating the db, creating
> multiple dbspaces and creating tables on seperate dbspaces?
> Can I go to 1TB? Given this might effect performance.