May be he is referring to 183 tables, 183 tablespace for 5 GB is a lot....

Regards,
Kondal YENNARAM
Database Engineering


-----Original Message-----
From: Stephane Paquette [mailto:db2udbdba-ezmlmshield-x65162992.[Email address protected]
Sent: Tuesday, October 26, 2004 12:36 PM
To: LazyDBA Discussion
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


DB2 & UDB email list listserv db2-l LazyDBA home page