DB2 v10 Onine Schema Changes

The term on-line schema means, we can alter the table with out dropping it:

Changes made in Db2 v10.

  • Altering a table space’s page size, data set size, segment size, and/or MEMBER CLUSTER structure
  • Altering a simple table space with only one table to a partition-by-growth Universal table space
  • Altering a segmented table space with only one table to a partition-by-growth Universal table space

  • Altering a classic partitioned table space to a partition-by-growth Universal table space

  • Altering  a classic partitioned table space to a range-partitioned Universal table space

  • Altering an index’s page size

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.