QIM00009 The (00043) SEGMENT xxxx, xxx, 0 was not found.

Document ID : KB000046144
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue

Importing a PSB(s) into the CA Repository using the IMS Exchange and the job is failing with a CC=8 and the folllowing error

MESSAGE: QIM00009

The (00043) SEGMENT xxx, sss, 0 was not found.

Where xxx is the segment name and sss is the status name.  

 

Cause:

 

The column LOCK_ID on DBX_XREF has been previously set on an entity type in the IMS metamodel.  e.g IMS DB (ent type 152).  A Value specified in LOCK_ID for a particular entity type prevents that entity type from being deleted in the event of a delete.  In the event of a select, the LOCK_ID value is used to select the value from the repository.  For example

SELECT ...... FROM DBX_XREF WHERE ENT_ID = XXX AND LOCK_ID = XXX;

This LOCK_ID value cascades down for all entity types so it is used in the case of SEGMENT even though the lock was set on IMS DB. 

This value can only be set manually by updating the DBX_XREF table directly.   It is not recommended to set the LOCK_ID value.

 

Resolution:

 

Update the DBX_XREF table and set the LOCK_ID to 0 for all entity types

 

UPDATE repowner.DBX_XREF

SET LOCK_ID = 0

;

 

where repowner equals your repository creator