Re: Tuning advice needed - IDS 11.5.FC1

On Jan 5, 12:21 pm, "Neil Truby" <neil.tr...@xxxxxxxxxxx> wrote:
"Tom" <tlow...@xxxxxxxxx> wrote in message

news:be07065d-7eec-4a15-9a44-99f571a1d2ee@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx





Greetings All,

I am looking for advice on tuning this instance. The overview is:

IBM P5 55A - dual quad core cpu's with 32G memory
Disk space is via two 2G fiber HBA's to an IBM 2105-800 (Shark)
Each database is in its own dbspace. Each dbspace is in its own LV.
O/S is AIX 5.3. IDS is 11.5.FC1
No one ever accesses this instance other than the unload script, which
is run locally.

This instance is a FlashCopy of the Live instance. The singular
purpose is to unload each database for archiving.
I started with the onconfig.std onconfig file. Using the largest
database as the point of reference, it took 3 hours and 45 minutes to
unload. I use a script that calls dbaccess and uses the unload command
to unload each table, one after the other, to a dedicated file system.

Well, a few thoughts.  Firstly if you're just running a load of sequential
ASCII unloads you could have saved yourself the bother of writing the script
and just used dbexport.

It's not entirely clear what your objective in asking the question is.  Is
it that the 1h 20m. or whatever it takes, is too long?  Why is it too long?
If the server no other purpose do you really care how long it takes to
unload?

A few things that you might consider if you do need to speed it up:
1. Experiment with much larger settings for Read Ahead
2. Use a binary onunload of each db.
3. Script HPL rather than dbaccess unloads for the larger tables at least..

rgds
Neil- Hide quoted text -

- Show quoted text -

Neil,

I will revisit dbexport. I have found in the past that my unload
script unloads a DB much faster, but perhaps that has changed in 11.5.

The server also houses the live instance. Our client usage is
primarily from 8:00 AM to 9:00 PM. My nightly archives need to be done
by 5:15 AM because they are used for two purposes: refreshing test and
training DB's and the contract required text-formatted archive file.
The archive file cannot be engine-dependant.

My objective is to get the best speed possible. I now have 90 DB's on
the server, with 35 more waiting to be brought over from older
servers.

Here is my current RA related stats:

Bufwait Ratio: 0.330752 Buffer Turnover: 0.176696 Ovbuff: 0

Read Ahead: 99.9441 Read Cache: 85.08 Write Cache: 99.84

FG Writes: 0 LRU Writes: 0 Chunk Writes: 1914

Thank you for the response,

Tom
.

Relevant Pages

  • [CFT][RFC] Module auto-unloading solution.
    ... I put together the script at the end of this ... It won't try to unload ethernet drivers ... ## your kernel modules. ... # Create a regexp of ethernet modules. ...
    (Linux-Kernel)
  • Re: Tuning advice needed - IDS 11.5.FC1
    ... Each database is in its own dbspace. ... purpose is to unload each database for archiving. ... I use a script that calls dbaccess and uses the unload command ... Script HPL rather than dbaccess unloads for the larger tables at least. ...
    (comp.databases.informix)
  • HTC Components with > 512 bytes of javascript slow to unload
    ... When using large number of copies of a lightweight HTC behavior ... component to unload the page, ... If I shrink the javascript code below the 512 byte limit, ... The 512 byte limit only affects the contents of the <script ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: 2 simple questions about SKILL language
    ... how to undefine it without exiting icfb? ... You cannot "unload" a script. ...
    (comp.cad.cadence)
  • hi all
    ... trying to use this script to remove the internet connection wizard as part ... The problem is that it does not unload the hive at the end of the script? ... ' Loads Default User Hive ...
    (microsoft.public.scripting.wsh)