Have you tried rebuilding the keys? <br><br><div class="gmail_quote">On Wed, Jul 11, 2012 at 12:40 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">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">rogers.com@lists.sowder.com</a><br>
[mailto:<a href="mailto:powerh-l-bounces%2Bken.langendock">powerh-l-bounces+ken.langendock</a>=<a href="mailto:rogers.com@lists.sowder.com">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">vical1@eastlink.ca</a><br>
Cc: powerh-l-bounces+bob.deskin=<a href="mailto:ca.ibm.com@lists.sowder.com">ca.ibm.com@lists.sowder.com</a>;<br>
<a href="mailto:powerh-l@lists.sowder.com">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">vical1@eastlink.ca</a><br>
To: <a href="mailto:powerh-l@lists.sowder.com">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">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">powerh-l-request@lists.sowder.com</a><br>
Sender: powerh-l-bounces+vical1=<a href="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">powerh-l@lists.sowder.com</a>><br>
Reply-to: <a href="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">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">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">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">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">powerh-l@lists.sowder.com</a>><br>
Message-ID: <000901cd5f7c$7182bfb0$54883f10$@<a href="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<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/att
achment.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">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">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">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">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to<br>
<a href="mailto:powerh-l-request@lists.sowder.com">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">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">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">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">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">powerh-l@lists.sowder.com</a><br>
Subscribe: 'subscribe' in message body to <a href="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">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.<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks<br><br>Brian Stephens<br>