Hi,

I try to process partitions of 2 cubes at the same time in AS2005.
but I think AS2005 disallow this and the second process is locked until the
first one release its lock.
Does it what's appends?

I have 2 cubes with partitionned measure groups (4 current year partition in
each cube; 1 by measure group).
I want to process the "Current year" partitions of cube 1 in a transaction
and the same thing for the cube 2.
I don't want 1 big transaction against all the cubes in case of a failure, 1
cube must keep his integrity. but if 1 partition fail, then the entire cube
transaction will be rolledback.
To optimize the processing time, I want to process the 2 sets of partitions
in parallel
But from what I see during a process the entire database is locked and I
can't. There is a workaround?

thanks.

Jerome.

As far as I know parallel processing is allowed only in the Enterprise
edition of SQL. Do you have the EE?


Radu.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

yes
its the enterprise edition.

but I want 2 parallel transactions and, in each one, a parallel process of
my partitions.


"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote