Topic
  • 4 replies
  • Latest Post - ‏2013-11-01T10:32:13Z by Wouter Liefting
Ramkumar_M
Ramkumar_M
2 Posts

Pinned topic Need help on IO/ Filesystem Tuning in 6.1

‏2013-10-31T08:06:45Z |

Hi ,

Application team is trying DB restore, from one Filesystem to another File system.

The read and write is happening at speed between 220 Kb/second and 350 Kb/second between the FS.

I need help in tuning Filesystem and IO in AIX 6.1 which could imporve the performance of copy from FS to FS.

 

  • zieggy
    zieggy
    11 Posts

    Re: Need help on IO/ Filesystem Tuning in 6.1

    ‏2013-10-31T08:49:44Z  

    Hi Ramkumar_M,

    First, consider this...

    1. What is the speed of your LAN?

    2. Are both the "source" and "target" server in the same LAN segment?

    3. How are you doing the restore? How big is your data?

    regards

     

  • Verleihnix
    Verleihnix
    3 Posts

    Re: Need help on IO/ Filesystem Tuning in 6.1

    ‏2013-10-31T14:12:00Z  

    check if the filesystems are mounted with the dio or cio Option.

    mount | grep <FS>

    if dio or cio is enabled, then you should disable it while the restore ist running.

    Example :

    1. Check for dio/cio

    mount | grep oradata

    /dev/datalv     /mydb/oradata   jfs2   May 22 17:13 rw,cio,noatime,log=INLINE

     

    2. Disable cio/dio

    chfs -s options=rw,noatime /mydb/oradata

     

    3. Make sure, there ist no access to the filesystem

     

    4. Remount the filesystem

     

    5. Restore the Database

     

    6. Enable cio/dio again

    chfs -s options=rw,cio,noatime /mydb/oradata

     

    7. Remount Filesystem

     

    DIO is used for JFS Filesystems and CIO for JFS2

  • Ramkumar_M
    Ramkumar_M
    2 Posts

    Re: Need help on IO/ Filesystem Tuning in 6.1

    ‏2013-11-01T06:56:53Z  

    check if the filesystems are mounted with the dio or cio Option.

    mount | grep <FS>

    if dio or cio is enabled, then you should disable it while the restore ist running.

    Example :

    1. Check for dio/cio

    mount | grep oradata

    /dev/datalv     /mydb/oradata   jfs2   May 22 17:13 rw,cio,noatime,log=INLINE

     

    2. Disable cio/dio

    chfs -s options=rw,noatime /mydb/oradata

     

    3. Make sure, there ist no access to the filesystem

     

    4. Remount the filesystem

     

    5. Restore the Database

     

    6. Enable cio/dio again

    chfs -s options=rw,cio,noatime /mydb/oradata

     

    7. Remount Filesystem

     

    DIO is used for JFS Filesystems and CIO for JFS2

    Hi zieggy/Verleihnix,

    Thanks for your reply.
    The Filesystem is not CIO, its JFS2 FS.

    FYI, we are trying to restore DB from one Fileystem to another FS in same server.
     this is a VIO client, ehternet is virtual


     

  • Wouter Liefting
    Wouter Liefting
    129 Posts

    Re: Need help on IO/ Filesystem Tuning in 6.1

    ‏2013-11-01T10:32:13Z  

    Hi zieggy/Verleihnix,

    Thanks for your reply.
    The Filesystem is not CIO, its JFS2 FS.

    FYI, we are trying to restore DB from one Fileystem to another FS in same server.
     this is a VIO client, ehternet is virtual


     

    Is the storage via the VIO server as well? How? Virtual FC, Virtual SCSI, storage pools or not? Are both FSs on the same physical hard disk? You might want to try tuning the queue_depth if on vSCSI.

    How much memory is in the client, how much write caching is done?