• 1 reply
  • Latest Post - ‏2013-07-02T18:53:53Z by ThiagoBonfante
2 Posts

Pinned topic DB2 Full Text Search IQQD0040E Error

‏2013-07-02T14:14:45Z |

I have a production database running DB2 at 10.1.2 workgroup (OpenSuse 12.2) and I have Full Text Search running pretty well there. Now I'm trying to build a test enviroment, but when I turn over the production backup into test machine with 10.1.2 express-c (OpenSuse 12.2 also) the FTS is presenting this error:

<message>IQQD0040E The client specified the wrong authentication token.           $                java.util.concurrent.ThreadPoolExecutor.runWorker(             java.util.concurrent.ThreadPoolExecutor$   </message>                                             


The redbook says to me that error cause is: "Usually this error occurs when there are 2 or more text search instances configured with the same port number and one instance is already running".

I've already searched other instances but I've only found one. So "usually" does not apply to my situation.

Anyone know what else I can do to fix that?

Best regards, Thiago.


  • ThiagoBonfante
    2 Posts

    Re: DB2 Full Text Search IQQD0040E Error



    I've found out a solution. When the backup is transported to a new instance of DB2, de FTS application engage it communication with a token. After restored, we just need to go to the bin directory of FTS, commonly at /home/db2inst1/db2tss/bin and run this command:

      configTool generateToken -seed <username> -configPath ~/sqllib/db2tss/config

    Hope this help anyone who's passing by this trouble.