ADSM-L

Re: Slow DB backups.

2002-10-17 02:09:58
Subject: Re: Slow DB backups.
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 17 Oct 2002 02:08:20 -0400
Did you recently have a database expansion?
Are you using RAW volumes or a JFS for the database?
 The layout of the above could really make a difference.  You can all of a
sudden get horrible performance.

What you need to do is look at all of the database backup messages and see
if the rate of a full or dbs type dump is consistent throughout, pages per
30 seconds.  If you notice a steep drop off, that is your problem.  Part of
the database is on a configuration that is bad.  We had this situation.

There is also another little scenario that can really bust you if you do not
realize what you are doing.  If you increase the DB buffer pool and it
causes the computational working set on an AIX TSM server to get larger than
the default of 20 percent of memory you will page your butt off.  This is
easy to fix.  On AIX, just use VMTUNE to set the maxperm (-P) and minperm
(-p) parameters like Mark says.  40 and 10 are a good start.  The other
thing you can do that we found really speed up the backups was raising the
maxfree and max page read ahead.  Remember though, all of these parameters
apply to JFS buffers.  If you are using any JFS at all the maxperm and
minperm could be factors.

I saw the same things you did once my TSM server grew up.  With Mark's
suggestions mine purrs like a kitten now.

What is your hardware?

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Suad Musovich [mailto:s.musovich AT AUCKLAND.AC DOT NZ]
Sent: Wednesday, October 16, 2002 2:52 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Slow DB backups.


Depends if you are running other processes (especially expiration). Also you
havent mentioned your HW configuration.

On Thu, 2002-10-17 at 04:54, Dearman, Richard wrote:
> I haven't done aTSM DB backup in the last few days.  So I started one
> today and it is moving very slow I have a 30GB database and it is only
> reading at about 500KB/s.  At this rate it will take hours to backup.
> Before it would only take 45minutes.
>
> Is this normal?
>
> Thanks
> ***************************EMAIL DISCLAIMER***************************
> This email and any files transmitted with it may be confidential and
> are intended solely for the use of th individual or entity to whom
> they are addressed. If you are not the intended recipient or the
> individual responsible for delivering the e-mail to the intended
> recipient, any disclosure, copying, distribution or any action taken
> or omitted to be taken in reliance on it, is strictly prohibited.  If
> you have received this e-mail in error, please delete it and notify
> the sender or contact Health Information Management 312.996.3941.

<Prev in Thread] Current Thread [Next in Thread>