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="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I have only read about this.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Do you happen to have a script I could use?<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ken<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;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:12.0pt">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>