Agents in 'Missing scan' status on LMT/TAD4D 7.5
Due to the defect in DB2 9.1/9.5 agents are not able to download all catalog files, and this stop software scans from succeeding.
Due to APAR IZ35064
incorrect data is being returned by DB2, and this stop the agents from obtaining the correct catalog files.
In order to resolve this issue:
1) Please upgrade DB2 to the suggested release, or apply this workaround -
run the following command as a DB2 administrator/owner of the instance where TLMA is located:
db2 update db cfg for tlma using dft_degree 1
2) Restart both the LMT/TAD4D server and the DB2 instance (stop the server, then restart the database, finally start the server)
3) Execute 'tlmagent -resetcache' on the affected agents.