Originally posted by: Ramkumar_M

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.

 

Originally posted by: zieggy

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

 

Originally posted by: Verleihnix

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

Originally posted by: Ramkumar_M

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

 

Originally posted by: Wouter Liefting

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?