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

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

 

 

Environment

Release : 15.1

Resolution

There is no need to recover anything because of the RC 07 (1).
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.