REORG large database space requirement
search cancel

REORG large database space requirement

book

Article ID: 129147

calendar_today

Updated On:

Products

IDMS IDMS - Database

Issue/Introduction

Running REORG on a large database. The estimate for total primary space is over 80 cylinders. Files 1 thru 8 are very large, between 5200 and 6600. An allocation such as this was defined:

CREATE DSMODEL WU0000* 
DSN 'hlq.REORG07.&DD' 
UNIT SYSDA 
SPACE CYL(4000,350) 
BLKSIZE 27998 


But the unload abends with space problems because the file reaches the 65000 tracks IBM restriction size. Is there a way around this?

Environment

Release: All supported releases.

Resolution

If the estimated size is too large for their environment then check on the number of slices that has been specified.

It should be possible to avoid this error by increasing the number of slices until the estimate is under 65000 tracks.