Since you don't keep type 2 dimensions, would it be better to store the retry limit in the log table. That way you'd know what the limit at the time was and there is no need to change the datatype for any column. You end up with the same amount of bytes taken up compared to changing to smallint.