HI

I have IBM AIX 4.3.2.0 running Baan on DB2. The database is about 270 G and it is using raw device not files.
when I use Baan to backup the database it gives me a poor backup rate about 1.1 G per hour. how can I make it faster??

Thanks in advance

There are so many ways like
1) Go for archiving and store the old data in some other server
2) If you are level1 driver try to change to Level 2 so that 270G will become
180G

regards
Juvenile

Hi ghabbour

Can u tell us more, how you use baan for backup.

rgds

Set up parameters such as RDS_FULL and SSTS_SET_ROWS in db_resource file ore as environment variables to "batch" mode type settings vs. OLTP.

You could also start several bdbpre processes each doing a particular set of tables.

Just some ideas.

Your backup seems to be very slow. As a comparison we back up 140 GB oracle database using AIX4.3.3-p620 'compress' (to intermediary disk) to reduce backup space in 3.5 hours. We then tar to LTO tape in approx .5 hour.

Hi All
Sorry to be late, I would like to make it a little bit clearer
1-
a- Due to some technical problems, Archiving is not an option.
b-I think level 1 and level 2 driver is related to the database itself, I mean it can not be changed unless you change the database itself.

2-I use the baan backup utility bdbpre6.1 for sequential dump of tables and store it on a hard disk until the whole backup is finished then take it on tape.

3- for the RDS_FULL and SSTS_SET_ROWS paramters, what are these parameters and what do they do?

Thank you all for your help, I really appreciate it.

Regards

You can search the threads on db_resource to understand how you can setup database parameters for your Baan database driver OR start already by reading this thread (http://www.baanboard.com/baanboard/showthread.php?t=10393&highlight=db_resource) and the performance guide that is mentioned there.