In this blog post, let’s learn about the error message “138 ISAM error: dbspace table overflow.” in Hydra and the description of the error.
Error Message
138 ISAM error: dbspace table overflow.
Error Details
If nused is less than npages, and nextns is large (over 200), the table has too many extents. The upper limit of extents per table is between 200 and 50. The limit varies with the table definition and the disk-page size in use. Reallocate the table using fewer, larger extents. Unload the table data to a flat file. Drop the table. Re-create the table, specifying a first-extent size sufficient to hold all its current data and a next-extent size between one-fourth and one-sixteenth its current size. Then reload the data into the table.
If nextns is small or the difference between npages and nused is less than the size of the next-extent size for the table, not enough disk space is available in the dbspace where the table resides. Use the chunk number from step 2 and the ON-Monitor or ON-Monitor Chunks display to determine the dbspace, then add a new chunk to that dbspace.