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


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