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.

DB Over 4G on ASA9/ASA10

3 posts in General Discussion Last posting was on 2007-10-05 12:50:44.0Z
Herman Miller Posted on 2007-10-03 20:19:56.0Z
Sender: 35fb.4703d36e.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: DB Over 4G on ASA9/ASA10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4703f96c.3976.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Oct 2007 13:19:56 -0700
X-Trace: forums-1-dub 1191442796 10.22.241.41 (3 Oct 2007 13:19:56 -0700)
X-Original-Trace: 3 Oct 2007 13:19:56 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6333
Article PK: 4707

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?


Josh Savill Posted on 2007-10-03 20:32:19.0Z
From: Josh Savill <no_spam_jsavill@ianywhere.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: DB Over 4G on ASA9/ASA10
References: <4703f96c.3976.1681692777@sybase.com>
In-Reply-To: <4703f96c.3976.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: jsavill-d620.sybase.com
X-Original-NNTP-Posting-Host: jsavill-d620.sybase.com
Message-ID: <4703fc53$1@forums-1-dub>
Date: 3 Oct 2007 13:32:19 -0700
X-Trace: forums-1-dub 1191443539 10.25.99.243 (3 Oct 2007 13:32:19 -0700)
X-Original-Trace: 3 Oct 2007 13:32:19 -0700, jsavill-d620.sybase.com
Lines: 19
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6334
Article PK: 2839


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?

Look at the following section in the documentation for the size and
limitations:

SQL Anywhere® Server - Database Administration >
Physical Limitations
SQL Anywhere size and number limitations

A table cannot span multiple dbspaces. You cannot move a table from one
dbspace to another.

--
Joshua Savill
Sybase iAnywhere - Product Manager


Breck Carter [Team iAnywhere] Posted on 2007-10-05 12:50:44.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: DB Over 4G on ASA9/ASA10
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <aeccg3h9un01uubro02ufttkqgk8012psq@4ax.com>
References: <4703f96c.3976.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 5 Oct 2007 05:50:44 -0700
X-Trace: forums-1-dub 1191588644 64.7.134.118 (5 Oct 2007 05:50:44 -0700)
X-Original-Trace: 5 Oct 2007 05:50:44 -0700, bcarter.sentex.ca
Lines: 27
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6341
Article PK: 2842


On 3 Oct 2007 13:19:56 -0700, Herman Miller wrote:

>After a new dbspace is created, can I move tables
>frm one dbspace to another?

There is no "move table" command or utility, *but* you can CREATE a
new table in a different dbspace, copy the rows, DROP the original
table and ALTER the new table to give it the original name. The
technique used to "copy the rows" may differ depending on the number
of rows: a single INSERT ... SELECT for a small number, UNLOAD ...
LOAD for a larger number, or perhaps a FETCH ... INSERT loop with
periodic COMMIT for a vast number of rows.

Caution: If the original table participated in foreign key
relationships, those will have to be re-created for the new table,
also by ALTER commands.

Code samples for all of the above are available on request.

Breck

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com