> I think the discussion could use more details about the architecture
> being used.
> If you haven't already, see IBM Technote 1208540.
>
> Richard Sims
Ahh those details.....
TSM server 5.3.2 on Solaris 9, 64 bit, 8 cpus' 32 GB ram.
DB size, 150 GB, 75% used
Current BUFPOOLSIZE 1 GB
My testing revealed much slower performance for large multi file backups
(1 million + files per file system) with BUFPOOLSIZE's 4 GB, 16 GB, 30 GB,
with the latter being the worst. 18 hour incrementals at the 30 GB size,
went down to <3 hours at 1 Gb.
I believe the advice in the technote, of max 2 GB on 32bit systems, and
1/2 total system memory on 64bit sytems (which is why I ran into the
problem in the first place) is probablby not good advice, especially on
servers with large amounts of memory and large databases.
I'm sure more plays out in this problem, like database fragmentation,
memory speeds.
It doesn't make much sense does it that using more memory for a datbase
buffer slows the database reads down.
I'm sure someone else out there on this list has ther BUFPOOLSIZE set to
those larger sizes and is having this issue without even realizing it, as
I did.
Matt G.
|