DB2 backups running slow

mixxalot · #1 (**permalink**) 11-20-03, 13:16

I am running a full online database backup on DB2 UDB 7.2 FP6 with AIX 5.2L both 32 bit. Normally the backups only take 2-3 hours but for some reason lately the backups are running MUCH SLOWER than usual. Like 5-6 hours. Any way to improve performance of backups? Thanks.

Scott

sathyaram_s · #2 (**permalink**) 11-20-03, 19:21

Could be other activity on the system ...

You can use buffer size, numbuffers,parallelism, numsessions(if you are using TSM) etc ...

Cheers
Sathyaram

Quote:

Originally posted by mixxalot
I am running a full online database backup on DB2 UDB 7.2 FP6 with AIX 5.2L both 32 bit. Normally the backups only take 2-3 hours but for some reason lately the backups are running MUCH SLOWER than usual. Like 5-6 hours. Any way to improve performance of backups? Thanks.

Scott

Internet Services

Web Development

Digital Marketing

Consumer Tech