B2B Integration

 View Only
  • 1.  BP Sporadically Hangs during Connection to DB2

    Posted Wed November 11, 2020 05:03 PM
    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
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: BP Sporadically Hangs during Connection to DB2

    Posted Thu November 12, 2020 07:24 AM

    Hi Karen, 

    This query requires logs and other information. I would suggest that you raise a support ticket for this issue. 



    ------------------------------
    Tanvi Kakodkar
    Community Manager - Supply Chain and Internet of Things
    IBM
    ------------------------------



  • 3.  RE: BP Sporadically Hangs during Connection to DB2

    Posted Wed November 18, 2020 01:55 AM
    Hi Karen,

    I think opening a case with product support will make more sense here. However just mentioning few points to be considered:

    How many processes can run in parallel? If there are are many processes spawned in parallel then DB may not allow new connections / cursors to be opened? So this is a runtime issue and you will see such issues intermittently. If too many parallel executions then these will also require DB to be tuned specifically from concurrent connections point of view.

    How big is the dataset coming out from table / view. If every time the number records varies then a large dataset also can hang the map execution. Larger dataset will require more memory.

    Regards,

    ------------------------------
    BHARAT BALOTHIA
    ------------------------------



  • 4.  RE: BP Sporadically Hangs during Connection to DB2

    Posted Wed March 10, 2021 07:33 AM
    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
    ------------------------------