Collection entry not found in the collection table

Another common cause of an object not being selected by OSMC is the collection entry not being found in the collection table (OAMADMIN.OBJ_COLLECTION_TBL) for the collection ID (ODCLID) in the object directory table for the storage group being processed.

You can verify that the collection table entry exists for the object with the following SQL statement:

SELECT * FROM OAMADMIN.CBR_COLLECTION_TBL C, HLQ.OSM_OBJ_DIR D
WHERE   ODNAME = 'object_name'
AND     D.ODCLID = C.ODCLID;

One row should be returned identifying the collection that you expect to be associated with the object.