I hope that there are 183 tables, not 183 tablespaces...
Any way backup time of 4 hours for 5 GB database is definetly a bit high....
Here is some performance tuning steps....
If you are using disk backup ..
1) You can use multiple sessions...
example :
BACKUP DATABASE sample TO /bkup_dir1,/bkup_dir2,/bkup_dir3 WITH 6 BUFFERS
BUFFER 2048
2) If you are using TSM for backup .. can use ..
example :
BACKUP DATABASE sample USE TSM OPEN 3 SESSIONS WITH 6 BUFFERS BUFFER 2048
Normal practice is use double the number of buffers,to number of
sessions(applicable to both disk/TSM)...
-----Check the UTIL_HEAP_SZ ,it should accomodate the buffers----
Note: Here is catch , if you are using TSM and multiple sessions, TSM must
be enabled to allow multiple tape mount simultaneously....
3) Finally you would like to use PARALLELISM n ...
This parameter defines the number (n) of processes that are started to read
data from the database. Each process is assigned to backup a specific table
space.
Note : Parallelism must be less than number of table spaces. And if you
really have 183 tablespaces, I don't know what you should set it but
PARALLELISM 4 - 6 , probably is good start.
Thanks
Amit Rai.
-----Original Message-----
From: Yennaram Kondal
[mailto:db2udbdba-ezmlmshield-x59745296.[Email address protected]
Sent: Tuesday, October 26, 2004 1:41 PM
To: LazyDBA Discussion
Subject: RE: Table space backup is slow - how to improve?
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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================
DB2 & UDB email list listserv db2-l LazyDBA home page