Error messages say the database is full when doing an ACF INSERT or CHANGE, but IDCAMS says the database is only 75% utilized.

Products

• ACF2
• ACF2 - z/OS
• ACF2 - MISC

Issue/Introduction

Doing a logonid INSERT command, or change a users password, various messages say that the database is full.

Messages that may appear are:

ACF02105 NO ROOM IN DATA BASE FOR ALTER REQUEST
ACF02107 NO ROOM IN DATA BASE FOR INSERT REQUEST
ACF02141 NO ROOM FOR PASSWORD RECORD FOR LOGONID $$ PASSWORD NOT CHANGED
ACF0A025 INSUFFICIENT SPACE IN DATABASE TO COMPLETE REQUEST 

Running a IDCAMS LISTCAT, the report says the database is only 75% used. Why don't the commands work?

.

Environment

Release:
Component: ACF2MS

Resolution

The ACF2 databases are standard VSAM KSDSs files. Even though the database itself is not totally full, the key being used by VSAM may be full. The resolution for that is to reorg the database. Run a IDCAMS LISTCAT against the database and see if FREESPAC is over 30%.  If more then 30%, then just a delete, redefine, and repro are needed.  If there is less than 30%, then the database needs to be enlarged.

  Please see KB000027050 on the procedures for redefining the PRIMARY database for a REORG or increasing the size.