ADSM-L

Re: slow DB2 backups

2002-11-18 21:18:41
Subject: Re: slow DB2 backups
From: Zig Zag <veritrash AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 18 Nov 2002 18:18:32 -0800
Muthyam,

Lotza things you could look at:

DSM.SYS file check the parmaters, do they make sense or jive with your OS 
settings?

Check the archives for TSM to OS tuning, I've caught a lot of good articles 
there!

Is compression on? Lotz of work on the client to do that.
What is your backbone? GBit/Css/En ?

Is your API current? What DB2 level are you at, there was a bug back a year or 
so
ago with DB2 not working correctly with TSM.

Is your TSM server a utility server like ours running 60+ billion other
applications, gasping for memory begging to turn itself off?

We had a slowness or "it won't do" performance problem. We took 3 hours off our
backups changing mgmt class to go to tape. Also running 1/2 on SP switch and 
1/2 on
GBit.(Switch card was getting hammered)

I get about 25 Sessions/Clients done in 15-16 hours for 12TB. 12 Fcal Tape
drives(3590). Client wants it done in 8.

All I want for xmas is a NEW TSM server. :)

--- Muthyam Reddy <MREDDY AT JOY DOT COM> wrote:
> ** High Priority **
>
> Hello...one and all
> subject:Slow DB2 backups on TSM.
>
> 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.
>
> We are just migrated to DB2.
>
> please...... needs urs help.
>
> thanks and regards
> /mani
>
>
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> This electronic mail transmission contains information from Joy Mining 
> Machinery
> which is confidential, and is intended only for the use of the proper 
> addressee.
> If you are not the intended recipient, please notify us immediately at the 
> return
> address on this transmission, or by telephone at (724) 779-4500, and delete 
> this
> message and any attachments from your system.  Unauthorized use, copying,
> disclosing, distributing, or taking any action in reliance on the contents of
> this
> transmission is strictly prohibited and may be unlawful.
>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com

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