Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
IAM FILE WARNING : IAMW22

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
bamohan

New User


Joined: 29 Jan 2007
Posts: 33
Location: chennai

PostPosted: Thu Aug 13, 2009 3:20 pm    Post subject: IAM FILE WARNING : IAMW22
Reply with quote

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.
Back to top
View user's profile Send private message

bamohan

New User


Joined: 29 Jan 2007
Posts: 33
Location: chennai

PostPosted: Thu Aug 13, 2009 3:22 pm    Post subject: Reply to: IAM FILE WARNING : IAMW22
Reply with quote

Just to wanted to add IPMRVALQ is the DD name
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Aug 13, 2009 3:28 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
vinuk2009

New User


Joined: 30 Apr 2009
Posts: 19
Location: chennai

PostPosted: Fri Aug 14, 2009 1:14 pm    Post subject: Reply to: IAM FILE WARNING : IAMW22
Reply with quote

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.
Back to top
View user's profile Send private message
bamohan

New User


Joined: 29 Jan 2007
Posts: 33
Location: chennai

PostPosted: Fri Aug 14, 2009 1:36 pm    Post subject:
Reply with quote

Thanks for the info. But my case is #6. I dont see any thing for #6.. Please advise.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Aug 14, 2009 1:45 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
vinuk2009

New User


Joined: 30 Apr 2009
Posts: 19
Location: chennai

PostPosted: Fri Aug 14, 2009 3:47 pm    Post subject: Reply to: IAM FILE WARNING : IAMW22
Reply with quote

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.
Back to top
View user's profile Send private message
JAYADEV.G

New User


Joined: 13 Apr 2007
Posts: 11
Location: hyderabad

PostPosted: Wed Sep 02, 2009 6:22 pm    Post subject: Reply to: IAM FILE WARNING : IAMW22
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 8 Fri Sep 22, 2017 11:35 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us