Receiving UT003010 Unloading-Reloading an SQL area.
Article ID: 58551
Updated On:
Products
Issue/Introduction
When running UNLOAD for an SQL area, the error UT003010 is received
Environment
IDMS - All Supported Releases
Cause
The UT003010 indicates that all areas involved in the UNLOAD are not defined to the segment coded on the utility's input parameter.
Resolution
From the Utilities manual:
The Unload/Reload SEGMENT
The SEGMENT used in the unload and reload operation must include:
The area(s) being unloaded.
All areas with physical connections to the area(s) being unloaded.
This includes:
Areas containing indexes on records or tables being unloaded.
Areas with set connections to areas being unloaded.
Areas containing tables related through a constraint to tables being
Unfortunately, there is no way to get around this requirement with Unload-reload. But, you can with the REORG utility. The REORG works on the DBNAME level, so you would need to define all segments to the same DBNAME.
The DBNAME should be the same name as the segment being REORG'd.
Please see the utilities manual for information regarding REORG.
Feedback
