Adaptive Server is attempting to write to a memory address space segment (MASS). A MASS is one or more contiguous pages Adaptive Server keeps in a data cache. However, in this event, the status of the MASS is “changing,” meaning another spid is updating the MASS. The spid initiating the write cannot write to the MASS until the MASS is no longer in use.
A high value for WaitTime for event 30 may indicate that the data cache is too small, causing pages in the data cache to reach the wash area frequently, forcing the checkpoint process to perform more writes than necessary.
