OLREORG DB13001E - UNEXPECTED RETURN CODE 07 (1) NO MORE EMPTY BLOCKS AVAILABLE

Products

• Datacom/AD
• Datacom
• DATACOM - AD
• Datacom/DB

Issue/Introduction

When running Datacom OLREORG it fails and cancels with this message:
             DB13001E - UNEXPECTED RETURN CODE 07 (1) NO MORE EMPTY BLOCKS AVAILABLE

Monitoring the space used for the area it increased to 100%.

Is the data in the database after the failure of OLREORG 100% reliable? or do I need to recover something? 

Is it normal for the space used for the Index/Area dataset to increase for the OLREORG.

Environment

Release : 15.1

Resolution

OLREORG does need some free space to work with so it can increase while processing.
In the OLREORG documentation it mentions you should have at least 20% free space. 

There is no need to recover anything because of the RC 07 (1). The data is still ok after the error, you just need to increase the size of the area. 

The documentation for Return Code 07 explains the error:

01    MORE EMPTY BLOCKS

A DBUTLTY OLREORG with REFGROUP 0 ended because it could not fine any more empty blocks

Extend the data set to provide more empty blocks and rerun the OLREORG or, if acceptable, run the OLREORG with a non-zero REFGROUP.

To resolve the problem run a DYNAMIC_EXTEND to add more space to the dataset.

You can issue the command from the console or DBUTLTY. For example from the console issue:
/F mufjobname,DYNAMIC_EXTEND <dbid>,<area>,100,CYL

For more information on how to do this see article 9503 - How to extend a Datacom area while the database is open

After the DYNAMIC_EXTEND you can rerun the OLREORG again.

Additional Information

See documentation section OLREORG (Reorganize a Database Online).