Changes to address problems after Db2 12 for zOS table definition changes

Db2 for z/OS database administrators often need to alter table definitions to support evolving requirements of applications. Issues like the following ones have arisen after those table definition changes. These issues can occur with single-table table spaces or multiple-table table spaces, but can be especially troublesome with multiple-table table spaces.
  • Database administrators commonly use an offline utility, such as DSN1COPY, to copy tables from one subsystem to another. When the copied tables have recent definition changes, the table definitions in the target catalog can become out of sync with the table data.
  • Most table definition changes generate new table versions. A maximum of 255 table versions are available, and when table spaces contain a lot of tables, you are likely to make many table definition changes and use all those versions quickly. When all the versions are used, you cannot perform any more table definition changes until you run REORG and MODIFY RECOVERY to recycle some versions. However, if any tables are at version 0, you cannot release any versions. Database administrators have indicated that they need Db2 changes to resolve this situation.
The following changes to Db2 12 for z/OS provide solutions to the problems listed above. All single-table or multiple-table table spaces can benefit from the changes, except work file table spaces, XML table spaces, and LOB table spaces.
  • To prevent problems due to a table’s data getting out of sync with the table’s catalog definition, Db2 writes information about the table structure in the table space's system pages. As a result, Db2 can determine a table’s structure without looking in the catalog. Db2 inserts this information automatically when you insert or update a row or run LOAD REPLACE on an existing table, or run REORG on the table space that contains the table, even when the table definition has had no changes. Db2 12 also inserts the information when you complete the definition of a new table. Alternatively, you can use the REPAIR utility with the INSERTVERSIONPAGES option to insert the information.
  • To make it possible to release versions when a table space has tables at version 0 and at version 255, the REPAIR utility has the new SETCURRENTVERSION option, which you specify with INSERTVERSIONPAGES. The SETCURRENTVERSION option changes the version number for any tables in the table space that are at version 0 to the current version of the table space. After this, you can run the REORG utility followed by the MODIFY RECOVERY utility to recycle unused table space versions.
To take advantage of these changes, apply the PTFs for the following Db2 12 APARs:
  • PI86880 and PI88940
Related information
Base release enhancements after the DB2 12 initial release (see "Changes to address problems after Db2 table definition changes")

Views: 498

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.


Db2 12 Migration Planning & Customer Experiences - Part 1

Started by Sandy Flippen in What's hot ? on Thursday. 0 Replies

Register Now! NEXT CONTENT! Upcoming double webcast Db2 12 Migration Planning and customer experiences. Live Q &A session! PART 1 24th Sept 11:00 AM EST PART 2…Continue

IBM Db2 Analytics Accelerator Workshop

Started by Sandy Flippen in What's hot ? on Tuesday. 0 Replies

IBM Db2 Analytics Accelerator WorkshopPeter Bendel and Ute BaumbachWhen: Thursday, Oct 24, 2019 14:00 to 17:00Where: TBD Price: FREELIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASISAbstract:Join this complimentary workshop…Continue

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service