ACF02105 NO ROOM IN DATA BASE FOR ALTER REQUEST
Article ID: 26095
Updated On:
Products
Issue/Introduction
When an attempt was made to execute a logonid INSERT or CHANGE command, receive error messages indicating that the database is full, even though IDCAMS reports that database is only 75% utilized. Why don't the commands work?
Messages that may appear are:
ACF02105 NO ROOM IN DATA BASE FOR ALTER REQUEST
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
Resolution
ACF2 databases are standard VSAM KSDS files. Even if the database itself is not full, the VSAM key structure may be exhausted, which requires a database reorganization. Run an IDCAMS LISTCAT command against the database to check if the FREESPACE is over 30%. If it exceeds 30%, a simple delete, redefine, and repro process is sufficient. However, if it is less than 30%, the database must be enlarged.
Please refer to "Expanding Space Allocation of ACF2 databases" for the procedures on redefining the PRIMARY database for a REORG or increasing its size.
Feedback
