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

Related articles

• DB2 -Multiple Rows Insert with Arrays (srinimf.com)
• DB2 Stored Proc from CICS-How? (srinimf.com)
• DB2-Calling Cobol,C,Java Programs from Stored Proc (srinimf.com)