[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference decwet::advfs_support

Title:AdvFS Support/Info/Questions Notefile
Notice:note 187 is Freq Asked Questions;note 7 is support policy
Moderator:DECWET::DADDAMIO
Created:Wed Jun 02 1993
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1077
Total number of notes:4417

1046.0. "defragment on ingres databases ?" by AKSELI::RIDANPAA (These boots are made for walking) Tue Apr 22 1997 05:16

    
    Hi,
    
    we have OMS-customer running ingres applications on D-Unix. And I would
    like to know what is the best way to defragment filesystems + the database 
    (top of AdvFs).
    
    I would like to use Advfs defragmenter but is it Ok, to use it on
    filesystems containing ingres database files? If it's OK to use it may I
    run it while database is active or should I shut down ingres first.
    (I'm aware of the performance reduction)
    
    Or should I use some other method (ingres export/import) to defrgament 
    database files ? I don't know much about ingres. 
    
    Environment:
    Digital UNIX 	V3.2C
    Ingres		6.4/05
    AdvFs util		AFA320
    
    Best regards,
    	Heikki Ridanp��
    	OMS - Finland
    	DTN: 879-4863
    
    Ps. Is there any way to include/exclude specific files when running
    defragment or is it always for whole filesystem ?
T.RTitleUserPersonal
Name
DateLines
1046.1KITCHE::schottEric R. Schott USG Product ManagementTue Apr 22 1997 07:4740
>    
>    we have OMS-customer running ingres applications on D-Unix. And I would
>    like to know what is the best way to defragment filesystems + the database 
>    (top of AdvFs).
>    
>    I would like to use Advfs defragmenter but is it Ok, to use it on
>    filesystems containing ingres database files? If it's OK to use it may I
>    run it while database is active or should I shut down ingres first.
>    (I'm aware of the performance reduction)

The advfs defragment program can be run while the system is running.


When it completes, the files (from advfs's view) will be defragmented.

As to what you might do to ingres to improve performance, this is
something to check with ingres on.

>    
>    Or should I use some other method (ingres export/import) to defrgament 
>    database files ? I don't know much about ingres. 
>    
>    Environment:
>    Digital UNIX 	V3.2C
>    Ingres		6.4/05
>    AdvFs util		AFA320
>    
>    Best regards,
>    	Heikki Ridanp��
>    	OMS - Finland
>    	DTN: 879-4863
>    
>    Ps. Is there any way to include/exclude specific files when running
>    defragment or is it always for whole filesystem ?

It runs for the domain you start it on...

I suggest you upgrade to a more recent version of Digital UNIX,
and ensure you install the latest patch kits.

1046.2the 'migrate' command might help a littleUNIFIX::HARRISJuggling has its ups and downsTue Apr 22 1997 09:0928
    Re: .0
    
>    Ps. Is there any way to include/exclude specific files when running
>    defragment or is it always for whole filesystem ?
    
    While I do not know of any way to exclude specific files, you can
    defragment files on a file by file basis using the 'migrate' command.
    
    The 'migrate' command attempts to allocate new storage from contiguous
    space.
    
    This will work even on domains with only 1 volume in the domain.
    
    The limitation is that if there is not enough contiguous space to
    effectivily defragment the file, then the 'migrate' command will not be
    able to create any.  The 'defragment' command can move files to create
    contiguous free space, so it can be more effective in defragmenting
    files.
    
    ----
    
    If you have customer requirements for the 'defragment' utility to
    provide explicit "defragment this set of files" or to explicitly "DO
    NOT touch this set of files" or treat these files a "Hot" files and
    postition them for optimum performance, or even to just defragment the
    free space, please enter a QAR and/or contact a product manager.
    
    					Bob Harris
1046.3Thank youAKSELI::RIDANPAAThese boots are made for walkingWed Apr 23 1997 01:129
    
    Thank's for the quick responses !!
    
    I ran defragment yesterday for all filesystems online without any
    problems. 
    
    _heikki_
    
    Re: .2 Than you for pointing out migrate command.