When attempting to run a batch query to temporary storage, receiving error: "MCH0601 Batch job has failed with error. Space offset XXXXXX is outside the current limit for object BXXXXXX"
This Error is generated when the results of a Query ran to Batch exceed the 16mb limit on temporary storage.
The 16mb limit is an IBM limit for User Spaces.
- In Query go to the Run | Batch Options Menu.
- Select the 'Results' Tab.
- Select 'Run to Table'.
- Specify the Collection (Library) and the name of the table you want to create and select what authority you want people to have to it.
- Select 'OK'
- Re-run the query.