SQL2025N error in db2 backup to SAMBA filesystem

[Former Member]

Hi,

we have mounted an external disk in our linux system using SAMBA.

The db2 backup offline fails with this error message:

ERRORMESSAGE: Error -2025 in dmdb6bkp.c(1498):

SQL2025N An I/O error "4" occurred on media

"/BACKUP/APPS/HP2.0.db2hp2.NODE0000.CATN0000.20080425130153.001".

All users (sidadm, db2sid, sapsid ) have read/write permissions in the filesystem /BACKUP. This filesystem has not file size limited.

In the db2diag.log these errors appear.

2008-04-25-13.22.55.404908+120 E66661757G394 LEVEL: Info

PID : 24014 TID : 2987636400 PROC : db2agent (HP2) 0

INSTANCE: db2hp2 NODE : 000 DB : HP2

APPHDL : 0-7 APPID: *LOCAL.db2hp2.080425112250

AUTHID : HP2ADM

FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1391

MESSAGE : Starting an offline db backup.

2008-04-25-13.22.55.470988+120 E66662152G524 LEVEL: Warning (OS)

PID : 24029 TID : 2987636400 PROC : db2med.24014.0 0

INSTANCE: db2hp2 NODE : 000

FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:150

MESSAGE : ZRC=0x860F0004=-2045837308=SQLO_DGFL "general failure (DD)"

DIA8402C A disk error has occurred.

CALLED : OS, -, chmod OSERR: EPERM (1)

DATA #1 : File name, 62 bytes

/BACKUP/APPS/HP2.0.db2hp2.NODE0000.CATN0000.20080425132255.001

2008-04-25-13.22.55.476804+120 E66664510G892 LEVEL: Severe

PID : 24014 TID : 2987636400 PROC : db2agent (HP2) 0

INSTANCE: db2hp2 NODE : 000 DB : HP2

APPHDL : 0-7 APPID: *LOCAL.db2hp2.080425112250

AUTHID : HP2ADM

FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:1041

MESSAGE : SQL2025N An I/O error "" occurred on media "".

DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes

sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2025 sqlerrml: 64

sqlerrmc: 4 /BACKUP/APPS/HP2.0.db2hp2.NODE0000.CATN0000.20080425132255.001

Versions:

Operating system : SUSE Linux Enterprise Server 10 (i586)

VERSION = 10

Database: DB6 9.1.3

SAP kernel: 7.0 patch 133

Best regards and thanks in advance.

[markus_doehr2]

If you use *nix on both systems I suggest you configure NFS instead of SAMBA...

Markus

[former_member185954]

Hello,

What user permission does your db2agent run under ? Ensure that whichever user it is running under has

rwx (even the execute) permission to the /BACKUP and its internal directories, you may exclude the 'x' permission on files.

Regards,

Siddhesh

Edited by: Siddhesh Ghag on Apr 28, 2008 12:24 PM

[Former Member]

Hi,

thanks for the suggestion, but all permissions are ok.

The db2 user is in usbshare group:

drwxrwxr-x 1 root usbshare 0 2008-04-28 10:00 APPS.

We cannot use NFS, the disk is not in a system, it's an external disk connected directly to the network.

Regards and thanks for the replies.

Sonia.

Edited by: Soporte IBM on Apr 28, 2008 1:22 PM

Finally we fixed this problem.

The problem was the user owner in this filesystem, the owner must be db2<sid>.

Edited by: Soporte IBM on Apr 29, 2008 4:03 PM

[former_member185954]

glad that the problem is fixed, on oracle it is similar normally.