Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2014
    Posts
    3

    Unanswered: Informix CDC API starts extremely slowly

    Hi, I wrote a C application to read CDC records from Informix logical log using CDC API. It starts a CDC session from an existing LSN where many CDC records alsredy exist, and reads them using ifx_lo_read().

    Unfortunately, ifx_lo_read() returnds CDC_REC_TIMEOUT many times, for 3-5 minutes !), until it returns the first CDC records.

    However, if the application executes EXEC SQL CREATE TEMP TABLE DUMMY(id integer),
    then ifx_lo_read returns the CDC records immediately with no delay.
    I tried other EXEC SQL commands, but they do not shorten the delay.

    My application will be installed on customer sites who will not like the idea that it creates tables on their production DB, not even temp tables.

    Can anyone explain what causes the delay and why creating a temp table prevents it, and how I can shorten the delay without this workaround?

    TIA

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,


    you may want to ask your question on the International Informix User Group Forum, which Informix experts and IBM Lab people use to keep monitoring.



    Best regards,
    Eric

  3. #3
    Join Date
    Apr 2014
    Posts
    3

    This is not so simple...

    Thanks Eric. It's not so simple to register to IIUG. Actually the form submission failed again and again until I gave up .

    I'll try again later.

    Sruli

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Sruli,

    could you reach this page? or did you have problems before reaching there?

    International Informix User Group - Members Area

    If you continue having issues, please PM me with details, I'll inform the webmaster for fixing.

    Thx
    Eric

  5. #5
    Join Date
    Apr 2014
    Posts
    3

    I became an IIUG member

    Eric, I was able to register. Thanks

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
  •