<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.6212" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Calibri color=#000080>Sometimes qtp is slow when running it
online. If you are running it in a session, try it in a job.</FONT></DIV>
<DIV><FONT face=Calibri color=#000080></FONT> </DIV>
<DIV><FONT face=Calibri color=#000080>Alfred</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=bws001@gmail.com href="mailto:bws001@gmail.com">Brian Stephens</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=ken.langendock@rogers.com
href="mailto:ken.langendock@rogers.com">Ken Langendock</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 11, 2012 11:09
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Bulk] Re: [Bulk] Re: KSAM
file performance</DIV>
<DIV><BR></DIV>What Vicki recommends would do the same thing and has
the advantage of removing deleted records.. I'm not on a 3K..
<DIV><BR>
<DIV>The KSAM manual is here. </DIV>
<DIV><A
href="http://www.hpmmsupport.com/MPE%20Manual/5000/B3265090386.10088/1.htm">http://www.hpmmsupport.com/MPE%20Manual/5000/B3265090386.10088/1.htm</A> <BR><BR>
<DIV class=gmail_quote>On Wed, Jul 11, 2012 at 1:00 PM, Ken Langendock <SPAN
dir=ltr><<A href="mailto:ken.langendock@rogers.com"
target=_blank>ken.langendock@rogers.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV lang=EN-US vlink="purple" link="blue">
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">I
have only read about this.<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Do
you happen to have a script I could use?<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><U></U><U></U></SPAN> </P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Ken<U></U><U></U></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><U></U><U></U></SPAN> </P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Brian Stephens
[mailto:<A href="mailto:bws001@gmail.com"
target=_blank>bws001@gmail.com</A>] <BR><B>Sent:</B> Wednesday, July 11,
2012 1:43 PM<BR><B>To:</B> Ken Langendock<BR><B>Cc:</B> <A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR><B>Subject:</B> [Bulk] Re:
[Bulk] Re: KSAM file performance<U></U><U></U></SPAN></P></DIV>
<P class=MsoNormal><U></U><U></U> </P>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt">Have you tried rebuilding the
keys? <U></U><U></U></P>
<DIV>
<P class=MsoNormal>On Wed, Jul 11, 2012 at 12:40 PM, Ken Langendock <<A
href="mailto:ken.langendock@rogers.com"
target=_blank>ken.langendock@rogers.com</A>> wrote:<U></U><U></U></P>
<P class=MsoNormal>I read the files sequentially and export to portable
subfiles for<BR>conversion.<BR><BR>Problem is the KSAM files do not contain
any modification history so I will<BR>have to re-read the entire file over
and over until the conversion is done.<BR>So any help speeding this up would
make a hell of a difference<BR><BR>Ken<BR><BR>-----Original
Message-----<BR>From: powerh-l-bounces+ken.langendock=<A
href="mailto:rogers.com@lists.sowder.com"
target=_blank>rogers.com@lists.sowder.com</A><BR>[mailto:<A
href="mailto:powerh-l-bounces%2Bken.langendock"
target=_blank>powerh-l-bounces+ken.langendock</A>=<A
href="mailto:rogers.com@lists.sowder.com"
target=_blank>rogers.com@lists.sowder.com</A>] On<BR>Behalf Of Bob
Deskin<BR>Sent: Wednesday, July 11, 2012 1:32 PM<BR>To: <A
href="mailto:vical1@eastlink.ca" target=_blank>vical1@eastlink.ca</A><BR>Cc:
powerh-l-bounces+bob.deskin=<A href="mailto:ca.ibm.com@lists.sowder.com"
target=_blank>ca.ibm.com@lists.sowder.com</A>;<BR><A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR>Subject: [Bulk] Re: KSAM file
performance<BR><BR>It may also depend on the key/index structure and how the
file is<BR>accesses. For example, if you do a keyed read on a repeating key
with lots<BR>of duplicates, I seem to recall something about having to read
down the<BR>chain from the beginning. It was a long time ago, but I do
remember issues<BR>like this. Are you reading the file sequentially or by
index?<BR><BR>Bob<BR><BR><BR><BR>From: <A
href="mailto:vical1@eastlink.ca" target=_blank>vical1@eastlink.ca</A><BR>To:
<A href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A>,<BR>Date: 2012-07-11
01:15 PM<BR>Subject: Re: KSAM file
performance<BR>Sent by:
powerh-l-bounces+bob.deskin=<A
href="mailto:ca.ibm.com@lists.sowder.com"
target=_blank>ca.ibm.com@lists.sowder.com</A><BR><BR><BR><BR>Ken, I'm not
sure which "version" of KSAM files you're using, but for<BR>older versions,
we had to periodically re-load the files--the details of<BR>why escapes me,
but I believe there were a number of factors that caused<BR>KSAM to grind to
a halt.<BR><BR>You should reference you HP3000 manual for instructions, but
if memorry<BR>serves, we FCOPY'd the data out to a flat file, deleted the
KSAM files<BR>(after a backup or two!) and re-created them, and then copied
the data<BR>back in. This re-organizes your keys and physically
deletes any logically<BR>deleted records.<BR><BR>Again -- going on memory
here from almost 20 years ago, but I suspect that<BR>could be your issue.
They were notorious for performance degradation<BR>unless regularly
re-built. Some newer version of KSAM were better, but<BR>could still
slow down over time.<BR><BR>Hope this is helpful!<BR><BR>Vicki
Robertson<BR><BR>Sent on the TELUS Mobility network with
BlackBerry<BR><BR>-----Original Message-----<BR>From: <A
href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR>Sender:
powerh-l-bounces+vical1=<A href="mailto:eastlink.ca@lists.sowder.com"
target=_blank>eastlink.ca@lists.sowder.com</A><BR>Date: Wed, 11 Jul 2012
12:00:03<BR>To: <<A href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A>><BR>Reply-to: <A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR>Subject: powerh-l Digest, Vol
85, Issue 2<BR><BR>Send powerh-l mailing list submissions to<BR>
<A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR><BR>To subscribe or
unsubscribe via the World Wide Web, visit<BR>
<A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>or,
via email, send a message with subject or body 'help' to<BR>
<A
href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR><BR>You can reach the
person managing the list at<BR>
<A href="mailto:powerh-l-owner@lists.sowder.com"
target=_blank>powerh-l-owner@lists.sowder.com</A><BR><BR>When replying,
please edit your Subject line so it is more specific<BR>than "Re: Contents
of powerh-l digest..."<BR><BR><BR>Today's Topics:<BR><BR> 1. FW:
Access KSAM files with QTP is really slow (Ken
Langendock)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message:
1<BR>Date: Wed, 11 Jul 2012 11:47:14 -0400<BR>From: "Ken Langendock" <<A
href="mailto:ken.langendock@rogers.com"
target=_blank>ken.langendock@rogers.com</A>><BR>Subject: FW: Access KSAM
files with QTP is really slow<BR>To: "'power-l'" <<A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A>><BR>Message-ID:
<000901cd5f7c$7182bfb0$54883f10$@<A href="mailto:langendock@rogers.com"
target=_blank>langendock@rogers.com</A>><BR>Content-Type: text/plain;
charset="us-ascii"<BR><BR>Hello all,<BR><BR><BR><BR>I am in the process of
extracting data from an HP3000 and ran into<BR>something<BR>that I have
never seen before.<BR><BR>When I extract data from KSAM files, the process
grinds to a halt<BR>practically, the IMAGE files are fine.<BR><BR><BR><BR>I
used to use KSAM all the time and never saw any performance
problems<BR>before like this.<BR><BR><BR><BR>Any ideas would be
appreciated.<BR><BR><BR><BR>Ken<BR><BR>-------------- next part
--------------<BR>An HTML attachment was scrubbed...<BR>URL: <<BR><A
href="http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/c1ace754/attachment.html"
target=_blank>http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/c1ace754/att<BR>achment.html</A><BR>><BR><BR>------------------------------<BR><BR>--<BR>=
= = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR>Subscribe:
&quot;subscribe&quot; in message body to<BR><A
href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR>Unsubscribe:
&quot;unsubscribe &lt;password&gt;&quot; in message body
to<BR><A href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:<A href="http://lists.sowder.com" target=_blank>lists.sowder.com</A>
powerh-l' to your search terms to search the<BR>list archive at
Google.<BR><BR>End of powerh-l Digest, Vol 85, Issue
2<BR>***************************************<BR>--<BR>= = = = = = = = = = =
= = = = = = = = = = = = = = = = =<BR>Mailing list: <A
href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in
message body to<BR><A href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR>Unsubscribe:
'unsubscribe &lt;password&gt;' in message body to<BR><A
href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:<A href="http://lists.sowder.com" target=_blank>lists.sowder.com</A>
powerh-l' to your search terms to search the<BR>list archive at
Google.<BR><BR><BR><BR>--<BR>= = = = = = = = = = = = = = = = = = = = = = = =
= = = =<BR>Mailing list: <A href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in
message body to <A href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR>Unsubscribe:
'unsubscribe &lt;password&gt;' in message body to<BR><A
href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:<A href="http://lists.sowder.com" target=_blank>lists.sowder.com</A>
powerh-l' to your search terms to search the list<BR>archive at
Google.<BR><BR>--<BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: <A href="mailto:powerh-l@lists.sowder.com"
target=_blank>powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in
message body to <A href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR>Unsubscribe:
'unsubscribe &lt;password&gt;' in message body to <A
href="mailto:powerh-l-request@lists.sowder.com"
target=_blank>powerh-l-request@lists.sowder.com</A><BR><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l"
target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:<A href="http://lists.sowder.com" target=_blank>lists.sowder.com</A>
powerh-l' to your search terms to search the list archive at Google.<SPAN
class=HOEnZb><FONT color=#888888><U></U><U></U></FONT></SPAN></P></DIV><SPAN
class=HOEnZb><FONT color=#888888>
<P class=MsoNormal><BR><BR clear=all><U></U><U></U></P>
<DIV>
<P class=MsoNormal><U></U><U></U> </P></DIV>
<P class=MsoNormal>-- <BR>Thanks<BR><BR>Brian
Stephens<U></U><U></U></P></FONT></SPAN></DIV></DIV></BLOCKQUOTE></DIV><BR><BR
clear=all>
<DIV><BR></DIV>-- <BR>Thanks<BR><BR>Brian Stephens<BR></DIV></DIV>
<P>
<HR>
<P></P>--<BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: 'subscribe' in
message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: 'unsubscribe
&lt;password&gt;' in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.<BR></BLOCKQUOTE></BODY></HTML>