KSAM file performance

[Bob Deskin]

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/attachment.html
>

------------------------------

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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 &lt;password&gt;' 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.