If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Parallel Processing of Table Publish

Started by chriso, 08 Aug 2008 02:32:35 PM

Previous topic - Next topic

chriso

Hi, need your help. Is there any way Table Publish can use more then one processor thread?
We've got HUGE Publish process and it always uses max 1 thread although there is a 32 thread cluster willing to pick some job ;-)
Guys, you're advice highly appreciated!
BTW, DB is MSSQL2005

sascha

Is the publish container allocated to the job server cluster directly or is it assigned to a dedicated single job server? In most cases you should allocate it to the cluster.

Please check also the properties of you different job server. You should be set to using CPUs with '-1' which means that it uses all the processors available. Furthermore all job server services should use the same domain user which has local admin rights on the different servers.

When using a version below 8.2 check if the COM+ object for planning is using the identity of the same user as the user account used by the planning service.

chriso

Publish container is assigned to the cluster.
Settings are ok from the side of planning cluster.
I think the problem is with the database process used by EP to perform publish, not in the planning itself.
But I don;t know the solution for that