cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Errno 22 when backing up on DB2 server

le_jawa
Not applicable

Hello all!

We just installed Netbackup 6 on multiple AIX 6.1 servers, two of which are DB2 servers (v9.5, for the record).  Once we started running backup jobs on those servers, we started getting messages similar to the following in the job logs from the database servers:

hostname: ERR - Cannot open file /path/to/file.DBF. Errno = 22: A system call received a parameter that is not valid.

The files in question are all DB2 files.  Permissions for the files that fail backup are the same as those that succeed.  All file sizes are under the limit set in /etc/security/limits.  The only thing I can figure is that the files are locked by the DB.  if that's the case, does anyone know how to resolve it?  Or have I missed the mark completely?

Thank you,
Jason
1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

Are you see those errors during a normal file system backup (Standard)?
The DB2 databases should not be backed up while the database is up and running. Ideally the DB2 agent should be used for database backups and the dbf's excluded from normal file system backups.

View solution in original post

1 REPLY 1

Marianne
Level 6
Partner    VIP    Accredited Certified

Are you see those errors during a normal file system backup (Standard)?
The DB2 databases should not be backed up while the database is up and running. Ideally the DB2 agent should be used for database backups and the dbf's excluded from normal file system backups.