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.

Using multiple files with Sybase

9 posts in General Discussion Last posting was on 2007-10-05 19:16:10.0Z
Herman Miller Posted on 2007-10-03 17:38:49.0Z
Sender: 35fb.4703d36e.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Using multiple files with Sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4703d3a9.3600.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Oct 2007 10:38:49 -0700
X-Trace: forums-1-dub 1191433129 10.22.241.41 (3 Oct 2007 10:38:49 -0700)
X-Original-Trace: 3 Oct 2007 10:38:49 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6329
Article PK: 2836

How do you configure SQL Anywhere 10 to use multiple files?
We currently have a file that is reaching the 4g mark.


Shuchit Posted on 2007-10-03 18:41:42.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Using multiple files with Sybase
From: Shuchit <me@privacy.net>
References: <4703d3a9.3600.1681692777@sybase.com>
Message-ID: <Xns99BE956D3EB7svelkarprivacynet@127.0.0.1>
User-Agent: Xnews/2006.08.24 Hamster/2.1.0.11
NNTP-Posting-Host: svelkar-pc.sybase.com
X-Original-NNTP-Posting-Host: svelkar-pc.sybase.com
Date: 3 Oct 2007 11:41:42 -0700
X-Trace: forums-1-dub 1191436902 10.25.98.144 (3 Oct 2007 11:41:42 -0700)
X-Original-Trace: 3 Oct 2007 11:41:42 -0700, svelkar-pc.sybase.com
Lines: 13
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6330
Article PK: 2835


Herman Miller wrote in news:4703d3a9.3600.1681692777@sybase.com:

> How do you configure SQL Anywhere 10 to use multiple files?
> We currently have a file that is reaching the 4g mark.
>

You would create new dbspaces.

See <http://preview.tinyurl.com/29st2r> which points to
<http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/
dbdaen10/da-blddbmod.html>

Shuchit


Herman Miller Posted on 2007-10-03 20:19:25.0Z
Sender: 35fb.4703d36e.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Using multiple files with Sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4703f94d.3972.1681692777@sybase.com>
References: <Xns99BE956D3EB7svelkarprivacynet@127.0.0.1>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Oct 2007 13:19:25 -0700
X-Trace: forums-1-dub 1191442765 10.22.241.41 (3 Oct 2007 13:19:25 -0700)
X-Original-Trace: 3 Oct 2007 13:19:25 -0700, 10.22.241.41
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6332
Article PK: 2838

What is the maximum db size for ASA9/ASA10? How many
dbspaces can ASA9/ASA10 support? Can a table spawn multiple
dbspaces? After a new dbspace is created, can I move tables
frm one dbspace to another?

> Herman Miller wrote in
> news:4703d3a9.3600.1681692777@sybase.com:
>
> > How do you configure SQL Anywhere 10 to use multiple
> > files? We currently have a file that is reaching the 4g
> > mark.
>
> You would create new dbspaces.
>
> See <http://preview.tinyurl.com/29st2r> which points to
> <http://www.ianywhere.com/developer/product_manuals/sqlany
> where/1001/en/html/ dbdaen10/da-blddbmod.html>
>
> Shuchit


Mark Culp Posted on 2007-10-04 00:53:03.0Z
Message-ID: <4704396E.47220557@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: Using multiple files with Sybase
References: <Xns99BE956D3EB7svelkarprivacynet@127.0.0.1> <4703f94d.3972.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe0004e23b1c57-cm00111a59be64.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe0004e23b1c57-cm00111a59be64.cpe.net.cable.rogers.com
Date: 3 Oct 2007 17:53:03 -0700
X-Trace: forums-1-dub 1191459183 99.235.248.3 (3 Oct 2007 17:53:03 -0700)
X-Original-Trace: 3 Oct 2007 17:53:03 -0700, cpe0004e23b1c57-cm00111a59be64.cpe.net.cable.rogers.com
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6335
Article PK: 4708

What OS are you using? More importantly, what file system are you using?
What page size are you using?

SQLAnywhere can handle up to 13 user dbspaces.

Depending on your file system and your page size, dbspaces can be
much much larger than 4GB.

Basically, each dbspace can have up to 2^28 pages, so for example,
a database that is using 4K pages can have up to 13 dbspaces of
2^28 * 4096 or 1TB each.

Most modern file systems support files this large... but if you
are using an older FS (e.g. FAT) then you will be limited to how
large each file (i.e. dbspace) can be.

Each table's data must reside in a single dbspace.

Copying table data to a new dbspace is fairly easy - create a
new table in the destination dbpsace, and
insert into T select * from S
(where T is the target table and S is the source table).
You will then need to do the appropriate FK fix-ups,
and then delete the original table.

- Mark

Herman, Miller wrote:
>
> What is the maximum db size for ASA9/ASA10? How many
> dbspaces can ASA9/ASA10 support? Can a table spawn multiple
> dbspaces? After a new dbspace is created, can I move tables
> frm one dbspace to another?
> > Herman Miller wrote in
> > news:4703d3a9.3600.1681692777@sybase.com:
> >
> > > How do you configure SQL Anywhere 10 to use multiple
> > > files? We currently have a file that is reaching the 4g
> > > mark.
> >
> > You would create new dbspaces.
> >
> > See <http://preview.tinyurl.com/29st2r> which points to
> > <http://www.ianywhere.com/developer/product_manuals/sqlany
> > where/1001/en/html/ dbdaen10/da-blddbmod.html>
> >
> > Shuchit


