Limiting Number of Reports that Run

[dpccgf]

Our user runs some fairly intensive reports that consume some memory.  Is there a way to limit the number of reports that can "execute" and leave the other in "pending" until a spot opens up?

Thanks in advance!

[MFGF]

Our user runs some fairly intensive reports that consume some memory.  Is there a way to limit the number of reports that can "execute" and leave the other in "pending" until a spot opens up?

Thanks in advance!

Hi,

For the instance as a whole, do you mean, or just for the one user?

For the Cognos instance, the number of reports that can run concurrently is determined by the number of report services defined, multiplied by the number of connections. So, if you have (say) 6 interactive report services and 4 connections, the total number of interactive reports that can run concurrently is 6 x 4 = 24. Reducing the number of services or the number of connections will obviously influence this. The same principles apply to batch reports.

For the user, I don't know of any way to limit the number of reports he/she can submit individually. If the user is submitting reports in the background (ie batch) you could perhaps lower the settings for batch report service during peak period - it has settings for both peak period and non-peak period. If you set 1 process, 1 high affinity connection and 1 low affinity connection, that might do it. If other users wanted to submit reports in batch it would impact them too, though.

Cheers!

MF.

[dpccgf]

Thanks MFGF, no it is not for user, just the system overall.  These are fairly large TM1 report workbooks and running them all at once results in some of them failing due to that out of memory error.  When I run them sequentially they run fine.  So want to be able to limit the number of these reports that can run at once, which I know would effect the entire instance, but the users are fine with that.  Basically want to allow only 3 reports to run at once. 

So in your calculation, I can setup one report service, but if I have 5 connections the lowest I can go is 5, correct?

[MFGF]

Basically want to allow only 3 reports to run at once.

Ok - sounds like one service and 3 connections? 

So in your calculation, I can setup one report service, but if I have 5 connections the lowest I can go is 5, correct?

Yep - 5 connections would allow the service to run 5 reports concurrently.

MF.