Suffice it to say that 183 tablespaces for that many tables seems
excessive. Is this a home grown or a
package system?
Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]
"Sanjay Nagpal "
<db2udbdba-ezmlms
hield-x36572415.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
10/26/2004 01:38
PM Subject
Re: Table space backup is slow -
how to improve?
strange...........183 tablespaces :(, hows the performance compare to less
number of tablespaces. ???
----- Original Message -----
From: "Stephane Paquette "
<db2udbdba-ezmlmshield-x65162992.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 26, 2004 10:06 PM
Subject: RE: Table space backup is slow - how to improve?
> Hi,
>
> I'm new to db2 udb, 183 tablespaces for 5G of data, isn't that a lot ?
>
> On Oracle, I would manage 5 gigs on 2-4 tablespaces maximum.
>
>
> Stéphane Paquette
> Administrateur de bases de données
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tél. (514) 499-7999 poste 7470 stephane.[Email address protected]
<mailto:stephane.[Email address protected]
>
>
>
> -----Original Message-----
> From: McClendon Rick
> [mailto:db2udbdba-ezmlmshield-x58673631.[Email address protected]
> Sent: 26 octobre, 2004 12:08
> To: LazyDBA Discussion
> Subject: Table space backup is slow - how to improve?
>
>
> I'm running DB2 UDB V8.1.7 on Linux. We have 183 tablespaces holding
> approximately 5g of data. It takes about 4 hours to complete the online
> image copy cycle.
>
> Anyone know of some things I can consider tweaking to improve
> performance?
>
> Rick
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---NOTICE---
> This E-mail, including the attachment/(s) if any, has been scanned for
viruses and dangerous content before delivering to
> your Mailbox. For any problem please contact Technical Support Cell -
Mumbai. [Email address protected]
>
Top Headlines from www.timesofindia.com and www.economictimes.com
Veerappan's moolah lying buried in the woods
http://timesofindia.indiatimes.com/articleshow/892601.cms
Only when you win at work can you win at home
http://economictimes.indiatimes.com/articleshow/893514.cms
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page