IBM Support

Deleted artifacts are not being removed within C&DS repository on DB2

Flashes (Alerts)


Abstract

The removal of deleted artifacts is not being performed if the C&DS repository is housed within a DB2 database.

Content

DESCRIPTION:
Resource Maintenance Framework is a feature of Collaboration and Deployment Services that performs artifact cleanup in the background without overtaxing the system. For example, when artifacts are deleted from the repository via Deployment Manager client, the actual removal of the objects will be queued, and performed at a time when the system can handle the extra processing.

Due to a defect of the Data Direct DB2 driver that is shipped with C&DS, the removal of these deleted artifacts is not being performed - attempts would result in an 'Invalid Column Name' error. As a result, the size of the repository will not be reduced and could lead to performance issues. Please see PI21465 for additional details.

AFFECTED PLATFORMS:
IBM SPSS Collaboration and Deployment Services 5.0 Fix Pack 2 or higher
IBM SPSS Collaboration and Deployment Services 6.0 GA or higher

FIX:
SPSS Collaboration and Deployment Services 5.0 Fix Pack 3 Interim Fix 003
and
SPSS Collaboration and Deployment Services 6.0 Fix Pack 1 Interim Fix 002
have been released to address this problem.


Note: The content of this Alert is based on the best available information as of the date of its publication.

[{"Product":{"code":"SS69YH","label":"IBM SPSS Collaboration and Deployment Services"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0;5.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 September 2022

UID

swg21680345