Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
parallel roatate partition!!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
hikaps14

Active User


Joined: 02 Sep 2005
Posts: 189
Location: Noida

PostPosted: Wed Apr 19, 2006 2:43 pm    Post subject: parallel roatate partition!!
Reply with quote

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 .
Back to top
View user's profile Send private message

ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Fri Apr 21, 2006 2:25 pm    Post subject: Re: parallel roatate partition!!
Reply with quote

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
Back to top
View user's profile Send private message
hikaps14

Active User


Joined: 02 Sep 2005
Posts: 189
Location: Noida

PostPosted: Fri Apr 21, 2006 6:57 pm    Post subject: Re: parallel roatate partition!!
Reply with quote

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 .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts how to specifiy partition endings whe... Auryn DB2 5 Thu Apr 14, 2016 2:32 pm
No new posts Query on Parallel processing of Store... rexx77 DB2 1 Thu Aug 14, 2014 12:41 pm
No new posts CA7 - Case where Jobs must NOT run in... thisak CA Products 4 Fri Oct 25, 2013 2:57 pm
No new posts Removing extra partition from PBG TS Jimy Carol DB2 3 Mon Jul 15, 2013 11:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us