DB Backup error

randi.clausen

When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>". The backups run every night. This error appears about two
times a week. This process is backing up databases from one server
over to another server both with OS Windows 2000 SP4. The destination
drive is a RAID 5 net bay device. The batch job that executes has
been running for years and the only recent change I know of is that
both servers had the Daylight Savings Time patch installed back in
March, 2007. The RAID drives do not indicate a problem visually. At
this point, I have no idea what is causing the failure. Please help.
Thank you!

Jul 3 '07 #1

janman

On Jul 3, 3:08 pm, randi.clau...@illinois.gov wrote:

When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>". The backups run every night. This error appears about two
times a week. This process is backing up databases from one server
over to another server both with OS Windows 2000 SP4. The destination
drive is a RAID 5 net bay device. The batch job that executes has
been running for years and the only recent change I know of is that
both servers had the Daylight Savings Time patch installed back in
March, 2007. The RAID drives do not indicate a problem visually. At
this point, I have no idea what is causing the failure. Please help.
Thank you!

Did you check the permissions for the dir?

Jul 3 '07 #2

Lennart

ra***********@illinois.gov wrote:

When backing up a group of DB2 WSE v8.2 databases, I am getting the
following error on one or two backups out of 38 being performed.
"SQL2025N An I/O error "200" occurred on media <target directory
path>". The backups run every night. This error appears about two
times a week. This process is backing up databases from one server
over to another server both with OS Windows 2000 SP4. The destination
drive is a RAID 5 net bay device. The batch job that executes has
been running for years and the only recent change I know of is that
both servers had the Daylight Savings Time patch installed back in
March, 2007. The RAID drives do not indicate a problem visually. At
this point, I have no idea what is causing the failure. Please help.
Thank you!

Given your description of the problem my best guess is network problems.
Check whether the network connection dropped at the time of the backup
that failed.
/Lennart

Jul 3 '07 #3