Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2014
    Location
    Long Island, New York
    Posts
    31

    Answered: SQL Replication error messages

    Does anyone know where to find documentation on SQL Replication error and warning messages. I'm having a hard time tracking down these messages. I think the second one is related to log file sizes because I saw "log file saturation" messages in db2diag.log file.

    2017-08-22-10.58.16.165166 <CPAINS2(CF/07)> ASN1001E APPLY "MYQUAL2" : "WorkerThread". The Apply program encountered an SQL error. The ERRCODE is "CF0107". The SQLSTATE is "09000". The SQLCODE is "18446744073709550893". The SQLERRM is "xxxx.xxxx-REC_INSERT▒-803▒23505▒1|xxxx.xxxx_PM_KEY". The SQLERRP is "SQLDMISR". The server name is "". The table name is "xxxx.xxxx_REC".

    2017-08-22-10.56.38.545749 <CPDTGT(73/01)> ASN1001E APPLY "MYQUAL1" : "WorkerThread". The Apply program encountered an SQL error. The ERRCODE is "730101". The SQLSTATE is "09000". The SQLCODE is "18446744073709550893". The SQLERRM is "xxxx.xxxx_DELETE_2▒-964▒57011▒". The SQLERRP is "SQLRL2F5". The server name is "". The table name is "xxxx.xxxx_REC".

    Thank you.

  2. Best Answer
    Posted by mark.bb


  3. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    306
    Provided Answers: 46

  4. #3
    Join Date
    Sep 2014
    Location
    Long Island, New York
    Posts
    31
    Thank you Mark, I didn't realize the error code was embedded in the message. Now I know where to look.

    xxxx.xxxx-REC_INSERT▒-803▒23505▒1|xxxx.xxxx_PM_KEY

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
  •