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
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 286 |
Nodes: | 16 (2 / 14) |
Uptime: | 89:22:46 |
Calls: | 6,496 |
Calls today: | 7 |
Files: | 12,100 |
Messages: | 5,277,442 |