Running mulitple jobs/reports

[bud659]

On 10.2.1 FP4 ,  when I run 2 different jobs..  the 1st job goes into 'Executing' status and the 2nd job goes into 'PENDING' status

Is there a tuning parameter that determines how many jobs/reports I can run simultaneously at one time? 

Thanks

[MFGF]

On 10.2.1 FP4 ,  when I run 2 different jobs..  the 1st job goes into 'Executing' status and the 2nd job goes into 'PENDING' status

Is there a tuning parameter that determines how many jobs/reports I can run simultaneously at one time? 

Thanks

How many reports does the first job trigger? How many batch report services are configured in your instance, and how many connections? The maximum number of simultaneous reports that can be run is the multiple of these two values. I'm guessing your first job has enough reports to use up all of the available connections on all the batch report services, so the rest (including the reports for the second job) will queue until resources are freed up to process them.

Cheers!

MF.

[bud659]

The first job has 11 reports and the second job has 3 reports. 
Batch report services :  Number of configured processes = 9.     
I couldn't find any Connection settings.  where are they? 

And if I understand correctly,  If I want to control how many reports/jobs are run at the same time,   its these 2 settings that control that?  Now if I can only find connections

Cheers

[MFGF]

The first job has 11 reports and the second job has 3 reports. 
Batch report services :  Number of configured processes = 9.     
I couldn't find any Connection settings.  where are they? 

And if I understand correctly,  If I want to control how many reports/jobs are run at the same time,   its these 2 settings that control that?  Now if I can only find connections

Cheers

Hi,

In the Admin Console, go to Configuration > Dispatchers and Services and go into the properties of the Batch Report Service entry. On the Settings tab, select "Tuning" frop the dropdown and you will see things like:

Number of high affinity connections for the batch report service during non-peak period
Number of low affinity connections for the batch report service during non-peak period
Maximum number of processes for the batch report service during non-peak period
Number of high affinity connections for the batch report service during peak period
Number of low affinity connections for the batch report service during peak period
Maximum number of processes for the batch report service during peak period

Cheers!

MF.

[cognoslearner1]

Hi MFGF,

So you mean number of interactive reports that can be run simultaneously = Maximum number processes for the Interactive report service * number of connections

for ex : Maximum number processes for the Interactive report service = 2 * # of CPUs ( lets consider we are using 2 cpus) = 4
Number of low affinity connections for the Interactive report service = for each BIBUS process 2 (in our ex number of BIBUS =2 * # of CPUs = 2 * 2 =  4 )      2 * 4 =  8 connections
8
So maximum number of interactive reports that can be run in this case is =  4 * 8 = 32 reports.

If I have another dispatcher then number of interactive reports would double to 64 ?

Is this calculation is correct ?

[MFGF]

Hi MFGF,

So you mean number of interactive reports that can be run simultaneously = Maximum number processes for the Interactive report service * number of connections

for ex : Maximum number processes for the Interactive report service = 2 * # of CPUs ( lets consider we are using 2 cpus) = 4
Number of low affinity connections for the Interactive report service = for each BIBUS process 2 (in our ex number of BIBUS =2 * # of CPUs = 2 * 2 =  4 )      2 * 4 =  8 connections
8
So maximum number of interactive reports that can be run in this case is =  4 * 8 = 32 reports.

If I have another dispatcher then number of interactive reports would double to 64 ?

Is this calculation is correct ?

No. Not interactive reports. These are reports that are run "live" in a user's browser session.

You need to took at the properties of the batch report service, not the interactive report service. Look at the maximum number of processes and multiply this by the number of connections.

Cheers!

MF.