Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007

    Unanswered: Long Tablespaces in Db2 Version 9


    Can some body suggest me what are the advantages of using long/large tablespaces Vs regular tablespaces.

    How we can make use of long tablespaces in Db2 version 9


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    With LARGE tablespaces, you have bigger RID and, thus, may fit more rows onto a single page. The basic things are explained in the manual and also how to use it:

    (This is the V9.5 manual - so you may want to have a look at the manual for your DB2 version.)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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