set file command

[Joe Boyle]

I think that your own suggestion of "set file xxx open 1" has a good chance
if you add share as in "set file xxx open 1 share". 

I think that all files with this open number will now be opened with the
same TX and allowing other users read/write access to the associated files;
I seem to recall that rdb will use the share option in the associated
reserving list.

It might be worth a test, and it allows the consistency TX which is usually
faster and more consistent updates.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Johnson, Harold A EDUC:EX
Sent: 09 December 2005 18:45
To: 'Joe Boyle'; powerh-l at lists.sowder.com
Subject: RE: set file command

Interesting.  Currently the process is set to commit at request, which I
gather locks during the input phase.    I will try this.

thnx


-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
Sent: 2005 December 9 10:12 AM
To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
Subject: RE: set file command



I think cognos dropped the ability to read tables in read only mode, and I
think BobD said they were looking at an enhancement to bring this back in a
later PH8 version.

Probable best option is 'commit at update', which only locks a row at the
actual moment it will be updated; the trade off is run-time, so possibly
'commit at 100' to reduce the lock time or even 'commit at sort-item' where
the concurrency TX means tables arn't locked for the duration of the qtp.

Regards, Joe. 
________________________________________
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Johnson, Harold A EDUC:EX
Sent: 09 December 2005 17:32
To: powerh-l at lists.sowder.com
Subject: set file command

A question regarding the "set file" command in QTP.  Recently, we were
running a new process in QTP which had a large number of links, but each
file was mentioned in a "set file xxx open read" statement.  However, during
the run, this process caused a lock on a table!   Is this syntax not
applicable anymore?    If so, what syntax should we be using?  ie: "set file
xxx open 1" ??
 
thnx
 
 
OpenVMS v7.3-2      RDB v7.1-241      PH  v7.10.G1
  
 


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.