parallel roatate partition!!

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

hi hav few archive tables .

each tablespace is a partitioned tablespace .

each table has an associated job to rotate its partitions .
whenever these jobs are run simultaneously .
there is an abend with sql code -911
showing contention with other jobs .

i think while rotating partition its taking lock on whole database
is it possible ?

can ne 1 give me a clear idea regarding this .

can't we run two parallel " rotate partition jobs " ?

Thanks in advance
-Kapil .

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Hi Kapil,
what you mean by rotating the partitions.
If you are interested in parallel load, use load job such that each will load in single partition. so that lock will be on single partition.

Regards
Rags

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

hi ,
i think i was not tat much clear to u .

actually i m running a querry in batch mode
alter table rotate partitions ending at " date ".

so when i run this querry for two different tables in batch mode .
ie. 2 tables being rotated simultaneously .

then an abend occurs .
with all the details i told u earlier .

so i want to know tat whether its some wealness of db2 . or i m making any mistake .