A database has been developed to study the evolution, the nonlinear effects on equilibria, and the disruptivity of locked and quasi-stationary modes with poloidal and toroidal mode numbers m=2 and n=1 at DIII-D. The analysis of 22,500 discharges shows that more than 18% of disruptions are due to locked or quasi-stationary modes with rotating precursors (not including born locked modes). A parameter formulated by the plasma internal inductance l_i divided by the safety factor at 95% of the poloidal flux, q_{95}, is found to exhibit predictive capability over whether a locked mode will cause a disruption or not, and does so up to hundreds of milliseconds before the disruption. Within 20 ms of the disruption, the shortest distance between the island separatrix and the unperturbed last closed flux surface, referred to as d_{edge}, performs comparably to l_i/q_{95} in its ability to discriminate disruptive locked modes. Out of all parameters considered, d_{edge} also correlates best with the duration of the locked mode. Within 50 ms of a locked mode disruption, average behavior includes exponential growth of the n=1 perturbed field, which might be due to the 2/1 locked mode. Even assuming the aforementioned 2/1 growth, disruptivity following a locked mode shows little dependence on island width up to 20 ms before the disruption. Separately, greater deceleration of the rotating precursor is observed when the wall torque is large. At locking, modes are often observed to align with a residual error field. Timescales associated with the mode evolution are also studied and dictate the response times necessary for disruption avoidance and mitigation.