[Bulk] Re: KSAM file performance
Brian Stephens
bws001 at gmail.com
Wed Jul 11 12:42:49 CDT 2012
Have you tried rebuilding the keys?
On Wed, Jul 11, 2012 at 12:40 PM, Ken Langendock
<ken.langendock at rogers.com>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.
>
--
Thanks
Brian Stephens
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/b016f6ce/attachment-0001.htm>
More information about the powerh-l
mailing list