DB2 V10-On-Line 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

About these ads

One thought on “DB2 V10-On-Line Schema Changes

  1. Pingback: DB2V10-Temporal data System Time & Business Time | Mainframe-Srini Blogs

Comments are closed.