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.

Info. on ASA V6 to ASA V9 rebuild

2 posts in General Discussion Last posting was on 2004-06-10 21:15:07.0Z
Steve Posted on 2004-06-10 18:28:26.0Z
Sender: f87.40c89327.1804289383@sybase.com
From: Steve
Newsgroups: ianywhere.public.general
Subject: Info. on ASA V6 to ASA V9 rebuild
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <40c8a84a.10b9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Jun 2004 11:28:26 -0700
X-Trace: forums-1-dub 1086892106 10.22.241.41 (10 Jun 2004 11:28:26 -0700)
X-Original-Trace: 10 Jun 2004 11:28:26 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3165
Article PK: 6625

Can someone please educate me on the process of unloading a
version 6 db and reloading a version 9 db. Where I become
confused is, when a database is rebuilt, how does the new
rebuilt database know its supposed to function as a version
9 database?


Breck Carter [TeamSybase] Posted on 2004-06-10 21:15:07.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Info. on ASA V6 to ASA V9 rebuild
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <o1jhc0lp40lidtvhsmhci4ni4i19pmt7on@4ax.com>
References: <40c8a84a.10b9.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: 10 Jun 2004 14:15:07 -0700
X-Trace: forums-1-dub 1086902107 64.7.134.118 (10 Jun 2004 14:15:07 -0700)
X-Original-Trace: 10 Jun 2004 14:15:07 -0700, bcarter.sentex.ca
Lines: 57
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3167
Article PK: 6628

The Version 9 dbinit.exe program will create a Version 9 database.
There are all sorts of ways the process can be semi-automated to hide
the true details from you (Sybase Central, dbunload -ar, etcetera) but
IMO the best way is to do it step-by-explicit-step.

Here is an excerpt from the beginning of Database Reorganization with
Unload/Reload in Chapter 10, Tuning, in the book SQL Anywhere Studio 9
Developer's Guide ISBN 1-55622-506-7 from Wordware Publishing (which
will be on the shelves in July):

=====
The ultimate, brute force technique for reorganizing an entire
database is to unload all the data, recreate the database from scratch
and then reload all the data. This is also the only way to reduce the
amount of disk space used by the database file; other techniques may
reorganize data inside the file but they cannot reduce the file size.

The following steps can be used to perform a database reorganization
via unload/reload; these steps assume some time is available to take
the database offline:

1. Disconnect all other users from the old database.
2. Unload the old database with dbunload.exe.
3. Stop the old database.
4. Backup and remove the old database.
5. Create a new database file with dbinit.exe.
6. Start the new database.
7. Increase the size of the new database file with ALTER DBSPACE in
ISQL.
8. Defragment the hard drive.
9. Examine and edit the reload.sql file if necessary.
10. Load the new database by running reload.sql via ISQL.
11. Check to make sure everything's OK.
12. Make the new database available.
=====

The book goes on to describe each step in great detail, but the Help
also provides a lot of information: see the Help for dbunload, dbinit
and dbisql.

Breck

On 10 Jun 2004 11:28:26 -0700, Steve wrote:

>Can someone please educate me on the process of unloading a
>version 6 db and reloading a version 9 db. Where I become
>confused is, when a database is rebuilt, how does the new
>rebuilt database know its supposed to function as a version
>9 database?

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com