Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012

    Unanswered: DEVICE and file in tablespace

    can any one please explain me what is the diff between device and file in db2 tablespaces. i can add container as file but can add ad device.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    have a look in developerworks and best practices
    ..DB2 Best Practices ...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    May 2003
    No one uses devices any more on tablespaces (they were made obsolete by NO FILE SYSTEM CACHING on tablespace definitions). Use files instead for DMS and automatic storage containers.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2009
    Zoetermeer, Holland
    Databases can use a disk without a file-system. Called a raw data device Raw device - Wikipedia, the free encyclopedia
    Those were the pre-SAN days.... Not encouraged any more.
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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