Raw Device

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • saurabh29feb
    New Member
    • Sep 2007
    • 4
    #1

    Raw Device

    Hi
    Is there any limit on size of raw device container (4GB etc) in db2 luw v8.1 fixpak 9?

    Regards
    Saurabh
    Tags: None
    • docdiesel
      Recognized Expert Contributor
      • Aug 2007
      • 297
      #2
      Hi,

      the maximum of tablespace size depends on the pages size. Using 4K pages, the DMS containers size may use up to 2 TB.

      Which OS is your DB2 installed on? Is OS and DB2 32bit or 64bit?

      Regards,

      Bernd

        Comment

        • Parnamwulan
          New Member
          • Apr 2008
          • 16
          #3
          Hello,

          You are limited only with the destination disk space (device space) up to 2TB (as docdiesel said) ... and optionally by bufferpool assigned (operating memory - you cannot load e.g. 2TB table in one piece)

          you can setup the pagesize up to 64k (depends on system) and then count your available space divided by 65536 (I hope - my system dont support it) or the highest available for your system (1k = 1024)

            Comment

            Previous template Next
            Working...