Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2

    Unanswered: Text Search on 10.5

    Is anyone else using Text Search on DB2 10.5 for Windows Server 2012?
    I am using it and I get a lot of CIE00756 errors. I have already made the changes recommended here: http://www-01.ibm.com/support/docvie...id=swg21397413 but it is still failing for those queries that use several text indexes on large tables.

    DB2 10.5 LUW
    Windows Server 2012 R2

    An example of a query that fails:
    SELECT ID
    FROM ContactTable
    WHERE (
    CONTAINS(FullName, CAST('"*test*"' AS VARCHAR(999))) = 1
    OR CONTAINS(FirstName, CAST('"*test*"' AS VARCHAR(999))) = 1
    OR CONTAINS(LastName, CAST('"*test*"' AS VARCHAR(999))) = 1
    )
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Problem solved - and I thought maybe it will help others.
    I've noticed that Text Search was using TCPv6 connections, so I've disabled TCPv6 as it says here: http://tweaks.com/windows/40099/how-...-disable-ipv6/
    Reboot Windows and we're fine.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    May 2015
    Location
    Korea
    Posts
    54
    Provided Answers: 1
    How did you find the cause? Exactly what diagnostic you did?

Posting Permissions

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