DB2 UDB Publishes fail on Always generated Columns

book

Article ID: 129201

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

DB2 UDB Publishes fail on Always generated Columns. Tables that have this kind of column can't be published to tables.  What can be done?

Environment

TDM Portal 4.7

Resolution

TDMWeb-4.7.79.0.zip resolves your issue. The code has been changed to make it an INSERT statement.  However, this requires that the user has elevated privileges to be able to insert into special tables such as this.  This type of enhanced privilege condition MAY not be granted due to DBA policies.  Please contact BC Support for this version.  Also, check with Support to make sure that this fix made it into the GA version after March 26, 2019.

Additional Information

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://comm.support.ca.com/kb/How-to-Download-Test-Data-Manager/KB000009671.    
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html