Re: ASA unload/reload question

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 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!

Todd
.

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