<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:18pt"><div style="RIGHT: auto"><SPAN style="RIGHT: auto">Also, if you sort the flat file by the primary key before reloading KSAM, you should gain some speed.</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Some coached people to keep each KSAM file to 3 x indexes, some would claim 6 and well, you can see where all that leads.</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"></SPAN> </div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto">Also, with qtp, it does maintain its own rollback, even on a ksam. sometimes it was easier to process flat files in quiz, output a subfile, and then load that via qtp. depends, right?</SPAN></div>
<div style="RIGHT: auto"><SPAN style="RIGHT: auto"><VAR id=yui-ie-cursor></VAR></SPAN> </div>
<div><BR></div>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 18pt">
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr><FONT size=2 face=Arial>
<DIV style="BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; PADDING-BOTTOM: 0px; LINE-HEIGHT: 0; MARGIN: 5px 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; HEIGHT: 0px; FONT-SIZE: 0px; BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; PADDING-TOP: 0px" class=hr contentEditable=false readonly="true"></DIV><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> "vical1@eastlink.ca" <vical1@eastlink.ca><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> powerh-l@lists.sowder.com <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, July 11, 2012 1:11 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: KSAM file performance<BR></FONT></DIV><BR>Ken, I'm not sure which "version" of KSAM files you're using, but for older versions, we had to periodically re-load the files--the details of why escapes me, but I believe there were a number of factors that caused KSAM to grind to a halt.<BR><BR>You should reference you
HP3000 manual for instructions, but if memorry serves, we FCOPY'd the data out to a flat file, deleted the KSAM files (after a backup or two!) and re-created them, and then copied the data back in. This re-organizes your keys and physically deletes any logically deleted records. <BR><BR>Again -- going on memory here from almost 20 years ago, but I suspect that could be your issue. They were notorious for performance degradation unless regularly re-built. Some newer version of KSAM were better, but 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" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Sender: powerh-l-bounces+vical1=<A href="mailto:eastlink.ca@lists.sowder.com"
ymailto="mailto:eastlink.ca@lists.sowder.com">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" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>><BR>Reply-to: <A href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">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" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR> http://lists.sowder.com/mailman/listinfo/powerh-l<BR>or, via email, send a message with subject or body 'help' to<BR> <A href="mailto:powerh-l-request@lists.sowder.com"
ymailto="mailto:powerh-l-request@lists.sowder.com">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" ymailto="mailto:powerh-l-owner@lists.sowder.com">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" ymailto="mailto:ken.langendock@rogers.com">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"
ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>><BR>Message-ID: <000901cd5f7c$7182bfb0$54883f10$@<A href="mailto:langendock@rogers.com" ymailto="mailto:langendock@rogers.com">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 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: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/c1ace754/attachment.html><BR><BR>------------------------------<BR><BR>--<BR>= = = = =
= = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe: &quot;subscribe&quot; in message body to <A href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to <A href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">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:lists.sowder.com powerh-l' to your search terms to search the 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" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in message body to <A href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">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" ymailto="mailto:powerh-l-request@lists.sowder.com">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:lists.sowder.com powerh-l' to your search terms to search the list archive at
Google.<BR><BR><BR></DIV></DIV></div></body></html>