1- Increase the parameters : UTL_HEAP_SZ
2- Use db2backup : WITH num-buff BUFFERS BUFFER buffer-size PARALLELISM n compress


Godd luck
-----Message d'origine-----
De : McClendon Rick
[mailto:db2udbdba-ezmlmshield-x58673631.[Email address protected]
Envoyé : mardi 26 octobre 2004 18:08
À : LazyDBA Discussion
Objet : 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