IAM FILE WARNING : IAMW22

bamohan · New User Joined: 29 Jan 2007 Posts: 33 Location: chennai

HI,

Can someone advise what remediation needs to be provided for the Error Message in batch jobs

+IAMW22 DD=IPMRVALQ FILE REORGANIZATION RECOMMENDED - EXCEEDED REQUESTED OVERFLOW RECORDS"

Thanks.

bamohan · New User Joined: 29 Jan 2007 Posts: 33 Location: chennai

Just to wanted to add IPMRVALQ is the DD name

expat · Posted: Thu Aug 13, 2009 3:28 pm

What does it say in the product manual regarding the message.

IAM is not a product used in every shop, so you - with access to the manuals will need to investigate yourself.

vinuk2009 · New User Joined: 30 Apr 2009 Posts: 19 Location: chennai

IAMW22

DD='ddname' FILE REORGANIZATION RECOMMENDED ¦

Reason: A file reorganization is being recommended for one of the
following reasons, as indicated in the message:
3. OVERFLOW INDEX EXCEEDS 16 MEG
4. OVERFLOW EXCEEDS 1000 CYLINDERS
5. EXCEEDED 13 EXTENTS ON SINGLE VOLUME
6. EXCEEDED REQUESTED OVERFLOW RECORDS

Return None.
Codes:

Action: For reasons 1 and 2, performance on the indicated file may
be adversely affected due to the size of the overflow
area. In particular, it may take several minutes to open
the file, and sequential processing may be detrimentally
the file, and sequential processing may be detrimentally
affected. It is therefore recommended that the file be
reorganized at the earliest convenient time to prevent
further performance deterioration. The file can be quickly
reorganized with FDRREORG(R), or if that product is not
available, then use IDCAMS REPRO.
For reason 3, because IAM files have a non-VSAM file
structure, they are limited to 16 extents per volume. The
file indicated currently has 14 or more extents, so future
growth will be restricted. To prevent an out of space
condition, action should be taken at the earliest possible
time. If there is sufficient space for the file to expand
on the volume that it currently resides, either use
COMPAKTOR to merge extents, or reorganize the file doing a
DELETE and DEFINE of the dataset, specifying a larger
space allocation. The current space allocation values can
be determined by performing a Listcat All on the dataset.
If the current volume has insufficient space, and you are
unable to free up sufficient space, then the dataset
should be moved to a different volume, where more DASD
space is available.
For reason 4, the file was defined with an Overflow
override, and the file has reached or exceeded that number
of records in extended overflow. Presumably, the override
was provided to indicate when the file should be
reorganized. IAM will continue to add records to extended
overflow, provided that IAM is able to obtain sufficient
DASD space to do so.

Hope it will be helpful.

bamohan · New User Joined: 29 Jan 2007 Posts: 33 Location: chennai

Thanks for the info. But my case is #6. I dont see any thing for #6.. Please advise.

expat · Posted: Fri Aug 14, 2009 1:45 pm

So what have you done to research the problem yourself.

Have you read the product manuals, as it seems that you site is licensed for the product, so all documentation should be available to you.

Have you looked at the manuals, have you looked for the manuals.

vinuk2009 · New User Joined: 30 Apr 2009 Posts: 19 Location: chennai

Hello Mohan,

Following action you need to take

For reason 4, the file was defined with an Overflow
override, and the file has reached or exceeded that number
of records in extended overflow. Presumably, the override
was provided to indicate when the file should be
reorganized. IAM will continue to add records to extended
overflow, provided that IAM is able to obtain sufficient
DASD space to do so.

JAYADEV.G · New User Joined: 13 Apr 2007 Posts: 11 Location: hyderabad

Hi,

Try doing del/def of that file .your overflow will be eliminated.

Because that is what we do when IAMW22 error comes for us.

After doin del/def give f32 option and u can find the overflow is '0'

another thing u can do in addtion to del/def is, increasing the space parameter in the data part in ur define card

Thanks/Jai