Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: Raw devices vs File system

    Has anyone switched to File system tablespaces from raw devices? Was there any noticable performance degradation? Is it worth the switch from a DBA standpoint (manageability)? Any other advice ?


  2. #2
    Join Date
    May 2003
    The advantages of raw devices have been reduced in recent versions of DB2 and raw devices are pretty much passe now. About the only situation where you might be able to see a difference is with large tables in a data warehouse environment where there are a lot of full table scans. Even then, I would not personally use them (I like to punish table scans).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts