Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    1

    Post Unanswered: QREP error in one QUEUE( QORD)

    2014-10-29-10.16.29.679420 <asnqwk> ASN7109I "Q Capture" : "QORD" : "WorkerThread" : At program termination, the lowest log sequence number of a transaction still to be committed (LSN) is "0000:0000:00BB:A4EF:5E42" and the highest log sequence number of a successfully processed transaction (MAXCMTSEQ) is "544F:6DEC:0000:0005:0000".
    2014-10-29-10.16.29.714038 <asnqwk> ASN7156I "Q Capture" : "QORD" : "WorkerThread" : The Q Capture program stopped processing log records in log file "/database/sqllogdir/EAI/NODE0000/S0034207.LOG".
    2014-10-29-10.16.29.714218 <stopLogrdThread> ASN8999D Waiting for log reader thread to stop
    2014-10-29-10.16.29.715057 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "WorkerThread" The thread "WorkerThread" received return code "0" from the exiting thread "txrdThread".
    2014-10-29-10.16.30.018350 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "414" from the exiting thread "WorkerThread".
    2014-10-29-10.16.31.019319 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "2001" from the exiting thread "AdminThread".
    2014-10-29-10.16.32.019304 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "2011" from the exiting thread "PruneThread".
    2014-10-29-10.16.32.020079 <Asnenv:delEnvIpcQRcvHdl> ASN0595I "Q Capture" : "QORD" : "Initial" The program removed an IPC queue with keys "(0x30000041)".
    2014-10-29-10.16.32.020102 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "0" from the exiting thread "HoldLThread".
    2014-10-29-10.16.32.020322 <erWhatSignal> ASN0591I "Q Capture" : "QORD" : "HoldLThread" The thread "HoldLThread" received "Handled" signal "SIGUSR2".
    2014-10-29-10.16.33.021315 <asnqcap::main> ASN0573I "Q Capture" : "QORD" : "Initial" : The program was stopped.



    The apply queue is stopping

    Can anyone have idea about it , thanks in advance

  2. #2
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Quote Originally Posted by rakesh341 View Post
    2014-10-29-10.16.29.679420 <asnqwk> ASN7109I "Q Capture" : "QORD" : "WorkerThread" : At program termination, the lowest log sequence number of a transaction still to be committed (LSN) is "0000:0000:00BB:A4EF:5E42" and the highest log sequence number of a successfully processed transaction (MAXCMTSEQ) is "544F:6DEC:0000:0005:0000".
    2014-10-29-10.16.29.714038 <asnqwk> ASN7156I "Q Capture" : "QORD" : "WorkerThread" : The Q Capture program stopped processing log records in log file "/database/sqllogdir/EAI/NODE0000/S0034207.LOG".
    2014-10-29-10.16.29.714218 <stopLogrdThread> ASN8999D Waiting for log reader thread to stop
    2014-10-29-10.16.29.715057 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "WorkerThread" The thread "WorkerThread" received return code "0" from the exiting thread "txrdThread".
    2014-10-29-10.16.30.018350 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "414" from the exiting thread "WorkerThread".
    2014-10-29-10.16.31.019319 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "2001" from the exiting thread "AdminThread".
    2014-10-29-10.16.32.019304 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "2011" from the exiting thread "PruneThread".
    2014-10-29-10.16.32.020079 <Asnenv:delEnvIpcQRcvHdl> ASN0595I "Q Capture" : "QORD" : "Initial" The program removed an IPC queue with keys "(0x30000041)".
    2014-10-29-10.16.32.020102 <asnThread::stop> ASN0590I "Q Capture" : "QORD" : "Initial" The thread "Initial" received return code "0" from the exiting thread "HoldLThread".
    2014-10-29-10.16.32.020322 <erWhatSignal> ASN0591I "Q Capture" : "QORD" : "HoldLThread" The thread "HoldLThread" received "Handled" signal "SIGUSR2".
    2014-10-29-10.16.33.021315 <asnqcap::main> ASN0573I "Q Capture" : "QORD" : "Initial" : The program was stopped.




    The apply queue is stopping

    Can anyone have idea about it , thanks in advance




    Hello rakesh,
    May be you need to check state of recv queue on target node, All i suspect there is some issue with LSN as well, Need to bring up your queue using the LSN number.
    Pl. check all the queue state is active. If bi-dir check the logs are getting processed for archival without any issues. As your case target node is unable to access your logs.
    happy if it can help you .. keep posted for the errors.
    Thx..
    - Ananth
    DB2 DBA LUW
    "coming second, just means you are the first loser"

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
  •