[Bulk] Re: KSAM file performance

[Ken Langendock]

Thanks everyone, but this system does not have an absolutely guaranteed
source code attached to it, so I am reluctant to move the tables into an
Image database or make changes to the files at all. I am pretty sure this is
KSAMXL, but I am not 100% sure.

 

I have already converted the application from HP3000 to a Windows version
(hence the reason for unloading the data into portable subfiles) so I am not
interested in a make-work project on this machine.

 

I agree it is probably a seriously fragmented file set that is causing my
problems. The keys on this entire system are all repeating as I think the
original designers never heard of MANUAL MASTERS or UNIQUE indexes in KSAM.

 

I was hoping someone would have a working script that does the re-org
automatically to simplify the process as I am not the most fluent MPE
programmer, not did I ever think I would be back on the platform as I left
it in 1995. Back then we actually proved that KSAM was faster than IMAGE for
our application and removed IMAGE altogether, but I never kept any of the
scripts as I never expected to go back once we went to Unix.

 

I thought about using quiz to export to a subfile, but I HATE the thought of
creating subfiles in quiz and I need to update a control file anyways, so I
gave up on that idea.

 

Ken

 

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 Jon Hawks
Sent: Friday, July 13, 2012 12:30 PM
To: vical1 at eastlink.ca; powerh-l at lists.sowder.com
Subject: [Bulk] Re: KSAM file performance

 

Also, if you sort the flat file by the primary key before reloading KSAM,
you should gain some speed.

Some coached people to keep each KSAM file to 3 x indexes, some would claim
6 and well, you can see where all that leads.

 

Also, with qtp, it does maintain its own rollback, even on a ksam.
sometimes it was easier to process flat files in quiz, output a subfile, and
then load that via qtp.  depends, right?

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120713/c43293e2/attachment.htm>