2+ Hour Delay In Work Process Manager Running Tasks
Issue:-
--------
customer seeing workflow Manager start tasks to run a workflow and the task starts but will sit idle for 2+ hours (idle time increases throughout the day) before it runs its first query. The query is reported with db2 connect error after 542 seconds and retries and completes the wf proc is about 1 second.
ERROR
-----------------------
ObjMgrLog Error 1 00000aab516100c4:0 2013-04-07 16:22:44 (clicon.cpp (3592)) SBL-DBC-00105: An error has occurred executing a Sql statement.
Please continue or ask your systems administrator to check your application configuration if the problem persists.
DBCLog DBCLogError 1 00000aab516100c4:0 2013-04-07 16:22:44 SQLError: sqlstate 40003: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.13.102.18". Communication function detecting the error: "recv". Protocol specific error code(s): "78", "*", "*". SQLSTATE=08001