Strange error message issued on DB2 10.5 FP8

[b***@gmail.com]

Hi Guys and Gals

AIX 7.1, DB2 10.5 FP8, 5 production DB's in HADR peer

Just out-of-the-blue comes this message this morning on my db2diag.log:


2017-08-28-07.12.22.996184-300 I38206A696 LEVEL: Warning
PID : 36700470 TID : 312456 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : OW_PROD
APPHDL : 0-31569 APPID: *LOCAL.db2inst1.180116180023
AUTHID : DB2INST1 HOSTNAME: p1proddb.vanhoof.com
EDUID : 312456 EDUNAME: db2agent (OW_PROD) 0
FUNCTION: DB2 UDB, config/install, sqlf_openfile, probe:3024
MESSAGE : File not found error was incorrectly detected as file successfully
opened after multiple attempts.
DATA #1 : String, 58 bytes
/db2syscat/db2inst1/NODE0000/SQL00001/MEMBER0000/SQLDBCONF
DATA #2 : signed integer, 4 bytes
1

now, /db2syscat is home to my DB2 catalog... and in the past month I have seen several cases where this code below doesn't work in trying to identify the current log path in a KORN script:

PATHTOLOGFILEScount=`db2 get db cfg for ow_prod | grep "Path to log files" | awk '{print $6}' | wc | awk '{print $2}' `



I'm reading this as an intermittent I-O Error...

Thoughts?

-Bruce

[TheBoss]

Post by b***@gmail.com
Hi Guys and Gals
AIX 7.1, DB2 10.5 FP8, 5 production DB's in HADR peer
Just out-of-the-blue comes this message this morning on my
2017-08-28-07.12.22.996184-300 I38206A696 LEVEL: Warning
PID : 36700470 TID : 312456 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : OW_PROD
APPHDL : 0-31569 APPID: *LOCAL.db2inst1.180116180023
AUTHID : DB2INST1 HOSTNAME: p1proddb.vanhoof.com
EDUID : 312456 EDUNAME: db2agent (OW_PROD) 0
FUNCTION: DB2 UDB, config/install, sqlf_openfile, probe:3024
MESSAGE : File not found error was incorrectly detected as file successfully
opened after multiple attempts.
DATA #1 : String, 58 bytes
/db2syscat/db2inst1/NODE0000/SQL00001/MEMBER0000/SQLDBCONF
DATA #2 : signed integer, 4 bytes
1
now, /db2syscat is home to my DB2 catalog... and in the past month I
have seen several cases where this code below doesn't work in trying
PATHTOLOGFILEScount=`db2 get db cfg for ow_prod | grep "Path to log
files" | awk '{print $6}' | wc | awk '{print $2}' `
I'm reading this as an intermittent I-O Error...
Thoughts?
-Bruce

My first thought would be there might be an issue with *ulimit* and/or
*MAXFILOP*