Re: TDP/SQL and Striping

2004-04-20 03:11:34
Subject: Re: TDP/SQL and Striping
From: Yiannakis Vakis <yiannakis.vakis AT ITD.BANKOFCYPRUS DOT COM>
Date: Tue, 20 Apr 2004 10:11:06 +0300
You should edit the file C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.cfg and
add (or change) the stripes parameter to 2.

STRIPes      2

I'm concerned about your performance. Of course that depends on the LAN
infrastructure you have. We use a Gbit network and a 190GB dbase is backed
up in about 3 hours. We do have STRIPES 2 and max mount points 2.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Jeff White
Sent: 19 April 2004 13:32
Subject: TDP/SQL and Striping


TSM server v5.1.5.2 running on IBM mainframe. OS is Z/OS 1.4
TSM Client v4.1.5.0
TDP version 2.2.1
SQL Server 7.0

I have a 20gb SQL database that takes slightly more than an hour to backup
using TDP and a 200gb SQL database taking 15 hours to backup using TDP.

I am considering using striping. I have read the redbook and the TSM/SQL
installation and Users guide and have evrything setup, or so i thought.

Collocation on FILESPACES
Node MAXNUMMP set to 8 mount points
Device Class set to Mount Limit 8
TXNGROUPMAX set to 256
The 20gb database is on one physical disk
The 200gb database is spread across 3 physical volumes

When i backup, it only uses a single thread, i.e. one mount point. Do i
need to ask our Database Admin guys to put striping on the SQL database?
The manuals were'nt clear about this

Jeff White
Senior Systems Programmer
ICT Operations and Services
1st Floor
Miller Street
0161 837 5020
jeff.white AT DOT uk


This e-mail may contain confidential information or be privileged. It is
intended to be read and used only by the named recipient(s). If you are not
the intended recipient(s) please notify us immediately so that we can make
arrangements for its return: you should not disclose the contents of this
e-mail to any other person, or take any copies. Unless stated otherwise by
an authorised individual, nothing contained in this e-mail is intended to
create binding legal obligations between us and opinions expressed are those
of the individual author.

The CIS marketing group, which is regulated for Investment Business by the
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R -
for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  -
for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone
0161-832-8686   Internet   E-mail cis AT DOT uk

CIS Deposit and Instant Access Savings Accounts are held with The
Co-operative Bank p.l.c., registered in England and Wales number 990937,
P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS
Policyholder Services Limited as agent of the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited


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