COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: actcognosuser on 21 Nov 2019 08:19:38 AM

Title: Active users
Post by: actcognosuser on 21 Nov 2019 08:19:38 AM
Hi,

I am trying to establish a baseline by determining concurrent users on the system. Is there a way to establish this?
Any tools that could help with this?

Thanks!
Title: Re: Baseline for Performance Testing
Post by: Andrei I on 21 Nov 2019 09:37:36 AM
Do you need to figure out an average number of concurrent users from the historical data (logs, Audit, etc) ?

Or you would like to estimate a max number of concurrent users which can be handled by your Cognos environment without queuing?
Title: Re: Baseline for Performance Testing
Post by: actcognosuser on 21 Nov 2019 11:12:38 AM
Figure out the current concurrent user statistics to establish a baseline.

Then analyze the impact of adding significant amount of users.

Audit db is not set up. Is there a way to obtain this information from logs or parse the information ?
Title: Re: Baseline for Performance Testing
Post by: Andrei I on 22 Nov 2019 07:07:25 AM
You can parse Cognos logs.... But it would be so much easier to use Audit Db
Title: Re: Baseline for Performance Testing
Post by: actcognosuser on 22 Nov 2019 07:43:25 AM
Would you please point me in the right direction? Is it cogserver.log?

This is from parsing cogserver.log

Is there a Kb document which states what each column is? For example what are Col 2,4,5 , 6,11,13.


Col 1: Server name - 111.11.111.111:1111
Col2:   17823   
Col3:  Date - 11/19/2019 10:27   
Col4: -6   
Col 5: 969FE476F78EC07598BE9430FD9170567DC799397AA6F36EB99DB1995AD77A39   
Col 6: 2jl4M2y4Mq8j4hM9vCvs9wMM2C8d94MCwhCys994
Col 7:
Col 8:
Col 9:   http-0000-000
Col 10: RSVP
Col 11: 0000
Col 12: 2
Col 13: Audit.Other.cms.CM
Col 14: QUERY
Col 15: MODEL
Col 16: /content/folder[@name='FABC']/report[@name='XYZ Report']
Col 17: Success/Failure
Col 18: Parameters

Title: Re: Baseline for Performance Testing
Post by: Andrei I on 22 Nov 2019 08:26:39 AM
I never had to do it.
You can look at the Cognos utility LogviewV2
It comes with the Cognos Server install (at least for C10)
See attached image
Title: Re: Baseline for Performance Testing
Post by: actcognosuser on 25 Nov 2019 08:35:57 AM
I am not able to open this attachment.

Thank You!
Title: Re: Baseline for Performance Testing
Post by: actcognosuser on 25 Nov 2019 08:47:15 AM
I found Logviewv2.jar file in the bin location.

How do we parse or view this kind of file?

Thank You!
Title: Re: Baseline for Performance Testing
Post by: Andrei I on 25 Nov 2019 08:56:27 AM
You have to run LogviewV2.exe and load cogserver.log files
See attached image
Title: Re: Baseline for Performance Testing
Post by: actcognosuser on 25 Nov 2019 10:14:22 AM
Pardon my ignorance.

But i'm only seeing logviewvr.jar file and not the executable file.

Title: Re: Baseline for Performance Testing
Post by: Andrei I on 25 Nov 2019 10:43:59 AM
I do not know why you can't find this file in your environment.
Regardless  the screenshot above should help you to understand the  cogserver.log structure
Title: Re: Baseline for Performance Testing
Post by: actcognosuser on 02 Dec 2019 02:33:54 PM
Thanks so much Andrei.

I am not sure how to get the logviewv2 executable file.

Can you please send me a screenshot of all the column headers of the cogserver.log.( as per the logviewvr.exe)


Since we do not have Audit configured , i'm trying to somehow parse out number of users running reports during peak hours.

Thank You!
Title: Re: Baseline for Performance Testing
Post by: Andrei I on 03 Dec 2019 10:02:09 AM
See attached