Subject: | |
From: | |
Reply To: | |
Date: | Tue, 22 Aug 2000 08:58:15 -0700 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hi Gravin,
The last file I was altering it to a larger size
PHRIST WAS 95% FULL.
FIRST TRYIED
MPEX
%ALTFILE PRHIST;FLIMIT=(EOF*1.60)
THIS JOB GOT ABORTED AFTER 4+ HOURS OF PROCESSING IN A JOB STREAM.
SECOND TRY
COPY PRHIST,PHRISTA (TOKE ABOUT 5 SECONDS )
FILE PHRISTA,OLD;SAVE
PURGE *PHRISTA
RESET PHRISTA
( THE ABOVE COMMANDS TOKE LESS THEN 3 SECONDS TO RUN)
MPEX
%ALTFILE PRHISTA;FLIMIT=210000 (TOKE ABOUT 10 SECONDS )
RENAME PRHIST,PRHISTB
RENAME PRHISTA,PRHIST
( THIS TOKE ABOUT 5 SECONDS TOTAL )
FCOPY FROM=PRHISTB;TO=PRHIST ( TOKE ABOUT 3 HOURS )
LF PRHIST@
ACCOUNT= ANOD GROUP= PROD
FILENAME CODE ------------LOGICAL RECORD----------- ----SPACE----
--DAYS--
SIZE TYP EOF LIMIT R/B SECTORS #X MX ACC
MOD
PRHIST KSAM 274B FAK 123333 210000 14 242176 122 *
1 1
PRHISTB KSAM 274B FAK 123386 130000 14 238848 61 * 1
1
GROUP TOTAL: 2 FILES 117 MEGABYTES 481024 SECTORS
Gavin Scott wrote:
> Hi,
>
> > We have upgraded from 6.0 to 6.5 about 3 month ago. Ever sent then I
> > have noticed that fcopy takes a vary long long time. This is also true
> > in MPE altfile command. Fcopy on a 100,000 record file used to take
> > less then 5 minutes, now it can takes over 3 hours.
>
> It's more than 36 *times* slower than before?
>
> Can you tell me the attributes of the file(s) involved and the :FCOPY
> command syntax that you're using so I can try the same thing here?
>
> Also the MPEX altfile command you tried.
>
> Thanks,
>
> Gavin
|
|
|