Herman Miller Posted on 2007-10-05 17:35:26.0Z
Sender: 7021.47067415.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Using multiple files with Sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <470675de.703f.1681692777@sybase.com>
References: <4704396E.47220557@iAnywhere.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Oct 2007 10:35:26 -0700
X-Trace: forums-1-dub 1191605726 10.22.241.41 (5 Oct 2007 10:35:26 -0700)
X-Original-Trace: 5 Oct 2007 10:35:26 -0700, 10.22.241.41
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6346
Article PK: 4714

We are using Windows Server 2003, our servers are virtual
where all virtuals share a RAID 5. Page size 8192.

> What OS are you using? More importantly, what file system
> are you using? What page size are you using?
>
> SQLAnywhere can handle up to 13 user dbspaces.
>
> Depending on your file system and your page size, dbspaces
> can be much much larger than 4GB.
>
> Basically, each dbspace can have up to 2^28 pages, so for
> example, a database that is using 4K pages can have up to
> 13 dbspaces of 2^28 * 4096 or 1TB each.
>
> Most modern file systems support files this large... but
> if you are using an older FS (e.g. FAT) then you will be
> limited to how large each file (i.e. dbspace) can be.
>
> Each table's data must reside in a single dbspace.
>
> Copying table data to a new dbspace is fairly easy -
> create a new table in the destination dbpsace, and
> insert into T select * from S
> (where T is the target table and S is the source table).
> You will then need to do the appropriate FK fix-ups,
> and then delete the original table.
>
> - Mark
>
> Herman, Miller wrote:
> >
> > What is the maximum db size for ASA9/ASA10? How many
> > dbspaces can ASA9/ASA10 support? Can a table spawn
> > multiple dbspaces? After a new dbspace is created, can I
> > move tables frm one dbspace to another?
> > > Herman Miller wrote in
> > > news:4703d3a9.3600.1681692777@sybase.com:
> > >
> > > > How do you configure SQL Anywhere 10 to use multiple
> > > > files? We currently have a file that is reaching the
> > > > 4g mark.
> > >
> > > You would create new dbspaces.
> > >
> > > See <http://preview.tinyurl.com/29st2r> which points
> > > to
> > >
> <http://www.ianywhere.com/developer/product_manuals/sqlany
> > where/1001/en/html/ dbdaen10/da-blddbmod.html> >
> > > Shuchit


Dean Jones Posted on 2007-10-04 13:39:23.0Z
From: "Dean Jones" <dean_dot_jones_at_powerobjects_dot_com>
Newsgroups: ianywhere.public.general
References: <4703d3a9.3600.1681692777@sybase.com>
Subject: Re: Using multiple files with Sybase
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: officenat.outtech.com
X-Original-NNTP-Posting-Host: officenat.outtech.com
Message-ID: <4704ed0b$1@forums-1-dub>
Date: 4 Oct 2007 06:39:23 -0700
X-Trace: forums-1-dub 1191505163 216.207.144.172 (4 Oct 2007 06:39:23 -0700)
X-Original-Trace: 4 Oct 2007 06:39:23 -0700, officenat.outtech.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6336
Article PK: 4709

We have a db that is 25gig. What's the issue with a 4gig file?

--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *

<Herman Miller> wrote in message news:4703d3a9.3600.1681692777@sybase.com...
> How do you configure SQL Anywhere 10 to use multiple files?
> We currently have a file that is reaching the 4g mark.


Dean Jones Posted on 2007-10-05 19:04:51.0Z
From: "Dean Jones" <dean_dot_jones_at_powerobjects_dot_com>
Newsgroups: ianywhere.public.general
References: <4704ed0b$1@forums-1-dub> <47067535.7034.1681692777@sybase.com>
Subject: Re: Using multiple files with Sybase
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: officenat.outtech.com
X-Original-NNTP-Posting-Host: officenat.outtech.com
Message-ID: <47068ad3$1@forums-1-dub>
Date: 5 Oct 2007 12:04:51 -0700
X-Trace: forums-1-dub 1191611091 216.207.144.172 (5 Oct 2007 12:04:51 -0700)
X-Original-Trace: 5 Oct 2007 12:04:51 -0700, officenat.outtech.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6347
Article PK: 4715

all I can say is look in the documentation. There might be some 4gig limit,
but it is not the database size.

--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *

<Herman> wrote in message news:47067535.7034.1681692777@sybase.com...
>I read somewhere that the max sze is 4gb, please educate on
> this. I am new to asa
>
>> We have a db that is 25gig. What's the issue with a 4gig
>> file?
>>
>> --
>> Dean Jones
>> CEO
>> PowerObjects
>> http://www.powerobjects.com
>> (612) 339-3355 Ext. 112
>>
>> TeamSybase
>> * * Think Sybase * *
>>
>>
>> <Herman Miller> wrote in message
>> > news:4703d3a9.3600.1681692777@sybase.com... How do you
>> > configure SQL Anywhere 10 to use multiple files? We
>> currently have a file that is reaching the 4g mark.
>>
>>