Ron, I was able to fcopy a file of 250k recs to $newpass.
Ray Shahan
"There is so much good in the worst of us,
and so much bad in the best of us,
that it behooves none of us
to talk about the rest of us"
--Robert Louis Stevenson?
> -----Original Message-----
> From: Ron Horner [SMTP:[log in to unmask]]
> Sent: Wednesday, November 26, 2003 11:44 AM
> To: Shahan, Ray; [log in to unmask]
> Subject: RE: [HP3000-L] Removing deleted recs from KSAM/xl file
>
> The limit seems to be about 10000.
>
> Ron Horner
> Horner Consulting
>
>
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On Behalf
> Of
> Shahan, Ray
> Sent: Wednesday, November 26, 2003 11:42 AM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] Removing deleted recs from KSAM/xl file
>
> Hmmm, I replied to one part of this thread to be careful when using
> $newpass
> as a receiver of file data since the file size of $newpass has a limit.
> Since I couldn't remember what that limit was, I tried to find it, and I
> can
> say that either there is no longer a limit issue for $newpass, or that if
> there is still a limit to how big $newpass can be, then it must be huge!!
> Anyone know the answer to this?
>
> Ray Shahan
>
> "There is so much good in the worst of us,
> and so much bad in the best of us,
> that it behooves none of us
> to talk about the rest of us"
> --Robert Louis Stevenson?
>
> > -----Original Message-----
> > From: Paul H. Christidis [SMTP:[log in to unmask]]
> > Sent: Wednesday, November 26, 2003 11:25 AM
> > To: [log in to unmask]
> > Subject: Re: [HP3000-L] Removing deleted recs from KSAM/xl file
> >
> > Jay,
> >
> > Try the following:
> >
> > fcopy from=ksamfile;to=($newpass);new
> > save $oldpass,newksam
> > purge ksamfile
> > rename newksam,ksamfile
> >
> > While the above is comprised by more commands it is actually faster AND
> > safer since the transaction manager is not being invoked (as it is in
> the
> > second fcopy), the ksamxl file is copied only once, and the usage of
> > 'newksam' allows for recovery in case of failure.
> >
> > If a failure was to occur while using the suggestion with the two
> 'fcopy'
> > commands (during the second fcopy), $oldpass would be gone and the
> > 'ksamfile', at best, would contain a subset of the records.
> >
> > Whether the original build should include the REUSE option? It depends.
> > The advantage of NOT using it is that it allows one the capability of
> > 'recovering' deleted records (records that were deleted in error?).
> >
> > Regards
> > Paul Christidis
> >
> > HP-3000 Systems Discussion <[log in to unmask]> wrote on 11/26/2003
> > 05:43:21 AM:
> >
> > > Thanks to everyone who responded.
> > >
> > > Ron and Stan are correct - the original build of the files should
> > > include the REUSE option.
> > >
> > > For now, though, I will use Tracy, Chris, and Mike's suggestion of
> using
> > > FCOPY.
> > >
> > > I especially liked Mike's idea:
> > >
> > > fcopy from=ksamfile;to=$newpass;new
> > > fcopy from=$oldpass;to=ksamfile
> > >
> > > Simple. And can be used on any nm ksam file.
> > >
> > > Thanks again. Happy Thanksgiving to everyone.
> > >
> > > Jay
> > >
> > > * To join/leave the list, search archives, change list settings, *
> > > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> >
> > * To join/leave the list, search archives, change list settings, *
> > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> ##########################################################################
> ##
> #########
> This e-mail message has been scanned for Viruses and Content and cleared
> by MailMarshal
> ##########################################################################
> ##
> #########
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
#####################################################################################
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
