Reading indexed subfiles in QTP
Cousins, Michael
Michael.Cousins@Cognos.COM
Wed, 17 Jun 1998 11:30:06 -0400
> The problem is fcontrol intrinsics used to prevent the interactive Qtp
> user from "interrupting" the process while an indexed file is locked.
> Indexed files are locked around reads.
>
> This problem only occurs when using a VTSERVER connection.
>
> To address this issue a new program parameter was added in 7.29.C5.
> "NOBREAKSET" disables Ctrl-Y and Ctrl-Break for the duration of the
> QTP session.
> Using this option has strong implications.
> A program, once started, cannot be stopped by the initiating session
> but rather must run to completion or be aborted by system management.
>
> The workaround is to increase the lock duration such as SET LOCK FILE
> RUN|REQUEST. This reduces the number of network packets that must be
> processed by VTSERVER.PUB.SYS, thus improving throughput.
>
======
> > Accessing an indexed subfile with QTP (7.29.C3) had become
> > unacceptably, excruciatingly slow.
> >
> > ACCESS *INDXFILE
> > SUBFILE NEWFILE KEEP INCLUDE INDXFILE
>
> The answer, many thanks to Wayne Hughes, is to specify
> SET LOCK FILE REQUEST when accessing indexed subfiles.
>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.