Running DBAN against dictionary area DDLDML get error saying OR52 not found

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

Running DBAN against a DDLDML area gets errors:

598601 - AREA PROCESSING BEGINNING: SYSTEM.DDLDML 

598714 - DBKEY 6053049:13 NO OR52 FOR THIS INDEX SET IX-RESGROUP 
598714 - DBKEY 6053122:30 NO OR52 FOR THIS INDEX SET IX-RESOURCE 

Answer:

The problem was that the DBA had specified subschema IDMSNWKA to be used for DBAN.

Whenever running DBAN or Unloading/Reloading a dictionary area (DDLDML, DDLDCMSG, DDLDCLOD) use SS IDMSNWKU which includes all records and sets that can reside in these areas.

There is a note in the Utilities manual in the chapter on the UNLOAD UTILITY that is pertinent for DBAN as well: 

 

When unloading a dictionary, the IDMSNWKU subschema should be used for all areas, except DDLCAT, DDLCATX, and DDLCATLOD.

The DDLCAT and DDLCATX areas should be unloaded and reloaded using the IDMSCATZ subschema.

The DDLCATLOD area should be unloaded and reloaded using the IDMSCATL subschema.