Hi Ian,
in fact, the session never get started even after hour. Another thing
that
i notice that the backup machanism using TSM seem to be very slow. I'm
not sure whether it is due TSM or my configuration on buffer size.
Sometime back i noticed a post on calculating the buffer size for
backup. I used the following to calculate the buffer size
I have about 77 table spaces. 15 table spaces use 32 Extent size and
the rest
of 62 table spaces uses 8 Extent size. The total extent for entire
database
is 976.
This is how i assign buffer size for 8 buffer
976 * 4096 = 3997696
3997696 * 8 = 31+ MB
So, i intend to modify the backup script as
db2 "backup db $dbname online use tsm open 4 sessions with 8 buffers
buffer 7808 parallelism 6"
As you can see my number of pages has been increased. I just wondering
whether
this would help me out speeding off backup process. Is there any other
method
or formula that i could use to optimize the backup process??
Please advice!!
Thanks
Uthuras
Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@corp.newsgroups.com>...
Uthuras wrote: Greetings,
We have DB2 V 8.1 with FP 4 on AIX 5.2. Our database backup is done
using TSM v
4.1.2. However, we notice TSM make use of only one session even though
we defined 4 sessions for backup. Here is the command
db2 "backup db $dbname online use tsm open 4 sessions with 8 buffers
buffer 3072 parallelism 6"
How do we enable the 4 sessions ? Is there any parameters need to set?
That is the correct way. Are you sure you only have 1 session connected
to the TSM server? During the first minute or two of the backup, you
will normally see only one session, and then the others sessions will
connect and start sending data.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----