Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    3

    Unanswered: SQLCA has already been built

    Hi all Does anybody has any idea of fixing this error . I really appreciate all your help.
    Thanks. mine is Db2 8.2 Aix 5.2

    2007-05-02-14.13.29.909956-360 I262439C423 LEVEL: Error
    PID : 55018 TID : 1 PROC : db2agent (P001) 0
    INSTANCE: db2p01 NODE : 000 DB : P001
    APPHDL : 0-393 APPID: *LOCAL.db2p01.070502201329
    FUNCTION: DB2 UDB, relation data serv, sqlrr_appl_init, probe:180 RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
    "SQLCA has already been built"

    2007-05-02-14.13.29.925313-360 I262863C692 LEVEL: Error
    PID : 55018 TID : 1 PROC : db2agent (P001) 0
    INSTANCE: db2p01 NODE : 000 DB : P001
    APPHDL : 0-393 APPID: *LOCAL.db2p01.070502201329
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1060 sqlerrml: 8
    sqlerrmc: NBKXG4O
    sqlerrp : sqlrrait
    sqlerrd : (1) 0x8012006D (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2007-05-02-14.13.29.951082-360 I263556C417 LEVEL: Severe
    PID : 55018 TID : 1 PROC : db2agent (P001) 0
    INSTANCE: db2p01 NODE : 000 DB : P001
    APPHDL : 0-393 APPID: *LOCAL.db2p01.070502201329
    FUNCTION: DB2 UDB, base sys utilities, sqlesrsu, probe:140 RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
    "SQLCA has already been built"

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    A quick search on the IBM support site came up with this:

    http://www-1.ibm.com/support/docview...UTF-8&lang=all

    Andy

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    This is usually a secondary error message, appearing as a result of an earlier condition, not unlike SQL0902N. Check db2diag.log above these entries to find the root cause.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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