| View previous topic :: View next topic | 
	
	
		| Author | Message | 
	
		| rubenprakash Beginner
 
 
 Joined: 03 Nov 2006
 Posts: 6
 Topics: 2
 Location: India
 
 | 
			
				|  Posted: Thu Nov 16, 2006 7:50 am    Post subject: GHU with PROCOPT=GOTP |   |  
				| 
 |  
				| Recently I came across a piece of code with the PSB is declared with PROCOPT=GOTP. In the application program, the DB is called with GHU. From the PROCOPT declared in the PSB it is evident that we cannot issue REPL call. Whether this GHU call will hold the DB from other transactions even the PSB is not given with the REPL option? _________________
 Regards, Ruben
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| shekar123 Advanced
 
 
 Joined: 22 Jul 2005
 Posts: 528
 Topics: 90
 Location: Bangalore India
 
 | 
			
				|  Posted: Thu Nov 16, 2006 8:59 am    Post subject: |   |  
				| 
 |  
				| Rubenprakash, 
 When you have PROCOPT=GOTP, you cannot give any REPL call and when it is not possible to give REPL ,you cannot update.I guess that the GHU call will hold the segment in the DB which will have a lock on the segment retrieved but finally if you give REPL call you might end up in a Status code RX .So even though the REPL option is not given , GHU Call will hold the DB.
 _________________
 Shekar
 Grow Technically
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| rubenprakash Beginner
 
 
 Joined: 03 Nov 2006
 Posts: 6
 Topics: 2
 Location: India
 
 | 
			
				|  Posted: Thu Nov 16, 2006 10:19 am    Post subject: |   |  
				| 
 |  
				| Thanks Shekar, The program doesnt have REPL call. But it is fetching the data with GHU. So my question was whether this GHU call can HOLD the DB though the PROCOPT has GOTP. So during this GHU call time other transaction cannot affect this DB? _________________
 Regards, Ruben
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| YSMVS Beginner
 
  
 Joined: 19 May 2004
 Posts: 51
 Topics: 25
 Location: My House
 
 | 
			
				|  Posted: Thu Nov 16, 2006 12:09 pm    Post subject: |   |  
				| 
 |  
				| You can issue a GHU call even the Procopt is G, but any update call may result in AM status code. _________________
 Thanks,
 YSMVS
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| Grant Beginner
 
 
 Joined: 02 Dec 2002
 Posts: 45
 Topics: 1
 Location: Sydney, NSW, Australia
 
 | 
			
				|  Posted: Thu Nov 16, 2006 5:38 pm    Post subject: |   |  
				| 
 |  
				| The GHU will not lock the record because locking is resolved at the PCB level. |  | 
	
		| Back to top |  | 
	
		|  | 
	
		| rubenprakash Beginner
 
 
 Joined: 03 Nov 2006
 Posts: 6
 Topics: 2
 Location: India
 
 | 
			
				|  Posted: Fri Nov 17, 2006 12:37 pm    Post subject: |   |  
				| 
 |  
				|  	  | Grant wrote: |  	  | The GHU will not lock the record because locking is resolved at the PCB level. | 
 
 Grant,
 
 So the GHU call will not lock the DB? Could you tell more on the other statement that LOCKING is resolved at PCB level?
 _________________
 Regards, Ruben
 |  | 
	
		| Back to top |  | 
	
		|  | 
	
		|  | 
	
		|  |