Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Space allocation for new columns for existing records

    Hi All,
    Do you have idea when exactly physical space is allocated for new columns when we add new columns (datatype like double) to existing table for existing records?

    Example: Table A (5B records)
    Table Size : 500 GB
    Average Col Length : 300

    New Columns : 20 (Nullable)
    Data Type : Double

    So after adding these 20 columns only is table size will increase(npages,fpages)?

    Updating values to these 20 columns is table size will increase(npages,fpages)?

    Or After doing Reorg it will increase or any other?

    Please provide your comments?

    Last edited by Pawan Kumar; 06-02-14 at 07:51.
    Pawan Kumar

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    if adding columns (nullable) to existing tables, rows will not be touched
    physical length of each datatype is specified in catalog
    db2 level ? platform ? alter command ?
    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

Posting Permissions

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