[Bulk] Re: [Bulk] Re: KSAM file performance
Alfred Munksgard
a.munksgard at verizon.net
Wed Jul 11 13:47:09 CDT 2012
Sometimes qtp is slow when running it online. If you are running it in a session, try it in a job.
Alfred
----- Original Message -----
From: Brian Stephens
To: Ken Langendock
Cc: powerh-l at lists.sowder.com
Sent: Wednesday, July 11, 2012 11:09 AM
Subject: Re: [Bulk] Re: [Bulk] Re: KSAM file performance
What Vicki recommends would do the same thing and has the advantage of removing deleted records.. I'm not on a 3K..
The KSAM manual is here.
http://www.hpmmsupport.com/MPE%20Manual/5000/B3265090386.10088/1.htm
On Wed, Jul 11, 2012 at 1:00 PM, Ken Langendock <ken.langendock at rogers.com> wrote:
I have only read about this.
Do you happen to have a script I could use?
Ken
From: Brian Stephens [mailto:bws001 at gmail.com]
Sent: Wednesday, July 11, 2012 1:43 PM
To: Ken Langendock
Cc: powerh-l at lists.sowder.com
Subject: [Bulk] Re: [Bulk] Re: KSAM file performance
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
--
Thanks
Brian Stephens
------------------------------------------------------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120711/e7ba66eb/attachment-0001.htm>
More information about the powerh-l
mailing list