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.