Prev: Migration from V8(solaris) to V9(redhat)
Next: message in db2diag.log
From: randi.clausen on 3 Jul 2007 16:08
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!

From: janman on 3 Jul 2007 16:37
On Jul 3, 3:08 pm, randi.clau...(a)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?

From: Lennart on 3 Jul 2007 16:47
randi.clausen(a)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
 | 
Pages: 1
Prev: Migration from V8(solaris) to V9(redhat)
Next: message in db2diag.log