Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Question Unanswered: db2 database pages

    Hello All,
    I know that several rows from a table can be allocated in one single data page, but do you know if several rows from several tables can be allocated in the same database page?.
    can i have also several nodes from several indexes in on single index page?
    Regards & Thanks,
    E.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Depends on what product you are talking about.

    With DB2 for z/OS, if you use a "simple" tablespace, you can have multiple tables per data page. This is not supported on segmented or partitioned tablespaces.

    With DB2 for Linux, UNIX, and Windows the answer is no, you cannot have multiple tables per data page.

    For indexes, the answer is no for either product.
    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
  •