ADSM-L

Re: slow DB2 backups

2002-11-21 08:33:03
Subject: Re: slow DB2 backups
From: Mark Stapleton <stapleto AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 21 Nov 2002 07:32:23 -0600
On Mon, 2002-11-18 at 19:26, Muthyam Reddy wrote:
> We have recently migrated our database to DB2 from Infromix on AIX 4.3 and 
> TSM version level 5.1.0.0.
> Before migration.. Informix database use to take 7 -8 hrs for 400Gb 
> database(RAW filesystems).Now same size of Database on DB2(raw filesystems) 
> is taken 16hrs to offline backup.Guess I'm missing some important parameters 
> somewhere on client or server configuration files.
>
> Please can anyone share their knowledge in taking fast efficient backups on 
> DB2 to TSM.
> Advice me what kind of compression makes things work better.

Look in www.redbooks.ibm.com for the redbook about using TSM to back up
databases. It's got everything you need to know.

--
--
Mark Stapleton (stapleton AT berbee DOT com)
Certified TSM consultant
Certified AIX system engineer
MCSE

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