DB2 Performance Features in DB2 V9 for z/OS – Part 14

CLONE Tables

As I have talked about in the previous weeks, DB2 Version 9 for z/OS has over 50+ great new DB2 performance features. Many of these features can really benefit your standard application performance; improve application response time and overall availability of your systems and data.

Another one of the great features for availability and flexibility with database changes is the new CLONE tables.  When you create CLONE tables, only available in DB2 Version 9 New Function Mode (NFM), they have the exact same structure, indexes, triggers and LOB objects. Everything is the same.  The data can then be put into the CLONE using the ALTER EXCHANGE statement that quickly manages application access while DB2 switches and renames the underlying DB2 datasets.

What is also great about CLONE tables is that your applications can immediately access and use them.  Your applications will use the same access paths as the base table’s real-time statistics are invalidated and then used for the new CLONE tables.

Even though there are a number of restrictions CLONE tables can be created on a range-partitioned or a partition-by-growth table space that is managed by DB2. CLONE tables can make your life easier for taking care of your database and the various application availability issues so check them out.  Also check out the usage of CLONE tables in a test environment so all the considerations can be experienced and you can see how the CLONE tables give your systems more availability and flexibility.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>