How to estimate Work files size to be used by CA IDMS REORG?
Article ID: 56611
Updated On:
Products
Issue/Introduction
One of the most common questions when using REORG, is how to estimate the Work File dataset sizes.
Environment
IDMS - All Supported Releases
Resolution
Within IDMS REORG setup execution options, there's syntax added in release 17.0 : " ESTIMATE workfile sizes" that estimates the size of all work files after UNLOADing the data. Or alternatively you can execute this statement as a separate job to get this report.
CREATE DSMODEL W*
DSN 'YOURHLQ.REORG.&DD'
UNIT SYSDA
SPACE TRK(100,100)
BLKSIZE 12004
;
REORG SEGMENT APPLDICT USING IDMSNWKU
AREA DDLDML
RELOAD INTO APPLDICT USING IDMSNWKU DMCL RELD1600
DIVIDE PROCESSING 4 WAYS
REUSE WORKFILES
AS SORTEXIT
ESTIMATE WORKFILE SIZES SUBMIT
STOP AFTER UNLOAD
CREATE ALL WORKFILES
SHARE
NOTIFY 10
;
In the REORG documentation USAGE section is the following
Work file creation
REORG can create work files dynamically or you can separately create them prior to beginning the unload and/or reload phases of REORG execution. Regardless of how the files are created, it is a good idea to halt execution after setup to determine what work files are needed by examining the report produced by REORG.
If using dynamic work file creation, you must specify the attributes of the work files using one or more CREATE DSMODEL statements. REORG creates the files either as directed by the CREATE WORKFILE clause or at the time they are first accessed. Dynamically created work files, other than DBKEYS files, are deleted automatically during the cleanup phase.
If you want to use REORG's size estimates to create a file, code a DSMODEL without a primary SPACE allocation. You can code a SPACE parameter with just a unit type (TRK, CYL, or blksize) and no value for primary allocation.
Additional Information
Feedback
