ESP dSeries Workload Automation

 View Only
  • 1.  Reporting takes very long time

    Posted Apr 02, 2020 02:08 PM
    Edited by Ravikumar K Apr 02, 2020 02:08 PM
    Hi Everyone.

    When i run any reports from Desktop client it is taking very long time to generate and produce the report.Is there any system parameter that we need to change to improve the efficiency of reporting

    Also, have an other issue when i run JOBMAP cli command from Desktop client it takes long time and Master engine itself going down


  • 2.  RE: Reporting takes very long time
    Best Answer

    Broadcom Employee
    Posted Apr 03, 2020 09:25 AM
    Hello,
    When Reports are executed there are several things happening on DE server side.  The reporting runs as an external process.  It connects to your database and then gathers data.  Then it builds the report from the data.  Check if your server has adequate memory, ideally it should have an additional of 2-4 GB free.
    Check if your database is busy or had large of number of records in history tables.  Make sure you have housekeeping jobs running to clear up history data.
    See this link here and this one here.

    Thank you,
    Nitin Pande

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------