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

Have Something to Say? Post Your Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s