Skip to main content

MFIMS IMSDBU to load IMS database

  • March 24, 2015
  • 0 replies
  • 0 views

Problem:

While trying to load IMS databases to ED IMS through IMSDBU tool, the following error is received :
'Duplicate secondary index key detected on input file'

The IMS segment has 2 secondary indexes. Both of them can have duplicate entries. When IMSDBU runs, it loads about 320 records before the duplicate error message is displayed.

If the indexes are removed, the load runs to the end.

Solution:

There are two secondary index definitions in one DBD.  We don’t support this but defining each index individually should work.

In Micro Focus IMS, each secondary index will result in a separate file.  There is one indexed file for each key.   
In this case, there are 2 XDFLDs defined in the primary DB so the following files are created.
XHUDIADX.DAT (secondary index)
XHUDIAHX.DAT (secondary index)
XHUDPAUX.DAT (primary DB and index)

Both secondary indexes allow non-unique keys so multiple root segments can be returned given a specific SX key.   
From an application perspective an identical behavior to mainframe should be seen.


#EnterpriseDeveloper
#IMSDBUDuplicatesecondaryindexkey
#MFDS

0 replies

Be the first to reply!