Hi,
(1) Wish to find out what size should I set "util_heap_sz" to for
optimum backup performance.

Environment: DB2 8.1 FP4 on AIX
(Will not be using COMPRESS option as it stores both the uncompressed
as well as compressed images in memory at this Fixpak level).

(2) What is the maximum value that I can set "util_heap_sz" on Linux -
I understand that this is affected by Kernel Parameter settings.
Thankx in advance............anurag

I think util_heap_sz is far from the most important parameter you can tune
for performance. it's a rather small value, you can just give big enough.


"Anurag" <k_anurag@Yahoo.com> ????
news:1104735192.107070.237050@f14g2000cwb.googlegr oups.com...
> Hi,
> (1) Wish to find out what size should I set "util_heap_sz" to for
> optimum backup performance.
>
> Environment: DB2 8.1 FP4 on AIX
> (Will not be using COMPRESS option as it stores both the uncompressed
> as well as compressed images in memory at this Fixpak level).
>
> (2) What is the maximum value that I can set "util_heap_sz" on Linux -
> I understand that this is affected by Kernel Parameter settings.
> Thankx in advance............anurag
>

maybe he wants to tune it in such a way that the time taken for
backups, restores and loads is the shortest.

regards,
dotyet

Hi,
For Backup Performance, we already have had a look into these:
(1) Parallelism
(2) Backup Buffer Size
(3) Number of Buffers
(4) Multiple Target Devices

We are kind of constrained not to tweak around with these any more.
Further, Incremental / Delta backup is ruled out as we have large
objects in the database.

So, I focus on Utility Heap Size. Is there anything else that I can
look into for improving backup performance?
Any thoughts on alternate strategy is also welcome.

..........anurag