Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2013
    Posts
    29

    Unanswered: DB2 error and warning messages

    Hello,

    after a test takeover on db2 9.7 I have noticed a bunch of warning messages in my db2diag.log file on my standby database:

    2013-08-12-06.44.20.348794+120 I308714984E321 LEVEL: Event
    PID : 5758 TID : 46912765695744PROC : db2acd
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:270
    STOP : Automatic Backup: evaluation has finished with errors on database MYDB

    2013-08-12-08.44.21.062250+120 I308715306E754 LEVEL: Warning
    PID : 5758 TID : 46912757823232PROC : db2acd
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, Health Monitor, db2HmonEvalBackup, probe:70
    CALLED : DB2 UDB, Health Monitor, hmonBkpGetHmonSQLConnection
    RETCODE : ZRC=0xFFFFFFFF=-1
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1060 sqlerrml: 7
    sqlerrmc: DB2HMON
    sqlerrp : SQLELOST
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate: 08004

    DB2 version: 9.7.0.4 fix pack: 4
    OS : SUSE Linux Enterprise Server 11 (x86_64)
    kernel: 2.6.32.46-0.3

    I have done a test takeover from primary to standby and back again. Everything worked fine (the database that was primary before is primary again), except for the warning messages that are now appearing on the standby database.

    I have searched for an answer on the web, but all I found was a fix for 9.5 database (mine is 9.7). Can anyone shed some light on the subject.

    Thank you in advance and best regards,
    kwhtre
    Last edited by kwhtre; 08-12-13 at 06:08. Reason: Forgot to write some info...

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55

  3. #3
    Join Date
    Oct 2008
    Posts
    82

    Cool

    I think it's due to the gap betwwen DB2HMOn and HADR ... We need to fix that gap..

  4. #4
    Join Date
    Feb 2013
    Posts
    29
    Thanks for fast answers

Posting Permissions

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