IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Concurrent update in HALDB


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bharathatibmmf

New User


Joined: 26 Apr 2010
Posts: 5
Location: UK

PostPosted: Mon Apr 26, 2010 7:37 pm
Reply with quote

Can someone please let me know if concurrent update to various HALDB partitions can be done for an IMS database organised as HALDB ?

can someone please just let me know if it is possible or not ...I can wait for the solution (if available)....
Back to top
View user's profile Send private message
makaveri

New User


Joined: 25 Apr 2010
Posts: 4
Location: bangalore

PostPosted: Tue Apr 27, 2010 1:35 am
Reply with quote

According to my experience we can't perform concurrent update on single partitions.if it is updating on different partition then it can access..

Its again depends on the SHARELEVEL defined during registering HALDB in RECON dataset.

1.DATABASE LEVEL SHARE
2.BLOCK LEVEL SHARE
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 27, 2010 1:49 am
Reply with quote

Hello and welcome to the forum,

Please change your "signature" removing your e-addr. We have had spammer problems when real e-addrs are posted.

Enjoy the forum icon_smile.gif
Back to top
View user's profile Send private message
makaveri

New User


Joined: 25 Apr 2010
Posts: 4
Location: bangalore

PostPosted: Tue Apr 27, 2010 1:56 am
Reply with quote

Thank You Dick for information.....

I think it looks good now....
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 27, 2010 2:07 am
Reply with quote

You're welcome icon_smile.gif

Quote:
I think it looks good now....
Yup, it does. . .

d
Back to top
View user's profile Send private message
bharathatibmmf

New User


Joined: 26 Apr 2010
Posts: 5
Location: UK

PostPosted: Tue Apr 27, 2010 2:54 pm
Reply with quote

Thanks Manoj...

For Eg:
If I have a DB with 6 partitions
JCL 1 - Updates partition 1 only
JCL 2 - Updates Partition 3 only
..
JCL n - Updates partition n only...

So if I access different partitions at the same time and update only that partition in 1 JCL and the other partition un the other JCL, will it work ?
Back to top
View user's profile Send private message
makaveri

New User


Joined: 25 Apr 2010
Posts: 4
Location: bangalore

PostPosted: Tue Apr 27, 2010 3:25 pm
Reply with quote

Yes..I'll work fine.there will not be any deadlock...

Please let me know if there are any issue..
Back to top
View user's profile Send private message
bharathatibmmf

New User


Joined: 26 Apr 2010
Posts: 5
Location: UK

PostPosted: Thu Apr 29, 2010 4:21 pm
Reply with quote

thanks Manoj
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Concurrent writing records to VSAM fr... JCL & VSAM 9
No new posts Read a flat file and update DB2 table JCL & VSAM 2
No new posts how to update an ISR appl var from an... TSO/ISPF 8
No new posts AUTHORIZED database error in HALDB IMS DB/DC 2
No new posts DB2 SQL query to read and update data... DB2 12
Search our Forums:

Back to Top