Skip to main content



Database server

developerWorks

General DB2 Informix Oracle
   Recommendations  |   More
  FICON/ECKD or FCP/SCSI for database disks
  Scaling storage servers
  Disk setup
  Linux kernel 2.6 - I/O options
  ext2 or ext3 filesystem?
  Tuning read ahead / prefetch features
  31-bit vs. 64-bit database architectures
  Shared memory setup
  Swapping
FICON/ECKD or FCP/SCSI for database disks

FCP/SCSI devices are faster than FICON/ECKD devices. Therefore it is recommended to put the database files into a filesystem on a disk connected by FCP/SCSI. For small systems, we recommend the usage of ECKD raw devices, because this configuration needs less CPU per transaction.

OLTP Workload - Database Disk Types


Test environment
  • IBM eServer zSeries 900 (2064-216)
  • IBM TotalStorage Enterprise Storage Server 2105-800
  • LPAR with 8 CPUs, 2GB memory
  • Novell/SUSE SLES 8 + SP2 for IBM zSeries (64-bit), kernel 2.4.19
  • Informix 9.4.0 FC3 (64-bit)
  • Benchmark Informix OLTP
  • Database data Logical Volume (LV): 8 CHPIDs, 8 host adapters, FCP/SCSI or FICON/ECKD disks in 8 ranks, ext2 filesystem

For the usage of FCP/SCSI devices on SLES8 a kernel level 2.4.21-251 or higher is recommended. This update contains performance relevant fixes which improve the throughput and reduce the CPU utilization to nearly the same level as ECKD disks.

For measurements on raw devices (direct I/O) on SCSI disks see Linux kernel 2.6 - I/O options.


Back to top


Document options

Document options requiring JavaScript are not displayed


Team
Please address any comments to the performance team: linux390@de.ibm.com