Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2013
    Posts
    39

    Unanswered: Data row insertion at page level

    Hi,

    I have questions regarding the data insertion.

    DB2 LUW V9.7

    1. whenever we insert a row into a table, where it insert at the page level. I want what actually happens at the page level when we insert a row in a table. (Please share if you have any useful link for it)

    2. if we are doing the online reorg on a table and a user insert a row on that table. So will that row also be reorged?

    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    1: it depends on too many variables. Why do you care?

    2) I would expect so.

    Andy

  3. #3
    Join Date
    Oct 2013
    Posts
    39
    1. I just wants to enhance my knowledge on this topic. Could you please tell on what kind of variable it depends. Or if you any link which you can share.

    2. Ok

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    There are a lot of different thing that will affect where data goes when inserted/updated. A few are:

    When creating / altering a table by using the APPEND clause
    Clustering indexes
    Multi-Dimensional clustering
    Partitioned tables

    I am sure there are more. If you want to continue to explore this, I suggest you read the manual.

    Andy

Posting Permissions

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