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

A page lock on a table in a Simple table space


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
lovemorning

New User


Joined: 15 Jun 2005
Posts: 16

PostPosted: Mon Mar 12, 2007 5:49 pm
Reply with quote

A page lock on a table in a Simple table space can make data from other tables temporarily unavailable? Is this true?
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Mon Mar 12, 2007 6:19 pm
Reply with quote

Thats very true. In simple tablespace a page can contain data from different tables. When a transaction puts a lock @ that page obviously the other tables data would be locked.
Back to top
View user's profile Send private message
lovemorning

New User


Joined: 15 Jun 2005
Posts: 16

PostPosted: Mon Mar 12, 2007 6:43 pm
Reply with quote

vini_srcna wrote:
Thats very true. In simple tablespace a page can contain data from different tables. When a transaction puts a lock @ that page obviously the other tables data would be locked.

Thanks vini :)
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Lock Escalation DB2 3
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top