IO08296: DGL3931A SQLCODE 605 ERROR IMPORTING PRE-EXISTING ITEM TYPE WITHINDEXES

APAR status

• Closed as program error.

Error description

• When importing an XSD file containing an item type definition,
  if that item type already exists in the system and it has
  indexes defined which are also defined in the XSD file, the
  following problems may occur:
  
  1) On a CM/MP server, the import fails with the following error:
  
  ICM7015:  During an SQL operation in the library server, an
  unexpected error occurred.  For details on the error, refer to
  the database document.  (STATE) : [LS RC = 7015, SQL RC = 605]
  
  2) On a CM z/OS server, the import succeeds, but the
  pre-existing index is dropped from the item type.
  
  In addition, if the index is non-unique, an "NU" suffix is added
  to the index name even if the pre-existing index already has
  that suffix. For example, index name TESTD001X1NU becomes
  TESTD001X1NUNU in the exported XSD file.
  

Local fix

• Use deferred DDL and don't submit the job containing the DROP
  INDEX statements.
  

Problem summary

• Importing pre-existing item type with database indexes fail
  

Problem conclusion

• fix in cm83fp9.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COMMON SYS ADMI

• Fixed component ID

  5724B1900

Applicable component levels

• R830 PSY

     UP

• R840 PSN

     UP