Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2013

    Smile Unanswered: Frequent errors in DIAG Logs

    Hi All,

    I am using..
    Informational tokens are "DB2 v10.5.0.3", "special_32392", "IP23544_32392", and
    Fix Pack "3".
    Product is installed at "/opt/IBM/db2/V10.5FP4".
    on AIX box

    Getting following error in 'diag' logs every night, below is the snapshot for the same.
    This is a production servers and we are performing export on all the tables during this time.

    Following up the same with IBM support team.
    Export is nothing but a simple "SELECT" on the required table which is not at all required locks on that particular table.

    Pls. anyone can help me in this to overcome such issues.

    2014-09-11- I1781260A753 LEVEL: Error
    PID : 6161014 TID : 63594 PROC : db2sysc 0
    INSTANCE: db2ipfrn NODE : 000 DB : PRODFRN
    HOSTNAME: pneftfndb0p8
    EDUID : 63594 EDUNAME: db2lfr.1 (PRODFRN) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgReadStartUse, probe:2100
    MESSAGE : ZRC=0x80100079=-2146434951=SQLP_LCON "Conditional Conflict"
    DIA8132C Conditional lock error occurred, lock name was "".
    DATA #1 : String, 35 bytes
    logStreamId / extentNum / lockMode:
    DATA #2 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
    DATA #3 : unsigned integer, 4 bytes
    DATA #4 : Lock Mode, PD_TYPE_SQLP_LOCK_MODE, 8 bytes
    SQLP_LOOS (..S) - Share Lock


  2. #2
    Join Date
    Apr 2013

    Smile db2cluster Error In Diag Logs

    Hi Experts,

    Informational tokens are "DB2 v10.5.0.3", "special_32392", "IP23544_32392", and
    Fix Pack "3".
    Product is installed at "/opt/IBM/db2/V10.5FP3".

    I am getting below error continuously in diag logs but not able to judge/analyze. Can anybody please help me to sort out what could be the possible cause.

    2014-09-17- E160650A378 LEVEL: Error
    PID : 8389352 TID : 1 PROC : db2cluster
    INSTANCE: db2ipfrn NODE : 000
    HOSTNAME: pneftfndb0p8
    EDUID : 1
    FUNCTION: DB2 UDB, high avail services, sqlhaUIMain, probe:400
    MESSAGE : ECF=0x90000531=-1879046863=ECF_SQLHA_INVALID_PARAM
    Invalid parameter to SQLHA call


  3. #3
    Join Date
    Jan 2003
    Provided Answers: 5
    Usually with errors in the db2diag.log file that I do not understand, I just open a PMR with IBM and they will tell me what it means. I suggest you do the same.


  4. #4
    Join Date
    Dec 2007
    Richmond, VA
    Provided Answers: 5
    you have an HADR environment? is it set correctly and in peer to peer mode?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts