ile system or message queue is no longer available

[Former Member]

Hi All,

We are using DB2 and AIX. We getting below error message in db2 log file.Please advise on this issue.

2014-08-13-05.09.08.624033+060 I12752832A1291     LEVEL: Error (OS)

PID     : 25756258             TID  : 1           PROC : db2fmp (168768) 0

INSTANCE: db2fdf               NODE : 000

APPID   : 10.144.69.239.57155.140801190410

EDUID   : 1                    EDUNAME: db2fmp (168768) 0

FUNCTION: DB2 Common, OSSe, OSSMountListing::getNext, probe:90

MESSAGE : ECF=0x90000034=-1879048140=ECF_FILE_REMOTE_SYSTEM_NOT_ACTIVE

          File is on a remote system and the link to that system is not active

CALLED  : OS, -, statvfs

OSERR   : ESTALE (52) "A file, file system or message queue is no longer available."

CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)

  [0] 0x09000000074F5548 pdOSSeLoggingCallback + 0x34

  [1] 0x0900000008F0A6C4 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4

  [2] 0x0900000008F0AB70 ossLogSysRC + 0x70

  [3] 0x0900000008F2EB90 getNext__15OSSMountListingFCPC23OSSMountListingGetParamCP12OSSMountInfo + 0x4B0

  [4] 0x09000000020314A4 db2sap_mount_info + 0x3C4

  [5] 0x0900000007760EE4 sqloInvokeFnArgs + 0xB4

  [6] 0x0900000007760D44 @76@sqlerRunRoutine__FP13sqleInvokerCBPi + 0x168

  [7] 0x0900000007760AD0 sqlerDyload + 0x140

  [8] 0x090000000774AA40 sqlerFmpListener + 0x154

  [9] 0x0000000100001230 main + 0x910

Regards,

Raj

[JPReyes]

This simply means you have lost a NFS mount.

Check your file system mounts.

Regards, Juan

[Former Member]

Hi,

I have checked with AIX team filesyetm every thing fine.Please tell me which filesystem caused thi issue.

Reagrds,

Raj