IBM Support

IMAM Incremental Import or Auto Discovery does not remove Alias object from repository after dropping table Alias/Synonym for DB2 and Oracle Connector

Troubleshooting


Problem

Using IBM Infosphere Metadata Asset Manager (IMAM) to import metadata via DB2 or Oracle Connector with "Share only changed assets" option, or performing Auto Discovery using DB2 or Oracle Connector, the Alias object remains in the repository after dropping the table alias/synonym at the source.

Symptom

The Alias object corresponding to dropped table alias/synonym remains in the repository after dropping the actual table alias/synonym at the source.

Cause

When only the alias/synonym is dropped then the base table remains unchanged. It does not get imported. So the Alias object under it does not get reflected as deleted in the repository.

Resolving The Problem

To resolve the problem in IMAM, reimport without "Share only changed assets" import option selected. 

In case of Auto Discovery the following command can be used to turn off the incremental import
On Windows
call C:\IBM\InformationServer\ASBServer\bin\iisAdmin -set -key mmi.admin.import.performDiscoveryDeltaImport -value false
On Linux
/opt/IBM/InformationServer/ASBServer/bin/iisAdmin.sh -set -key mmi.admin.import.performDiscoveryDeltaImport -value false
To turn the incremental import back on
On Windows
call C:\IBM\InformationServer\ASBServer\bin\iisAdmin -set -key mmi.admin.import.performDiscoveryDeltaImport -value true
On Linux
/opt/IBM/InformationServer/ASBServer/bin/iisAdmin.sh -set -key mmi.admin.import.performDiscoveryDeltaImport -value true

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"IBM InfoSphere Metadata Asset Manager","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.7.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 March 2019

UID

ibm10875926

Page Feedback