Re: ASA unload/reload question

In article <233de18d-01eb-4ad5-bfe3-630e27066c36@
8g2000hse.googlegroups.com>, ever90321@xxxxxxxxxxx says...
On Mar 13, 8:28 am, David Kerber
<ns_dkerber@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
In article <be75bfe6-49d8-406b-bab4-7d222badc701@
59g2000hsb.googlegroups.com>, ever90...@xxxxxxxxxxx says...

Newbie question coming... I'd like to reclaim wasted space in a
Sybase ASA 9 database using the unload/reload technique. I have the

Why? Has your usage pattern changed enough that you are sure it won't
just grow back to its current size again? The empty space in a database
file is reused for various purposes, so most databases grow to a certain
size based on their usage patterns, and then stay at that size from then
on. A file-system based defrag can be useful for performance reasons
once it reaches a stable size, but unload/reload rarely gains you much.

The size of the database seems to continue growing, no matter what.
The number of employees in this company can vary, as it goes through
swings in the sales staff, and we're currently on a down-swing.
Primarily, though, the database just seems *huge* compared to what
Sybase Central tells me is inside. I don't have a great background in
databases, and am really curious what the actual size will be, even
for the short term, once I've reloaded. So it's also partly to get
experience.

The db also contains temp tables that are needed for running complex
queries, roll back logs, etc, so if there are some of those in the app,
there can be lots of empty space most of the time, that is only used
occasionally.


The unload process generates a script that will have all those options
set correctly. So just use those scripts to create the new database.
Or you could unload/reload into a new database, which will handle all
that automatically.

Ah! I did skim the .sql file briefly, but must have missed that. I
also didn't realize it would populate those settings to a new
database. Will try this shorty. Thanks for the tips!

Make sure you copy off your production db before doing this!!


--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
.

Relevant Pages

  • Re: ASA unload/reload question
    ... Sybase ASA 9 database using the unload/reload technique. ... Has your usage pattern changed enough that you are sure it won't ...
    (comp.databases.sybase)
  • Re: ASA unload/reload question
    ... Sybase ASA 9 database using the unload/reload technique. ... Has your usage pattern changed enough that you are sure it won't ...
    (comp.databases.sybase)
  • RE: IEF195I
    ... What's the JCL for //DD1 look like and how much space are you asking for? ... Of Duane Shields ... Our database group is trying to do a unload/reload of a database to increase ...
    (bit.listserv.ibm-main)
  • Re: Adapting software to multiple usage patterns
    ... and a fair way down the call graph in the library it goes through function pointers to database specific functions so we can select the database type at run time. ... For big lists we would use a heap manager, for normal lists malloc at ... However, it does not map to the usage pattern of, I need this to run as fast as possible because it is used a vast amount and my heavy duty server will hit 100% CPU usage and take a while even if it is fast. ...
    (comp.lang.c)
  • ASA unload/reload question
    ... Sybase ASA 9 database using the unload/reload technique. ...
    (comp.databases.sybase)
Loading