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 |
|
 |
|
|