1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • Strange error message issued on DB2 10.5 FP8

    From [email protected]@21:1/5 to All on Mon Aug 28 06:00:37 2017
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From TheBoss@21:1/5 to [email protected] on Mon Aug 28 20:25:38 2017
    [email protected] wrote in news:[email protected]:

    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


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

    --
    Jeroen

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)