Partitioning key columns for tables created before Db2 Version 5 can now be updated

By Haakon Roberts and Judy Tobias. Before Db2 Version 5, table columns that were in a partitioning index could not be updated. Since Version 5, the columns were updateable in tables that were created in Version 5 or later, but the partitioning key columns in older tables remained non-updateable. You needed to use an awkward and time-consuming procedure, such as unloading the data, dropping the table, recreating the table, and reloading the data, to make the columns updateable.
You now have much better alternatives. If you perform one of these operations, Db2 automatically makes the columns updateable:
  • In Db2 11 or Db2 12, convert the table space from index-controlled partitioning to table-controlled partitioning
  • In Db2 11 or Db2 12, convert the table space to a partition-by-range table space
  • In Db2 12, convert the table space from a partition-by-range table space with absolute page numbering to a partition-by-range table space with relative page numbering
To take advantage of these changes, before you convert your table spaces, apply the relevant PTFs, based on your version of Db2:
Db2 12: APAR PI73415
Db2 11: APAR PI73421
Related information

Views: 141

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

New SQL pagination syntax - a Db2 12 greatest hit with John Campbell

Posted by Paul McWilliams on May 22, 2018 at 21:25 0 Comments

Db2 12 for z/OS introduces new SQL syntax that makes the difficult task of coding efficient SQL pagination—returning a portion of a result set based on data position—much easier for application developers. Read more in…



  • Add Videos
  • View All [Latest Blogs from the Biggest Names in DB2]

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service