Hi Karen,
How many records you are fetching from DB in each map execution?
Whenever this issue had occurred, did you take a note of how many files are being processed by the Maps that connect to the DB - from your QueueWatch and Queue Depth?
From the tuning settings in Dashboard UI, you can check dbpools and max threads allocated to the db pools.
If this is occurring because of peak load, please check the values set at your database -- processes, open cursors.
If these are all looking fine, further log analysis and tuning will be needed. Please follow up with IBM Support.
Regards
Indu
------------------------------
INDUBHARATHI Routhu Lead Consultant
------------------------------
Original Message:
Sent: Wed November 11, 2020 05:03 PM
From: Karen Gallello
Subject: BP Sporadically Hangs during Connection to DB2
Hello,
I have a business process that uses an ODBC map to connect to a DB2 database to retrieve records that are waiting to be processed by SI. Occasionally the process will hang during the connection and will stay active until the system either runs out of memory or it is manually stopped. Once the process is stopped, the system needs to be restarted before the process can be resubmitted.
The last time this issue occurred, IBM support worked with me to increase the java heap size which was thought to be the issue. The process has been running fine until this morning when it hung up during the connection.
Has anyone worked with ODBC maps and encountered any similar issues? This is a new process that has only been in production for a few months and the problem has occurred at least once per month. Any input or assistance with figuring this out would be greatly appreciated!
Karen
------------------------------
Karen
------------------------------
#B2BIntegration
#SupplyChain