Articles & Content

Archives

C13 - Shadow Tables To Speed Up Analytic Queries In Your OLTP Environment

Topic: 2014 EMEA

Subtopic: DB2 for LUW



Invariably, an OLTP environment has applications where there are analytic queries that need to be run fast. DB2 10.5 with BLU acceleration was primarily targeted for a warehouse environment. 

In the DB2 Cancun Release, a new feature has been introduced to allow column oriented shadow tables copies of row-organized tables. This allows analytical applications to reap the benefits of BLU acceleration while your OLTP transactions continue to use the row-organized tables.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.