Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2016
    Posts
    29

    Answered: DB2 diaglog error on db210.5 fp8

    Hello all,

    After migrating form 9.7 to 10.5 i am seeing below diaglog error every day on all environments.
    can some one suggest what that could be ?



    2017-08-20-11.28.09.694975+120 E35620728A1116 LEVEL: Error
    PID : 25952370 TID : 25393 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : EMADB
    APPHDL : 0-58499 APPID: *LOCAL.db2ecqea.170820092813
    AUTHID : DB2ECQEA HOSTNAME: lnxaix21375999
    EDUID : 25393 EDUNAME: db2agent (EMADB) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post, probe:870
    MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : String, 28 bytes
    UCstate terminate bit is set
    DATA #2 : Hexdump, 4 bytes
    0x0000000110E09688 : 0000 0140 ...@
    DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLRRRCP
    sqlerrd : (1) 0x80090003 (2) 0x00000003 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

  2. Best Answer
    Posted by db2mor

    "I have seen that message sqlca already built so many times, with different sqlcodes, so after investigation of the SQLCODE and zrc , I usually ignore it as I could not find any impact it had, and at least one PMR that I opened resulted in IBM suggesting that I ignore it."


  3. #2
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    Study the information for SQL1224N in the Knowledge Center for V10.5 and determine by elimination and monitoring the most likely causes (there are many).

  4. #3
    Join Date
    Apr 2016
    Posts
    29
    Thanks db2mor,

    I have went through those errors in the IBM link https://www.ibm.com/support/knowledg...sql01224n.html
    And did some RND on our Test DB but no luck. After research I just want to ask our DBA's, on their view .
    I was told by one of my friend that, This diaglog error is a bug and can be ignored. I just want some more information possible from other DBA's around the world.

  5. #4
    Join Date
    Apr 2012
    Posts
    1,143
    Provided Answers: 27
    I have seen that message sqlca already built so many times, with different sqlcodes, so after investigation of the SQLCODE and zrc , I usually ignore it as I could not find any impact it had, and at least one PMR that I opened resulted in IBM suggesting that I ignore it.

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
  •