ADSM-L

Re: [ADSM-L] TSM performance very poor, Recovery log is being pinned

2007-07-27 13:24:59
Subject: Re: [ADSM-L] TSM performance very poor, Recovery log is being pinned
From: Robert Clark <Robert_Clark AT MAC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 27 Jul 2007 10:01:31 -0700
Is the SATA setup as disk storage pools? Is it filesystem or raw
logical volumes?

What is the OS? vmstat or top/topas may give some ideas.

What is the network transport? Fast ethernet?

[RC]

On Jul 27, 2007, at 2:49 AM, Craig Ross wrote:

10 days ago I Recently added 15TB of SATA storage and a new Fabric
with 4
new LTO drives to our 3584 library,
The DB is approx 90GB TSM

Few days ago I noticed processing had ground to halt, after digging
around I
have found as soon as server gets busy maybe 4 processes 8 or so
sessions
the recovery log begins "sh logpinned" to pin and the Database gets
locks.
Shown by running "sh locks"
And as result the server suffers!
Now today I have stopped using the new Tech LTO 3 and SATA and
things are
coping better but still worse than previous as soon as load is
increased Log
pins and processing slows drastically.

Are there any steps I can take which will help my scenario.
Would a DB UNLOAD RELOAD help that much?

Reference: Recovery log has heaps of room DB has heaps of room 90Gb
DB with
100GB of room.

Any advice is much appreciated.