Previous Topic: Process 2--Information GatheringNext Topic: Process 4--Reorganizing the Database


Process 3--Allocating Work Files

The CA IDMS/DB Reorg PAGUTIL file needs to be VSAM.

This process allocates all of the work files to disk. When you are allocating space for the work files, you must include DLBL statements for every work file used by CA IDMS/DB Reorg and EXTENT and ASSGN statements for each file's corresponding logical unit. If you are reorganizing an index area sorted by db-key, after the OPTALLOC step, you must allocate space for IIXEXOL, IIXSRKY, and IIXEXTR. See Target or Distribution source library member USRIDCAM.

 *
 *    SAMPLE JCL TO ALLOCATE VSAM WORK FILE - PAGUTIL
 *
 // DLBL   PAGUTIL,'vsam.work.space',0,VSAM
 // EXTENT SYS014,volser,,,reltrk,amount
 // ASSGN  SYS014,DISK,VOL=volser,SHR
 // EXEC   IDCAMS,SIZE=AUTO
     DELETE ('vsam.work.space') CLUSTER
     DEFINE CLUSTER ( -
                    NAME('vsam.work.space') -
                    RECORDS(record.numbers) -
                    NUMBERED -
                    RECORDSIZE(8168 8168) -
                    usetype -
                    VOLUMES(volume.name) -
                    ) -
            DATA    ( -
                    NAME('vsam.work.space.DATA') -
                    )
 /*
 *

Work Files and Corresponding Logical Units:

dbmsnms

SYSnnn

CNTRL1

CNTRL2

PAGUTIL

EXTRACT

PRIOPTA

SECOPTA

PRIREAL

UNALLOC

SECREAL

ALLOCX

DBREC

IIXEXOL

IIXSRKY

IIXEXTR

SECALX2

SECIIX2

DBKEYS

SYS010

SYS011

SYS014

SYS015

SYS016

SYS017

SYS018

SYS019

SYS020

SYS021

SYS022

SYS025

SYS026

SYS027

SYS028

SYS029

SYS032

Key for Sample JCL to Allocate VSAM Work File PAGUTIL:

Parameter

Description

vsam.work.space

The file ID of the one VSAM file to be used by CA IDMS/DB Reorg. (It is suggested that this file ID include the name PAGUTIL.)

volser

The volume serial number or generic assignment of the disk volume on which the file, as specified in the preceding DLBL statement, resides.

reltrk

Relative track or relative block number: the starting position on the DASD for storage of the work file specified in the previous statement.

amount

The space allocation you need to store the file specified in the previous statement.

record.numbers

The number of records to be allocated to the VSAM work file.

usetype

The appropriate type: REUSE or UNIQUE. If you specify UNIQUE, you must DELETE and DEFINE this cluster prior to each execution of the PRIALLOC step.

volume.name

The volume to contain the cluster or component.