Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

IBM Cognos Analytics Slow

  • 1.  IBM Cognos Analytics Slow

    Posted Thu June 20, 2024 09:14 AM

    In recent months the advanced report system has been very slow to navigate, before advanced processing was faster, and we have not had any increase in the use of cognos, does anyone have any suggestions on what can be done or analyzed
    Note, we increased the RAM to 32GB



    ------------------------------
    João Alves
    ------------------------------


  • 2.  RE: IBM Cognos Analytics Slow

    Posted Fri June 21, 2024 04:51 AM

    Hi João,

    Which version do you use? You might want to check the level of Audit on your system. Make sure your logging level is Basic (audit enabled) or Minimal (audit is disabled). You shoud avoid to use Full or Trace.

    More information: Setting up audit reporting

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------

    Original Message


  • 3.  RE: IBM Cognos Analytics Slow

    Posted Tue June 25, 2024 01:24 PM
    Edited by João Alves Tue June 25, 2024 01:33 PM

    Hi Patrick, we are on version 11.1.7-2106251648

    Also all our settings are at minimum

    ------------------------------
    João Alves
    ------------------------------

    Original Message


  • 4.  RE: IBM Cognos Analytics Slow

    Posted Thu June 27, 2024 06:00 AM

    Hi João,

    You are using an old release (11.1.7-2106251648, also known as v11.1.7 FP3, release in June 2021). You should probably upgrade to v11.1.7 FP8 (11.1.7-2402131538, release in February 2024).

    Best regards,



    ------------------------------
    Patrick Neveu
    Collaboration Betters The World (CBTW)
    IBM Champion
    ------------------------------

    Original Message


  • 5.  RE: IBM Cognos Analytics Slow

    Posted Fri June 21, 2024 10:22 AM

    Are you running Cognos on Windows or Linux?  If Windows, how often do you reboot the server?  I would assume at least monthly if you're applying Windows security updates.  We tend to patch every other month unless Microsoft releases a zero-day type critical vulnerability patch.  On the months that we don't patch, I still reboot.  I've found having Cognos running more than 45-50 days since a reboot starts causing occasional odd issues (transient report failures, unable to authenticate schedule user credentials, etc).  Cognos definitely has memory leaks and their java code doesn't seem to do sufficient garbage collection over a long period of time.

    Additionally, I'd recommend doing some checking to see how much RAM Cognos is using.  We have our Windows (2016 & 2022) servers configured for 64GB.  We use SQL Server for our content store and it's installed on the same server as Cognos. It's configured for 10GB RAM.  We have the Cognos JVM heap set to 20GB so once things are up and stable we tend to be running with 75% RAM utilization.

    If you're running on Linux, be sure to check how much swap is being used.  Once swapping starts happening your performance can really tank, especially if you're running the content store on the same server.

    Regards,

    Wayne



    ------------------------------
    Wayne Westlake
    ------------------------------

    Original Message


  • 6.  RE: IBM Cognos Analytics Slow

    Posted Tue June 25, 2024 01:39 PM

    Hi Wayne, we are using Windows, when we detected the problem we restarted the machine, but it continued to be slow



    ------------------------------
    João Alves
    ------------------------------

    Original Message


  • 7.  RE: IBM Cognos Analytics Slow

    Posted Mon June 24, 2024 07:03 AM

    Hi Joao

    Are you able to eliminate the webserver as a possible culprit by testing via the dispatcher directly?



    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 8.  RE: IBM Cognos Analytics Slow

    Posted Tue June 25, 2024 11:15 AM

    When we upgraded to 11 (new Glass Interface) we had some issues with slow navigation when there were a lot of logged in users.  Increasing the value for "Maximum number of processes for the batch report service during peak period" resolved it.

    Shawn



    ------------------------------
    Shawn Lamson
    ------------------------------

    Original Message


  • 9.  RE: IBM Cognos Analytics Slow

    Posted Tue June 25, 2024 01:37 PM

    Our setting is at 2, what value did you increase it to?



    ------------------------------
    João Alves
    ------------------------------

    Original Message


  • 10.  RE: IBM Cognos Analytics Slow

    Posted Tue June 25, 2024 02:27 PM

    We increased it to 6 (six) for both peak and non-peak hours.

    Regards,

    Shawn



    ------------------------------
    Shawn Lamson
    ------------------------------

    Original Message


  • 11.  RE: IBM Cognos Analytics Slow

    Posted Wed July 31, 2024 12:57 PM

    Hi - Can you check your Cognos Installed directory for a specific file named "Cogstatup.lock" in Configuration Folder.



    ------------------------------
    Hashim Raza
    ------------------------------

    Original Message


Related Content