[Bulk] Re: KSAM file performance
Jeff Hoffman
wonicon at optusnet.com.au
Fri Jul 13 07:40:22 CDT 2012
Ken
Are your subfiles indexed? that would be a killer.
Thought about loading the Ksam data into an Image or RBD table(s) and
working from their?
I forget the name of the RDB that comes with HP3000's but is easy to
build tables and load the data and performance is good.
Regards
Jeff
At 03:40 AM 12/07/2012, you wrote:
>I read the files sequentially and export to portable subfiles for
>conversion.
>
>Problem is the KSAM files do not contain any modification history so I will
>have to re-read the entire file over and over until the conversion is done.
>So any help speeding this up would make a hell of a difference
>
>Ken
>
>-----Original Message-----
>From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
>[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
>Behalf Of Bob Deskin
>Sent: Wednesday, July 11, 2012 1:32 PM
>To: vical1 at eastlink.ca
>Cc: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com;
>powerh-l at lists.sowder.com
>Subject: [Bulk] Re: KSAM file performance
>
>It may also depend on the key/index structure and how the file is
>accesses. For example, if you do a keyed read on a repeating key with lots
>of duplicates, I seem to recall something about having to read down the
>chain from the beginning. It was a long time ago, but I do remember issues
>like this. Are you reading the file sequentially or by index?
>
>Bob
>
>
>
>From: vical1 at eastlink.ca
>To: powerh-l at lists.sowder.com,
>Date: 2012-07-11 01:15 PM
>Subject: Re: KSAM file performance
>Sent by: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
>
>
>
>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.
>
>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.
>
>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.
>
>Hope this is helpful!
>
>Vicki Robertson
>
>Sent on the TELUS Mobility network with BlackBerry
>
>-----Original Message-----
>From: powerh-l-request at lists.sowder.com
>Sender: powerh-l-bounces+vical1=eastlink.ca at lists.sowder.com
>Date: Wed, 11 Jul 2012 12:00:03
>To: <powerh-l at lists.sowder.com>
>Reply-to: powerh-l at lists.sowder.com
>Subject: powerh-l Digest, Vol 85, Issue 2
>
>Send powerh-l mailing list submissions to
> powerh-l at lists.sowder.com
>
>To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.sowder.com/mailman/listinfo/powerh-l
>or, via email, send a message with subject or body 'help' to
> powerh-l-request at lists.sowder.com
>
>You can reach the person managing the list at
> powerh-l-owner at lists.sowder.com
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of powerh-l digest..."
>
>
>Today's Topics:
>
> 1. FW: Access KSAM files with QTP is really slow (Ken Langendock)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Wed, 11 Jul 2012 11:47:14 -0400
>From: "Ken Langendock" <ken.langendock at rogers.com>
>Subject: FW: Access KSAM files with QTP is really slow
>To: "'power-l'" <powerh-l at lists.sowder.com>
>Message-ID: <000901cd5f7c$7182bfb0$54883f10$@langendock at rogers.com>
>Content-Type: text/plain; charset="us-ascii"
>
>Hello all,
>
>
>
>I am in the process of extracting data from an HP3000 and ran into
>something
>that I have never seen before.
>
>When I extract data from KSAM files, the process grinds to a halt
>practically, the IMAGE files are fine.
>
>
>
>I used to use KSAM all the time and never saw any performance problems
>before like this.
>
>
>
>Any ideas would be appreciated.
>
>
>
>Ken
>
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: <
>http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/c1ace754/att
>achment.html
> >
>
>------------------------------
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>list archive at Google.
>
>End of powerh-l Digest, Vol 85, Issue 2
>***************************************
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the
>list archive at Google.
>
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
>archive at Google.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: 'unsubscribe <password>' in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search
>the list archive at Google.
More information about the powerh-l
mailing list