DB2 commands encounter 0x83000299 mapping to OS Error 0x299 = 665 while writing data to media

Technote (troubleshooting)


Problem(Abstract)

While running any commands in DB2 which are responsible for writing data to media users might encounter below errors :

SQL2025N An I/O error occurred. Error code: code. Media on which this error occurred: dir_or_devices.
SQL2024N The utility encountered an I/O error code while accessing the file type file-type.

Symptom

Error messages returned to application and in db2diag.log


Cause

The RC 0x83000299 maps to OS Error 0x299 = 665 which suggests that the operation could not continue due to a file system limitation.

Diagnosing the problem

In the db2diag.log, there will be more information related to the SQL2025N or SQL2024N error codes. It will contain something similar to following :

yyyy-mm-dd-mm.ss.ms.+ t                  LEVEL: Severe
PID     : 1028                 TID  : 2468        PROC : db2syscs.exe
INSTANCE: db2_instance_name               NODE : 000
EDUID   : 2468                 EDUNAME: db2pfchr (db name) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSMapAndWrite, probe:4154
MESSAGE : ZRC=0x83000299=-2097151335

Checking the ZRC :

$ db2diag -rc -2097151335

Input ZRC string '-2097151335' parsed as 0x83000299 (-2097151335).

ZRC value to map: 0x83000299 (-2097151335)
        V7 Equivalent ZRC value: 0xFFFFB299 (-19815)

ZRC class :
        Unexpected Operating System error (Class Index: 3)
Component:
        Unknown component (Component Index: 0)
        Undefined as of DB2 v9.7.0.6; s120629
Operating system reason code (errno):
        0x00000299 (665) = Error 665 occurred.
NOTE: Errno value 665 is excessively large.
        It is possible that this error code is not a ZRC value.


This directly maps to OS error 0x299 == 665 ERROR_FILE_SYSTEM_LIMITATION

665 (0x299) : The requested operation could not be completed due to a file system
limitation.

Hence, it is the OS, which fails to complete the DB2 write request to the media due to the above file limitation error and thus, DB2 fails with error codes SQL2025N and/or SQL2024N.

Resolving the problem

Please refer to IBM Information center for error codes SQL2025N and/or SQL2024N.


There are several Microsoft technotes, which provide information for this type of problem, here are a couple of them :
http://support.microsoft.com/kb/2002606
http://support.microsoft.com/default.aspx?scid=kb;EN-US;967351

If users still get the same error after applying the proposed Microsoft patches, please engage Microsoft support to further assist on finding the root cause.


Related information

SQL2025N
SQL2024N

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.1, 9.5, 9.7, 9.8, 10.1

Operating system(s):

Windows

Reference #:

1644966

Modified date:

2013-07-25

Translate my page

Machine Translation

Content navigation