search cancel

How can we limit the primary space allocation for dataset SYSREC in a REORG utility?

book

Article ID: 54063

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS CA Distributed Database Management CA Database Analyzer for DB2 for Oracle Database Analyzer (IMS Tools) Mainframe Configuration Manager for IMS for z/OS IMS TOOLS - MISC Compress Data Compression (IMS Tools) Database Analyzer for IMS for z/OS Database Copier for IMS for z/OS Database Organizer for IMS for z/OS Mainframe Extended Terminal Manager (IMS Tools) High Performance Recovery for IMS for z/OS Database Organizer (IMS Tools) Mainframe Program Restart Manager for IMS for z/OS Secondary Index Builder for IMS for z/OS Secondary Index for IMS for z/OS

Issue/Introduction

Description:

The primary space allocation of the SYSREC dataset in a REORG job exceeds our hardware limitation of 65535 tracks. Is there a way to limit the allocation calculated by %ROSYSREC?

Solution:

To limit the primary space allocation using %ROSYSREC you can add the following #IF logic to a copy of the MJUTLRO model in your highlevel.MODEL library.

 #IF(%OBJTYPE,NE,INDEX)  
 //SYSREC   DD  DSN=%USERID..%SPACENM..REORG.D%DATE..I%INCR,           
 //             UNIT=%UNIT,DISP=(,KEEP),
 #IF(%ROSYSREC>nnnn)                                     
 //  SPACE=(CYL,(nnnn,%CALC(%ROSYSREC/10))) 
 #ELSE                                                   
 //  SPACE=(CYL,(%ROSYSREC,20))                          
 #ENDIF  
 #ENDIF

where nnnn is the maximum for your site. This example will give you the maximum primary allocation.

Please note that the SPACE definitions used are just examples and that you can use your own calculations based on site requirements and standards. It is recommend that you take a copy of the MJUTLRO model and customize that, rather than change the supplied model.

Environment

Release:
Component: DBA