File-of-files resizing ? 
Author Message
 File-of-files resizing ?

Is there anyway to resize the file-of-files safely ? and also make sure that
the system will recreate FOF at the new size rather than always at a 101
modulo when doing a restore ?.

We were wondering why our file-saves were taking longer and longer lately
and found out that the fof is grossly undersized. (56 frames per group istat
was recomending over 3000 mod rather than 101). I cleared out the fof except
for 1 and 2 and then did a save and it reduced the time taken by two hours,
but the next night the save took an extra 45 mins ..(fof was up to 16 frames
per group).

Carl Keogh
Systems Administrator
Bristile Ltd




Mon, 11 Jun 2001 03:00:00 GMT
 File-of-files resizing ?

On Thu, 24 Dec 1998 11:53:21 +0800, "Carl Keogh"

Quote:

>Is there anyway to resize the file-of-files safely ? and also make sure that
>the system will recreate FOF at the new size rather than always at a 101
>modulo when doing a restore ?.

I am not sure what the file-of-files is exactly, I am guessing it is
file statistics of sorts?

If this flavor of Pick you are working with is like most others, login
to the account this file resides in, edit the file descriptor for the
data section of file-of-files, as in ED DICT FILE-OF-FILES
FILE-OF-FILES. In attribute 13 type '(mod,sep)' where mod is the new
modulo and sep is the new separation. Then when you do a backup and
restore, the file will be recreated at the new size and should retain
that size unless you change the parameters in attribute 13 of the file
descriptor again.

If you want to resize this file without going through a
backup/restore, create a temp file with the proper size, copy all
items dict and data from file-of-files to the temp file, delete the
file-of-files file, recreate the file-of-files at the proper size,
copy the dict/data from the temp file back then delete the temp file.

Now, this file-of-files may actually be an account or system file, in
which case you would have to do something like ED SYSTEM FILE-OF-FILES
and change attribute 13. In this case you will have to do a
backup/restore to resize.

Joe Walter

http://jaw1.home.mindspring.com



Sat, 16 Jun 2001 03:00:00 GMT
 File-of-files resizing ?
Using the resize attribute 13 is a correct method for fixing this issue.
However, simply creating a new file and then renaming is not.  The base
address and the modulo size of the file-of-files are relevant reserved
information.  There is a TA on the Pick website regarding this procedure.
Please see http://www.picksys.com/ftp/pub/technotes/rs/t54.txt

Jay Adams

Quote:

>>Is there anyway to resize the file-of-files safely ?

[snip]


Sat, 16 Jun 2001 03:00:00 GMT
 File-of-files resizing ?


Quote:

>Is there anyway to resize the file-of-files safely ? and also make sure that
>the system will recreate FOF at the new size rather than always at a 101
>modulo when doing a restore ?.

The ONLY way to resize this file is to do a full system save and restore.
Note that the file is a DX file. DO NOT unDX IT ! Change attribute
13 to the appropriate new modulo, then do a full system save and
restore.

Whilst you're at it, check the size of the MDS file as well.

Bryan



Sun, 17 Jun 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Resizing file-of-files

2. DAO Blob Adding/Extracting (audio files, text files, image files, program files)

3. Cannot resize LDF file

4. Resize Trans Log File

5. Resize Log File

6. Log file resize

7. How to resize an export file

8. How to resize redo log files

9. Resizing a Data File

10. Resizing redo log files

11. How to Resize REDO LOG Files


 
Powered by phpBB® Forum Software