Skip to Content
author's profile photo Former Member
Former Member

SQL2025N error in db2 backup to SAMBA filesystem

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 28, 2008 at 10:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 28, 2008 at 10:30 AM

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

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.